jpswade · August 1, 2021 10:35 · Aug 1, 2021
diff --git a/SqliteTrait.php b/SqliteTrait.php
@@ -0,0 +1,26 @@
+<?php
+
+namespace App\Traits;
+
+use Illuminate\Database\SQLiteConnection;
+use Illuminate\Support\Facades\DB;
+
+trait SqliteTrait
+{
+    protected static function setUpSqlite(): void
+    {
+        $db = DB::connection();
+        if ($db instanceof SQLiteConnection) {
+            /** Fix: no such function: CONCAT */
+            $db->getPdo()
+                ->sqliteCreateFunction(
+                    'concat',
+                    function (...$input) {
+                        return implode('', $input);
+                    }
+                );
+            /** Fix: Cannot add a NOT NULL column with default value NULL */
+           $db->getSchemaBuilder()->enableForeignKeyConstraints();
+        }
+    }
+}