pacificclimate / modelmeta

An ORM representation of the model metadata database
GNU General Public License v3.0
1 stars 0 forks source link

modelmeta/data/mddb-v2.sqlite migration state is erroneous #77

Open rod-glover opened 6 years ago

rod-glover commented 6 years ago

In modelmeta/data/mddb-v2.sqlite, table alembic_version indicates the database is at migration 12f290b63791 (handle variant sampling geometry). That migration includes making the columns data_files.x_dim_name and data_files.y_dim_name nullable.

However, those columns are still marked NOT NULL in the current database.

This needs to be investigated and fixed. Work on issue #68 will be necessary to experiment with this in SQLite databases. Fixing that issue may show that this is an anomaly with just this database, or it may reveal that it is a problem with the migration in SQLite, in which case that must be fixed.