php-migration
php-migration copied to clipboard
`SqliteDatabase#dropDatabase` ignores views
Hi,
ByJG\DbMigration\Database\SqliteDatabase#dropDatabase
ignores created views which causes errors if you're using the reset command on a database with views ("SQLSTATE[HY000]: General error: 1 table my_view already exists").
Could you provide a small example of your base.sql and migration files to help me to reproduce your issue at my side?
Bump
https://github.com/chpio/repro_byjg_migration_sqlite_view
then execute ./db reset -vvv
twice. (why is a flag needed to print sql errors? without -vvv
it just prints "-- Error migrating tables --" without an actual error).
OK, I found the issue and created PR #40.
About the -vvv
, it is the very verbose mode. Without that, only the programs only show the error.