Define ignored tables in alembic.ini

Exclude_tables.md

Add this in your ini file:

[alembic:exclude]
tables = spatial_ref_sys

In env.py:

    import re 
    
    def exclude_tables_from_config(config_):
        tables_ = config_.get("tables", None)
        if tables_ is not None:
            tables = tables_.split(",")
        return tables
        
    # Changes from: https://gist.github.com/utek/6163250#gistcomment-3851168
    exclude_tables = re.sub(r"\s+", '',  # replace whitespace
                        config.get_main_option('exclude', '')).split(',')


    def include_object(object, name, type_, *args, **kwargs):
        return not (type_ == 'table' and name in exclude_tables)
     
    def run_migrations_offline():
        """Run migrations in 'offline' mode.
    
        This configures the context with just a URL
        and not an Engine, though an Engine is acceptable
        here as well.  By skipping the Engine creation
        we don't even need a DBAPI to be available.
    
        Calls to context.execute() here emit the given string to the
        script output.
    
        """
        # url = config.get_main_option("sqlalchemy.url")
        context.configure(url=engine.url, include_object=include_object)
    
        with context.begin_transaction():
            context.run_migrations()
    
    
    def run_migrations_online():
        """Run migrations in 'online' mode.
    
        In this scenario we need to create an Engine
        and associate a connection with the context.
    
        """
        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()

Another approach is given in the docs if instead of explicitly excluding tables, you would for example prefer to include tables only defined in the model (which turned out to my reason ending up here 😀):

target_metadata = MyModel.metadata

def include_name(name, type_, parent_names):
    if type_ == "table":
        return name in target_metadata.tables
    else:
        return True

and then passed to context in the run functions as before:

context.configure(
    # ...
    target_metadata = target_metadata,
    include_name = include_name,
    include_schemas = False
)

@heathhenley Simple! and working perfectly for me. Thanks👍

@heathhenley Works like a charm, thanks!

thanks, everything worked 👍👍

In addition to @heathhenley comment, you need to configure context in do_run_migrations, which will be executed in run_migrations online.

def do_run_migrations(connection: Connection) -> None:
    context.configure(
        connection=connection,
        target_metadata=target_metadata,
        include_name=include_name,
        include_schemas=False
    )

    with context.begin_transaction():
        context.run_migrations()