sqlalchemy_helpers package

SQLAlchemy Helpers

A set of tools to integrate SQLAlchemy and Alembic in your project, with sane defauts.

sqlalchemy_helpers.__version__

this package’s version.

Type:

str

Submodules

• sqlalchemy_helpers.aio module
  • AsyncDatabaseManager
    • AsyncDatabaseManager.alembic_cfg
    • AsyncDatabaseManager.engine
    • AsyncDatabaseManager.Session
    • AsyncDatabaseManager.configured_connection()
    • AsyncDatabaseManager.create()
    • AsyncDatabaseManager.drop()
    • AsyncDatabaseManager.get_current_revision()
    • AsyncDatabaseManager.get_status()
    • AsyncDatabaseManager.sync()
    • AsyncDatabaseManager.upgrade()
  • Base
    • Base.metadata
    • Base.registry
  • get_by_pk()
  • get_one()
  • get_or_create()
  • update_or_create()
• sqlalchemy_helpers.fastapi module
• sqlalchemy_helpers.flask_ext module
  • DatabaseExtension
    • DatabaseExtension.before_request()
    • DatabaseExtension.init_app()
    • DatabaseExtension.manager
    • DatabaseExtension.session
    • DatabaseExtension.teardown()
  • first_or_404()
  • get_or_404()
  • get_url_from_app()
• sqlalchemy_helpers.manager module
  • Base
    • Base.metadata
    • Base.registry
  • BaseDatabaseManager
    • BaseDatabaseManager.alembic_cfg
    • BaseDatabaseManager.engine
    • BaseDatabaseManager.Session
    • BaseDatabaseManager.get_latest_revision()
  • DatabaseManager
    • DatabaseManager.alembic_cfg
    • DatabaseManager.engine
    • DatabaseManager.Session
    • DatabaseManager.create()
    • DatabaseManager.drop()
    • DatabaseManager.get_current_revision()
    • DatabaseManager.get_status()
    • DatabaseManager.sync()
    • DatabaseManager.upgrade()
  • DatabaseStatus
    • DatabaseStatus.NO_INFO
    • DatabaseStatus.UPGRADE_AVAILABLE
    • DatabaseStatus.UP_TO_DATE
  • SyncResult
    • SyncResult.ALREADY_UP_TO_DATE
    • SyncResult.CREATED
    • SyncResult.UPGRADED
  • exists_in_db()
  • get_base()
  • get_by_pk()
  • get_one()
  • get_or_create()
  • is_sqlite()
  • model_property()
  • session_and_model_property()
  • set_sqlite_pragma()
  • update_or_create()