Add test for uuid (#248)

darkdef · web-flow · commit 54ca29ed7429 · 2023-03-10T23:43:03.000+03:00
* Add test for uuid

* styleci fix
diff --git a/tests/CommandTest.php b/tests/CommandTest.php
@@ -293,4 +293,27 @@ public function testUpsert(array $firstData, array $secondData): void
     {
         parent::testUpsert($firstData, $secondData);
     }
+
+    public function testinsertWithReturningPksUuid(): void
+    {
+        $db = $this->getConnection(true);
+        $insertedUuid = '875343b3-6bd0-4bec-81bb-aa68bb52d945';
+
+        $command = $db->createCommand();
+        $result = $command->insertWithReturningPks(
+            '{{%table_uuid}}',
+            [
+                'col' => 'test',
+            ],
+        );
+
+        $this->assertIsString($result['uuid']);
+
+        // for example ['uuid' => 738146be-87b1-49f2-9913-36142fb6fcbe]
+        $this->assertStringMatchesFormat('%s-%s-%s-%s-%s', $result['uuid']);
+
+        $this->assertEquals(36, strlen($result['uuid']));
+
+        $db->close();
+    }
 }
diff --git a/tests/Provider/SchemaProvider.php b/tests/Provider/SchemaProvider.php
@@ -338,6 +338,37 @@ public static function columns(): array
                 ],
                 'animal',
             ],
+            [
+                [
+                    'uuid' => [
+                        'type' => 'string',
+                        'dbType' => 'uuid',
+                        'phpType' => 'string',
+                        'primaryKey' => true,
+                        'allowNull' => false,
+                        'autoIncrement' => false,
+                        'enumValues' => null,
+                        'size' => null,
+                        'precision' => null,
+                        'scale' => null,
+                        'defaultValue' => null,
+                    ],
+                    'col' => [
+                        'type' => 'string',
+                        'dbType' => 'varchar',
+                        'phpType' => 'string',
+                        'primaryKey' => false,
+                        'allowNull' => true,
+                        'autoIncrement' => false,
+                        'enumValues' => null,
+                        'size' => 16,
+                        'precision' => null,
+                        'scale' => null,
+                        'defaultValue' => null,
+                    ],
+                ],
+                'table_uuid',
+            ],
         ];
     }
 
diff --git a/tests/Support/Fixture/pgsql.sql b/tests/Support/Fixture/pgsql.sql
@@ -34,13 +34,16 @@ DROP TABLE IF EXISTS "T_constraints_1";
 DROP TABLE IF EXISTS "T_upsert";
 DROP TABLE IF EXISTS "T_upsert_1";
 DROP TABLE IF EXISTS "table_with_array_col";
+DROP TABLE IF EXISTS "table_uuid";
 
 DROP SCHEMA IF EXISTS "schema1" CASCADE;
 DROP SCHEMA IF EXISTS "schema2" CASCADE;
 
 CREATE SCHEMA "schema1";
 CREATE SCHEMA "schema2";
 
+CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
+
 CREATE TABLE "constraints"
 (
   id integer not null,
@@ -431,3 +434,8 @@ CREATE TABLE "table_with_array_col" (
     "id" SERIAL NOT NULL PRIMARY KEY,
     "array_col"  integer ARRAY[4]
 );
+
+CREATE TABLE "table_uuid" (
+    "uuid" uuid NOT NULL PRIMARY KEY DEFAULT uuid_generate_v4(),
+    "col" varchar(16)
+);
