Yiisoft\Db\Tests\AbstractSchemaTest

Complexity

Total Complexity

7

Size/Duplication

Total Lines	82
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	testGetDefaultSchema()	0	7	1
A	testCreateColumnSchemaBuilder()	0	9	1
A	testIsReadQuery()	0	10	1
A	testRefresh()	0	9	1
A	testColumnSchemaDbTypecastWithEmptyCharType()	0	6	1
A	testGetPDOType()	0	27	2

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Tests;

use PDO;
use PHPUnit\Framework\TestCase;
use Yiisoft\Db\Schema\ColumnSchema;
use Yiisoft\Db\Schema\ColumnSchemaBuilder;
use Yiisoft\Db\Schema\Schema;
use Yiisoft\Db\Tests\Support\Assert;
use Yiisoft\Db\Tests\Support\TestTrait;

use function fclose;
use function fopen;
use function print_r;

abstract class AbstractSchemaTest extends TestCase
{
    use TestTrait;

    public function testCreateColumnSchemaBuilder(): void
    {
        $db = $this->getConnection();

        $schema = $db->getSchema();

The assignment to $schema is dead and can be removed.

        $columnSchemaBuilder = $db->getSchema()->createColumnSchemaBuilder('string');

        $this->assertInstanceOf(ColumnSchemaBuilder::class, $columnSchemaBuilder);
        $this->assertSame('string', $columnSchemaBuilder->getType());
    }

    public function testColumnSchemaDbTypecastWithEmptyCharType(): void
    {
        $columnSchema = new ColumnSchema();
        $columnSchema->setType(Schema::TYPE_CHAR);

        $this->assertSame('', $columnSchema->dbTypecast(''));
    }

    public function testGetDefaultSchema(): void
    {
        $db = $this->getConnection();

        $schema = $db->getSchema();

        $this->assertNull($schema->getDefaultSchema());
    }

    public function testGetPDOType(): void
    {
        $values = [
            [null, PDO::PARAM_NULL],
            ['', PDO::PARAM_STR],
            ['hello', PDO::PARAM_STR],
            [0, PDO::PARAM_INT],
            [1, PDO::PARAM_INT],
            [1337, PDO::PARAM_INT],
            [true, PDO::PARAM_BOOL],
            [false, PDO::PARAM_BOOL],
            [$fp = fopen(__FILE__, 'rb'), PDO::PARAM_LOB],
        ];

        $db = $this->getConnection();

        $schema = $db->getSchema();

        foreach ($values as $value) {
            $this->assertSame(
                $value[1],
                $schema->getPdoType($value[0]),
                'type for value ' . print_r($value[0], true) . ' does not match.',

Are you sure print_r($value[0], true) of type string|true can be used in concatenation?

            );
        }

        fclose($fp);
    }

    public function testIsReadQuery(): void
    {
        $db = $this->getConnection();

        $schema = $db->getSchema();

        $this->assertTrue($schema->isReadQuery('SELECT * FROM tbl'));
        $this->assertTrue($schema->isReadQuery('SELECT * FROM tbl WHERE id=1'));
        $this->assertTrue($schema->isReadQuery('SELECT * FROM tbl WHERE id=1 LIMIT 1'));
        $this->assertTrue($schema->isReadQuery('SELECT * FROM tbl WHERE id=1 LIMIT 1 OFFSET 1'));
    }

    public function testRefresh(): void
    {
        $db = $this->getConnection();

        $schema = $db->getSchema();
        $schema->refresh();

        $this->assertSame([], Assert::getInaccessibleProperty($schema, 'tableMetadata'));
        $this->assertSame([], Assert::getInaccessibleProperty($schema, 'tableNames'));
    }
}