StefanoTreeTest\Integration\Adapter\AdapterAbstract

Complexity

Total Complexity

13

Size/Duplication

Total Lines	162
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	2

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	5	1
A	tearDown()	0	5	1
	getAdapter()	0	1	?
A	getDataSet()	0	4	1
A	testIsInTransaction()	0	9	1
A	testCommitTransaction()	0	10	1
A	testRollbackTransaction()	0	10	1
A	testHandleNestedTransaction()	0	16	2
A	testQuoteIdentifier()	0	32	3
A	testExecuteInsertSQL()	0	24	1
A	testExecuteSQL()	0	23	1

<?php

declare(strict_types=1);

namespace StefanoTreeTest\Integration\Adapter;

use StefanoTree\NestedSet\Adapter\AdapterInterface;
use StefanoTreeTest\IntegrationTestCase;

abstract class AdapterAbstract extends IntegrationTestCase
{
    /**
     * @var AdapterInterface
     */
    protected $adapter;

    protected $adapterCanQuoteIdentifier = true;

    protected function setUp()
    {
        $this->adapter = null;
        parent::setUp();
    }

    protected function tearDown()
    {
        $this->adapter = null;
        parent::tearDown();
    }

    /**
     * @return AdapterInterface
     */
    abstract protected function getAdapter(): AdapterInterface;

    protected function getDataSet()
    {
        return $this->createMySQLXMLDataSet(__DIR__.'/../_files/NestedSet/initDataSet.xml');
    }

    public function testIsInTransaction()
    {
        $adapter = $this->getAdapter();

        $this->assertFalse($adapter->isInTransaction());
        $adapter->beginTransaction();
        $this->assertTrue($adapter->isInTransaction());
        $adapter->rollbackTransaction();
    }

    public function testCommitTransaction()
    {
        $adapter = $this->getAdapter();

        $this->assertFalse($adapter->isInTransaction());
        $adapter->beginTransaction();
        $this->assertTrue($adapter->isInTransaction());
        $adapter->commitTransaction();
        $this->assertFalse($adapter->isInTransaction());
    }

    public function testRollbackTransaction()
    {
        $adapter = $this->getAdapter();

        $this->assertFalse($adapter->isInTransaction());
        $adapter->beginTransaction();
        $this->assertTrue($adapter->isInTransaction());
        $adapter->rollbackTransaction();
        $this->assertFalse($adapter->isInTransaction());
    }

    public function testHandleNestedTransaction()
    {
        $adapter = $this->getAdapter();
        if (!$adapter->canHandleNestedTransaction()) {
            $this->markTestSkipped('Adapter does not support nested transaction');

            return;
        }
        $adapter->beginTransaction();
        $this->assertTrue($adapter->isInTransaction());
        $adapter->beginTransaction();
        $adapter->commitTransaction();
        $this->assertTrue($adapter->isInTransaction());
        $adapter->commitTransaction();
        $this->assertFalse($adapter->isInTransaction());
    }

    public function testQuoteIdentifier()
    {
        $a = $this->getAdapter();

        if ($this->adapterCanQuoteIdentifier) {
            if ('pgsql' == TEST_STEFANO_DB_VENDOR) {
                $this->assertEquals(
                    '"simple"',
                    $a->quoteIdentifier('simple')
                );

                $this->assertEquals(
                    '"more"."complex"',
                    $a->quoteIdentifier('more.complex')
                );
            } else {
                $this->assertEquals(
                    '`simple`',
                    $a->quoteIdentifier('simple')
                );

                $this->assertEquals(
                    '`more`.`complex`',
                    $a->quoteIdentifier('more.complex')
                );
            }
        } else {
            $this->assertEquals(
                'more.complex',
                $a->quoteIdentifier('more.complex'));
        }
    }

    public function testExecuteInsertSQL()
    {
        $a = $this->getAdapter();

        $sql = 'INSERT INTO tree_traversal (name, lft, rgt, parent_id, level)'
            .' VALUES(:name, :lft, :rgt, :parent_id, :level)';

        $data = array(
            'name' => 'ahoj',
            'lft' => 123,
            'rgt' => 456,
            'parent_id' => 10,
            'level' => 789,
        );

        $id = $a->executeInsertSQL($sql, $data);
        $this->assertEquals(26, $id);

        $result = $a->executeSelectSQL('SELECT * FROM tree_traversal WHERE tree_traversal_id = 26');
        $this->assertEquals(
            array(
                0 => array_merge($data, array('tree_traversal_id' => 26)),
            ), $result);
    }

    public function testExecuteSQL()
    {
        $a = $this->getAdapter();

        $sql = 'UPDATE tree_traversal SET name = :name WHERE tree_traversal_id = :id';

        $data = array(
            'name' => 'testujeme parne valce',
            'id' => 10,
        );

        $a->executeSQL($sql, $data);

        $result = $a->executeSelectSQL(
            'SELECT tree_traversal_id AS id, name FROM tree_traversal WHERE tree_traversal_id = :id',
            array('id' => $data['id'])
        );

        $this->assertEquals(
            array(
                0 => $data,
            ), $result);
    }
}