File: GuidTest.php

package info (click to toggle)
php-doctrine-dbal 4.3.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: experimental
  • size: 5,092 kB
  • sloc: php: 60,293; xml: 618; makefile: 23
file content (43 lines) | stat: -rw-r--r-- 1,269 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?php

declare(strict_types=1);

namespace Doctrine\DBAL\Tests\Functional\Types;

use Doctrine\DBAL\Schema\Column;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Tests\FunctionalTestCase;
use Doctrine\DBAL\Types\Types;

class GuidTest extends FunctionalTestCase
{
    protected function setUp(): void
    {
        $table = Table::editor()
            ->setUnquotedName('guid_table')
            ->setColumns(
                Column::editor()
                    ->setUnquotedName('guid')
                    ->setTypeName(Types::GUID)
                    ->create(),
            )
            ->create();

        $this->dropAndCreateTable($table);
    }

    public function testInsertAndSelect(): void
    {
        $guid = '7c620eda-ea79-11eb-9a03-0242ac130003';

        $result = $this->connection->insert('guid_table', ['guid' => $guid]);
        self::assertSame(1, $result);

        $value = $this->connection->fetchOne('SELECT guid FROM guid_table');

        // the platforms with native UUID support inconsistently format the binary value
        // as a string using the lower or the upper case; this is acceptable since
        // regardless of the case they encode the same binary value
        self::assertEqualsIgnoringCase($guid, $value);
    }
}