Fix #295: Fix multiline and single quote in default string value, add support for PostgreSQL 9.4 parentheses around negative numeric default values

Tigrov · web-flow · commit 2e00673fa345 · 2023-07-24T09:29:02.000+03:00
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -9,6 +9,7 @@
 - Chg #288: Typecast refactoring (@Tigrov)
 - Chg #291: Update phpTypecast for bool type (@Tigrov)
 - Enh #294: Refactoring of `Schema::normalizeDefaultValue()` method (@Tigrov)
+- Bug #295: Fix multiline and single quote in default string value, add support for PostgreSQL 9.4 parentheses around negative numeric default values (@Tigrov)
 - Bug #296: Prevent posible issues with array default values `('{one,two}'::text[])::varchar[]`, remove `ArrayParser::parseString()` (@Tigrov)
 
 ## 1.0.0 April 12, 2023
diff --git a/src/Schema.php b/src/Schema.php
@@ -863,7 +863,8 @@ private function normalizeDefaultValue(string|null $defaultValue, ColumnSchemaIn
             return new Expression($defaultValue);
         }
 
-        $value = preg_replace("/^B?['(](.*?)[)']::[^:]+$/", '$1', $defaultValue);
+        $value = preg_replace("/^B?['(](.*?)[)'](?:::[^:]+)?$/s", '$1', $defaultValue);
+        $value = str_replace("''", "'", $value);
 
         if ($column->getType() === self::TYPE_BINARY && str_starts_with($value, '\\x')) {
             return hex2bin(substr($value, 2));
diff --git a/tests/Provider/SchemaProvider.php b/tests/Provider/SchemaProvider.php
@@ -89,7 +89,7 @@ public static function columns(): array
                         'size' => 100,
                         'precision' => null,
                         'scale' => null,
-                        'defaultValue' => 'something',
+                        'defaultValue' => 'some\'thing',
                     ],
                     'char_col3' => [
                         'type' => 'text',
@@ -104,6 +104,19 @@ public static function columns(): array
                         'scale' => null,
                         'defaultValue' => null,
                     ],
+                    'char_col4' => [
+                        'type' => 'string',
+                        'dbType' => 'varchar',
+                        'phpType' => 'string',
+                        'primaryKey' => false,
+                        'allowNull' => true,
+                        'autoIncrement' => false,
+                        'enumValues' => null,
+                        'size' => null,
+                        'precision' => null,
+                        'scale' => null,
+                        'defaultValue' => "first line\nsecond line",
+                    ],
                     'float_col' => [
                         'type' => 'double',
                         'dbType' => 'float8',
diff --git a/tests/Support/Fixture/pgsql.sql b/tests/Support/Fixture/pgsql.sql
@@ -142,8 +142,9 @@ CREATE TABLE "type" (
   tinyint_col smallint DEFAULT '1',
   smallint_col smallint DEFAULT '1',
   char_col char(100) NOT NULL,
-  char_col2 varchar(100) DEFAULT 'something',
+  char_col2 varchar(100) DEFAULT 'some''thing',
   char_col3 text,
+  char_col4 character varying DEFAULT E'first line\nsecond line',
   float_col double precision NOT NULL,
   float_col2 double precision DEFAULT '1.23',
   blob_col bytea DEFAULT 'a binary value',

Original file line number	Diff line number	Diff line change
`@@ -863,7 +863,8 @@ private function normalizeDefaultValue(string\|null $defaultValue, ColumnSchemaIn`
`863`	`863`	`return new Expression($defaultValue);`
`864`	`864`	`}`
`865`	`865`
`866`		`- $value = preg_replace("/^B?['(](.*?)[)']::[^:]+$/", '$1', $defaultValue);`
	`866`	`+ $value = preg_replace("/^B?['(](.*?)[)'](?:::[^:]+)?$/s", '$1', $defaultValue);`
	`867`	`+ $value = str_replace("''", "'", $value);`
`867`	`868`
`868`	`869`	`if ($column->getType() === self::TYPE_BINARY && str_starts_with($value, '\\x')) {`
`869`	`870`	`return hex2bin(substr($value, 2));`