stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.57k stars 1.54k forks source link

View B dependency on table A Issues arising from modifying A #1157

Closed liyuan116 closed 1 year ago

liyuan116 commented 1 year ago

In previous version 0.12.2, we created a view B dependency on table A and then deleted table A by changing the primary key of table A or deleting a field of table A. It is good to create a temporary table a_temp and write data from table A. Finally, it is good to delete table A and rename a_temp to Table A.

However, 0.13.3 release is not ok the error is View B depends on Table A not found What's going on? What's the right thing to do?

thanks~

liyuan116 commented 1 year ago

my error info :com.initialize.resident.thread (30): Fatal error: Could not initialize database: error in view b: no such table: main.a @jberkel can you help me? delete table a then create is histort Migration

liyuan116 commented 1 year ago

other questions 1.How to simply delete a column in a table ? 2.How to simply add a primary key to an existing table? 3.Delete Table A Whether to delete the related view and then do the following things? Create a new table without deleting original table and then import the original table data and rename new table to the original table name. @jberkel

liyuan116 commented 1 year ago

Fatal error: Could not initialize database: UNIQUE constraint failed: schema_migrations.version (code: 19)