Yiisoft\Db\Sqlite\Tests\SchemaTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	94
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getExpectedColumns()	0	23	1
A	testGetSchemaNames()	0	3	1
A	testQuoteTableName()	0	5	1
A	constraintsProvider()	0	21	1
A	quoteTableNameDataProvider()	0	9	1
A	testCompositeFk()	0	13	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite\Tests;

use Yiisoft\Db\Constraints\Constraint;
use Yiisoft\Db\Tests\AnyValue;
use Yiisoft\Db\Tests\SchemaTest as AbstractSchemaTest;

class SchemaTest extends AbstractSchemaTest
{
    protected ?string $driverName = 'sqlite';

    public function testGetSchemaNames()
    {
        $this->markTestSkipped('Schemas are not supported in SQLite.');
    }

    public function getExpectedColumns()
    {
        $columns = parent::getExpectedColumns();

        unset(
            $columns['enum_col'],
            $columns['bit_col'],
            $columns['json_col']
        );

        $columns['int_col']['dbType'] = 'integer';
        $columns['int_col']['size'] = null;
        $columns['int_col']['precision'] = null;
        $columns['int_col2']['dbType'] = 'integer';
        $columns['int_col2']['size'] = null;
        $columns['int_col2']['precision'] = null;
        $columns['bool_col']['type'] = 'boolean';
        $columns['bool_col']['phpType'] = 'boolean';
        $columns['bool_col2']['type'] = 'boolean';
        $columns['bool_col2']['phpType'] = 'boolean';
        $columns['bool_col2']['defaultValue'] = true;

        return $columns;
    }

    public function testCompositeFk()
    {
        $db = $this->getConnection();

        $schema = $db->getSchema();

        $table = $schema->getTableSchema('composite_fk');

        $this->assertCount(1, $table->foreignKeys);
        $this->assertTrue(isset($table->foreignKeys[0]));
        $this->assertEquals('order_item', $table->foreignKeys[0][0]);
        $this->assertEquals('order_id', $table->foreignKeys[0]['order_id']);
        $this->assertEquals('item_id', $table->foreignKeys[0]['item_id']);
    }

    public function constraintsProvider()
    {
        $result = parent::constraintsProvider();

        $result['1: primary key'][2]->setName(null);
        $result['1: check'][2][0]->setColumnNames(null);
        $result['1: check'][2][0]->setExpression('"C_check" <> \'\'');
        $result['1: unique'][2][0]->setName(AnyValue::getInstance());
        $result['1: index'][2][1]->setName(AnyValue::getInstance());

        $result['2: primary key'][2]->setName(null);
        $result['2: unique'][2][0]->setName(AnyValue::getInstance());
        $result['2: index'][2][2]->setName(AnyValue::getInstance());

        $result['3: foreign key'][2][0]->setName(null);
        $result['3: index'][2] = [];

        $result['4: primary key'][2]->setName(null);
        $result['4: unique'][2][0]->setName(AnyValue::getInstance());

        return $result;
    }

    /**
     * @dataProvider quoteTableNameDataProvider
     * @param $name
     * @param $expectedName
     * @throws \yii\base\NotSupportedException
     */
    public function testQuoteTableName($name, $expectedName)
    {
        $schema = $this->getConnection()->getSchema();
        $quotedName = $schema->quoteTableName($name);
        $this->assertEquals($expectedName, $quotedName);
    }

    public function quoteTableNameDataProvider()
    {
        return [
            ['test', '`test`'],
            ['test.test', '`test`.`test`'],
            ['test.test.test', '`test`.`test`.`test`'],
            ['`test`', '`test`'],
            ['`test`.`test`', '`test`.`test`'],
            ['test.`test`.test', '`test`.`test`.`test`'],
        ];
    }
}