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

Complexity

Conditions	2
Paths	2

Size

Total Lines	27
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function getAdapter()
    {
        $options = new Options(array(
            'tableName' => 'tree_traversal_with_scope',
            'tableAlias' => 'ttws',
            '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());

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

        $adapter->setDefaultDbSelect($select);

        return $adapter;
    }
}