Add support for ULID generation in formatAsSqlFunction and update type functions

zaenalcoders · zaenalcoders · commit 9a76d1edd540 · 2025-12-02T20:41:49.000+07:00
diff --git a/src/InsertEdit.php b/src/InsertEdit.php
@@ -1068,6 +1068,13 @@ private function formatAsSqlFunction(
             return $this->dbi->quoteString($uuid);
         }
 
+        if ($editField->function === 'ULID') {
+            /* generate ULID */
+            $ulid = (string) Ulid::generate();
+
+            return $this->dbi->quoteString($ulid);
+        }
+
         if (
             in_array($editField->function, $this->getGisFromTextFunctions(), true)
             || in_array($editField->function, $this->getGisFromWKBFunctions(), true)
diff --git a/src/Types.php b/src/Types.php
@@ -395,6 +395,7 @@ public function getFunctionsClass(TypeClass $class): array
                     'SOUNDEX',
                     'SPACE',
                     'TRIM',
+                    'ULID',
                     'UNCOMPRESS',
                     'UNHEX',
                     'UPPER',
