Skip to content

Instantly share code, notes, and snippets.

@Stiivi
Last active May 4, 2022 14:45
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Stiivi/8618942769b0bc6a8ba3371c4431ad75 to your computer and use it in GitHub Desktop.
Save Stiivi/8618942769b0bc6a8ba3371c4431ad75 to your computer and use it in GitHub Desktop.
Cubes SQLAlchemy imports
"""Aliases for SQL/SQLAlchemy objects that are assured to be correctly
type-checked."""
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment