TheCodingMachine\FluidSchema\TdbmFluidColumnTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	142
Duplicated Lines	13.38 %

Coupling/Cohesion

Components	0
Dependencies	9

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
B	testTypes()	0	104	3
A	testReference()	19	19	1
A	testReferenceException()	0	14	1

<?php

namespace TheCodingMachine\FluidSchema;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;
use PHPUnit\Framework\TestCase;

class TdbmFluidColumnTest extends TestCase
{
    public function testTypes()
    {
        $schema = new Schema();
        $fluid = new TdbmFluidSchema($schema);

        $posts = $fluid->table('posts');

        $column = $posts->column('foo');

        $dbalColumn = $schema->getTable('posts')->getColumn('foo');

        $column->integer();
        $this->assertSame(Type::getType(Type::INTEGER), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::INTEGER has been deprecated with message: Use {@see DefaultTypes::INTEGER} instead.

        $column->smallInt();
        $this->assertSame(Type::getType(Type::SMALLINT), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::SMALLINT has been deprecated with message: Use {@see DefaultTypes::SMALLINT} instead.

        $column->bigInt();
        $this->assertSame(Type::getType(Type::BIGINT), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::BIGINT has been deprecated with message: Use {@see DefaultTypes::BIGINT} instead.

        $column->decimal(12, 32);
        $this->assertSame(Type::getType(Type::DECIMAL), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DECIMAL has been deprecated with message: Use {@see DefaultTypes::DECIMAL} instead.

        $this->assertSame(12, $dbalColumn->getPrecision());
        $this->assertSame(32, $dbalColumn->getScale());

        $column->float(32, 12);
        $this->assertSame(Type::getType(Type::FLOAT), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::FLOAT has been deprecated with message: Use {@see DefaultTypes::FLOAT} instead.

        $this->assertSame(32, $dbalColumn->getPrecision());
        $this->assertSame(12, $dbalColumn->getScale());

        $column->string(42, true);
        $this->assertSame(Type::getType(Type::STRING), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::STRING has been deprecated with message: Use {@see DefaultTypes::STRING} instead.

        $this->assertSame(42, $dbalColumn->getLength());
        $this->assertSame(true, $dbalColumn->getFixed());

        $column->text();
        $this->assertSame(Type::getType(Type::TEXT), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::TEXT has been deprecated with message: Use {@see DefaultTypes::TEXT} instead.

        $column->guid();
        $this->assertSame(Type::getType(Type::GUID), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::GUID has been deprecated with message: Use {@see DefaultTypes::GUID} instead.

        $column->blob();
        $this->assertSame(Type::getType(Type::BLOB), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::BLOB has been deprecated with message: Use {@see DefaultTypes::BLOB} instead.

        $column->boolean();
        $this->assertSame(Type::getType(Type::BOOLEAN), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::BOOLEAN has been deprecated with message: Use {@see DefaultTypes::BOOLEAN} instead.

        $column->date();
        $this->assertSame(Type::getType(Type::DATE), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATE has been deprecated with message: Use {@see DefaultTypes::DATE_MUTABLE} instead.

        $column->datetime();
        $this->assertSame(Type::getType(Type::DATETIME), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATETIME has been deprecated with message: Use {@see DefaultTypes::DATETIME_MUTABLE} instead.

        $column->datetimeTz();
        $this->assertSame(Type::getType(Type::DATETIMETZ), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATETIMETZ has been deprecated with message: Use {@see DefaultTypes::DATETIMETZ_MUTABLE} instead.

        $column->time();
        $this->assertSame(Type::getType(Type::TIME), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::TIME has been deprecated with message: Use {@see DefaultTypes::TIME_MUTABLE} instead.

        $column->array();
        $this->assertSame(Type::getType(Type::TARRAY), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::TARRAY has been deprecated with message: Use {@see DefaultTypes::ARRAY} instead.

        $column->simpleArray();
        $this->assertSame(Type::getType(Type::SIMPLE_ARRAY), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::SIMPLE_ARRAY has been deprecated with message: Use {@see DefaultTypes::SIMPLE_ARRAY} instead.

        $column->jsonArray();
        $this->assertSame(Type::getType(Type::JSON_ARRAY), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::JSON_ARRAY has been deprecated with message: Use {@see DefaultTypes::JSON_ARRAY} instead.

        $column->object();
        $this->assertSame(Type::getType(Type::OBJECT), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::OBJECT has been deprecated with message: Use {@see DefaultTypes::OBJECT} instead.

        if (defined('Doctrine\\DBAL\\Types\\Type::BINARY')) {
            $column->binary(43);
            $this->assertSame(Type::getType(Type::BINARY), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::BINARY has been deprecated with message: Use {@see DefaultTypes::BINARY} instead.

            $this->assertSame(43, $dbalColumn->getLength());
            $this->assertSame(false, $dbalColumn->getFixed());
        }

        if (defined('Doctrine\\DBAL\\Types\\Type::DATE_IMMUTABLE')) {
            // Doctrine DBAL 2.6+
            $column->dateImmutable();
            $this->assertSame(Type::getType('date_immutable'), $dbalColumn->getType());

            $column->datetimeImmutable();
            $this->assertSame(Type::getType(Type::DATETIME_IMMUTABLE), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATETIME_IMMUTABLE has been deprecated with message: Use {@see DefaultTypes::DATETIME_IMMUTABLE} instead.

            $column->datetimeTzImmutable();
            $this->assertSame(Type::getType(Type::DATETIMETZ_IMMUTABLE), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATETIMETZ_IMMUTABLE has been deprecated with message: Use {@see DefaultTypes::DATETIMETZ_IMMUTABLE} instead.

            $column->time();
            $this->assertSame(Type::getType(Type::TIME), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::TIME has been deprecated with message: Use {@see DefaultTypes::TIME_MUTABLE} instead.

            $column->timeImmutable();
            $this->assertSame(Type::getType(Type::TIME_IMMUTABLE), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::TIME_IMMUTABLE has been deprecated with message: Use {@see DefaultTypes::TIME_IMMUTABLE} instead.

            $column->dateInterval();
            $this->assertSame(Type::getType(Type::DATEINTERVAL), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::DATEINTERVAL has been deprecated with message: Use {@see DefaultTypes::DATEINTERVAL} instead.

            $column->json();
            $this->assertSame(Type::getType(Type::JSON), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::JSON has been deprecated with message: Use {@see DefaultTypes::JSON} instead.

        }

        $this->assertSame('foo', $column->getDbalColumn()->getName());
    }

    public function testReference()

This method seems to be duplicated in your project.

    {
        $schema = new Schema();
        $fluid = new TdbmFluidSchema($schema);

        $countries = $fluid->table('countries');
        $countries->id();

        $users = $fluid->table('users');
        $users->column('country_id')->references('countries', 'myfk');

        $dbalColumn = $schema->getTable('users')->getColumn('country_id');

        $this->assertSame(Type::getType(Type::INTEGER), $dbalColumn->getType());

The constant Doctrine\DBAL\Types\Type::INTEGER has been deprecated with message: Use {@see DefaultTypes::INTEGER} instead.

        $fk = $schema->getTable('users')->getForeignKey('myfk');
        $this->assertSame('users', $fk->getLocalTableName());
        $this->assertSame('countries', $fk->getForeignTableName());
        $this->assertSame(['country_id'], $fk->getLocalColumns());
    }

    public function testReferenceException()
    {
        $schema = new Schema();
        $fluid = new TdbmFluidSchema($schema);

        $countries = $fluid->table('countries');
        $countries->column('id1')->integer();
        $countries->column('id2')->integer();
        $countries->primaryKey(['id1','id2']);

        $users = $fluid->table('users');
        $this->expectException(FluidSchemaException::class);
        $users->column('country_id')->references('countries', 'myfk');
    }
}