StefanoTreeTest\Integration\Adapter\Zend1JoinTableTest::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::getZend1DbAdapter());

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

        $adapter->setDefaultDbSelect($select);

        return $adapter;
    }
}