FlexPHP\Database\Tests\Unit\ColumnTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	102
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	getDefault()	0	10	1
A	testItDefinitionAi()	0	21	1
A	testItDefinitionDefault()	0	17	1
A	testItDefinition()	0	20	1
A	testItDefinitionPk()	0	19	1

<?php declare(strict_types=1);
/*
 * This file is part of FlexPHP.
 *
 * (c) Freddie Gar <freddie.gar@outlook.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace FlexPHP\Database\Tests\Unit;

use FlexPHP\Database\Column;
use FlexPHP\Database\Tests\TestCase;
use FlexPHP\Schema\SchemaAttribute;

class ColumnTest extends TestCase
{
    public function testItDefinition(): void
    {
        $schemaAttribute = new SchemaAttribute('foo', 'integer', [
            'min' => 10,
            'max' => 100,
        ]);

        $column = new Column($schemaAttribute);

        $this->assertEquals($schemaAttribute->name(), $column->getName());
        $this->assertEquals($schemaAttribute->dataType(), $column->getType());
        $this->assertFalse($column->isPrimaryKey());
        $this->assertFalse($column->isForeingKey());
        $this->assertEquals([
            'length' => $schemaAttribute->maxLength(),
            'notnull' => $schemaAttribute->isRequired(),
            'autoincrement' => $schemaAttribute->isAi(),
            'comment' => $schemaAttribute->name(),
            'default' => $schemaAttribute->default(),
        ], $column->getOptions());
    }

    public function testItDefinitionAi(): void
    {
        $schemaAttribute = new SchemaAttribute('foo', 'integer', [
            'pk' => true,
            'ai' => true,
            'required' => true,
        ]);

        $column = new Column($schemaAttribute);

        $this->assertEquals($schemaAttribute->name(), $column->getName());
        $this->assertEquals($schemaAttribute->dataType(), $column->getType());
        $this->assertTrue($column->isPrimaryKey());
        $this->assertFalse($column->isForeingKey());
        $this->assertEquals([
            'length' => $schemaAttribute->maxLength(),
            'notnull' => $schemaAttribute->isRequired(),
            'autoincrement' => $schemaAttribute->isAi(),
            'comment' => $schemaAttribute->name(),
            'default' => $schemaAttribute->default(),
        ], $column->getOptions());
    }

    public function testItDefinitionPk(): void
    {
        $schemaAttribute = new SchemaAttribute('bar', 'integer', [
            'fk' => 'baz',
        ]);

        $column = new Column($schemaAttribute);

        $this->assertEquals($schemaAttribute->name(), $column->getName());
        $this->assertEquals($schemaAttribute->dataType(), $column->getType());
        $this->assertFalse($column->isPrimaryKey());
        $this->assertTrue($column->isForeingKey());
        $this->assertEquals([
            'length' => $schemaAttribute->maxLength(),
            'notnull' => $schemaAttribute->isRequired(),
            'autoincrement' => $schemaAttribute->isAi(),
            'comment' => $schemaAttribute->name(),
            'default' => $schemaAttribute->default(),
        ], $column->getOptions());
    }

    /**
     * @dataProvider getDefault
     *
     * @param mixed $default
     */
    public function testItDefinitionDefault(string $dataType, $default): void
    {
        $schemaAttribute = new SchemaAttribute('bar', $dataType, [
            'default' => $default,
        ]);

        $column = new Column($schemaAttribute);

        $this->assertEquals($schemaAttribute->name(), $column->getName());
        $this->assertEquals($dataType, $column->getType());
        $this->assertEquals([
            'length' => $schemaAttribute->maxLength(),
            'notnull' => $schemaAttribute->isRequired(),
            'autoincrement' => $schemaAttribute->isAi(),
            'comment' => $schemaAttribute->name(),
            'default' => $schemaAttribute->default(),
        ], $column->getOptions());
    }

    public function getDefault(): array
    {
        return [
            ['string', null],
            ['string', ''],
            ['string', 'A'],
            ['string', '1'],
            ['integer', '1'],
            ['float', '1.9'],
            ['datetime', 'NOW'],
        ];
    }
}