StefanoTreeTest\Integration\Adapter\Zend1JoinTableTest::getAdapter()

Complexity

Conditions	2
Paths	2

Size

Total Lines

30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function getAdapter()
    {
        $options = new Options(array(
            'tableName' => 'tree_traversal_with_scope',
            'idColumnName' => 'tree_traversal_id',
            'scopeColumnName' => 'scope',
        ));

        if ('pgsql' == TEST_STEFANO_DB_ADAPTER) {
            $options->setSequenceName('tree_traversal_with_scope_tree_traversal_id_seq');
        }

        $adapter = new NestedSetAdapter($options, TestUtil::getZend1DbAdapter());

        $selectBuilder = function () {
            $select = TestUtil::getZend1DbAdapter()->select();
            $select->from(array('tree_traversal_with_scope'))
                ->joinLeft(
                    array('ttm' => 'tree_traversal_metadata'),
                    'ttm.tree_traversal_id = tree_traversal_with_scope.tree_traversal_id',
                    array('metadata' => 'name')
                );

            return $select;
        };

        $adapter->setDbSelectBuilder($selectBuilder);

        return $adapter;
    }
}