packages/sql-semantics/tests/Unit/Core/Schema/ColumnDefinitionTest.php

1<?php
2
3declare(strict_types=1);
4
5namespace Tests\Unit\Core\Schema;
6
7use PHPUnit\Framework\Attributes\CoversClass;
8use PHPUnit\Framework\Attributes\Medium;
9use PHPUnit\Framework\TestCase;
10use SqlSemantics\Core\Binder;
11use SqlSemantics\Core\SchemaBuilder;
12use SqlSemantics\Core\SemanticException;
13use SqlSemantics\Core\Type\Nullability;
14use SqlSemantics\Platform\PostgreSql\Dialect as PostgreSqlDialect;
15
16#[CoversClass(\SqlSemantics\Core\Schema\ColumnDefinition::class)]
17#[CoversClass(\SqlSemantics\Core\Binding\ExpressionBinder::class)]
18#[CoversClass(\SqlSemantics\Core\Binding\ExpressionRules::class)]
19#[CoversClass(\SqlSemantics\Core\Binding\FromBinder::class)]
20#[CoversClass(\SqlSemantics\Core\Binding\LiteralBinder::class)]
21#[CoversClass(\SqlSemantics\Core\Binding\NullFacts::class)]
22#[CoversClass(\SqlSemantics\Core\Binding\ProjectionBinder::class)]
23#[CoversClass(\SqlSemantics\Core\Binding\SelectBinder::class)]
24#[CoversClass(\SqlSemantics\Core\Binding\SyntaxGuard::class)]
25#[CoversClass(\SqlSemantics\Core\Binding\SelectModifiersBinder::class)]
26#[CoversClass(\SqlSemantics\Core\Binding\TypeResolution::class)]
27#[CoversClass(Binder::class)]
28#[CoversClass(SchemaBuilder::class)]
29#[CoversClass(\SqlSemantics\Core\Ast\DialectParser::class)]
30#[CoversClass(\SqlSemantics\Core\Ast\ColumnReader::class)]
31#[CoversClass(\SqlSemantics\Core\Ast\ConstraintReader::class)]
32#[CoversClass(\SqlSemantics\Core\Ast\Identifiers::class)]
33#[CoversClass(\SqlSemantics\Core\Ast\SchemaReader::class)]
34#[CoversClass(\SqlSemantics\Core\Ast\StatementList::class)]
35#[CoversClass(\SqlSemantics\Core\Ast\TokenGroups::class)]
36#[CoversClass(\SqlSemantics\Core\Ast\Tree::class)]
37#[CoversClass(\SqlSemantics\Core\Ast\TypeReader::class)]
38#[CoversClass(\SqlSemantics\Core\Binding\BoundRelation::class)]
39#[CoversClass(\SqlSemantics\Core\Binding\IdentitySequence::class)]
40#[CoversClass(\SqlSemantics\Core\Binding\Scope::class)]
41#[CoversClass(\SqlSemantics\Core\Binding\TableResolver::class)]
42#[CoversClass(\SqlSemantics\Core\Model\ColumnBinding::class)]
43#[CoversClass(\SqlSemantics\Core\Model\Expression::class)]
44#[CoversClass(\SqlSemantics\Core\Model\Join::class)]
45#[CoversClass(\SqlSemantics\Core\Model\Ordering::class)]
46#[CoversClass(\SqlSemantics\Core\Model\OutputColumn::class)]
47#[CoversClass(\SqlSemantics\Core\Model\BoundSelect::class)]
48#[CoversClass(\SqlSemantics\Core\Model\TableUse::class)]
49#[CoversClass(\SqlSemantics\Core\Schema::class)]
50#[CoversClass(\SqlSemantics\Core\Schema\TableConstraint::class)]
51#[CoversClass(\SqlSemantics\Core\Schema\TableDefinition::class)]
52#[CoversClass(SemanticException::class)]
53#[CoversClass(\SqlSemantics\Core\Type\TypeDescriptor::class)]
54#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Core\Policy\SyntaxRules::class)]
55#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\PostgreSql\QueryRules::class)]
56#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\PostgreSql\Platform::class)]
57#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\PostgreSql\TypeRules::class)]
58#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\PostgreSql\NameRules::class)]
59#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\PostgreSql\SchemaRules::class)]
60#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\Sqlite\QueryRules::class)]
61#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\Sqlite\Platform::class)]
62#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\Sqlite\TypeRules::class)]
63#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\Sqlite\NameRules::class)]
64#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\Sqlite\SchemaRules::class)]
65#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\MySql\QueryRules::class)]
66#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\MySql\Platform::class)]
67#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\MySql\TypeRules::class)]
68#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\MySql\NameRules::class)]
69#[\PHPUnit\Framework\Attributes\UsesClass(\SqlSemantics\Platform\MySql\SchemaRules::class)]
70#[Medium]
71final class ColumnDefinitionTest extends TestCase
72{
73    public function testKeepsDefaultsAsOriginalSyntax(): void
74    {
75        $column = (new SchemaBuilder(PostgreSqlDialect::PostgreSql))->build('CREATE TABLE users (score INTEGER DEFAULT 42)')->tables[0]->columns[0];
76        self::assertSame(Nullability::MaybeNull, $column->nullability);
77        self::assertNotNull($column->defaultExpression);
78        self::assertSame('DEFAULT 42', trim(\SqlSemantics\Statement\Writer::render($column->defaultExpression)));
79    }
80
81    public function testWithNullabilityPreservesAllTypedAttributes(): void
82    {
83        $column = (new \SqlSemantics\Facade\Schema(PostgreSqlDialect::PostgreSql))->analyze('CREATE TABLE t (label TEXT COLLATE "C" DEFAULT \'hello\')')->tables[0]->columns[0];
84        $refined = $column->withNullability(Nullability::NotNull);
85        self::assertSame(Nullability::MaybeNull, $column->nullability);
86        self::assertSame(Nullability::NotNull, $refined->nullability);
87        self::assertSame($column->attributes, $refined->attributes);
88        self::assertSame($column->collation, $refined->collation);
89        self::assertSame($column->defaultExpression, $refined->defaultExpression);
90    }
91
92}
93