I'm using alembic to manage database migrations as per user defined sqlalchemy models. My challenge is that I'd like for alembic to ignore any creation, deletion, or changes to a specific set of tables.
Note: My Q is similar to this question Ignoring a model when using alembic autogenerate but is different in that I want to control alembic from outside the model definition.
Here's a sample table I want to ignore:
from sqlalchemy import MetaData
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base(metadata=MetaData())
class Ignore1(Base):
"""
Signed in to the account...
"""
__tablename__ = 'ignore_1'
__table_args__ = {
'info':{'skip_autogenerate':True}
}
id = Column(Integer, primary_key=True)
foo = Column(String(20), nullable=True)
Example code (which does not solve my issue):
In alembic/env.py
# Ideally this is stored in my actual database, but for now, let's assume we have a list...
IGNORE_TABLES = ['ignore_1', 'ignore_2']
def include_object(object, name, type_, reflected, compare_to):
"""
Should you include this table or not?
"""
if type_ == 'table' and (name in IGNORE_TABLES or object.info.get("skip_autogenerate", False)):
return False
elif type_ == "column" and object.info.get("skip_autogenerate", False):
return False
return True
# Then add to config
context.configure(
...
include_object=include_object,
...
)
from Alembic ignore specific tables
No comments:
Post a Comment