timelink.migrations package

timelink.migrations.autogenerate(db_url, message)

Autogenerate migration script.

timelink.migrations.column_exists(table_name, column_name, alembic_op)

Check if a column exists

Parameters:

• table_name – name of table

• column_name – name of column

• alembic_op – alembic operations object in use

Example:

timelink.migrations.current(db_url, verbose=False)

Get the current revision of the database.

timelink.migrations.downgrade(db_url, revision)

Downgrade the database to the given revision.

timelink.migrations.get_versions(base='base', head='heads')

Get the list of versions of the database.

Parameters:

• base (str) – The base revision to start from.

• head (str) – The head revision to stop at.

timelink.migrations.heads(db_url)

Show heads of database

timelink.migrations.history(verbose=False)

Show the migration history.

timelink.migrations.revision(db_url, message, autogenerate=False)

Create a new revision.

timelink.migrations.set_db_url(db_url)

Set the database URL in the alembic configuration.

This should be done before running any alembic commands in a specific database

timelink.migrations.stamp(db_url, revision: str)

Stamp current revision to a given revision Use “heads” to mark the database as up-to-date

timelink.migrations.upgrade(db_url, revision='heads')

Upgrade the database to a given revision (default most recent).

Submodules

timelink.migrations.alembic_extensions module

class timelink.migrations.alembic_extensions.CreateViewOp(target)

class timelink.migrations.alembic_extensions.DropViewOp(target)

class timelink.migrations.alembic_extensions.ReplaceableObject(name, sqltext)

A class for creating replaceable database objects.

“We first need to create a simple object that represents the “CREATE View” / “DROP View” aspect of what it is we’re building. We can just as well put strings inside dictionaries, which would also work. Nevertheless, I will illustrate how this object helps organize the code below.”

class timelink.migrations.alembic_extensions.ReversibleOp(target)

classmethod invoke_for_target(operations, target)

This method is proxied on the Operations class, via the Operations.drop_view() method.

classmethod replace(operations, target, replaces=None, replace_with=None)

This method is proxied on the Operations class, via the Operations.replace_view() method.