How do i check, when php artisan migrate is working, has database view?
Something like this,
if(Schema::hasView('search_content')) {
return;
}
-
Try checking with hasTable only.Rahul– Rahul2019-09-16 14:55:56 +00:00Commented Sep 16, 2019 at 14:55
-
1By using DB::statement("SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';"); something like this.Rahul– Rahul2019-09-16 14:58:44 +00:00Commented Sep 16, 2019 at 14:58
Add a comment
|
2 Answers
Try this,
\DB::select("SELECT * FROM information_schema.VIEWS WHERE TABLE_NAME='table_name'")
Comments
It may not apply to everyone's needs buy I found myself into a similar problem after upgrading from Laravel 5.6 to 6.
I had a Mysql VIEW migration that needed to updated.
I'd also rather have a hasView() but instead of using hasTable() I am updating the full Mysql View statement using MySql CREATE OR REPLACE VIEW so that the view get overriden anyway.
CREATE or REPLACE VIEW full statement...
