Quoter test (for increase test support) (#155)

darkdef · web-flow · commit 8dcf41e8058d · 2022-10-13T20:08:17.000+03:00
* Remove connection from Quoter

* Add tests for Quoter
diff --git a/tests/QuoterTest.php b/tests/QuoterTest.php
@@ -0,0 +1,57 @@
+<?php
+
+declare(strict_types=1);
+
+namespace Yiisoft\Db\Pgsql\Tests;
+
+use Yiisoft\Db\TestSupport\TestQuoterTrait;
+
+/**
+ * @group pgsql
+ */
+final class QuoterTest extends TestCase
+{
+    use TestQuoterTrait;
+
+    /**
+     * @return string[][]
+     */
+    public function simpleTableNamesProvider(): array
+    {
+        return [
+            ['test', 'test', ],
+            ['te`st', 'te`st', ],
+            ['te\'st', 'te\'st', ],
+            ['current-table-name', 'current-table-name', ],
+            ['"current-table-name"', 'current-table-name', ],
+        ];
+    }
+
+    /**
+     * @return string[][]
+     */
+    public function simpleColumnNamesProvider(): array
+    {
+        return [
+            ['test', '"test"', 'test'],
+            ['"test"', '"test"', 'test'],
+            ['*', '*', '*'],
+        ];
+    }
+
+    /**
+     * @return string[][]
+     */
+    public function columnNamesProvider(): array
+    {
+        return [
+            ['*', '*'],
+            ['table.*', '"table".*'],
+            ['"table".*', '"table".*'],
+            ['table.column', '"table"."column"'],
+            ['"table".column', '"table"."column"'],
+            ['table."column"', '"table"."column"'],
+            ['"table"."column"', '"table"."column"'],
+        ];
+    }
+}
