Merge pull request #7 from rafaelmb/patch-1

Sqlite compatibilty
ulearnpro · Nov 6, 2019 · 4482eab · 4482eab
2 parents a167d96 + f450317
commit 4482eab
Showing 2 changed files with 8 additions and 2 deletions.
diff --git a/app/Http/Controllers/Controller.php b/app/Http/Controllers/Controller.php
@@ -17,9 +17,9 @@ static function getColumnTable($table)
 	{
 		$columns = array();
 		$prefix  = \DB::getTablePrefix();
-		foreach (\DB::select("SHOW COLUMNS FROM $prefix$table") as $column) {
+		foreach (\DB::getSchemaBuilder()->getColumnListing($prefix.$table) as $column) {
 		   //print_r($column);
-		    $columns[$column->Field] = '';
+		    $columns[$column] = '';
 		}
 
 		$object = (object) $columns;

diff --git a/app/Providers/AppServiceProvider.php b/app/Providers/AppServiceProvider.php
@@ -24,5 +24,11 @@ public function register()
     public function boot()
     {
         //
+        if (\DB::Connection() instanceof \Illuminate\Database\SQLiteConnection) {
+            \DB::connection()->getPdo()->sqliteCreateFunction('REGEXP', function ($pattern, $value) {
+                mb_regex_encoding('UTF-8');
+                return (false !== mb_ereg($pattern, $value)) ? 1 : 0;
+            });
+        }
     }
 }