I am running mysql in production but would like to run a simple tests in a sqlite in memory db.
The legacy mysql db has tables with columns that are mysql specific types, Which are declared in declarative models (subclassing declarative_base). I would like to run some simple tests without going to mysql and so would need to swap out the columns of the model. How do I do this? I've tried writing a patcher/unpatcher to swap out table in my model, but when I run some tests, I get OperationalError: (OperationalError) near ")": syntax error u'\nCREATE TABLE my_table (\n)\n\n' () Which makes my think that I am not patching the columns properly. Does anyone know how I can do this? What am I doing wrong? Currently, I create new columns and attach brand new Table object to __table__ and save the old table. The DB is created, create_all() is and convert_columns is run in setUp. drop_all() and revert_columns is run during tearDown in my tests mysql_sqlite_mapping = {INTEGER: Integer, MEDIUMINT: Integer, TEXT: text} def convert_columns(self, my_class, mapping): for column in my_class.__table__.columns: if type(column.type) in mapping: replacement_col = Column(column.name, mapping[type(column.type)], primary_key=column.primary_key, nullable=column.nullable, key=column.key, unique=column.unique) converted_columns.append(replacement_col) self.registry[my_class] = my_class.__table__ my_class.__table__.metadata.remove(my_class.__table__) my_class.__table__ = Table(my_class.__table__.name, my_class.__table__.metadata) for column in converted_columns: my_class.__table__.append_column(column) return my_class def revert_columns(self, my_class): saved_table = self.registry[my_class] metadata = my_class.__table__.metadata my_class.__table__.metadata.remove(my_class.__table__) model_class.__table__ = Table(saved_table.name, metadata) for column in saved_table.columns: column.table = None my_class.__table__.append_column(column) self.registry.pop(my_class) -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.