search

chop-dbhi / data-models-sqlalchemy

SQLAlchemy models and DDL and ERD generation from chop-dbhi/data-models style JSON endpoints.
Other
11 stars 3 forks source link

Version history table statements often fail #16

Closed gracebrownecodes closed 9 years ago

gracebrownecodes commented 9 years ago

Too many DDL scripts generated by the service refer to a version_history table that often does not exist. If there were a portable "create table if not exists" statement, that would be ideal, but I think lacking that, we should just drop the idea of a version history table until a better idea presents itself. Perhaps rolling our own portable "create table if not exists" statements would be best.

gracebrownecodes commented 9 years ago

Looks like MSSQL is the only one that doesn't support create table if not exists, and I found an alternative, so I'm pushing up a version that should fix this problem.