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

Complexity

Conditions	2
Paths	2

Size

Total Lines	30
Code Lines	18

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::getZend2DbAdapter());

        $selectBuilder = function () {
            $select = new \Zend\Db\Sql\Select('tree_traversal_with_scope');
            $select->join(
                array('ttm' => 'tree_traversal_metadata'),
                'ttm.tree_traversal_id = tree_traversal_with_scope.tree_traversal_id',
                array('metadata' => 'name'),
                $select::JOIN_LEFT
            );

            return $select;
        };

        $adapter->setDbSelectBuilder($selectBuilder);

        return $adapter;
    }
}