sqlalchemy Objects #sqlalchemy

sqlalchemy.py

"""Aliases for SQL/SQLAlchemy objects that are assured to be correctly type-checked.

https://gist.github.com/Stiivi/8618942769b0bc6a8ba3371c4431ad75
"""

import sqlalchemy


# Engine
# ======
Engine = sqlalchemy.engine.base.Engine
Connection = sqlalchemy.engine.base.Connection
Connectable = sqlalchemy.engine.base.Connectable
create_engine = sqlalchemy.engine.create_engine

ResultProxy = sqlalchemy.engine.result.ResultProxy
RowProxy = sqlalchemy.engine.result.RowProxy


# Schema
# ======
MetaData = sqlalchemy.sql.schema.MetaData
Column = sqlalchemy.sql.schema.Column
Table = sqlalchemy.sql.schema.Table

# Elements
# ========
ColumnElement = sqlalchemy.sql.elements.ColumnElement
and_ = sqlalchemy.sql.elements.and_
or_ = sqlalchemy.sql.elements.or_
not_ = sqlalchemy.sql.elements.not_

# Selectables
# ===========
Select = sqlalchemy.sql.selectable.Select
FromClause = sqlalchemy.sql.selectable.FromClause


# Functions and Expressions
# =========================
extract = sqlalchemy.sql.expression.extract
case = sqlalchemy.sql.expression.case

func = sqlalchemy.sql.expression.func
join = sqlalchemy.sql.expression.join
select = sqlalchemy.sql.expression.select


# Operators
# =========
le = sqlalchemy.sql.operators.le
lt = sqlalchemy.sql.operators.lt
ge = sqlalchemy.sql.operators.ge
gt = sqlalchemy.sql.operators.gt

# Exceptions
# ==========

NoSuchTableError = sqlalchemy.exc.NoSuchTableError