Skip to content

Instantly share code, notes, and snippets.

@nathancahill
Created September 14, 2014 20:24
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nathancahill/aeec99f6a3423c5ada77 to your computer and use it in GitHub Desktop.
Save nathancahill/aeec99f6a3423c5ada77 to your computer and use it in GitHub Desktop.
Exclude spatial_ref_sys from Alembic
"""
Mirror of code here: http://dev.utek.pl/2013/ignoring-tables-in-alembic/
Usage:
[alembic:exclude]
tables = spatial_ref_sys
"""
def exclude_tables_from_config(config_):
tables_ = config_.get("tables", None)
if tables_ is not None:
tables = tables_.split(",")
return tables
exclude_tables = exclude_tables_from_config(config.get_section('alembic:exclude'))
def include_object(object, name, type_, reflected, compare_to):
if type_ == "table" and name in exclude_tables:
return False
else:
return True
def run_migrations_online():
if isinstance(engine, Engine):
connection = engine.connect()
else:
raise Exception('Expected engine instance got %s instead' % type(engine))
context.configure(
connection=connection,
target_metadata=target_metadata,
include_object=include_object
)
try:
with context.begin_transaction():
context.run_migrations()
finally:
connection.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment