The congress.db.api Module¶

congress.db.api.commit_unlock_tables(session)¶

Commit and unlock tables for supported backends: MySQL and PostgreSQL

congress.db.api.get_engine()¶

Helper method to grab engine.

congress.db.api.get_locking_session()¶

Obtain db_session that works with table locking

supported backends: MySQL and PostgreSQL return default session if backend not supported (eg. sqlite)

congress.db.api.get_session(autocommit=True, expire_on_commit=False, make_new=False)¶

Helper method to grab session.

congress.db.api.is_mysql()¶

Return true if and only if database backend is mysql

congress.db.api.is_postgres()¶

Return true if and only if database backend is postgres

congress.db.api.is_sqlite()¶

Return true if and only if database backend is sqlite

congress.db.api.lock_tables(session, tables)¶

Write-lock tables for supported backends: MySQL and PostgreSQL

congress.db.api.rollback_unlock_tables(session)¶

Rollback and unlock tables

supported backends: MySQL and PostgreSQL