Full Stack Python

All topics | Blog | Supporter's Edition | @fullstackpython | Facebook | What's new?

sqlalchemy.sql.util ClauseAdapter Example Code

ClauseAdapter is a class within the sqlalchemy.sql.util module of the SQLAlchemy project.

Example 1 from sqlalchemy-utils

sqlalchemy-utils (project documentation and PyPI package information) is a code library with various helper functions and new data types that make it easier to use SQLAlchemy when building projects that involve more specific storage requirements such as currency. The wide array of data types includes ranged values and aggregated attributes.

sqlalchemy-utils / sqlalchemy_utils / relationships / init.py

# __init__.py
import sqlalchemy as sa
from sqlalchemy.sql.util import ClauseAdapter

from .chained_join import chained_join  # noqa


def path_to_relationships(path, cls):
    relationships = []
    for path_name in path.split('.'):
        rel = getattr(cls, path_name)
        relationships.append(rel)
        cls = rel.mapper.class_
    return relationships


def adapt_expr(expr, *selectables):
    for selectable in selectables:
        expr = ClauseAdapter(selectable).traverse(expr)
    return expr


def inverse_join(selectable, left_alias, right_alias, relationship):
    if relationship.property.secondary is not None:
        secondary_alias = sa.alias(relationship.property.secondary)
        return selectable.join(
            secondary_alias,
            adapt_expr(
                relationship.property.secondaryjoin,
                sa.inspect(left_alias).selectable,
                secondary_alias
            )
        ).join(
            right_alias,
            adapt_expr(
                relationship.property.primaryjoin,
                sa.inspect(right_alias).selectable,
                secondary_alias
            )
        )
    else:
        join = sa.orm.join(right_alias, left_alias, relationship)
        onclause = join.onclause


## ... source file continues with no further ClauseAdapter examples...

Sponsored By

Software errors are inevitable. Chaos is not. Try Sentry for free.

The most accurate speech-to-text API. Built for Python developers.

Table of Contents

1. Introduction 2. Development Environments 3. Data 4. Web Development 5. Deployment 6. DevOps Changelog What Full Stack Means About the Author Future Directions Page Statuses SQLAlchemy Extensions SQLAlchemy Example Code SQLAlchemy Models sqlalchemy.databases mysql sqlalchemy.dialects mssql sqlalchemy.dialects mysql sqlalchemy.dialects oracle sqlalchemy.schema DDL sqlalchemy.dialects postgresql sqlalchemy.sql.expression Function sqlalchemy.dialects sqlite sqlalchemy.dialects.mysql pymysql sqlalchemy.dialects.postgresql ARRAY sqlalchemy.dialects.postgresql BIGINT sqlalchemy.dialects.postgresql BIT sqlalchemy.dialects.postgresql DOUBLE_PRECISION sqlalchemy.dialects.postgresql ExcludeConstraint sqlalchemy.dialects.postgresql INTEGER sqlalchemy.dialects.postgresql JSON sqlalchemy.dialects.postgresql TSVECTOR sqlalchemy.dialects.postgresql pypostgresql sqlalchemy.dialects.postgresql.base PGCompiler sqlalchemy.dialects.postgresql.base PGIdentifierPreparer sqlalchemy.dialects.postgresql.base PGTypeCompiler sqlalchemy.dialects.postgresql.psycopg2 PGDialect_psycopg2 sqlalchemy.dialects.sqlite pysqlite sqlalchemy.engine Connection sqlalchemy.engine Engine sqlalchemy.engine create_engine sqlalchemy.engine default sqlalchemy.engine url sqlalchemy.engine.default DefaultDialect sqlalchemy.engine.interfaces ExecutionContext sqlalchemy.engine.result ResultMetaData sqlalchemy.engine.result RowProxy sqlalchemy.engine.strategies EngineStrategy sqlalchemy.engine.strategies MockEngineStrategy sqlalchemy.engine.url make_url sqlalchemy.events SchemaEventTarget sqlalchemy.exc ArgumentError sqlalchemy.exc DataError sqlalchemy.exc DatabaseError sqlalchemy.exc IntegrityError sqlalchemy.exc InvalidRequestError sqlalchemy.exc NoInspectionAvailable sqlalchemy.exc NoSuchTableError sqlalchemy.exc OperationalError sqlalchemy.exc ProgrammingError sqlalchemy.exc UnsupportedCompilationError sqlalchemy.ext compiler sqlalchemy.ext.associationproxy AssociationProxy sqlalchemy.ext.automap automap_base sqlalchemy.ext.compiler compiles sqlalchemy.ext.declarative DeclarativeMeta sqlalchemy.ext.declarative declarative_base sqlalchemy.ext.hybrid hybrid_method sqlalchemy.ext.hybrid hybrid_property sqlalchemy.ext.mutable Mutable sqlalchemy.inspection inspect sqlalchemy.orm ColumnProperty sqlalchemy.orm CompositeProperty sqlalchemy.orm Load sqlalchemy.orm Query sqlalchemy.orm RelationshipProperty sqlalchemy.orm SynonymProperty sqlalchemy.orm aliased sqlalchemy.orm attributes sqlalchemy.orm backref sqlalchemy.orm class_mapper sqlalchemy.orm column_property sqlalchemy.orm composite sqlalchemy.orm interfaces sqlalchemy.orm mapper sqlalchemy.orm mapperlib sqlalchemy.orm object_mapper sqlalchemy.orm object_session sqlalchemy.orm relationship sqlalchemy.orm session sqlalchemy.orm sessionmaker sqlalchemy.orm strategies sqlalchemy.orm.attributes InstrumentedAttribute sqlalchemy.orm.attributes QueryableAttribute sqlalchemy.orm.attributes flag_modified sqlalchemy.orm.collections InstrumentedList sqlalchemy.orm.exc NoResultFound sqlalchemy.orm.exc UnmappedClassError sqlalchemy.orm.exc UnmappedInstanceError sqlalchemy.orm.interfaces MapperProperty sqlalchemy.orm.interfaces PropComparator sqlalchemy.orm.mapper Mapper sqlalchemy.orm.properties ColumnProperty sqlalchemy.orm.properties RelationshipProperty sqlalchemy.orm.query Query sqlalchemy.orm.query QueryContext sqlalchemy.orm.relationships RelationshipProperty sqlalchemy.orm.session Session sqlalchemy.orm.session object_session sqlalchemy.orm.util AliasedClass sqlalchemy.orm.util AliasedInsp sqlalchemy.orm.util identity_key sqlalchemy.pool NullPool sqlalchemy.pool StaticPool sqlalchemy.schema CheckConstraint sqlalchemy.schema Column sqlalchemy.schema CreateIndex sqlalchemy.schema CreateTable sqlalchemy.schema DDLElement sqlalchemy.schema ForeignKey sqlalchemy.schema ForeignKeyConstraint sqlalchemy.schema Index sqlalchemy.schema PrimaryKeyConstraint sqlalchemy.schema Table sqlalchemy.sql ClauseElement sqlalchemy.sql column sqlalchemy.sql expression sqlalchemy.sql extract sqlalchemy.sql functions sqlalchemy.sql operators sqlalchemy.sql schema sqlalchemy.sql select sqlalchemy.sql sqltypes sqlalchemy.sql table sqlalchemy.sql.compiler SQLCompiler sqlalchemy.sql.elements ColumnElement sqlalchemy.sql.elements Label sqlalchemy.sql.expression ClauseElement sqlalchemy.sql.expression ColumnClause sqlalchemy.sql.expression ColumnElement sqlalchemy.sql.expression Executable sqlalchemy.sql.expression FunctionElement sqlalchemy.sql.expression UnaryExpression sqlalchemy.sql.functions FunctionElement sqlalchemy.sql.functions GenericFunction sqlalchemy.sql.naming conv sqlalchemy.sql.schema Column sqlalchemy.sql.schema SchemaItem sqlalchemy.sql.sqltypes NullType sqlalchemy.sql.util ClauseAdapter sqlalchemy.sql.visitors traverse sqlalchemy.types Boolean sqlalchemy.types Date sqlalchemy.types DateTime sqlalchemy.types Enum sqlalchemy.types Float sqlalchemy.types Integer sqlalchemy.types Interval sqlalchemy.types NULLTYPE sqlalchemy.types String sqlalchemy.types Text sqlalchemy.types Time sqlalchemy.types TypeEngine sqlalchemy.types UserDefinedType sqlalchemy.types to_instance sqlalchemy.util OrderedDict sqlalchemy.util OrderedSet sqlalchemy.util set_creation_order sqlalchemy.util symbol sqlalchemy.util topological sqlalchemy.util.langhelpers public_factory sqlalchemy.util.langhelpers symbol ...or view the full table of contents.

Full Stack Python

Full Stack Python is an open book that explains concepts in plain language and provides helpful resources for those topics.

Updates via Twitter & Facebook.

Chapters

1. Introduction 2. Development Environments 3. Data 4. Web Development 5. Deployment 6. DevOps Changelog What Full Stack Means About the Author Future Directions Page Statuses » sqlalchemy.sql.util ClauseAdapter ...or view the full table of contents.

Matt Makai 2012-2021