Release: 1.4.0b1 beta release | Release Date: November 2, 2020

SQLAlchemy 1.4 Documentation

Contents | Index | Download as ZIP file

Index

Symbols | _ | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Symbols

**cparams (sqlalchemy.engine.default.DefaultDialect.connect parameter)
(sqlalchemy.engine.Dialect.connect parameter)
**dialect_kw (sqlalchemy.schema.Constraint parameter)
(sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
**dialect_kwargs (sqlalchemy.schema.MetaData.reflect parameter)
**kw (sqlalchemy.dialects.mysql.Insert.on_duplicate_key_update parameter)
(sqlalchemy.engine.URL.translate_connect_args parameter)
(sqlalchemy.events.DDLEvents.after_create parameter)
**kwargs (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.operate parameter)
(sqlalchemy.orm.ColumnProperty.Comparator.operate parameter)
(sqlalchemy.orm.PropComparator.any parameter)
**types (sqlalchemy.sql.expression.TextClause.columns parameter)
*addl_attrs (sqlalchemy.orm.defer parameter)
(sqlalchemy.orm.undefer parameter)
*args (sqlalchemy.dialects.mysql.Insert.on_duplicate_key_update parameter)
(sqlalchemy.schema.Column parameter)
(sqlalchemy.schema.Table parameter)
*cargs (sqlalchemy.engine.default.DefaultDialect.connect parameter)
(sqlalchemy.engine.Dialect.connect parameter)
*clauses (sqlalchemy.sql.expression.GenerativeSelect.group_by parameter)
(sqlalchemy.sql.expression.GenerativeSelect.order_by parameter)
(sqlalchemy.sql.expression.Select.group_by parameter)
*col_expressions (sqlalchemy.engine.CursorResult.columns parameter)
(sqlalchemy.engine.Result.columns parameter)
*cols (sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.composite parameter)
(sqlalchemy.sql.expression.TextClause.columns parameter)
*columns (sqlalchemy.orm.deferred parameter)
(sqlalchemy.schema.ColumnCollectionConstraint parameter)
(sqlalchemy.schema.UniqueConstraint parameter)
*elements (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
*entities (sqlalchemy.future.select parameter)
(sqlalchemy.orm.Query.from_self parameter)
(sqlalchemy.sql.expression.select parameter)
*enums (sqlalchemy.types.Enum parameter)
*expr (sqlalchemy.orm.Query.distinct parameter)
(sqlalchemy.orm.Query.prefix_with parameter)
(sqlalchemy.orm.Query.suffix_with parameter)
*expressions (sqlalchemy.schema.Index parameter)
*exprs (sqlalchemy.orm.Bundle parameter)
*from_obj (sqlalchemy.orm.Query.select_from parameter)
*fromclauses (sqlalchemy.sql.expression.ScalarSelect.correlate parameter)
(sqlalchemy.sql.expression.ScalarSelect.correlate_except parameter)
(sqlalchemy.sql.expression.Select.correlate parameter)
*multiparams/**params (sqlalchemy.engine.Connection.execute parameter)
*names (sqlalchemy.orm.validates parameter)
*opts (sqlalchemy.orm.Load.options parameter) , [0]
*order_by (sqlalchemy.sql.expression.within_group parameter)
*other (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.operate parameter)
(sqlalchemy.orm.ColumnProperty.Comparator.operate parameter)
(sqlalchemy.orm.PropComparator.operate parameter)
*props (sqlalchemy.orm.Query.join parameter)
*selects (sqlalchemy.sql.expression.except_ parameter)
(sqlalchemy.sql.expression.except_all parameter)
(sqlalchemy.sql.expression.intersect parameter)
*whens (sqlalchemy.sql.expression.case parameter)
1.x style
1.x-style
2.0 style
2.0-style

_

__add__() (sqlalchemy.sql.expression.ColumnOperators method)
__and__() (sqlalchemy.sql.expression.ColumnOperators method)
(sqlalchemy.sql.expression.Operators method)
__call__() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.sessionmaker method)
(sqlalchemy.schema.DDLElement method)
__delete__() (sqlalchemy.orm.InstrumentedAttribute method)
__div__() (sqlalchemy.sql.expression.ColumnOperators method)
__eq__() (sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
(sqlalchemy.orm.RelationshipProperty.Comparator method)
__ge__() (sqlalchemy.sql.expression.ColumnOperators method)
__get__() (sqlalchemy.orm.InstrumentedAttribute method)
__getitem__() (sqlalchemy.sql.expression.ColumnOperators method)
__gt__() (sqlalchemy.sql.expression.ColumnOperators method)
__hash__() (sqlalchemy.sql.expression.ColumnOperators method)
__init__() (sqlalchemy.dialects.mssql.BIT method)
(sqlalchemy.dialects.mssql.CHAR method)
(sqlalchemy.dialects.mssql.DATETIME2 method)
__invert__() (sqlalchemy.sql.expression.ColumnOperators method)
(sqlalchemy.sql.expression.Operators method)
__le__() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
__lshift__() (sqlalchemy.sql.expression.ColumnOperators method)
__lt__() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
__mod__() (sqlalchemy.sql.expression.ColumnOperators method)
__mul__() (sqlalchemy.sql.expression.ColumnOperators method)
__ne__() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
__neg__() (sqlalchemy.sql.expression.ColumnOperators method)
__or__() (sqlalchemy.sql.expression.ColumnOperators method)
(sqlalchemy.sql.expression.Operators method)
__radd__() (sqlalchemy.sql.expression.ColumnOperators method)
__rdiv__() (sqlalchemy.sql.expression.ColumnOperators method)
__rmod__() (sqlalchemy.sql.expression.ColumnOperators method)
__rmul__() (sqlalchemy.sql.expression.ColumnOperators method)
__rshift__() (sqlalchemy.sql.expression.ColumnOperators method)
__rsub__() (sqlalchemy.sql.expression.ColumnOperators method)
__rtruediv__() (sqlalchemy.sql.expression.ColumnOperators method)
__set__() (sqlalchemy.orm.InstrumentedAttribute method)
__sub__() (sqlalchemy.sql.expression.ColumnOperators method)
__truediv__() (sqlalchemy.sql.expression.ColumnOperators method)
_connection_record (sqlalchemy.pool._ConnectionFairy attribute)
_ConnectionFairy (class in sqlalchemy.pool)
_ConnectionRecord (class in sqlalchemy.pool)
_create_rule (sqlalchemy.schema.Constraint parameter)
_CreateDropBase (class in sqlalchemy.schema)
_fields (sqlalchemy.engine.Row attribute)
_get_listen_keys() (sqlalchemy.ext.mutable.Mutable class method)
_listen_on_attribute() (sqlalchemy.ext.mutable.Mutable class method)
_mapping (sqlalchemy.engine.Row attribute)
_parents (sqlalchemy.ext.mutable.Mutable attribute)
(sqlalchemy.ext.mutable.MutableBase attribute)
_type_bound (sqlalchemy.schema.Constraint parameter)

A

AbstractConcreteBase (class in sqlalchemy.ext.declarative)
ACID
ACID model
active_history (sqlalchemy.orm.AttributeEvents parameter)
(sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.composite parameter)
adapt() (sqlalchemy.types.SchemaType method)
(sqlalchemy.types.TypeEngine method)
adapt_on_names (sqlalchemy.orm.aliased parameter)
adapt_to_emulated() (sqlalchemy.types.Interval method)
adapt_to_entity() (sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
(sqlalchemy.orm.RelationshipProperty.Comparator method)
adapter (sqlalchemy.orm.PropComparator attribute)
(sqlalchemy.orm.QueryableAttribute attribute)
(sqlalchemy.orm.RelationshipProperty.Comparator attribute)
add() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.ext.mutable.MutableSet method)
(sqlalchemy.orm.scoping.scoped_session method)
add_all() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
add_column() (sqlalchemy.orm.Query method)
add_columns() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
add_criteria() (sqlalchemy.ext.baked.BakedQuery method)
add_entity() (sqlalchemy.orm.Query method)
add_is_dependent_on() (sqlalchemy.schema.Table method)
add_properties() (sqlalchemy.orm.Mapper method)
add_property() (sqlalchemy.orm.Mapper method)
AddConstraint (class in sqlalchemy.schema)
adds() (sqlalchemy.orm.collections.collection static method)
adjacent_to() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
after_attach() (sqlalchemy.orm.SessionEvents method)
after_begin() (sqlalchemy.orm.SessionEvents method)
after_bulk_delete() (sqlalchemy.orm.SessionEvents method)
after_bulk_update() (sqlalchemy.orm.SessionEvents method)
after_commit() (sqlalchemy.orm.SessionEvents method)
after_configured() (sqlalchemy.orm.MapperEvents method)
after_create() (sqlalchemy.events.DDLEvents method)
after_cursor_execute() (sqlalchemy.events.ConnectionEvents method)
after_delete() (sqlalchemy.orm.MapperEvents method)
after_drop() (sqlalchemy.events.DDLEvents method)
after_execute() (sqlalchemy.events.ConnectionEvents method)
after_flush() (sqlalchemy.orm.SessionEvents method)
after_flush_postexec() (sqlalchemy.orm.SessionEvents method)
after_insert() (sqlalchemy.orm.MapperEvents method)
after_parent_attach() (sqlalchemy.events.DDLEvents method)
after_rollback() (sqlalchemy.orm.SessionEvents method)
after_soft_rollback() (sqlalchemy.orm.SessionEvents method)
after_transaction_create() (sqlalchemy.orm.SessionEvents method)
after_transaction_end() (sqlalchemy.orm.SessionEvents method)
after_update() (sqlalchemy.orm.MapperEvents method)
against() (sqlalchemy.schema.DDLElement method)
aggregate_order_by (class in sqlalchemy.dialects.postgresql)
Alias (class in sqlalchemy.sql.expression)
alias (sqlalchemy.orm.aliased parameter)
alias() (in module sqlalchemy.sql.expression)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.CTE method)
aliased (sqlalchemy.orm.Query.join parameter)
(sqlalchemy.orm.with_polymorphic parameter)
aliased() (in module sqlalchemy.orm)
AliasedClass (class in sqlalchemy.orm.util)
AliasedInsp (class in sqlalchemy.orm.util)
AliasedReturnsRows (class in sqlalchemy.sql.expression)
aliasname (sqlalchemy.orm.polymorphic_union parameter)
All() (in module sqlalchemy.dialects.postgresql)
all() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
all_() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
all_orm_descriptors (sqlalchemy.orm.Mapper attribute)
allow_partial_pks (sqlalchemy.orm.mapper parameter)
allows_lambda (sqlalchemy.sql.expression.ColumnElement attribute)
always (sqlalchemy.schema.Identity parameter)
always_refresh (sqlalchemy.orm.mapper parameter)
AmbiguousForeignKeysError
and_() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
annotations
anon_label (sqlalchemy.schema.Column attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
ansi_bind_rules (sqlalchemy.sql.compiler.SQLCompiler attribute)
AnsiFunction (class in sqlalchemy.sql.functions)
Any() (in module sqlalchemy.dialects.postgresql)
any() (sqlalchemy.ext.associationproxy.AssociationProxyInstance method)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance method)
any_() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
any_op() (sqlalchemy.orm.RelationshipProperty.Comparator static method)
append (sqlalchemy.engine.URL.update_query_dict parameter)
(sqlalchemy.engine.URL.update_query_pairs parameter)
(sqlalchemy.engine.URL.update_query_string parameter)
append() (sqlalchemy.ext.mutable.MutableList method)
(sqlalchemy.ext.orderinglist.OrderingList method)
(sqlalchemy.orm.AttributeEvents method)
append_column() (sqlalchemy.schema.Table method)
append_constraint() (sqlalchemy.schema.Table method)
appender() (sqlalchemy.orm.collections.collection static method)
AppenderQuery (class in sqlalchemy.orm)
apply_labels() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
args (sqlalchemy.orm.InstanceEvents.init parameter)
(sqlalchemy.orm.InstanceEvents.init_failure parameter)
argument (sqlalchemy.orm.relationship parameter)
argument_for() (sqlalchemy.schema.CheckConstraint class method)
(sqlalchemy.schema.Column class method)
(sqlalchemy.schema.ColumnCollectionConstraint class method)
argument_name (sqlalchemy.schema.CheckConstraint.argument_for parameter)
(sqlalchemy.schema.Column.argument_for parameter)
(sqlalchemy.schema.ColumnCollectionConstraint.argument_for parameter)
ArgumentError
ARRAY (class in sqlalchemy.dialects.postgresql)
array (class in sqlalchemy.dialects.postgresql)
ARRAY (class in sqlalchemy.types)
array() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
ARRAY.Comparator (class in sqlalchemy.dialects.postgresql)
(class in sqlalchemy.types)
array_agg (class in sqlalchemy.sql.functions)
array_agg() (in module sqlalchemy.dialects.postgresql)
array_for_multi_clause (sqlalchemy.sql.functions.OrderedSetAgg attribute)
(sqlalchemy.sql.functions.percentile_cont attribute)
(sqlalchemy.sql.functions.percentile_disc attribute)
as_boolean() (sqlalchemy.types.JSON.Comparator method)
as_comparison() (sqlalchemy.sql.functions.FunctionElement method)
as_declarative() (in module sqlalchemy.orm)
as_declarative_base() (sqlalchemy.orm.registry method)
as_float() (sqlalchemy.types.JSON.Comparator method)
as_integer() (sqlalchemy.types.JSON.Comparator method)
as_json() (sqlalchemy.types.JSON.Comparator method)
as_mutable() (sqlalchemy.ext.mutable.Mutable class method)
as_scalar() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
(sqlalchemy.sql.expression.SelectBase method)
as_string() (sqlalchemy.types.JSON.Comparator method)
as_tuple (sqlalchemy.dialects.postgresql.ARRAY parameter)
(sqlalchemy.types.ARRAY parameter)
as_uuid (sqlalchemy.dialects.postgresql.UUID parameter)
asc() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
ascii (sqlalchemy.dialects.mysql.ENUM parameter)
(sqlalchemy.dialects.mysql.LONGTEXT parameter)
(sqlalchemy.dialects.mysql.MEDIUMTEXT parameter)
asdecimal (sqlalchemy.dialects.mssql.REAL parameter)
(sqlalchemy.dialects.oracle.DOUBLE_PRECISION parameter)
(sqlalchemy.dialects.oracle.NUMBER parameter)
AssertionPool (class in sqlalchemy.pool)
associate_with() (sqlalchemy.ext.mutable.Mutable class method)
associate_with_attribute() (sqlalchemy.ext.mutable.Mutable class method)
association relationship
ASSOCIATION_PROXY (in module sqlalchemy.ext.associationproxy)
association_proxy() (in module sqlalchemy.ext.associationproxy)
AssociationProxy (class in sqlalchemy.ext.associationproxy)
AssociationProxyInstance (class in sqlalchemy.ext.associationproxy)
astext (sqlalchemy.dialects.postgresql.JSON.Comparator attribute)
astext_type (sqlalchemy.dialects.postgresql.JSON parameter)
AsyncConnection (class in sqlalchemy.ext.asyncio)
AsyncEngine (class in sqlalchemy.ext.asyncio)
AsyncMappingResult (class in sqlalchemy.ext.asyncio)
AsyncResult (class in sqlalchemy.ext.asyncio)
AsyncScalarResult (class in sqlalchemy.ext.asyncio)
AsyncSession (class in sqlalchemy.ext.asyncio)
AsyncSessionTransaction (class in sqlalchemy.ext.asyncio)
AsyncTransaction (class in sqlalchemy.ext.asyncio)
atomicity
attr (sqlalchemy.ext.associationproxy.association_proxy parameter)
(sqlalchemy.ext.associationproxy.AssociationProxy parameter)
(sqlalchemy.ext.associationproxy.AssociationProxyInstance attribute)
attr_name (sqlalchemy.ext.indexable.index_property parameter)
attribute_instrument() (sqlalchemy.orm.InstrumentationEvents method)
attribute_mapped_collection() (in module sqlalchemy.orm.collections)
attribute_names (sqlalchemy.ext.asyncio.AsyncSession.expire parameter)
(sqlalchemy.orm.scoping.scoped_session.expire parameter)
(sqlalchemy.orm.scoping.scoped_session.refresh parameter)
AttributeEvent (class in sqlalchemy.orm)
AttributeEvents (class in sqlalchemy.orm)
AttributeState (class in sqlalchemy.orm)
attrname (sqlalchemy.ext.automap.generate_relationship parameter)
attrs (sqlalchemy.orm.InstanceEvents.expire parameter)
(sqlalchemy.orm.InstanceEvents.refresh parameter)
(sqlalchemy.orm.InstanceEvents.refresh_flush parameter)
autocommit (sqlalchemy.engine.Connection.execution_options parameter)
(sqlalchemy.orm.Session parameter)
(sqlalchemy.orm.sessionmaker parameter)
autoescape (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.contains parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.endswith parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.startswith parameter)
autoflush (sqlalchemy.orm.Session parameter)
(sqlalchemy.orm.sessionmaker parameter)
autoflush() (sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
autoincrement (sqlalchemy.schema.Column parameter)
autoload (sqlalchemy.schema.Table parameter)
autoload_replace (sqlalchemy.schema.MetaData.reflect parameter)
(sqlalchemy.schema.Table parameter)
autoload_with (sqlalchemy.schema.Table parameter)
automap_base() (in module sqlalchemy.ext.automap)
AutomapBase (class in sqlalchemy.ext.automap)

B

back_populates (sqlalchemy.orm.relationship parameter)
backref
(sqlalchemy.orm.relationship parameter)
backref() (in module sqlalchemy.orm)
bake_queries (sqlalchemy.orm.relationship parameter)
baked_lazyload() (sqlalchemy.orm.Load method) , [3]
BakedQuery (class in sqlalchemy.ext.baked)
Bakery (class in sqlalchemy.ext.baked)
bakery() (in module sqlalchemy.ext.baked)
(sqlalchemy.ext.baked.BakedQuery class method)
base (sqlalchemy.ext.automap.classname_for_table parameter)
(sqlalchemy.ext.automap.generate_relationship parameter)
(sqlalchemy.ext.automap.name_for_collection_relationship parameter)
base_columns (sqlalchemy.sql.expression.ColumnElement attribute)
base_mapper (sqlalchemy.orm.Mapper attribute)
BaseCursorResult (class in sqlalchemy.engine)
batch (sqlalchemy.orm.mapper parameter)
before_attach() (sqlalchemy.orm.SessionEvents method)
before_commit() (sqlalchemy.orm.SessionEvents method)
before_compile() (sqlalchemy.orm.QueryEvents method)
before_compile_delete() (sqlalchemy.orm.QueryEvents method)
before_compile_update() (sqlalchemy.orm.QueryEvents method)
before_configured() (sqlalchemy.orm.MapperEvents method)
before_create() (sqlalchemy.events.DDLEvents method)
before_cursor_execute() (sqlalchemy.events.ConnectionEvents method)
before_delete() (sqlalchemy.orm.MapperEvents method)
before_drop() (sqlalchemy.events.DDLEvents method)
before_execute() (sqlalchemy.events.ConnectionEvents method)
before_flush() (sqlalchemy.orm.SessionEvents method)
before_insert() (sqlalchemy.orm.MapperEvents method)
before_mapper_configured() (sqlalchemy.orm.MapperEvents method)
before_parent_attach() (sqlalchemy.events.DDLEvents method)
before_update() (sqlalchemy.orm.MapperEvents method)
begin() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
(sqlalchemy.events.ConnectionEvents method)
begin_nested() (sqlalchemy.engine.Connection method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
(sqlalchemy.ext.asyncio.AsyncSession method)
begin_twophase() (sqlalchemy.engine.Connection method)
(sqlalchemy.events.ConnectionEvents method)
between() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
BFILE (class in sqlalchemy.dialects.oracle)
bidirectional relationship
BIGINT (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
BigInteger (class in sqlalchemy.types)
BINARY (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
binary (sqlalchemy.dialects.mysql.CHAR parameter)
(sqlalchemy.dialects.mysql.ENUM parameter)
(sqlalchemy.dialects.mysql.LONGTEXT parameter)
BinaryExpression (class in sqlalchemy.sql.expression)
bind (sqlalchemy.dialects.postgresql.ENUM.create parameter)
(sqlalchemy.dialects.postgresql.ENUM.drop parameter)
(sqlalchemy.engine.reflection.Inspector parameter)
bind parameter
bind parameters
bind_arguments (sqlalchemy.orm.ORMExecuteState attribute)
(sqlalchemy.orm.ORMExecuteState.invoke_statement parameter)
(sqlalchemy.orm.scoping.scoped_session.connection parameter)
bind_expression() (sqlalchemy.types.TypeDecorator method)
(sqlalchemy.types.TypeEngine method)
bind_mapper() (sqlalchemy.orm.Session method)
bind_processor() (sqlalchemy.dialects.postgresql.HSTORE method)
(sqlalchemy.types.Boolean method)
(sqlalchemy.types.Interval method)
bind_table() (sqlalchemy.orm.Session method)
bindparam() (in module sqlalchemy.sql.expression)
BindParameter (class in sqlalchemy.sql.expression)
bindparams() (sqlalchemy.sql.expression.TextClause method)
binds (sqlalchemy.orm.Session parameter)
BIT (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.postgresql)
BLANK_SCHEMA (sqlalchemy.schema.sqlalchemy.schema attribute)
BLOB (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
bool_op() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
BOOLEAN (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Boolean (class in sqlalchemy.types)
bound parameter
bound parameters
branch (sqlalchemy.events.ConnectionEvents.engine_connect parameter)
bulk_insert_mappings() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
bulk_replace() (in module sqlalchemy.orm.collections)
(sqlalchemy.orm.AttributeEvents method)
bulk_save_objects() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
bulk_update_mappings() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
Bundle (class in sqlalchemy.orm)
BYTEA (class in sqlalchemy.dialects.postgresql)

C

c (sqlalchemy.orm.Bundle attribute)
(sqlalchemy.orm.Mapper attribute)
(sqlalchemy.schema.Table attribute)
cache (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
CacheKey (class in sqlalchemy.sql.expression)
callable_ (sqlalchemy.schema.DDLElement attribute)
(sqlalchemy.schema.DDLElement.execute_if parameter)
(sqlalchemy.sql.expression.bindparam parameter)
callables (sqlalchemy.orm.InstanceState attribute)
candidate key
cartesian product
cascade
(sqlalchemy.orm.MapperProperty attribute)
(sqlalchemy.orm.relationship parameter)
cascade_backrefs (sqlalchemy.orm.relationship parameter)
cascade_iterator() (sqlalchemy.orm.Mapper method)
(sqlalchemy.orm.MapperProperty method)
(sqlalchemy.orm.RelationshipProperty method)
cascade_scalar_deletes (sqlalchemy.ext.associationproxy.AssociationProxy parameter)
CascadeOptions (class in sqlalchemy.orm)
cascading (sqlalchemy.orm.declared_attr attribute)
Case (class in sqlalchemy.sql.expression)
case() (in module sqlalchemy.sql.expression)
case_sensitive (sqlalchemy.create_engine parameter)
Cast (class in sqlalchemy.sql.expression)
cast() (in module sqlalchemy.sql.expression)
(sqlalchemy.schema.Column method)
(sqlalchemy.sql.expression.ColumnElement method)
cast_nulls (sqlalchemy.orm.polymorphic_union parameter)
chain() (sqlalchemy.sql.visitors.ExternalTraversal method)
chained_exception (sqlalchemy.engine.ExceptionContext attribute)
changed() (sqlalchemy.ext.mutable.Mutable method)
(sqlalchemy.ext.mutable.MutableComposite method)
CHAR (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
char_length (class in sqlalchemy.sql.functions)
charset (sqlalchemy.dialects.mysql.ENUM parameter)
(sqlalchemy.dialects.mysql.LONGTEXT parameter)
(sqlalchemy.dialects.mysql.MEDIUMTEXT parameter)
check constraint
check_modified() (sqlalchemy.orm.IdentityMap method)
CheckConstraint (class in sqlalchemy.schema)
checkfirst (sqlalchemy.dialects.postgresql.ENUM.create parameter)
(sqlalchemy.dialects.postgresql.ENUM.drop parameter)
(sqlalchemy.schema.MetaData.create_all parameter)
checkin() (sqlalchemy.events.PoolEvents method)
checkout() (sqlalchemy.events.PoolEvents method)
ChunkedIteratorResult (class in sqlalchemy.engine)
CIDR (class in sqlalchemy.dialects.postgresql)
CircularDependencyError
class_ (sqlalchemy.ext.associationproxy.AssociationProxy.for_class parameter)
(sqlalchemy.orm.composite parameter)
(sqlalchemy.orm.Mapper attribute)
class_attribute (sqlalchemy.orm.MapperProperty attribute)
(sqlalchemy.orm.RelationshipProperty attribute)
(sqlalchemy.orm.SynonymProperty attribute)
class_instrument() (sqlalchemy.orm.InstrumentationEvents method)
class_manager (sqlalchemy.orm.Mapper attribute)
class_mapper() (in module sqlalchemy.orm)
class_registry (sqlalchemy.orm.declarative_base parameter)
(sqlalchemy.orm.registry parameter)
class_uninstrument() (sqlalchemy.orm.InstrumentationEvents method)
classes (sqlalchemy.ext.automap.AutomapBase attribute)
(sqlalchemy.orm.with_polymorphic parameter)
ClassManager (class in sqlalchemy.orm)
ClassManager.memoized_attribute (class in sqlalchemy.orm)
classname_for_table (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
classname_for_table() (in module sqlalchemy.ext.automap)
clause (sqlalchemy.ext.asyncio.AsyncSession.get_bind parameter)
(sqlalchemy.ext.horizontal_shard.ShardedSession.get_bind parameter)
(sqlalchemy.orm.scoping.scoped_session.connection parameter)
ClauseElement (class in sqlalchemy.sql.expression)
clauseelement (sqlalchemy.events.ConnectionEvents.after_execute parameter)
(sqlalchemy.events.ConnectionEvents.before_execute parameter)
ClauseElement.memoized_attribute (class in sqlalchemy.sql.expression)
ClauseList (class in sqlalchemy.sql.expression)
clauses (sqlalchemy.orm.CompositeProperty.Comparator attribute)
(sqlalchemy.sql.functions.FunctionElement attribute)
clear() (sqlalchemy.ext.mutable.MutableDict method)
(sqlalchemy.ext.mutable.MutableList method)
(sqlalchemy.ext.mutable.MutableSet method)
clear_compiled_cache() (sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncEngine method)
clear_mappers() (in module sqlalchemy.orm)
CLOB (class in sqlalchemy.types)
cloned_traverse() (in module sqlalchemy.sql.visitors)
close() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.LegacyCursorResult method)
close_all() (sqlalchemy.ext.asyncio.AsyncSession class method)
(sqlalchemy.orm.scoping.scoped_session class method)
(sqlalchemy.orm.Session class method)
close_all_sessions() (in module sqlalchemy.orm)
close_detached() (sqlalchemy.events.PoolEvents method)
close_with_result (sqlalchemy.orm.scoping.scoped_session.connection parameter)
(sqlalchemy.orm.Session.connection parameter)
closed (sqlalchemy.engine.Connection attribute)
cls (sqlalchemy.orm.declarative_base parameter)
(sqlalchemy.orm.registry.generate_base parameter)
(sqlalchemy.orm.registry.map_declaratively parameter)
coalesce (class in sqlalchemy.sql.functions)
coerce() (sqlalchemy.ext.mutable.Mutable class method)
(sqlalchemy.ext.mutable.MutableBase class method)
(sqlalchemy.ext.mutable.MutableDict class method)
coerce_arguments (sqlalchemy.sql.functions.GenericFunction attribute)
coerce_compared_value() (sqlalchemy.types.TypeDecorator method)
(sqlalchemy.types.TypeEngine method)
(sqlalchemy.types.UserDefinedType method)
coerce_to_is_types (sqlalchemy.types.TypeDecorator attribute)
collate() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
collation (sqlalchemy.dialects.mssql.CHAR parameter)
(sqlalchemy.dialects.mssql.TEXT parameter)
(sqlalchemy.dialects.mssql.VARCHAR parameter)
collection (class in sqlalchemy.orm.collections) , [4]
(sqlalchemy.orm.AttributeEvents.init_collection parameter)
collection_adapter (in module sqlalchemy.orm.collections)
(sqlalchemy.orm.AttributeEvents.init_collection parameter)
collection_class (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
(sqlalchemy.orm.relationship parameter)
CollectionAdapter (class in sqlalchemy.orm.collections)
cols (sqlalchemy.sql.expression.ValuesBase.return_defaults parameter)
coltype (sqlalchemy.dialects.postgresql.HSTORE.result_processor parameter)
(sqlalchemy.types.Boolean.result_processor parameter)
(sqlalchemy.types.Float.result_processor parameter)
Column (class in sqlalchemy.schema)
column (sqlalchemy.schema.ForeignKey attribute)
(sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.Table.corresponding_column parameter)
column() (in module sqlalchemy.sql.expression)
(sqlalchemy.sql.expression.Select method)
Column.memoized_attribute (class in sqlalchemy.schema)
column_attrs (sqlalchemy.orm.Mapper attribute)
column_descriptions (sqlalchemy.orm.Query attribute)
(sqlalchemy.sql.expression.Select attribute)
column_expression() (sqlalchemy.types.TypeDecorator method)
(sqlalchemy.types.TypeEngine method)
column_keys (sqlalchemy.schema.Column.compile parameter)
(sqlalchemy.schema.ForeignKeyConstraint attribute)
(sqlalchemy.schema.Table.compile parameter)
column_mapped_collection() (in module sqlalchemy.orm.collections)
column_prefix (sqlalchemy.orm.mapper parameter)
column_property() (in module sqlalchemy.orm)
column_reflect() (sqlalchemy.events.DDLEvents method)
ColumnAssociationProxyInstance (class in sqlalchemy.ext.associationproxy)
ColumnClause (class in sqlalchemy.sql.expression)
ColumnCollection (class in sqlalchemy.sql.expression)
ColumnCollectionConstraint (class in sqlalchemy.schema)
ColumnCollectionMixin (class in sqlalchemy.schema)
ColumnDefault (class in sqlalchemy.schema)
ColumnElement (class in sqlalchemy.sql.expression)
ColumnElement.memoized_attribute (class in sqlalchemy.sql.expression)
ColumnOperators (class in sqlalchemy.sql.expression)
ColumnProperty (class in sqlalchemy.orm)
ColumnProperty.Comparator (class in sqlalchemy.orm)
columns (sqlalchemy.orm.Bundle attribute)
(sqlalchemy.orm.Mapper attribute)
(sqlalchemy.schema.ColumnCollectionConstraint attribute)
columns clause
columns() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
comment (sqlalchemy.schema.Column parameter)
(sqlalchemy.schema.Table parameter)
commit() (sqlalchemy.engine.Transaction method)
(sqlalchemy.events.ConnectionEvents method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
commit_twophase() (sqlalchemy.events.ConnectionEvents method)
common_parent() (sqlalchemy.orm.Mapper method)
Comparator (class in sqlalchemy.ext.hybrid)
comparator (sqlalchemy.sql.expression.ColumnElement attribute)
(sqlalchemy.types.PickleType parameter)
comparator() (sqlalchemy.ext.hybrid.hybrid_property method)
comparator_factory (sqlalchemy.dialects.postgresql.HSTORE attribute)
(sqlalchemy.dialects.postgresql.JSON attribute)
(sqlalchemy.dialects.postgresql.JSONB attribute)
compare() (sqlalchemy.schema.Column method)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.ClauseElement method)
compare_against_backend() (sqlalchemy.types.TypeEngine method)
compare_values() (sqlalchemy.types.ARRAY method)
(sqlalchemy.types.PickleType method)
(sqlalchemy.types.TypeDecorator method)
compile() (sqlalchemy.schema.Column method)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.ClauseElement method)
compile_kwargs (sqlalchemy.engine.Compiled parameter)
(sqlalchemy.schema.Column.compile parameter)
(sqlalchemy.schema.Table.compile parameter)
compile_state (sqlalchemy.engine.Compiled attribute)
Compiled (class in sqlalchemy.engine)
compiled_cache (sqlalchemy.engine.Connection.execution_options parameter)
CompileError
compiles() (in module sqlalchemy.ext.compiler)
composite primary key
composite() (in module sqlalchemy.orm)
CompositeProperty (class in sqlalchemy.orm)
CompositeProperty.Comparator (class in sqlalchemy.orm)
CompositeProperty.CompositeBundle (class in sqlalchemy.orm)
composites (sqlalchemy.orm.Mapper attribute)
CompoundSelect (class in sqlalchemy.sql.expression)
Computed (class in sqlalchemy.schema)
concat (class in sqlalchemy.sql.functions)
concat() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
Concatenable (class in sqlalchemy.types)
Concatenable.Comparator (class in sqlalchemy.types)
concrete (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
ConcreteBase (class in sqlalchemy.ext.declarative)
ConcurrentModificationError (in module sqlalchemy.orm.exc)
configuration (sqlalchemy.engine_from_config parameter)
configure() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.sessionmaker method)
configure_mappers() (in module sqlalchemy.orm)
configured (sqlalchemy.orm.Mapper attribute)
confirm_deleted_rows (sqlalchemy.orm.mapper parameter)
conn (sqlalchemy.events.ConnectionEvents.after_cursor_execute parameter)
(sqlalchemy.events.ConnectionEvents.after_execute parameter)
(sqlalchemy.events.ConnectionEvents.before_cursor_execute parameter)
conn_type (sqlalchemy.types.TypeEngine.compare_against_backend parameter)
connect() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
connect_args (sqlalchemy.create_engine parameter)
Connection (class in sqlalchemy.engine)
(class in sqlalchemy.future)
connection (sqlalchemy.engine.Connection attribute)
(sqlalchemy.engine.default.DefaultDialect.do_begin_twophase parameter)
(sqlalchemy.engine.default.DefaultDialect.do_commit_twophase parameter)
connection() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
connection_callable() (sqlalchemy.ext.horizontal_shard.ShardedSession method)
connection_proxy (sqlalchemy.events.PoolEvents.checkout parameter)
connection_record (sqlalchemy.events.PoolEvents.checkin parameter)
(sqlalchemy.events.PoolEvents.checkout parameter)
(sqlalchemy.events.PoolEvents.connect parameter)
ConnectionEvents (class in sqlalchemy.events)
consistency
constrained
constraint
Constraint (class in sqlalchemy.schema)
constraint (sqlalchemy.dialects.postgresql.Insert.on_conflict_do_nothing parameter)
(sqlalchemy.dialects.postgresql.Insert.on_conflict_do_update parameter)
(sqlalchemy.ext.automap.name_for_collection_relationship parameter)
constraints
construct_arguments (sqlalchemy.engine.default.DefaultDialect attribute)
construct_params() (sqlalchemy.engine.Compiled method)
(sqlalchemy.sql.compiler.DDLCompiler method)
(sqlalchemy.sql.compiler.SQLCompiler method)
constructor (sqlalchemy.orm.declarative_base parameter)
(sqlalchemy.orm.registry parameter)
contained_by() (sqlalchemy.dialects.postgresql.ARRAY.Comparator method)
(sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.dialects.postgresql.JSONB.Comparator method)
contains() (in module sqlalchemy.event)
(sqlalchemy.dialects.postgresql.ARRAY.Comparator method)
(sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
contains_column() (sqlalchemy.schema.CheckConstraint method)
(sqlalchemy.schema.ColumnCollectionConstraint method)
(sqlalchemy.schema.ForeignKeyConstraint method)
contains_eager() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
context (sqlalchemy.events.ConnectionEvents.after_cursor_execute parameter)
(sqlalchemy.events.ConnectionEvents.before_cursor_execute parameter)
(sqlalchemy.events.ConnectionEvents.handle_error parameter)
conv() (in module sqlalchemy.schema)
convert_int (sqlalchemy.dialects.mssql.ROWVERSION parameter)
(sqlalchemy.dialects.mssql.TIMESTAMP parameter)
convert_unicode (sqlalchemy.create_engine parameter)
(sqlalchemy.dialects.mssql.CHAR parameter)
(sqlalchemy.dialects.mssql.TEXT parameter)
converter() (sqlalchemy.orm.collections.collection static method)
copy() (sqlalchemy.orm.ClassManager method)
(sqlalchemy.schema.Column method)
(sqlalchemy.schema.ForeignKey method)
correlate (sqlalchemy.sql.expression.Select.create_legacy_select parameter)
correlate() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Exists method)
(sqlalchemy.sql.expression.ScalarSelect method)
correlate_except() (sqlalchemy.sql.expression.Exists method)
(sqlalchemy.sql.expression.ScalarSelect method)
(sqlalchemy.sql.expression.Select method)
correlated subqueries
correlated subquery
correlates
corresponding_column() (sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.ColumnCollection method)
(sqlalchemy.sql.expression.Select method)
count (class in sqlalchemy.sql.functions)
(sqlalchemy.sql.expression.GenerativeSelect.fetch parameter)
(sqlalchemy.sql.expression.Select.fetch parameter)
count() (sqlalchemy.ext.baked.Result method)
(sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
count_from (sqlalchemy.ext.orderinglist.ordering_list parameter)
count_from_0() (in module sqlalchemy.ext.orderinglist)
count_from_1() (in module sqlalchemy.ext.orderinglist)
count_from_n_factory() (in module sqlalchemy.ext.orderinglist)
create() (sqlalchemy.dialects.postgresql.ENUM method)
(sqlalchemy.engine.URL class method)
(sqlalchemy.schema.Index method)
create_all() (sqlalchemy.schema.MetaData method)
create_async_engine() (in module sqlalchemy.ext.asyncio)
create_connect_args() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
create_constraint (sqlalchemy.dialects.mysql.BOOLEAN parameter)
(sqlalchemy.types.Boolean parameter)
(sqlalchemy.types.Enum parameter)
create_cursor() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
create_engine() (in module sqlalchemy)
(in module sqlalchemy.future)
create_legacy_select() (sqlalchemy.sql.expression.Select class method)
create_mock_engine() (in module sqlalchemy)
create_row_processor() (sqlalchemy.orm.Bundle method)
(sqlalchemy.orm.CompositeProperty.CompositeBundle method)
(sqlalchemy.orm.MapperProperty method)
create_type (sqlalchemy.dialects.postgresql.ENUM parameter)
create_xid() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
CreateColumn (class in sqlalchemy.schema)
CreateEnginePlugin (class in sqlalchemy.engine)
createfunc (sqlalchemy.util.ScopedRegistry parameter) , [4]
CreateIndex (class in sqlalchemy.schema)
CreateSchema (class in sqlalchemy.schema)
CreateSequence (class in sqlalchemy.schema)
CreateTable (class in sqlalchemy.schema)
creator (sqlalchemy.create_engine parameter)
(sqlalchemy.ext.associationproxy.association_proxy parameter)
(sqlalchemy.ext.associationproxy.AssociationProxy parameter)
criterion (sqlalchemy.orm.PropComparator.any parameter)
(sqlalchemy.orm.PropComparator.has parameter)
(sqlalchemy.orm.QueryableAttribute.any parameter)
CRUD
crud
CTE (class in sqlalchemy.sql.expression)
cte() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.HasCTE method)
cube (class in sqlalchemy.sql.functions)
cume_dist (class in sqlalchemy.sql.functions)
current_date (class in sqlalchemy.sql.functions)
current_executable (sqlalchemy.sql.compiler.SQLCompiler attribute)
current_parameters (sqlalchemy.engine.default.DefaultExecutionContext attribute)
current_time (class in sqlalchemy.sql.functions)
current_timestamp (class in sqlalchemy.sql.functions)
current_user (class in sqlalchemy.sql.functions)
cursor
(sqlalchemy.engine.ExceptionContext attribute)
(sqlalchemy.events.ConnectionEvents.after_cursor_execute parameter)
cursor() (sqlalchemy.pool._ConnectionFairy method)
CursorResult (class in sqlalchemy.engine)
custom_op (class in sqlalchemy.sql.expression)
cycle (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
cyclomatic complexity

D

data marshalling
data() (sqlalchemy.sql.expression.Values method)
data_type (sqlalchemy.schema.Sequence parameter)
database (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
database metadata
DatabaseError
DataError
datatype (sqlalchemy.ext.indexable.index_property parameter)
DATE (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.oracle)
(class in sqlalchemy.dialects.sqlite)
Date (class in sqlalchemy.types)
DATERANGE (class in sqlalchemy.dialects.postgresql)
DATETIME (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.sqlite)
(class in sqlalchemy.types)
DateTime (class in sqlalchemy.types)
DATETIME2 (class in sqlalchemy.dialects.mssql)
DATETIMEOFFSET (class in sqlalchemy.dialects.mssql)
day_precision (sqlalchemy.dialects.oracle.INTERVAL parameter)
(sqlalchemy.types.Interval parameter)
DBAPI
dbapi_connection (sqlalchemy.engine.default.DefaultDialect.do_begin parameter)
(sqlalchemy.engine.default.DefaultDialect.do_commit parameter)
(sqlalchemy.engine.default.DefaultDialect.do_rollback parameter)
dbapi_exception_translation_map (sqlalchemy.engine.default.DefaultDialect attribute)
DBAPIError
DDL
(class in sqlalchemy.schema)
ddl_compiler (sqlalchemy.engine.default.DefaultDialect attribute)
DDLCompiler (class in sqlalchemy.sql.compiler)
DDLElement (class in sqlalchemy.schema)
DDLEvents (class in sqlalchemy.events)
DECIMAL (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
decimal_return_scale (sqlalchemy.dialects.mssql.REAL parameter)
(sqlalchemy.dialects.oracle.DOUBLE_PRECISION parameter)
(sqlalchemy.dialects.oracle.NUMBER parameter)
declarative_base (sqlalchemy.ext.automap.automap_base parameter)
declarative_base() (in module sqlalchemy.orm)
declared_attr (class in sqlalchemy.orm)
default (sqlalchemy.ext.indexable.index_property parameter)
(sqlalchemy.schema.CheckConstraint.argument_for parameter)
(sqlalchemy.schema.Column parameter)
default_comparator (sqlalchemy.types.TypeEngine.Comparator attribute)
default_expr (sqlalchemy.orm.query_expression parameter)
default_from() (sqlalchemy.sql.compiler.SQLCompiler method)
default_isolation_level (sqlalchemy.engine.Connection attribute)
default_schema_name (sqlalchemy.engine.reflection.Inspector attribute)
DefaultClause (class in sqlalchemy.schema)
DefaultDialect (class in sqlalchemy.engine.default)
DefaultExecutionContext (class in sqlalchemy.engine.default)
DefaultGenerator (class in sqlalchemy.schema)
defaultload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
defer() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
deferrable (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
(sqlalchemy.schema.CheckConstraint parameter)
(sqlalchemy.schema.ColumnCollectionConstraint parameter)
deferred (sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.composite parameter)
deferred() (in module sqlalchemy.orm)
deferred_scalar_loader (sqlalchemy.orm.ClassManager attribute)
DeferredReflection (class in sqlalchemy.ext.declarative)
define_constraint_remote_table() (sqlalchemy.sql.compiler.DDLCompiler method)
defined() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
del_attribute() (in module sqlalchemy.orm.attributes)
Delete (class in sqlalchemy.sql.expression)
delete() (in module sqlalchemy.sql.expression)
(sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.ext.associationproxy.AssociationProxyInstance method)
delete_context (sqlalchemy.orm.QueryEvents.before_compile_delete parameter)
(sqlalchemy.orm.SessionEvents.after_bulk_delete parameter)
delete_extra_from_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
(sqlalchemy.sql.compiler.StrSQLCompiler method)
deleted
(sqlalchemy.ext.asyncio.AsyncSession attribute)
(sqlalchemy.orm.InstanceState attribute)
deleted_to_detached() (sqlalchemy.orm.SessionEvents method)
deleted_to_persistent() (sqlalchemy.orm.SessionEvents method)
deleter() (sqlalchemy.ext.hybrid.hybrid_property method)
denormalize_name() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
dense_rank (class in sqlalchemy.sql.functions)
deprecated_since (sqlalchemy.exc.RemovedIn20Warning attribute)
(sqlalchemy.exc.SADeprecationWarning attribute)
(sqlalchemy.exc.SAPendingDeprecationWarning attribute)
deregister() (in module sqlalchemy.ext.compiler)
desc() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
description (sqlalchemy.sql.expression.AliasedReturnsRows attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
(sqlalchemy.sql.expression.FromClause attribute)
descriptor
(sqlalchemy.orm.synonym parameter)
descriptors
Deserializer() (in module sqlalchemy.ext.serializer)
detach() (sqlalchemy.engine.Connection method)
(sqlalchemy.events.PoolEvents method)
(sqlalchemy.pool._ConnectionFairy method)
detached
(sqlalchemy.orm.InstanceState attribute)
detached_to_persistent() (sqlalchemy.orm.SessionEvents method)
DetachedInstanceError
dialect
Dialect (class in sqlalchemy.engine)
dialect (sqlalchemy.dialects.postgresql.HSTORE.bind_processor parameter)
(sqlalchemy.dialects.postgresql.HSTORE.result_processor parameter)
(sqlalchemy.engine.Compiled parameter)
dialect_impl() (sqlalchemy.types.TypeEngine method)
dialect_kwargs (sqlalchemy.schema.CheckConstraint attribute)
(sqlalchemy.schema.Column attribute)
(sqlalchemy.schema.ColumnCollectionConstraint attribute)
dialect_name (sqlalchemy.schema.CheckConstraint.argument_for parameter)
(sqlalchemy.schema.Column.argument_for parameter)
(sqlalchemy.schema.ColumnCollectionConstraint.argument_for parameter)
dialect_options (sqlalchemy.schema.CheckConstraint attribute)
(sqlalchemy.schema.Column attribute)
(sqlalchemy.schema.ColumnCollectionConstraint attribute)
DialectEvents (class in sqlalchemy.events)
DialectKWArgs (class in sqlalchemy.sql.base)
dict (sqlalchemy.orm.InstanceState attribute)
dict_ (sqlalchemy.orm.AttributeEvents.init_scalar parameter)
dict_getter() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
difference_update() (sqlalchemy.ext.mutable.MutableSet method)
difference_update_query() (sqlalchemy.engine.URL method)
dimensions (sqlalchemy.dialects.postgresql.ARRAY parameter)
(sqlalchemy.types.ARRAY parameter)
direction (sqlalchemy.ext.automap.generate_relationship parameter)
dirty (sqlalchemy.ext.asyncio.AsyncSession attribute)
(sqlalchemy.orm.scoping.scoped_session attribute)
(sqlalchemy.orm.Session attribute)
discard() (sqlalchemy.ext.mutable.MutableSet method)
DisconnectionError
discriminator
dispatch() (sqlalchemy.sql.visitors.InternalTraversal method)
display_width (sqlalchemy.dialects.mysql.BIGINT parameter)
(sqlalchemy.dialects.mysql.INTEGER parameter)
(sqlalchemy.dialects.mysql.MEDIUMINT parameter)
dispose() (sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncEngine method)
(sqlalchemy.ext.instrumentation.InstrumentationManager method)
dispose_collection() (sqlalchemy.orm.AttributeEvents method)
distinct (sqlalchemy.sql.expression.Select.create_legacy_select parameter)
distinct() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
distinct_target_key (sqlalchemy.orm.relationship parameter)
DML
do_begin() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_begin_twophase() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_close() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_commit() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_commit_twophase() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_connect() (sqlalchemy.events.DialectEvents method)
do_execute() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.events.DialectEvents method)
do_execute_no_params() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.events.DialectEvents method)
do_executemany() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.events.DialectEvents method)
do_init() (sqlalchemy.orm.ColumnProperty method)
(sqlalchemy.orm.CompositeProperty method)
(sqlalchemy.orm.MapperProperty method)
do_orm_execute() (sqlalchemy.orm.SessionEvents method)
do_prepare_twophase() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_recover_twophase() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_release_savepoint() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_rollback() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_rollback_to_savepoint() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_rollback_twophase() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_savepoint() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_set_input_sizes() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
do_setinputsizes() (sqlalchemy.events.DialectEvents method)
doc (sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.composite parameter)
(sqlalchemy.orm.relationship parameter)
domain model
DontWrapMixin (class in sqlalchemy.exc)
DOUBLE (class in sqlalchemy.dialects.mysql)
DOUBLE_PRECISION (class in sqlalchemy.dialects.oracle)
(class in sqlalchemy.dialects.postgresql)
dp_annotations_key (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_anon_name (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_boolean (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_clauseelement (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_clauseelement_list (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_clauseelement_tuple (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_clauseelement_tuples (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_dialect_options (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_dml_multi_values (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_dml_ordered_values (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_dml_values (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_fromclause_canonical_column_collection (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_fromclause_ordered_set (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_has_cache_key (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_has_cache_key_list (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_named_ddl_element (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_operator (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_plain_dict (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_plain_obj (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_prefix_sequence (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_propagate_attrs (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_statement_hint_list (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_string (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_string_clauseelement_dict (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_string_list (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_string_multi_dict (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_table_hint_list (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_type (sqlalchemy.sql.visitors.InternalTraversal attribute)
dp_unknown_structure (sqlalchemy.sql.visitors.InternalTraversal attribute)
DQL
driver (sqlalchemy.engine.Engine attribute)
drivername (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
drop() (sqlalchemy.dialects.postgresql.ENUM method)
(sqlalchemy.schema.Index method)
(sqlalchemy.schema.Sequence method)
drop_all() (sqlalchemy.schema.MetaData method)
DropConstraint (class in sqlalchemy.schema)
DropIndex (class in sqlalchemy.schema)
DropSchema (class in sqlalchemy.schema)
DropSequence (class in sqlalchemy.schema)
DropTable (class in sqlalchemy.schema)
dumps() (in module sqlalchemy.ext.serializer)
durability
dynamic_loader() (in module sqlalchemy.orm)

E

e (sqlalchemy.pool._ConnectionFairy.invalidate parameter)
(sqlalchemy.pool._ConnectionRecord.invalidate parameter)
eager load
eager loaded
eager loading
eager loads
eager_defaults (sqlalchemy.orm.mapper parameter)
eagerload() (in module sqlalchemy.orm)
echo (sqlalchemy.create_engine parameter)
(sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
echo_pool (sqlalchemy.create_engine parameter)
effective_value (sqlalchemy.sql.expression.BindParameter attribute)
element (sqlalchemy.orm.aliased parameter)
(sqlalchemy.schema.CreateTable parameter)
(sqlalchemy.sql.expression.Over attribute)
elements (sqlalchemy.schema.ForeignKeyConstraint attribute)
else_ (sqlalchemy.sql.expression.case parameter)
empty() (sqlalchemy.orm.attributes.History method)
empty_in_strategy (sqlalchemy.create_engine parameter)
enable_assertions() (sqlalchemy.orm.Query method)
enable_baked_queries (sqlalchemy.orm.Session parameter)
enable_eagerloads() (sqlalchemy.orm.Query method)
enable_from_linting (sqlalchemy.create_engine parameter)
enable_relationship_loading() (sqlalchemy.orm.Session method)
encoding (sqlalchemy.create_engine parameter)
endswith() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
Engine (class in sqlalchemy.engine)
(class in sqlalchemy.future)
engine (sqlalchemy.engine.ExceptionContext attribute)
(sqlalchemy.ext.automap.AutomapBase.prepare parameter)
engine_connect() (sqlalchemy.events.ConnectionEvents method)
engine_created() (sqlalchemy.engine.CreateEnginePlugin method)
(sqlalchemy.engine.default.DefaultDialect class method)
(sqlalchemy.engine.Dialect class method)
engine_disposed() (sqlalchemy.events.ConnectionEvents method)
engine_from_config() (in module sqlalchemy)
entities (sqlalchemy.orm.Query parameter)
entity (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.RelationshipProperty attribute)
(sqlalchemy.orm.RelationshipProperty.Comparator attribute)
entity_namespace (sqlalchemy.schema.Table attribute)
(sqlalchemy.sql.expression.FromClause attribute)
(sqlalchemy.sql.expression.TableClause attribute)
entity_or_base (sqlalchemy.orm.with_loader_criteria parameter)
ENUM (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.postgresql)
Enum (class in sqlalchemy.types)
enums (sqlalchemy.dialects.mysql.ENUM parameter)
escape (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.contains parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.endswith parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.ilike parameter)
escaped_bind_names (sqlalchemy.sql.compiler.SQLCompiler attribute)
evaluates_none() (sqlalchemy.types.TypeEngine method)
Events (class in sqlalchemy.event.base)
events (sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
examples.adjacency_list
module
examples.association
module
examples.asyncio
module
examples.custom_attributes
module
examples.dogpile_caching
module
examples.dynamic_dict
module
examples.elementtree
module
examples.extending_query
module
examples.generic_associations
module
examples.graphs
module
examples.inheritance
module
examples.join_conditions
module
examples.large_collection
module
examples.materialized_paths
module
examples.nested_sets
module
examples.performance
module
examples.postgis
module
examples.sharding
module
examples.space_invaders
module
examples.versioned_history
module
examples.versioned_rows
module
examples.vertical
module
except_() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
except_all() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
exception (sqlalchemy.engine.Connection.invalidate parameter)
(sqlalchemy.events.PoolEvents.invalidate parameter)
ExceptionContext (class in sqlalchemy.engine)
exclude_properties (sqlalchemy.orm.mapper parameter)
ExcludeConstraint (class in sqlalchemy.dialects.postgresql)
excluded (sqlalchemy.dialects.postgresql.Insert attribute)
(sqlalchemy.dialects.sqlite.Insert attribute)
exec_driver_sql() (sqlalchemy.engine.Connection method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
Executable (class in sqlalchemy.sql.expression)
execute() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
execute_chooser (sqlalchemy.ext.horizontal_shard.ShardedSession parameter)
execute_if() (sqlalchemy.schema.DDLElement method)
execute_sequence_format (sqlalchemy.engine.default.DefaultDialect attribute)
executemany (sqlalchemy.events.ConnectionEvents.after_cursor_execute parameter)
(sqlalchemy.events.ConnectionEvents.before_cursor_execute parameter)
execution_context (sqlalchemy.engine.ExceptionContext attribute)
execution_ctx_cls (sqlalchemy.engine.default.DefaultDialect attribute)
execution_options (sqlalchemy.create_engine parameter)
(sqlalchemy.engine.Compiled attribute)
(sqlalchemy.events.ConnectionEvents.after_execute parameter)
execution_options() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
ExecutionContext (class in sqlalchemy.engine)
executor (sqlalchemy.create_mock_engine parameter)
existing_adapter (sqlalchemy.orm.collections.bulk_replace parameter)
Exists (class in sqlalchemy.sql.expression)
exists() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.schema.Table method)
expanding (sqlalchemy.sql.expression.bindparam parameter)
expire
expire() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.InstanceEvents method)
(sqlalchemy.orm.scoping.scoped_session method)
expire_all() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
expire_on_commit (sqlalchemy.orm.Session parameter)
(sqlalchemy.orm.sessionmaker parameter)
expire_on_flush (sqlalchemy.orm.column_property parameter)
expired
expired_attribute_loader (sqlalchemy.orm.ClassManager attribute)
expired_attributes (sqlalchemy.orm.InstanceState attribute)
expires
Expiring
expiring
exported_columns (sqlalchemy.schema.Table attribute)
(sqlalchemy.sql.expression.FromClause attribute)
(sqlalchemy.sql.expression.ReturnsRows attribute)
expr (sqlalchemy.orm.with_expression parameter)
(sqlalchemy.sql.expression.between parameter)
expression (sqlalchemy.orm.ColumnProperty attribute)
(sqlalchemy.orm.CompositeProperty.Comparator attribute)
(sqlalchemy.schema.Column attribute)
expression() (sqlalchemy.ext.hybrid.hybrid_method method)
(sqlalchemy.ext.hybrid.hybrid_property method)
expressions (sqlalchemy.orm.ColumnProperty.Comparator attribute)
expunge() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
expunge_all() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
extend() (sqlalchemy.ext.mutable.MutableList method)
extend_existing (sqlalchemy.schema.MetaData.reflect parameter)
(sqlalchemy.schema.Table parameter)
ExtendedInstrumentationRegistry (class in sqlalchemy.ext.instrumentation)
extension_type (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
(sqlalchemy.orm.QueryableAttribute attribute)
ExternalTraversal (class in sqlalchemy.sql.visitors)
extra_dependencies (sqlalchemy.schema.sort_tables parameter)
(sqlalchemy.schema.sort_tables_and_constraints parameter)
Extract (class in sqlalchemy.sql.expression)
extract() (in module sqlalchemy.sql.expression)

F

facade
false() (in module sqlalchemy.sql.expression)
False_ (class in sqlalchemy.sql.expression)
fetch() (sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
fetchall() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
FetchedValue (class in sqlalchemy.schema)
fetchmany() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
fetchone() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
fields (sqlalchemy.dialects.postgresql.INTERVAL parameter)
filter() (sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.FunctionFilter method)
filter_by() (sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
filter_fn (sqlalchemy.schema.sort_tables_and_constraints parameter)
filter_states_for_dep() (sqlalchemy.orm.UOWTransaction method)
finalize_flush_changes() (sqlalchemy.orm.UOWTransaction method)
first() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
first_connect() (sqlalchemy.events.PoolEvents method)
first_init() (sqlalchemy.orm.InstanceEvents method)
flag_dirty() (in module sqlalchemy.orm.attributes)
flag_modified() (in module sqlalchemy.orm.attributes)
flags (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.regexp_match parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.regexp_replace parameter)
(sqlalchemy.orm.PropComparator.regexp_match parameter)
flat (sqlalchemy.orm.aliased parameter)
(sqlalchemy.orm.with_polymorphic parameter)
(sqlalchemy.sql.expression.alias parameter)
FLOAT (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Float (class in sqlalchemy.types)
flush() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
flush_context (sqlalchemy.orm.InstanceEvents.refresh_flush parameter)
(sqlalchemy.orm.SessionEvents.after_flush parameter)
(sqlalchemy.orm.SessionEvents.after_flush_postexec parameter)
FlushError
for_class() (sqlalchemy.ext.associationproxy.AssociationProxy method)
for_executemany (sqlalchemy.sql.compiler.SQLCompiler parameter)
for_proxy() (sqlalchemy.ext.associationproxy.AssociationProxyInstance class method)
for_session() (sqlalchemy.ext.baked.BakedQuery method)
for_update (sqlalchemy.schema.Sequence parameter)
force (sqlalchemy.sql.compiler.IdentifierPreparer.quote parameter)
(sqlalchemy.sql.compiler.IdentifierPreparer.quote_schema parameter)
foreign key constraint
foreign() (in module sqlalchemy.orm)
foreign_key_constraints (sqlalchemy.schema.Table attribute)
foreign_keys (sqlalchemy.orm.relationship parameter)
(sqlalchemy.schema.Table attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
ForeignKey (class in sqlalchemy.schema)
ForeignKeyConstraint (class in sqlalchemy.schema)
format_column() (sqlalchemy.sql.compiler.IdentifierPreparer method)
format_schema() (sqlalchemy.sql.compiler.IdentifierPreparer method)
format_table() (sqlalchemy.sql.compiler.IdentifierPreparer method)
format_table_seq() (sqlalchemy.sql.compiler.IdentifierPreparer method)
freeze() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
FROM clause
from_ (sqlalchemy.sql.expression.Select.join_from parameter)
from_engine() (sqlalchemy.engine.reflection.Inspector class method)
from_entity (sqlalchemy.orm.Query.with_parent parameter)
(sqlalchemy.orm.with_parent parameter)
from_joinpoint (sqlalchemy.orm.Query.join parameter)
from_obj (sqlalchemy.orm.Query.select_entity_from parameter)
(sqlalchemy.sql.expression.Select.create_legacy_select parameter)
from_select() (sqlalchemy.sql.expression.Insert method)
from_self() (sqlalchemy.orm.Query method)
from_statement() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
FromClause (class in sqlalchemy.sql.expression)
fromkeys() (sqlalchemy.orm.ClassManager method)
froms (sqlalchemy.sql.expression.Select attribute)
FrozenResult (class in sqlalchemy.engine)
fsp (sqlalchemy.dialects.mysql.DATETIME parameter)
(sqlalchemy.dialects.mysql.TIME parameter)
(sqlalchemy.dialects.mysql.TIMESTAMP parameter)
full (sqlalchemy.ext.baked.BakedQuery.spoil parameter)
(sqlalchemy.orm.Query.join parameter)
(sqlalchemy.schema.Table.join parameter)
func (in module sqlalchemy.sql.expression)
funcfilter() (in module sqlalchemy.sql.expression)
Function (class in sqlalchemy.sql.functions)
FunctionAsBinary (class in sqlalchemy.sql.functions)
FunctionElement (class in sqlalchemy.sql.functions)
FunctionFilter (class in sqlalchemy.sql.expression)
future (sqlalchemy.create_engine parameter)
(sqlalchemy.orm.Session parameter)

G

generate_base() (sqlalchemy.orm.registry method)
generate_relationship (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
generate_relationship() (in module sqlalchemy.ext.automap)
generative
GenerativeSelect (class in sqlalchemy.sql.expression)
GenericFunction (class in sqlalchemy.sql.functions)
GenericTypeCompiler (class in sqlalchemy.sql.compiler)
get() (sqlalchemy.ext.associationproxy.AssociationProxyInstance method)
(sqlalchemy.ext.baked.Result method)
(sqlalchemy.orm.ClassManager method)
get_attribute() (in module sqlalchemy.orm.attributes)
get_attribute_history() (sqlalchemy.orm.UOWTransaction method)
get_backend_name() (sqlalchemy.engine.URL method)
get_bind() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.ext.horizontal_shard.ShardedSession method)
(sqlalchemy.orm.scoping.scoped_session method)
get_check_constraints() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_children() (sqlalchemy.schema.Column method)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.ClauseElement method)
get_columns() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_current_parameters() (sqlalchemy.engine.default.DefaultExecutionContext method)
get_dbapi_type() (sqlalchemy.types.Date method)
(sqlalchemy.types.DateTime method)
(sqlalchemy.types.Integer method)
get_dialect() (sqlalchemy.engine.URL method)
get_dialect_cls() (sqlalchemy.engine.default.DefaultDialect class method)
(sqlalchemy.engine.Dialect class method)
get_driver_name() (sqlalchemy.engine.URL method)
get_enums() (sqlalchemy.dialects.postgresql.base.PGInspector method)
get_execution_options() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncEngine method)
get_foreign_keys() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_foreign_table_names() (sqlalchemy.dialects.postgresql.base.PGInspector method)
get_history() (in module sqlalchemy.orm.attributes)
(sqlalchemy.orm.CompositeProperty method)
get_indexes() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_instance_dict() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
get_isolation_level() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
get_lastrowid() (sqlalchemy.engine.default.DefaultExecutionContext method)
get_nested_transaction() (sqlalchemy.engine.Connection method)
(sqlalchemy.orm.Session method)
get_out_parameter_values() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
get_pk_constraint() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_property() (sqlalchemy.orm.Mapper method)
get_property_by_column() (sqlalchemy.orm.Mapper method)
get_raw_connection() (sqlalchemy.ext.asyncio.AsyncConnection method)
get_referent() (sqlalchemy.schema.ForeignKey method)
get_result_cursor_strategy() (sqlalchemy.engine.ExecutionContext method)
get_result_processor() (sqlalchemy.engine.default.DefaultExecutionContext method)
get_rowcount() (sqlalchemy.engine.ExecutionContext method)
get_schema_names() (sqlalchemy.engine.reflection.Inspector method)
get_select_precolumns() (sqlalchemy.sql.compiler.SQLCompiler method)
get_sequence_names() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_sorted_table_and_fkc_names() (sqlalchemy.engine.reflection.Inspector method)
get_table_comment() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_table_names() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_table_oid() (sqlalchemy.dialects.postgresql.base.PGInspector method)
get_table_options() (sqlalchemy.engine.reflection.Inspector method)
get_temp_table_names() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_temp_view_names() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_transaction() (sqlalchemy.engine.Connection method)
(sqlalchemy.orm.Session method)
get_unique_constraints() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_view_definition() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
get_view_names() (sqlalchemy.dialects.postgresql.base.PGInspector method)
(sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
getset_factory (sqlalchemy.ext.associationproxy.AssociationProxy parameter)
getter() (sqlalchemy.ext.hybrid.hybrid_property method)
group (sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.composite parameter)
group_by (sqlalchemy.sql.expression.Select.create_legacy_select parameter)
group_by() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
group_by_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
grouping_sets (class in sqlalchemy.sql.functions)

H

handle_dbapi_exception() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
handle_dialect_kwargs() (sqlalchemy.engine.CreateEnginePlugin method)
handle_error() (sqlalchemy.events.ConnectionEvents method)
handle_pool_kwargs() (sqlalchemy.engine.CreateEnginePlugin method)
has() (sqlalchemy.ext.associationproxy.AssociationProxyInstance method)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance method)
has_all() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.dialects.postgresql.JSONB.Comparator method)
has_any() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.dialects.postgresql.JSONB.Comparator method)
has_changes() (sqlalchemy.orm.attributes.History method)
has_identity (sqlalchemy.orm.InstanceState attribute)
has_index() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
has_inherited_table() (in module sqlalchemy.orm)
has_key() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.dialects.postgresql.JSONB.Comparator method)
(sqlalchemy.engine.LegacyRow method)
has_op() (sqlalchemy.orm.RelationshipProperty.Comparator static method)
has_out_parameters (sqlalchemy.sql.compiler.SQLCompiler attribute)
has_parent() (sqlalchemy.orm.ClassManager method)
has_sequence() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.reflection.Inspector method)
has_table() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
(sqlalchemy.engine.Engine method)
HasCTE (class in sqlalchemy.sql.expression)
hashable (sqlalchemy.types.ARRAY attribute)
(sqlalchemy.types.TypeEngine attribute)
HasPrefixes (class in sqlalchemy.sql.expression)
HasSuffixes (class in sqlalchemy.sql.expression)
having (sqlalchemy.sql.expression.Select.create_legacy_select parameter)
having() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
hide_parameters (sqlalchemy.create_engine parameter)
hide_password (sqlalchemy.engine.URL.render_as_string parameter)
History (class in sqlalchemy.orm.attributes)
history (sqlalchemy.orm.AttributeState attribute)
host (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
HSTORE (class in sqlalchemy.dialects.postgresql)
hstore (class in sqlalchemy.dialects.postgresql)
HSTORE.Comparator (class in sqlalchemy.dialects.postgresql)
hybrid_method (class in sqlalchemy.ext.hybrid)
HYBRID_METHOD (in module sqlalchemy.ext.hybrid)
hybrid_property (class in sqlalchemy.ext.hybrid)
HYBRID_PROPERTY (in module sqlalchemy.ext.hybrid)

I

id_chooser (sqlalchemy.ext.horizontal_shard.ShardedSession parameter)
ident (sqlalchemy.orm.Query.get parameter)
(sqlalchemy.orm.Session.get parameter)
(sqlalchemy.sql.compiler.IdentifierPreparer.quote parameter)
Identified (class in sqlalchemy.log)
identifier (sqlalchemy.sql.functions.AnsiFunction attribute)
(sqlalchemy.sql.functions.array_agg attribute)
(sqlalchemy.sql.functions.char_length attribute)
IdentifierError
IdentifierPreparer (class in sqlalchemy.sql.compiler)
Identity (class in sqlalchemy.schema)
identity (sqlalchemy.orm.InstanceState attribute)
identity map
identity_key (sqlalchemy.orm.InstanceState attribute)
identity_key() (in module sqlalchemy.orm.util)
(sqlalchemy.ext.asyncio.AsyncSession class method)
(sqlalchemy.orm.scoping.scoped_session class method)
identity_key_from_instance() (sqlalchemy.orm.Mapper method)
identity_key_from_primary_key() (sqlalchemy.orm.Mapper method)
identity_key_from_row() (sqlalchemy.orm.Mapper method)
identity_map (sqlalchemy.orm.Session attribute)
IdentityMap (class in sqlalchemy.orm)
ilike() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
IMAGE (class in sqlalchemy.dialects.mssql)
immediateload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
impl (sqlalchemy.types.Interval attribute)
(sqlalchemy.types.PickleType attribute)
implicit_returning (sqlalchemy.create_engine parameter)
(sqlalchemy.schema.Table parameter)
(sqlalchemy.sql.expression.TableClause attribute)
in_() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
in_nested_transaction() (sqlalchemy.engine.Connection method)
(sqlalchemy.orm.Session method)
in_transaction() (sqlalchemy.engine.Connection method)
(sqlalchemy.orm.Session method)
include (sqlalchemy.dialects.postgresql.base.PGInspector.get_view_names parameter)
include_aliases (sqlalchemy.orm.with_loader_criteria parameter)
include_backrefs (sqlalchemy.orm.validates parameter)
include_collections (sqlalchemy.ext.asyncio.AsyncSession.is_modified parameter)
(sqlalchemy.orm.scoping.scoped_session.is_modified parameter)
(sqlalchemy.orm.Session.is_modified parameter)
include_columns (sqlalchemy.engine.reflection.Inspector.reflect_table parameter)
(sqlalchemy.schema.Table parameter)
include_defaults (sqlalchemy.sql.expression.Insert.from_select parameter)
include_foreign_key_constraints (sqlalchemy.schema.CreateTable parameter)
include_properties (sqlalchemy.orm.mapper parameter)
include_removes (sqlalchemy.orm.validates parameter)
increment (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
Index (class in sqlalchemy.schema)
index (sqlalchemy.engine.CursorResult.scalars parameter)
(sqlalchemy.engine.Result.scalars parameter)
(sqlalchemy.ext.asyncio.AsyncResult.scalars parameter)
index_elements (sqlalchemy.dialects.postgresql.Insert.on_conflict_do_nothing parameter)
(sqlalchemy.dialects.postgresql.Insert.on_conflict_do_update parameter)
(sqlalchemy.dialects.sqlite.Insert.on_conflict_do_nothing parameter)
index_property (class in sqlalchemy.ext.indexable)
index_where (sqlalchemy.dialects.postgresql.Insert.on_conflict_do_nothing parameter)
(sqlalchemy.dialects.postgresql.Insert.on_conflict_do_update parameter)
(sqlalchemy.dialects.sqlite.Insert.on_conflict_do_nothing parameter)
Indexable (class in sqlalchemy.types)
Indexable.Comparator (class in sqlalchemy.types)
INET (class in sqlalchemy.dialects.postgresql)
info (sqlalchemy.engine.Connection attribute)
(sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.ext.associationproxy.AssociationProxy parameter)
inherit_cache (sqlalchemy.sql.functions.AnsiFunction attribute)
(sqlalchemy.sql.functions.array_agg attribute)
(sqlalchemy.sql.functions.char_length attribute)
inherit_condition (sqlalchemy.orm.mapper parameter)
inherit_foreign_keys (sqlalchemy.orm.mapper parameter)
inherit_schema (sqlalchemy.types.Enum parameter)
inherits (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
init() (sqlalchemy.orm.InstanceEvents method)
(sqlalchemy.orm.MapperProperty method)
(sqlalchemy.orm.RelationshipProperty method)
init_collection() (in module sqlalchemy.orm.attributes)
(sqlalchemy.orm.AttributeEvents method)
init_failure() (sqlalchemy.orm.InstanceEvents method)
init_scalar() (sqlalchemy.orm.AttributeEvents method)
initialize() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
initialize_instance_dict() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
initially (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
(sqlalchemy.schema.CheckConstraint parameter)
(sqlalchemy.schema.ColumnCollectionConstraint parameter)
initiator (sqlalchemy.orm.AttributeEvents.append parameter)
(sqlalchemy.orm.AttributeEvents.bulk_replace parameter)
(sqlalchemy.orm.AttributeEvents.modified parameter)
inline (sqlalchemy.dialects.mysql.insert parameter)
(sqlalchemy.dialects.postgresql.insert parameter)
(sqlalchemy.dialects.sqlite.insert parameter)
inline() (sqlalchemy.sql.expression.Insert method)
(sqlalchemy.sql.expression.Update method)
inner_columns (sqlalchemy.sql.expression.Select attribute)
innerjoin (sqlalchemy.orm.joinedload parameter)
(sqlalchemy.orm.relationship parameter)
(sqlalchemy.orm.with_polymorphic parameter)
Insert (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.postgresql)
(class in sqlalchemy.dialects.sqlite)
insert() (in module sqlalchemy.dialects.mysql)
(in module sqlalchemy.dialects.postgresql)
(in module sqlalchemy.dialects.sqlite)
insert_single_values_expr (sqlalchemy.sql.compiler.SQLCompiler attribute)
inserted (sqlalchemy.dialects.mysql.Insert attribute)
inserted_primary_key (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
inserted_primary_key_rows (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
inspect() (in module sqlalchemy)
InspectionAttr (class in sqlalchemy.orm)
InspectionAttrInfo (class in sqlalchemy.orm)
Inspector (class in sqlalchemy.engine.reflection)
install_descriptor() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
install_member() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
install_state() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
instance (sqlalchemy.ext.asyncio.AsyncSession.expire parameter)
(sqlalchemy.ext.asyncio.AsyncSession.is_modified parameter)
(sqlalchemy.orm.attributes.set_attribute parameter)
instance_state() (in module sqlalchemy.orm.attributes)
InstanceEvents (class in sqlalchemy.orm)
instances (sqlalchemy.orm.SessionEvents.before_flush parameter)
instances() (sqlalchemy.orm.Query method)
InstanceState (class in sqlalchemy.orm)
instrument_attribute() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
instrument_class() (sqlalchemy.orm.ColumnProperty method)
(sqlalchemy.orm.CompositeProperty method)
(sqlalchemy.orm.MapperEvents method)
instrument_collection_class() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
instrumentation
instrumentation_finders (in module sqlalchemy.ext.instrumentation)
INSTRUMENTATION_MANAGER (in module sqlalchemy.ext.instrumentation)
InstrumentationEvents (class in sqlalchemy.orm)
InstrumentationFactory (class in sqlalchemy.orm.instrumentation)
InstrumentationManager (class in sqlalchemy.ext.instrumentation)
instrumented
InstrumentedAttribute (class in sqlalchemy.orm)
InstrumentedDict (class in sqlalchemy.orm.collections)
InstrumentedList (class in sqlalchemy.orm.collections)
InstrumentedSet (class in sqlalchemy.orm.collections)
instrumenting
INT (in module sqlalchemy.types)
INT4RANGE (class in sqlalchemy.dialects.postgresql)
INT8RANGE (class in sqlalchemy.dialects.postgresql)
INTEGER (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Integer (class in sqlalchemy.types)
IntegrityError
InterfaceError
InternalError
internally_instrumented() (sqlalchemy.orm.collections.collection static method)
InternalTraversal (class in sqlalchemy.sql.visitors)
intersect() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
intersect_all() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
intersection_update() (sqlalchemy.ext.mutable.MutableSet method)
INTERVAL (class in sqlalchemy.dialects.oracle)
(class in sqlalchemy.dialects.postgresql)
Interval (class in sqlalchemy.types)
invalidate() (sqlalchemy.engine.Connection method)
(sqlalchemy.events.PoolEvents method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
invalidate_pool_on_disconnect (sqlalchemy.engine.ExceptionContext attribute)
invalidated (sqlalchemy.engine.Connection attribute)
InvalidatePoolError
InvalidRequestError
invoke_statement() (sqlalchemy.orm.ORMExecuteState method)
is_() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
is_active (sqlalchemy.ext.asyncio.AsyncSession attribute)
(sqlalchemy.orm.scoping.scoped_session attribute)
(sqlalchemy.orm.Session attribute)
is_aliased_class (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
is_attribute (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
is_bound() (sqlalchemy.schema.MetaData method)
(sqlalchemy.schema.ThreadLocalMetaData method)
is_bundle (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
is_clause_element (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
is_comparison (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.op parameter)
(sqlalchemy.orm.PropComparator.op parameter)
(sqlalchemy.orm.QueryableAttribute.op parameter)
is_delete (sqlalchemy.orm.ORMExecuteState attribute)
is_deleted() (sqlalchemy.orm.UOWTransaction method)
is_derived_from() (sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.AliasedReturnsRows method)
(sqlalchemy.sql.expression.FromClause method)
is_disconnect (sqlalchemy.engine.ExceptionContext attribute)
is_disconnect() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
is_distinct_from() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
is_insert (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
(sqlalchemy.orm.ORMExecuteState attribute)
is_instance (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
is_instrumented() (in module sqlalchemy.orm.instrumentation)
is_literal (sqlalchemy.sql.expression.column parameter)
is_mapper (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
(sqlalchemy.orm.Mapper attribute)
is_modified() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
is_not() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
is_not_distinct_from() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
is_orm_statement (sqlalchemy.orm.ORMExecuteState attribute)
is_prepared (sqlalchemy.engine.default.DefaultDialect.do_commit_twophase parameter)
(sqlalchemy.engine.default.DefaultDialect.do_rollback_twophase parameter)
(sqlalchemy.engine.Dialect.do_commit_twophase parameter)
is_property (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
(sqlalchemy.orm.MapperProperty attribute)
is_relationship_load (sqlalchemy.orm.ORMExecuteState attribute)
is_select (sqlalchemy.orm.ORMExecuteState attribute)
is_selectable (sqlalchemy.ext.associationproxy.AssociationProxy attribute)
(sqlalchemy.orm.InspectionAttr attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
is_sibling() (sqlalchemy.orm.Mapper method)
is_single_entity (sqlalchemy.orm.Query attribute)
is_update (sqlalchemy.orm.ORMExecuteState attribute)
is_valid (sqlalchemy.pool._ConnectionFairy attribute)
isa() (sqlalchemy.orm.Mapper method)
isdelete (sqlalchemy.sql.compiler.SQLCompiler attribute)
isnot() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
isnot_distinct_from() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
isolate_multiinsert_groups (sqlalchemy.engine.default.DefaultExecutionContext.get_current_parameters parameter)
isolated
Isolation
isolation
isolation level
isolation_level (sqlalchemy.create_engine parameter)
(sqlalchemy.engine.Connection.execution_options parameter)
isouter (sqlalchemy.orm.Query.join parameter)
(sqlalchemy.schema.Table.join parameter)
(sqlalchemy.sql.expression.FromClause.join parameter)
isoutparam (sqlalchemy.sql.expression.bindparam parameter)
item_type (sqlalchemy.dialects.postgresql.ARRAY parameter)
(sqlalchemy.types.ARRAY parameter)
items() (sqlalchemy.engine.LegacyRow method)
(sqlalchemy.engine.RowMapping method)
(sqlalchemy.orm.ClassManager method)
iterate() (in module sqlalchemy.sql.visitors)
(sqlalchemy.sql.visitors.ExternalTraversal method)
iterate_properties (sqlalchemy.orm.Mapper attribute)
iterator (sqlalchemy.sql.visitors.traverse_using parameter)
iterator() (sqlalchemy.orm.collections.collection static method)
IteratorResult (class in sqlalchemy.engine)
iterkeys() (sqlalchemy.engine.LegacyRow method)
itervalues() (sqlalchemy.engine.LegacyRow method)

J

Join (class in sqlalchemy.sql.expression)
join() (in module sqlalchemy.orm)
(in module sqlalchemy.sql.expression)
(sqlalchemy.orm.AppenderQuery method)
join_depth (sqlalchemy.orm.relationship parameter)
join_from() (sqlalchemy.sql.expression.Select method)
joinedload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
JSON (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.postgresql)
JSON.Comparator (class in sqlalchemy.dialects.postgresql)
(class in sqlalchemy.types)
JSON.JSONElementType (class in sqlalchemy.types)
JSON.JSONIndexType (class in sqlalchemy.types)
JSON.JSONIntIndexType (class in sqlalchemy.types)
JSON.JSONPathType (class in sqlalchemy.types)
JSON.JSONStrIndexType (class in sqlalchemy.types)
json_deserializer (sqlalchemy.create_engine parameter)
json_serializer (sqlalchemy.create_engine parameter)
JSONB (class in sqlalchemy.dialects.postgresql)
JSONB.Comparator (class in sqlalchemy.dialects.postgresql)

K

keep_existing (sqlalchemy.schema.Table parameter)
key (sqlalchemy.ext.mutable.Mutable.coerce parameter)
(sqlalchemy.ext.mutable.MutableBase.coerce parameter)
(sqlalchemy.orm.attributes.get_history parameter)
key_share (sqlalchemy.sql.expression.GenerativeSelect.with_for_update parameter)
(sqlalchemy.sql.expression.Select.with_for_update parameter)
key_value_pairs (sqlalchemy.engine.URL.update_query_pairs parameter)
keys() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
kwargs (sqlalchemy.engine.CreateEnginePlugin parameter)
(sqlalchemy.engine_from_config parameter)
(sqlalchemy.orm.InstanceEvents.init parameter)

L

Label (class in sqlalchemy.sql.expression)
label() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Bundle method)
(sqlalchemy.orm.Query method)
label_length (sqlalchemy.create_engine parameter)
lambda_stmt() (in module sqlalchemy.sql.expression)
LambdaElement (class in sqlalchemy.sql.expression)
LargeBinary (class in sqlalchemy.types)
last_inserted_params() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
last_updated_params() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
lastrow_has_defaults() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.default.DefaultExecutionContext method)
lastrowid (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
Lateral (class in sqlalchemy.sql.expression)
lateral() (in module sqlalchemy.sql.expression)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.Select method)
lazy (sqlalchemy.orm.relationship parameter)
lazy initialization
lazy load
lazy loaded
lazy loading
lazy loads
lazy_loaded_from (sqlalchemy.orm.ORMExecuteState attribute)
(sqlalchemy.orm.Query attribute)
lazyload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
left (sqlalchemy.sql.expression.join parameter)
(sqlalchemy.sql.expression.outerjoin parameter)
(sqlalchemy.sql.functions.FunctionAsBinary attribute)
left_index (sqlalchemy.sql.functions.FunctionElement.as_comparison parameter)
legacy_is_orphan (sqlalchemy.orm.mapper parameter)
LegacyCursorResult (class in sqlalchemy.engine)
LegacyRow (class in sqlalchemy.engine)
length (sqlalchemy.dialects.mssql.CHAR parameter)
(sqlalchemy.dialects.mssql.IMAGE parameter)
(sqlalchemy.dialects.mssql.TEXT parameter)
like() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
limit (sqlalchemy.sql.expression.GenerativeSelect.limit parameter)
(sqlalchemy.sql.expression.Select.create_legacy_select parameter)
(sqlalchemy.sql.expression.Select.limit parameter)
limit() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
link_to_name (sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
listen() (in module sqlalchemy.event)
listeners (sqlalchemy.create_engine parameter)
(sqlalchemy.schema.Table parameter)
listens_for() (in module sqlalchemy.event)
literal() (in module sqlalchemy.sql.expression)
literal_binds (sqlalchemy.sql.expression.values parameter)
literal_column() (in module sqlalchemy.sql.expression)
literal_execute (sqlalchemy.sql.expression.bindparam parameter)
literal_execute_params (sqlalchemy.sql.compiler.SQLCompiler attribute)
literal_processor() (sqlalchemy.types.Boolean method)
(sqlalchemy.types.Integer method)
(sqlalchemy.types.JSON.JSONElementType method)
Load (class in sqlalchemy.orm) , [13]
load (sqlalchemy.orm.scoping.scoped_session.merge parameter)
(sqlalchemy.orm.Session.merge parameter)
load() (sqlalchemy.orm.InstanceEvents method)
load_dialect_impl() (sqlalchemy.types.TypeDecorator method)
load_history() (sqlalchemy.orm.AttributeState method)
load_on_pending (sqlalchemy.orm.relationship parameter)
load_only() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
load_options (sqlalchemy.orm.ORMExecuteState attribute)
(sqlalchemy.orm.Query attribute)
load_provisioning() (sqlalchemy.engine.default.DefaultDialect class method)
(sqlalchemy.engine.Dialect class method)
loaded_as_persistent() (sqlalchemy.orm.SessionEvents method)
loaded_value (sqlalchemy.orm.AttributeState attribute)
loader_strategy_path (sqlalchemy.orm.ORMExecuteState attribute)
LoaderStrategyException
loads() (in module sqlalchemy.ext.serializer)
local_attr (sqlalchemy.ext.associationproxy.AssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance attribute)
local_cls (sqlalchemy.ext.automap.generate_relationship parameter)
(sqlalchemy.ext.automap.name_for_collection_relationship parameter)
(sqlalchemy.ext.automap.name_for_scalar_relationship parameter)
local_execution_options (sqlalchemy.orm.ORMExecuteState attribute)
local_table (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
(sqlalchemy.orm.registry.map_imperatively parameter)
localtime (class in sqlalchemy.sql.functions)
localtimestamp (class in sqlalchemy.sql.functions)
logging_name (sqlalchemy.create_engine parameter)
(sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
LONG (class in sqlalchemy.dialects.oracle)
LONGBLOB (class in sqlalchemy.dialects.mysql)
LONGTEXT (class in sqlalchemy.dialects.mysql)
lower_bound (sqlalchemy.sql.expression.between parameter)

M

MACADDR (class in sqlalchemy.dialects.postgresql)
make_transient() (in module sqlalchemy.orm)
make_transient_to_detached() (in module sqlalchemy.orm)
make_url() (in module sqlalchemy.engine)
manage() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
(sqlalchemy.orm.ClassManager method)
manager_getter() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
many to many
many to one
MANYTOMANY (in module sqlalchemy.orm)
MANYTOONE (in module sqlalchemy.orm)
map_column (sqlalchemy.orm.synonym parameter)
map_declaratively() (sqlalchemy.orm.registry method)
map_imperatively() (sqlalchemy.orm.registry method)
mapped
mapped class
mapped() (sqlalchemy.orm.registry method)
mapped_collection() (in module sqlalchemy.orm.collections)
mapped_table (sqlalchemy.orm.Mapper attribute)
MappedCollection (class in sqlalchemy.orm.collections)
Mapper (class in sqlalchemy.orm)
mapper (sqlalchemy.ext.asyncio.AsyncSession.get_bind parameter)
(sqlalchemy.ext.horizontal_shard.ShardedSession.get_bind parameter)
(sqlalchemy.orm.declarative_base parameter)
mapper() (in module sqlalchemy.orm)
mapper_configured() (sqlalchemy.orm.MapperEvents method)
MapperEvents (class in sqlalchemy.orm)
MapperProperty (class in sqlalchemy.orm)
mapping
(sqlalchemy.types.Variant parameter)
MappingResult (class in sqlalchemy.engine)
mappings (sqlalchemy.orm.scoping.scoped_session.bulk_insert_mappings parameter)
(sqlalchemy.orm.scoping.scoped_session.bulk_update_mappings parameter)
(sqlalchemy.orm.Session.bulk_insert_mappings parameter)
mappings() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
marshalling
match (sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
match() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
MatchType (class in sqlalchemy.types)
matrix() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
max (class in sqlalchemy.sql.functions)
max_identifier_length (sqlalchemy.create_engine parameter)
max_overflow (sqlalchemy.create_engine parameter)
(sqlalchemy.pool.QueuePool parameter)
maxvalue (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
MEDIUMBLOB (class in sqlalchemy.dialects.mysql)
MEDIUMINT (class in sqlalchemy.dialects.mysql)
MEDIUMTEXT (class in sqlalchemy.dialects.mysql)
memoized_instancemethod() (sqlalchemy.orm.ClassManager class method)
(sqlalchemy.orm.QueryableAttribute class method)
(sqlalchemy.schema.Column class method)
merge() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
merge_frozen_result() (in module sqlalchemy.orm)
merge_result() (in module sqlalchemy.orm)
(sqlalchemy.orm.Query method)
MergedResult (class in sqlalchemy.engine)
metaclass (sqlalchemy.orm.declarative_base parameter)
(sqlalchemy.orm.registry.generate_base parameter)
metadata
MetaData (class in sqlalchemy.schema)
metadata (sqlalchemy.orm.declarative_base parameter)
(sqlalchemy.orm.registry parameter)
(sqlalchemy.schema.Sequence parameter)
method chaining
min (class in sqlalchemy.sql.functions)
minvalue (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
mode (class in sqlalchemy.sql.functions)
modified() (sqlalchemy.orm.AttributeEvents method)
module
examples.adjacency_list
examples.association
module (sqlalchemy.create_engine parameter)
MONEY (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.postgresql)
MovedIn20Warning
multiparams (sqlalchemy.events.ConnectionEvents.after_execute parameter)
(sqlalchemy.events.ConnectionEvents.before_execute parameter)
MultipleResultsFound
must_exist (sqlalchemy.schema.Table parameter)
Mutable (class in sqlalchemy.ext.mutable)
mutable (sqlalchemy.ext.indexable.index_property parameter)
MutableBase (class in sqlalchemy.ext.mutable)
MutableComposite (class in sqlalchemy.ext.mutable)
MutableDict (class in sqlalchemy.ext.mutable)
MutableList (class in sqlalchemy.ext.mutable)
MutableSet (class in sqlalchemy.ext.mutable)

N

N plus one
N plus one problem
name (sqlalchemy.dialects.mysql.BOOLEAN parameter)
(sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
(sqlalchemy.engine.default.DefaultDialect.do_release_savepoint parameter)
name_for_collection_relationship (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
name_for_collection_relationship() (in module sqlalchemy.ext.automap)
name_for_scalar_relationship (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
name_for_scalar_relationship() (in module sqlalchemy.ext.automap)
names (sqlalchemy.engine.URL.translate_connect_args parameter)
(sqlalchemy.sql.expression.Insert.from_select parameter)
naming_convention (sqlalchemy.schema.MetaData parameter)
national (sqlalchemy.dialects.mysql.LONGTEXT parameter)
(sqlalchemy.dialects.mysql.MEDIUMTEXT parameter)
(sqlalchemy.dialects.mysql.TEXT parameter)
native (sqlalchemy.types.Interval parameter)
native_enum (sqlalchemy.types.Enum parameter)
NCHAR (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
NCLOB (class in sqlalchemy.dialects.oracle)
nested (sqlalchemy.orm.scoping.scoped_session.begin parameter)
(sqlalchemy.orm.Session.begin parameter)
(sqlalchemy.orm.SessionTransaction attribute)
NestedTransaction (class in sqlalchemy.engine)
new (sqlalchemy.ext.asyncio.AsyncSession attribute)
(sqlalchemy.orm.scoping.scoped_session attribute)
(sqlalchemy.orm.Session attribute)
new_adapter (sqlalchemy.orm.collections.bulk_replace parameter)
next_value (class in sqlalchemy.sql.functions)
next_value() (sqlalchemy.schema.Sequence method)
no_autoflush (sqlalchemy.ext.asyncio.AsyncSession attribute)
(sqlalchemy.orm.scoping.scoped_session attribute)
(sqlalchemy.orm.Session attribute)
no_parameters (sqlalchemy.engine.Connection.execution_options parameter)
NO_STATE (in module sqlalchemy.orm.exc)
NoForeignKeysError
NoInspectionAvailable
noload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
nomaxvalue (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
nominvalue (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
non_added() (sqlalchemy.orm.attributes.History method)
non_deleted() (sqlalchemy.orm.attributes.History method)
non_primary (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
none_as_null (sqlalchemy.dialects.mssql.JSON parameter)
(sqlalchemy.dialects.postgresql.JSON parameter)
(sqlalchemy.types.JSON parameter)
NoReferencedColumnError
NoReferencedTableError
NoReferenceError
NoResultFound
normalize_name() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
normalized_query (sqlalchemy.engine.URL attribute)
NoSuchColumnError
NoSuchModuleError
NoSuchTableError
not_() (in module sqlalchemy.sql.expression)
not_extend_left_of() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
not_extend_right_of() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
NOT_EXTENSION (in module sqlalchemy.orm)
not_ilike() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
not_in() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
not_like() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
notilike() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
notin_() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
notlike() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
NotSupportedError
now (class in sqlalchemy.sql.functions)
nowait (sqlalchemy.sql.expression.GenerativeSelect.with_for_update parameter)
(sqlalchemy.sql.expression.Select.with_for_update parameter)
NTEXT (class in sqlalchemy.dialects.mssql)
Null (class in sqlalchemy.sql.expression)
NULL (sqlalchemy.types.JSON attribute)
null() (in module sqlalchemy.sql.expression)
nullable (sqlalchemy.schema.Column parameter)
NullPool (class in sqlalchemy.pool)
nulls_first() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
nulls_last() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
nullsfirst() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
nullslast() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
NullType (class in sqlalchemy.types)
num (sqlalchemy.engine.ChunkedIteratorResult.yield_per parameter)
(sqlalchemy.engine.CursorResult.yield_per parameter)
(sqlalchemy.engine.Result.yield_per parameter)
NUMBER (class in sqlalchemy.dialects.oracle)
NUMERIC (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Numeric (class in sqlalchemy.types)
NUMRANGE (class in sqlalchemy.dialects.postgresql)
NVARCHAR (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)

O

obj (sqlalchemy.ext.associationproxy.AssociationProxy.for_class parameter)
(sqlalchemy.orm.attributes.get_history parameter)
(sqlalchemy.orm.attributes.init_collection parameter)
object (sqlalchemy.ext.asyncio.AsyncConnection.execute parameter)
(sqlalchemy.orm.InstanceState attribute)
object_mapper() (in module sqlalchemy.orm)
object_session() (in module sqlalchemy.orm)
(sqlalchemy.ext.asyncio.AsyncSession class method)
(sqlalchemy.orm.scoping.scoped_session class method)
object_state() (in module sqlalchemy.orm.util)
ObjectAssociationProxyInstance (class in sqlalchemy.ext.associationproxy)
ObjectDeletedError
ObjectDereferencedError
ObjectNotExecutableError
objects (sqlalchemy.orm.scoping.scoped_session.bulk_save_objects parameter)
(sqlalchemy.orm.scoping.scoped_session.flush parameter)
(sqlalchemy.orm.Session.bulk_save_objects parameter)
of (sqlalchemy.sql.expression.GenerativeSelect.with_for_update parameter)
(sqlalchemy.sql.expression.Select.with_for_update parameter)
of_type() (sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
(sqlalchemy.orm.RelationshipProperty.Comparator method)
of_type_op() (sqlalchemy.orm.RelationshipProperty.Comparator static method)
offset (sqlalchemy.sql.expression.GenerativeSelect.offset parameter)
(sqlalchemy.sql.expression.Select.create_legacy_select parameter)
(sqlalchemy.sql.expression.Select.offset parameter)
offset() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
OID (class in sqlalchemy.dialects.postgresql)
oldvalue (sqlalchemy.orm.AttributeEvents.set parameter)
omit_join (sqlalchemy.orm.relationship parameter)
on (sqlalchemy.schema.CreateTable parameter)
(sqlalchemy.schema.DDLElement attribute)
on_conflict_do_nothing() (sqlalchemy.dialects.postgresql.Insert method)
(sqlalchemy.dialects.sqlite.Insert method)
on_conflict_do_update() (sqlalchemy.dialects.postgresql.Insert method)
(sqlalchemy.dialects.sqlite.Insert method)
on_connect() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
on_duplicate_key_update() (sqlalchemy.dialects.mysql.Insert method)
on_null (sqlalchemy.schema.Identity parameter)
onclause (sqlalchemy.schema.Table.join parameter)
(sqlalchemy.schema.Table.outerjoin parameter)
(sqlalchemy.sql.expression.FromClause.join parameter)
ondelete (sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
one to many
one() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
one_or_none() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
onebased (sqlalchemy.ext.indexable.index_property parameter)
ONETOMANY (in module sqlalchemy.orm)
only (sqlalchemy.schema.MetaData.reflect parameter)
only_return_tuples() (sqlalchemy.orm.Query method)
only_synonyms (sqlalchemy.sql.expression.Select.reduce_columns parameter)
onupdate (sqlalchemy.schema.Column parameter)
(sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
op (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.operate parameter)
(sqlalchemy.orm.ColumnProperty.Comparator.operate parameter)
(sqlalchemy.orm.PropComparator.operate parameter)
op() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
operate() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.ColumnProperty.Comparator method)
(sqlalchemy.orm.PropComparator method)
OperationalError
operator (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.op parameter)
(sqlalchemy.orm.PropComparator.op parameter)
(sqlalchemy.orm.QueryableAttribute.op parameter)
Operators (class in sqlalchemy.sql.expression)
ops (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
optional (sqlalchemy.schema.Sequence parameter)
options (sqlalchemy.orm.Session.get parameter)
options() (sqlalchemy.orm.Load method) , [16]
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Executable method)
opts (sqlalchemy.events.ConnectionEvents.set_connection_execution_options parameter)
(sqlalchemy.events.ConnectionEvents.set_engine_execution_options parameter)
(sqlalchemy.sql.visitors.iterate parameter)
or_() (in module sqlalchemy.sql.expression)
order (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
order_by (sqlalchemy.orm.relationship parameter)
(sqlalchemy.sql.expression.over parameter)
(sqlalchemy.sql.expression.Select.create_legacy_select parameter)
order_by() (sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
order_by_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
ordered_values() (sqlalchemy.sql.expression.Update method)
OrderedSetAgg (class in sqlalchemy.sql.functions)
ordering_attr (sqlalchemy.ext.orderinglist.OrderingList parameter)
ordering_func (sqlalchemy.ext.orderinglist.OrderingList parameter)
ordering_list() (in module sqlalchemy.ext.orderinglist)
OrderingList (class in sqlalchemy.ext.orderinglist)
orig (sqlalchemy.exc.StatementError attribute)
original (sqlalchemy.sql.expression.AliasedReturnsRows attribute)
original_exception (sqlalchemy.engine.ExceptionContext attribute)
orm_execute_state (sqlalchemy.orm.SessionEvents.do_orm_execute parameter)
ORMExecuteState (class in sqlalchemy.orm)
other (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.contains parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.endswith parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.ilike parameter)
outerjoin() (in module sqlalchemy.orm)
(in module sqlalchemy.sql.expression)
(sqlalchemy.orm.AppenderQuery method)
outparam() (in module sqlalchemy.sql.expression)
Over (class in sqlalchemy.sql.expression)
over() (in module sqlalchemy.sql.expression)
(sqlalchemy.sql.expression.FunctionFilter method)
(sqlalchemy.sql.expression.WithinGroup method)
overlap() (sqlalchemy.dialects.postgresql.ARRAY.Comparator method)
overlaps (sqlalchemy.orm.relationship parameter)
overlaps() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
overrides (sqlalchemy.ext.hybrid.hybrid_property attribute)

P

packagenames (sqlalchemy.sql.functions.Function parameter)
(sqlalchemy.sql.functions.FunctionElement attribute)
parameters (sqlalchemy.engine.Connection.exec_driver_sql parameter)
(sqlalchemy.engine.ExceptionContext attribute)
(sqlalchemy.events.ConnectionEvents.after_cursor_execute parameter)
params (sqlalchemy.engine.Compiled attribute)
(sqlalchemy.engine.Compiled.construct_params parameter)
(sqlalchemy.events.ConnectionEvents.after_execute parameter)
params() (sqlalchemy.ext.baked.Result method)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.ClauseElement method)
paramstyle (sqlalchemy.create_engine parameter)
parent (sqlalchemy.events.DDLEvents.after_parent_attach parameter)
(sqlalchemy.events.DDLEvents.before_parent_attach parameter)
(sqlalchemy.orm.QueryableAttribute attribute)
partition_by (sqlalchemy.sql.expression.over parameter)
partitions() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
passive (sqlalchemy.orm.attributes.get_history parameter)
passive_deletes (sqlalchemy.orm.mapper parameter)
(sqlalchemy.orm.relationship parameter)
passive_updates (sqlalchemy.orm.mapper parameter)
(sqlalchemy.orm.relationship parameter)
password (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
pattern (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.regexp_match parameter)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.regexp_replace parameter) [0]
(sqlalchemy.orm.PropComparator.regexp_match parameter)
pending
(sqlalchemy.orm.InstanceState attribute)
pending_to_persistent() (sqlalchemy.orm.SessionEvents method)
pending_to_transient() (sqlalchemy.orm.SessionEvents method)
PendingRollbackError
percent (sqlalchemy.sql.expression.GenerativeSelect.fetch parameter)
(sqlalchemy.sql.expression.Select.fetch parameter)
percent_rank (class in sqlalchemy.sql.functions)
percentile_cont (class in sqlalchemy.sql.functions)
percentile_disc (class in sqlalchemy.sql.functions)
persist_selectable (sqlalchemy.orm.Mapper attribute)
persisted (sqlalchemy.schema.Computed parameter)
persistent
(sqlalchemy.orm.InstanceState attribute)
persistent_to_deleted() (sqlalchemy.orm.SessionEvents method)
persistent_to_detached() (sqlalchemy.orm.SessionEvents method)
persistent_to_transient() (sqlalchemy.orm.SessionEvents method)
PGInspector (class in sqlalchemy.dialects.postgresql.base)
pickle() (sqlalchemy.orm.InstanceEvents method)
pickler (sqlalchemy.types.PickleType parameter)
PickleType (class in sqlalchemy.types)
plugin
plugin-specific
plugins (sqlalchemy.create_engine parameter)
polymorphic
polymorphic_identity (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
polymorphic_iterator() (sqlalchemy.orm.Mapper method)
polymorphic_load (sqlalchemy.orm.mapper parameter)
polymorphic_map (sqlalchemy.orm.Mapper attribute)
polymorphic_on (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
(sqlalchemy.orm.with_polymorphic parameter)
polymorphic_union() (in module sqlalchemy.orm)
polymorphically
Pool (class in sqlalchemy.pool)
pool (sqlalchemy.create_engine parameter)
pool_logging_name (sqlalchemy.create_engine parameter)
pool_pre_ping (sqlalchemy.create_engine parameter)
pool_recycle (sqlalchemy.create_engine parameter)
pool_reset_on_return (sqlalchemy.create_engine parameter)
pool_size (sqlalchemy.create_engine parameter)
(sqlalchemy.pool.QueuePool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
pool_timeout (sqlalchemy.create_engine parameter)
pool_use_lifo (sqlalchemy.create_engine parameter)
poolclass (sqlalchemy.create_engine parameter)
PoolEvents (class in sqlalchemy.events)
pop() (sqlalchemy.ext.mutable.MutableDict method)
(sqlalchemy.ext.mutable.MutableList method)
(sqlalchemy.ext.mutable.MutableSet method)
popitem() (sqlalchemy.ext.mutable.MutableDict method)
(sqlalchemy.orm.ClassManager method)
(sqlalchemy.orm.collections.MappedCollection method)
populate_existing (sqlalchemy.orm.Session.get parameter)
populate_existing() (sqlalchemy.orm.Query method)
port (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
post_compile_params (sqlalchemy.sql.compiler.SQLCompiler attribute)
post_configure_attribute() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
post_exec() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
post_instrument_class() (sqlalchemy.orm.MapperProperty method)
(sqlalchemy.orm.RelationshipProperty method)
(sqlalchemy.orm.SynonymProperty method)
post_update (sqlalchemy.orm.relationship parameter)
postfetch_cols() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
postfetch_lastrowid (sqlalchemy.sql.compiler.SQLCompiler attribute)
pre_exec() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
pre_ping (sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
precedence (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.op parameter)
(sqlalchemy.orm.PropComparator.op parameter)
(sqlalchemy.orm.QueryableAttribute.op parameter)
precision (sqlalchemy.dialects.mssql.REAL parameter)
(sqlalchemy.dialects.mysql.DECIMAL parameter)
(sqlalchemy.dialects.mysql.DOUBLE parameter)
prefetch_cols() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
prefix (sqlalchemy.engine_from_config parameter)
prefix_with() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.HasPrefixes method)
(sqlalchemy.sql.expression.Select method)
prefixes (sqlalchemy.schema.Table parameter)
prepare() (sqlalchemy.engine.TwoPhaseTransaction method)
(sqlalchemy.ext.automap.AutomapBase class method)
(sqlalchemy.ext.declarative.DeferredReflection class method)
prepare_instrumentation() (in module sqlalchemy.orm.collections)
prepare_twophase() (sqlalchemy.events.ConnectionEvents method)
preparer (sqlalchemy.engine.default.DefaultDialect attribute)
preserve_order (sqlalchemy.orm.scoping.scoped_session.bulk_save_objects parameter)
(sqlalchemy.orm.Session.bulk_save_objects parameter)
preserve_parameter_order (sqlalchemy.sql.expression.update parameter)
previous_transaction (sqlalchemy.orm.SessionEvents.after_soft_rollback parameter)
primary key
primary key constraint
primary_key (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.mapper parameter)
(sqlalchemy.orm.Mapper.identity_key_from_primary_key parameter)
primary_key_from_instance() (sqlalchemy.orm.Mapper method)
primary_mapper() (sqlalchemy.orm.Mapper method)
primaryjoin (sqlalchemy.orm.relationship parameter)
PrimaryKeyConstraint (class in sqlalchemy.schema)
process_bind_param() (sqlalchemy.types.TypeDecorator method)
process_compile_state() (sqlalchemy.orm.Load method) , [17]
process_literal_param() (sqlalchemy.types.TypeDecorator method)
process_result_value() (sqlalchemy.types.TypeDecorator method)
ProgrammingError
propagate (sqlalchemy.orm.AttributeEvents parameter)
(sqlalchemy.orm.InstanceEvents parameter)
(sqlalchemy.orm.MapperEvents parameter)
propagate_to_loaders (sqlalchemy.orm.with_loader_criteria parameter)
PropComparator (class in sqlalchemy.orm)
properties (sqlalchemy.orm.mapper parameter)
property (sqlalchemy.orm.Query.with_parent parameter)
(sqlalchemy.orm.QueryableAttribute attribute)
(sqlalchemy.orm.with_parent parameter)
protocol (sqlalchemy.types.PickleType parameter)
proxy_bulk_set (sqlalchemy.ext.associationproxy.AssociationProxy parameter)
proxy_factory (sqlalchemy.ext.associationproxy.AssociationProxy parameter)
proxy_set (sqlalchemy.sql.expression.ColumnElement attribute)
Python Enhancement Proposals
PEP 249 [0] [1] [2] [3]
PEP 484 [0]
python_type (sqlalchemy.types.ARRAY attribute)
(sqlalchemy.types.Boolean attribute)
(sqlalchemy.types.Date attribute)

Q

Query (class in sqlalchemy.orm)
query (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
query() (sqlalchemy.orm.scoping.scoped_session method)
(sqlalchemy.orm.Session method)
query_cache_size (sqlalchemy.create_engine parameter)
query_class (sqlalchemy.orm.relationship parameter)
query_cls (sqlalchemy.orm.Session parameter)
query_expression() (in module sqlalchemy.orm)
query_or_session (sqlalchemy.ext.baked.BakedQuery.to_query parameter)
query_parameters (sqlalchemy.engine.URL.update_query_dict parameter)
query_property() (sqlalchemy.orm.scoping.scoped_session method)
query_string (sqlalchemy.engine.URL.update_query_string parameter)
QueryableAttribute (class in sqlalchemy.orm)
QueryableAttribute.memoized_attribute (class in sqlalchemy.orm)
QueryContext (class in sqlalchemy.orm)
QueryContext.default_load_options (class in sqlalchemy.orm)
QueryEvents (class in sqlalchemy.orm)
QueuePool (class in sqlalchemy.pool)
quote (sqlalchemy.schema.Column parameter)
(sqlalchemy.schema.Index parameter)
(sqlalchemy.schema.Sequence parameter)
quote() (sqlalchemy.sql.compiler.IdentifierPreparer method)
quote_identifier() (sqlalchemy.sql.compiler.IdentifierPreparer method)
quote_schema (sqlalchemy.schema.MetaData parameter)
(sqlalchemy.schema.Sequence parameter)
(sqlalchemy.schema.Table parameter)
quote_schema() (sqlalchemy.sql.compiler.IdentifierPreparer method)
quoted_name (class in sqlalchemy.sql.expression)
quoting (sqlalchemy.dialects.mysql.ENUM parameter)
(sqlalchemy.dialects.mysql.SET parameter)

R

raiseerr (sqlalchemy.inspect parameter)
raiseload (sqlalchemy.orm.column_property parameter)
(sqlalchemy.orm.defer parameter)
(sqlalchemy.orm.deferred parameter)
raiseload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
random (class in sqlalchemy.sql.functions)
range_ (sqlalchemy.sql.expression.over parameter)
RangeOperators (class in sqlalchemy.dialects.postgresql.ranges)
RangeOperators.comparator_factory (class in sqlalchemy.dialects.postgresql.ranges)
rank (class in sqlalchemy.sql.functions)
RAW (class in sqlalchemy.dialects.oracle)
raw (sqlalchemy.orm.AttributeEvents parameter)
(sqlalchemy.orm.InstanceEvents parameter)
(sqlalchemy.orm.MapperEvents parameter)
raw_connection() (sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncEngine method)
read (sqlalchemy.sql.expression.GenerativeSelect.with_for_update parameter)
(sqlalchemy.sql.expression.Select.with_for_update parameter)
read committed
read uncommitted
REAL (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.postgresql)
reconstructor() (in module sqlalchemy.orm)
record_info (sqlalchemy.pool._ConnectionFairy attribute)
(sqlalchemy.pool._ConnectionRecord attribute)
recover (sqlalchemy.engine.default.DefaultDialect.do_commit_twophase parameter)
(sqlalchemy.engine.default.DefaultDialect.do_rollback_twophase parameter)
(sqlalchemy.engine.Dialect.do_commit_twophase parameter)
recreate() (sqlalchemy.pool.Pool method)
recursive (sqlalchemy.sql.expression.HasCTE.cte parameter)
(sqlalchemy.sql.expression.Select.cte parameter)
(sqlalchemy.sql.expression.SelectBase.cte parameter)
recycle (sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
reduce_columns (sqlalchemy.orm.Query.subquery parameter)
reduce_columns() (sqlalchemy.sql.expression.Select method)
refcolumns (sqlalchemy.schema.ForeignKeyConstraint parameter)
references() (sqlalchemy.schema.Column method)
(sqlalchemy.schema.ForeignKey method)
referred_cls (sqlalchemy.ext.automap.generate_relationship parameter)
(sqlalchemy.ext.automap.name_for_collection_relationship parameter)
(sqlalchemy.ext.automap.name_for_scalar_relationship parameter)
referred_schema_fn (sqlalchemy.schema.Table.to_metadata parameter)
referred_table (sqlalchemy.schema.ForeignKeyConstraint attribute)
reflect (sqlalchemy.ext.automap.AutomapBase.prepare parameter)
(sqlalchemy.schema.MetaData parameter)
reflect() (sqlalchemy.schema.MetaData method)
reflect_table() (sqlalchemy.engine.reflection.Inspector method)
reflecttable() (sqlalchemy.engine.reflection.Inspector method)
refresh() (sqlalchemy.ext.asyncio.AsyncSession method)
(sqlalchemy.orm.InstanceEvents method)
(sqlalchemy.orm.scoping.scoped_session method)
refresh_flush() (sqlalchemy.orm.InstanceEvents method)
REGCLASS (class in sqlalchemy.dialects.postgresql)
regexp (sqlalchemy.dialects.sqlite.DATE parameter)
(sqlalchemy.dialects.sqlite.DATETIME parameter)
(sqlalchemy.dialects.sqlite.TIME parameter)
regexp_match() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
regexp_replace() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
register_function() (in module sqlalchemy.sql.functions)
registry
(class in sqlalchemy.orm)
relation() (in module sqlalchemy.orm)
relational
relational algebra
relationship
relationship() (in module sqlalchemy.orm)
RelationshipProperty (class in sqlalchemy.orm)
RelationshipProperty.Comparator (class in sqlalchemy.orm)
relationships
(sqlalchemy.orm.Mapper attribute)
release
release_savepoint() (sqlalchemy.events.ConnectionEvents method)
released
releases
remote() (in module sqlalchemy.orm)
remote_attr (sqlalchemy.ext.associationproxy.AssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance attribute)
remote_side (sqlalchemy.orm.relationship parameter)
remove() (in module sqlalchemy.event)
(sqlalchemy.ext.mutable.MutableList method)
(sqlalchemy.ext.mutable.MutableSet method)
remove_state() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
remove_state_actions() (sqlalchemy.orm.UOWTransaction method)
RemovedIn20Warning
remover() (sqlalchemy.orm.collections.collection static method)
removes() (sqlalchemy.orm.collections.collection static method)
removes_return() (sqlalchemy.orm.collections.collection static method)
render_as_string() (sqlalchemy.engine.URL method)
render_literal_value() (sqlalchemy.sql.compiler.SQLCompiler method)
render_nulls (sqlalchemy.orm.scoping.scoped_session.bulk_insert_mappings parameter)
(sqlalchemy.orm.Session.bulk_insert_mappings parameter)
render_table_with_column_in_update_from (sqlalchemy.sql.compiler.SQLCompiler attribute)
reorder() (sqlalchemy.ext.orderinglist.OrderingList method)
reorder_on_append (sqlalchemy.ext.orderinglist.OrderingList parameter)
repeatable read
replace_existing (sqlalchemy.schema.Table.append_column parameter)
replace_selectable() (sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.Select method)
(sqlalchemy.sql.expression.Selectable method)
replacement_traverse() (in module sqlalchemy.sql.visitors)
replaces() (sqlalchemy.orm.collections.collection static method)
require_embedded (sqlalchemy.schema.Table.corresponding_column parameter)
(sqlalchemy.sql.expression.ColumnCollection.corresponding_column parameter)
(sqlalchemy.sql.expression.Select.corresponding_column parameter)
required (sqlalchemy.sql.expression.bindparam parameter)
reset() (sqlalchemy.events.PoolEvents method)
reset_isolation_level() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
reset_joinpoint() (sqlalchemy.orm.Query method)
reset_on_return (sqlalchemy.pool.Pool parameter)
(sqlalchemy.pool.SingletonThreadPool parameter)
resolve_fks (sqlalchemy.schema.MetaData.reflect parameter)
(sqlalchemy.schema.Table parameter)
ResourceClosedError
restore_load_context (sqlalchemy.orm.InstanceEvents parameter)
(sqlalchemy.orm.SessionEvents parameter)
Result (class in sqlalchemy.engine)
(class in sqlalchemy.ext.baked)
result (sqlalchemy.events.ConnectionEvents.after_execute parameter)
result_processor() (sqlalchemy.dialects.postgresql.HSTORE method)
(sqlalchemy.types.Boolean method)
(sqlalchemy.types.Float method)
retrieve_as_bitwise (sqlalchemy.dialects.mysql.SET parameter)
return_defaults (sqlalchemy.orm.scoping.scoped_session.bulk_insert_mappings parameter)
(sqlalchemy.orm.scoping.scoped_session.bulk_save_objects parameter)
(sqlalchemy.orm.Session.bulk_insert_mappings parameter)
return_defaults() (sqlalchemy.sql.expression.ValuesBase method)
return_fn (sqlalchemy.ext.automap.generate_relationship parameter)
return_type (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.op parameter)
(sqlalchemy.orm.PropComparator.op parameter)
(sqlalchemy.orm.QueryableAttribute.op parameter)
returned_defaults (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
returned_defaults_rows (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
RETURNING
returning (sqlalchemy.sql.compiler.SQLCompiler attribute)
returning() (sqlalchemy.sql.expression.Delete method)
(sqlalchemy.sql.expression.Insert method)
(sqlalchemy.sql.expression.Update method)
returning_precedes_values (sqlalchemy.sql.compiler.SQLCompiler attribute)
RETURNS_BYTES (sqlalchemy.types.String attribute)
RETURNS_CONDITIONAL (sqlalchemy.types.String attribute)
returns_rows (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
RETURNS_UNICODE (sqlalchemy.types.String attribute)
returns_unicode_strings (sqlalchemy.engine.default.DefaultDialect attribute)
RETURNS_UNKNOWN (sqlalchemy.types.String attribute)
ReturnsRows (class in sqlalchemy.sql.expression)
ReturnTypeFromArgs (class in sqlalchemy.sql.functions)
retval (sqlalchemy.events.ConnectionEvents parameter)
(sqlalchemy.orm.AttributeEvents parameter)
(sqlalchemy.orm.MapperEvents parameter)
reverse() (sqlalchemy.ext.mutable.MutableList method)
reverse_operate() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.ColumnProperty.Comparator method)
(sqlalchemy.orm.PropComparator method)
right (sqlalchemy.schema.Table.join parameter)
(sqlalchemy.schema.Table.outerjoin parameter)
(sqlalchemy.sql.expression.FromClause.join parameter)
right_index (sqlalchemy.sql.functions.FunctionElement.as_comparison parameter)
rollback() (sqlalchemy.engine.Transaction method)
(sqlalchemy.events.ConnectionEvents method)
(sqlalchemy.ext.asyncio.AsyncConnection method)
rollback_savepoint() (sqlalchemy.events.ConnectionEvents method)
rollback_twophase() (sqlalchemy.events.ConnectionEvents method)
rollup (class in sqlalchemy.sql.functions)
Row (class in sqlalchemy.engine)
row (sqlalchemy.orm.Mapper.identity_key_from_row parameter)
rowcount (sqlalchemy.engine.BaseCursorResult attribute)
(sqlalchemy.engine.CursorResult attribute)
RowMapping (class in sqlalchemy.engine)
rows (sqlalchemy.sql.expression.over parameter)
ROWVERSION (class in sqlalchemy.dialects.mssql)
run_callable() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
run_sync() (sqlalchemy.ext.asyncio.AsyncConnection method)
(sqlalchemy.ext.asyncio.AsyncSession method)

S

SADeprecationWarning
sampling (sqlalchemy.sql.expression.tablesample parameter)
SAPendingDeprecationWarning
savepoint() (sqlalchemy.events.ConnectionEvents method)
SAWarning
scalar (sqlalchemy.ext.associationproxy.AssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance attribute)
(sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance attribute)
scalar subquery
scalar() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Engine method)
scalar_one() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
scalar_one_or_none() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
scalar_subquery() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
(sqlalchemy.sql.expression.SelectBase method)
ScalarResult (class in sqlalchemy.engine)
scalars() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)
(sqlalchemy.ext.asyncio.AsyncResult method)
ScalarSelect (class in sqlalchemy.sql.expression)
scale (sqlalchemy.dialects.mysql.DECIMAL parameter)
(sqlalchemy.dialects.mysql.DOUBLE parameter)
(sqlalchemy.dialects.mysql.FLOAT parameter)
schema (sqlalchemy.dialects.postgresql.base.PGInspector.get_enums parameter)
(sqlalchemy.dialects.postgresql.base.PGInspector.get_view_names parameter)
(sqlalchemy.engine.default.DefaultDialect.get_sequence_names parameter)
schema_for_object (sqlalchemy.sql.compiler.IdentifierPreparer attribute)
schema_for_object() (sqlalchemy.engine.Connection method)
schema_translate_map (sqlalchemy.engine.Compiled parameter)
(sqlalchemy.engine.Connection.execution_options parameter)
(sqlalchemy.sql.compiler.DDLCompiler parameter)
SchemaEventTarget (class in sqlalchemy.events)
SchemaItem (class in sqlalchemy.schema)
SchemaType (class in sqlalchemy.types)
scoped_session (class in sqlalchemy.orm.scoping)
ScopedRegistry (class in sqlalchemy.util)
scopefunc (sqlalchemy.orm.scoping.scoped_session parameter)
(sqlalchemy.util.ScopedRegistry parameter) [0]
second_precision (sqlalchemy.dialects.oracle.INTERVAL parameter)
(sqlalchemy.types.Interval parameter)
secondary (sqlalchemy.orm.relationship parameter)
secondaryjoin (sqlalchemy.orm.relationship parameter)
seed (sqlalchemy.sql.expression.tablesample parameter)
Select (class in sqlalchemy.sql.expression)
select (sqlalchemy.sql.expression.Insert.from_select parameter)
select() (in module sqlalchemy.future)
(in module sqlalchemy.sql.expression)
(sqlalchemy.schema.Table method)
select_entity_from() (sqlalchemy.orm.Query method)
select_from() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Exists method)
(sqlalchemy.sql.expression.Select method)
selectable
Selectable (class in sqlalchemy.sql.expression)
selectable (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.orm.with_polymorphic parameter)
(sqlalchemy.sql.expression.alias parameter)
SelectBase (class in sqlalchemy.sql.expression)
selected_columns (sqlalchemy.sql.expression.CompoundSelect attribute)
(sqlalchemy.sql.expression.Select attribute)
(sqlalchemy.sql.expression.SelectBase attribute)
selectin_polymorphic() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
selectinload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
self_and_descendants (sqlalchemy.orm.Mapper attribute)
self_group() (sqlalchemy.schema.Column method)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.BinaryExpression method)
Sequence (class in sqlalchemy.schema)
sequence_name (sqlalchemy.engine.reflection.Inspector.has_sequence parameter)
serializable
Serializer() (in module sqlalchemy.ext.serializer)
server_default (sqlalchemy.schema.Column parameter)
server_onupdate (sqlalchemy.schema.Column parameter)
Session
(class in sqlalchemy.orm)
session (sqlalchemy.orm.InstanceState attribute)
(sqlalchemy.orm.ORMExecuteState attribute)
(sqlalchemy.orm.Query parameter)
session_factory (sqlalchemy.orm.scoping.scoped_session attribute)
(sqlalchemy.orm.scoping.scoped_session parameter)
session_user (class in sqlalchemy.sql.functions)
SessionEvents (class in sqlalchemy.orm)
sessionmaker (class in sqlalchemy.orm)
SessionTransaction (class in sqlalchemy.orm)
SET (class in sqlalchemy.dialects.mysql)
set() (sqlalchemy.engine.URL method)
(sqlalchemy.ext.associationproxy.AssociationProxyInstance method)
(sqlalchemy.orm.AttributeEvents method)
set_ (sqlalchemy.dialects.postgresql.Insert.on_conflict_do_update parameter)
(sqlalchemy.dialects.sqlite.Insert.on_conflict_do_update parameter)
set_attribute() (in module sqlalchemy.orm.attributes)
set_committed_value() (in module sqlalchemy.orm.attributes)
set_connection_execution_options() (sqlalchemy.events.ConnectionEvents method)
set_engine_execution_options() (sqlalchemy.events.ConnectionEvents method)
set_isolation_level() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect method)
set_parent() (sqlalchemy.orm.MapperProperty method)
(sqlalchemy.orm.RelationshipProperty method)
(sqlalchemy.orm.SynonymProperty method)
set_shard() (sqlalchemy.ext.horizontal_shard.ShardedQuery method)
setdefault() (sqlalchemy.ext.mutable.MutableDict method)
(sqlalchemy.orm.ClassManager method)
(sqlalchemy.orm.collections.MappedCollection method)
setter() (sqlalchemy.ext.hybrid.hybrid_property method)
setup() (sqlalchemy.orm.MapperProperty method)
(sqlalchemy.orm.RelationshipProperty method)
(sqlalchemy.orm.SynonymProperty method)
shard_chooser (sqlalchemy.ext.horizontal_shard.ShardedSession parameter)
ShardedQuery (class in sqlalchemy.ext.horizontal_shard)
ShardedSession (class in sqlalchemy.ext.horizontal_shard)
shards (sqlalchemy.ext.horizontal_shard.ShardedSession parameter)
shares_lineage() (sqlalchemy.schema.Column method)
(sqlalchemy.sql.expression.ColumnElement method)
should_autocommit_text() (sqlalchemy.engine.default.DefaultExecutionContext method)
(sqlalchemy.engine.ExecutionContext method)
should_evaluate_none (sqlalchemy.types.JSON attribute)
(sqlalchemy.types.TypeEngine attribute)
single (sqlalchemy.orm.Mapper attribute)
single_entity (sqlalchemy.orm.Bundle attribute)
(sqlalchemy.orm.Bundle parameter)
single_parent (sqlalchemy.orm.relationship parameter)
SingletonThreadPool (class in sqlalchemy.pool)
size (sqlalchemy.engine.CursorResult.partitions parameter)
(sqlalchemy.engine.Result.partitions parameter)
skip_fn (sqlalchemy.schema.sort_tables parameter)
skip_locked (sqlalchemy.sql.expression.GenerativeSelect.with_for_update parameter)
(sqlalchemy.sql.expression.Select.with_for_update parameter)
slice() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
(sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
SMALLDATETIME (class in sqlalchemy.dialects.mssql)
SMALLINT (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
SmallInteger (class in sqlalchemy.types)
SMALLMONEY (class in sqlalchemy.dialects.mssql)
soft (sqlalchemy.pool._ConnectionFairy.invalidate parameter)
(sqlalchemy.pool._ConnectionRecord.invalidate parameter)
soft_invalidate() (sqlalchemy.events.PoolEvents method)
sort() (sqlalchemy.ext.mutable.MutableList method)
sort_key_function (sqlalchemy.types.Enum parameter)
(sqlalchemy.types.TypeEngine attribute)
sort_tables() (in module sqlalchemy.schema)
sort_tables_and_constraints() (in module sqlalchemy.schema)
sorted_tables (sqlalchemy.schema.MetaData attribute)
spoil() (sqlalchemy.ext.baked.BakedQuery method)
(sqlalchemy.sql.expression.StatementLambdaElement method)
sql_compiler (sqlalchemy.engine.Compiled attribute)
(sqlalchemy.sql.compiler.SQLCompiler attribute)
sql_only (sqlalchemy.orm.raiseload parameter)
SQL_VARIANT (class in sqlalchemy.dialects.mssql)
sqlalchemy.dialects.firebird.base
module
sqlalchemy.dialects.firebird.fdb
module
sqlalchemy.dialects.firebird.kinterbasdb
module
sqlalchemy.dialects.mssql.base
module
sqlalchemy.dialects.mssql.mxodbc
module
sqlalchemy.dialects.mssql.pymssql
module
sqlalchemy.dialects.mssql.pyodbc
module
sqlalchemy.dialects.mysql.base
module
sqlalchemy.dialects.mysql.cymysql
module
sqlalchemy.dialects.mysql.mysqlconnector
module
sqlalchemy.dialects.mysql.mysqldb
module
sqlalchemy.dialects.mysql.oursql
module
sqlalchemy.dialects.mysql.pymysql
module
sqlalchemy.dialects.mysql.pyodbc
module
sqlalchemy.dialects.oracle.base
module
sqlalchemy.dialects.oracle.cx_oracle
module
sqlalchemy.dialects.postgresql.asyncpg
module
sqlalchemy.dialects.postgresql.base
module
sqlalchemy.dialects.postgresql.pg8000
module
sqlalchemy.dialects.postgresql.psycopg2
module
sqlalchemy.dialects.postgresql.psycopg2cffi
module
sqlalchemy.dialects.postgresql.pygresql
module
sqlalchemy.dialects.postgresql.pypostgresql
module
sqlalchemy.dialects.sqlite
module
sqlalchemy.dialects.sqlite.base
module
sqlalchemy.dialects.sqlite.pysqlcipher
module
sqlalchemy.dialects.sqlite.pysqlite
module
sqlalchemy.dialects.sybase.base
module
sqlalchemy.dialects.sybase.mxodbc
module
sqlalchemy.dialects.sybase.pyodbc
module
sqlalchemy.dialects.sybase.pysybase
module
sqlalchemy.engine
module
sqlalchemy.exc
module
sqlalchemy.ext.associationproxy
module
sqlalchemy.ext.automap
module
sqlalchemy.ext.baked
module
sqlalchemy.ext.compiler
module
sqlalchemy.ext.declarative
module
sqlalchemy.ext.horizontal_shard
module
sqlalchemy.ext.hybrid
module
sqlalchemy.ext.indexable
module
sqlalchemy.ext.instrumentation
module
sqlalchemy.ext.mutable
module
sqlalchemy.ext.orderinglist
module
sqlalchemy.ext.serializer
module
sqlalchemy.future
module
sqlalchemy.inspection
module
sqlalchemy.orm.exc
module
sqlalchemy.orm.instrumentation
module
sqlalchemy.orm.session
module
sqlalchemy.pool
module
sqlalchemy.schema
module
sqlalchemy.sql.expression
module
sqlalchemy.sql.functions
module
sqlalchemy.sql.visitors
module
sqlalchemy.types
module
sqlalchemy_exception (sqlalchemy.engine.ExceptionContext attribute)
SQLAlchemyError
SQLCompiler (class in sqlalchemy.sql.compiler)
sqltext (sqlalchemy.schema.CheckConstraint parameter)
(sqlalchemy.schema.Computed parameter)
StaleDataError
start (sqlalchemy.schema.Identity parameter)
(sqlalchemy.schema.Sequence parameter)
start() (sqlalchemy.ext.asyncio.AsyncConnection method)
(sqlalchemy.ext.asyncio.AsyncTransaction method)
startswith() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method)
(sqlalchemy.orm.PropComparator method)
(sqlalchemy.orm.QueryableAttribute method)
state (sqlalchemy.orm.Mapper.cascade_iterator parameter)
(sqlalchemy.schema.DDLElement.execute_if parameter)
state_dict (sqlalchemy.orm.InstanceEvents.pickle parameter)
(sqlalchemy.orm.InstanceEvents.unpickle parameter)
state_getter() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
(sqlalchemy.orm.ClassManager method)
statement (sqlalchemy.engine.Compiled parameter)
(sqlalchemy.engine.Connection.exec_driver_sql parameter)
(sqlalchemy.engine.Connection.execute parameter)
statement_compiler (sqlalchemy.engine.default.DefaultDialect attribute)
StatementError
StatementLambdaElement (class in sqlalchemy.sql.expression)
StaticPool (class in sqlalchemy.pool)
storage_format (sqlalchemy.dialects.sqlite.DATE parameter)
(sqlalchemy.dialects.sqlite.DATETIME parameter)
(sqlalchemy.dialects.sqlite.TIME parameter)
strategy (sqlalchemy.engine.CursorResult.unique parameter)
(sqlalchemy.engine.Result.unique parameter)
stream() (sqlalchemy.ext.asyncio.AsyncConnection method)
(sqlalchemy.ext.asyncio.AsyncSession method)
stream_results (sqlalchemy.engine.Connection.execution_options parameter)
strict (sqlalchemy.dialects.mysql.ENUM parameter)
strictly_left_of() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
strictly_right_of() (sqlalchemy.dialects.postgresql.ranges.RangeOperators.comparator_factory method)
String (class in sqlalchemy.types)
string_bind_processor() (sqlalchemy.types.JSON.JSONElementType method)
string_literal_processor() (sqlalchemy.types.JSON.JSONElementType method)
stringify_dialect (sqlalchemy.sql.expression.ColumnElement attribute)
StrSQLCompiler (class in sqlalchemy.sql.compiler)
subject (sqlalchemy.inspect parameter)
subquery
Subquery (class in sqlalchemy.sql.expression)
subquery() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
(sqlalchemy.sql.expression.SelectBase method)
subqueryload() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
subtransactions (sqlalchemy.orm.scoping.scoped_session.begin parameter)
(sqlalchemy.orm.Session.begin parameter)
suffix_with() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.HasSuffixes method)
(sqlalchemy.sql.expression.Select method)
sum (class in sqlalchemy.sql.functions)
sum() (sqlalchemy.orm.attributes.History method)
supports_execution (sqlalchemy.sql.expression.ColumnElement attribute)
supports_sane_multi_rowcount() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
supports_sane_rowcount() (sqlalchemy.engine.BaseCursorResult method)
(sqlalchemy.engine.CursorResult method)
supports_sane_rowcount_returning (sqlalchemy.engine.default.DefaultDialect attribute)
symmetric (sqlalchemy.sql.expression.between parameter)
symmetric_difference_update() (sqlalchemy.ext.mutable.MutableSet method)
sync_backref (sqlalchemy.orm.relationship parameter)
synchronize_session (sqlalchemy.orm.Query.delete parameter)
(sqlalchemy.orm.Query.update parameter)
synonym() (in module sqlalchemy.orm)
synonym_for() (in module sqlalchemy.orm)
SynonymProperty (class in sqlalchemy.orm)
synonyms (sqlalchemy.orm.Mapper attribute)
sysdate (class in sqlalchemy.sql.functions)
system (sqlalchemy.schema.Column parameter)

T

Table (class in sqlalchemy.schema)
table (sqlalchemy.dialects.mysql.insert parameter)
(sqlalchemy.dialects.postgresql.insert parameter)
(sqlalchemy.dialects.sqlite.insert parameter)
table metadata
table() (in module sqlalchemy.sql.expression)
Table.memoized_attribute (class in sqlalchemy.schema)
table_map (sqlalchemy.orm.polymorphic_union parameter)
table_name (sqlalchemy.engine.reflection.Inspector.get_check_constraints parameter)
(sqlalchemy.engine.reflection.Inspector.get_columns parameter)
(sqlalchemy.engine.reflection.Inspector.get_foreign_keys parameter)
table_names() (sqlalchemy.engine.Engine method)
TableClause (class in sqlalchemy.sql.expression)
TableClause.memoized_attribute (class in sqlalchemy.sql.expression)
tablename (sqlalchemy.ext.automap.classname_for_table parameter)
tables (sqlalchemy.orm.Mapper attribute)
(sqlalchemy.schema.MetaData attribute)
(sqlalchemy.schema.MetaData.create_all parameter)
TableSample (class in sqlalchemy.sql.expression)
tablesample() (in module sqlalchemy.sql.expression)
(sqlalchemy.schema.Table method)
(sqlalchemy.sql.expression.FromClause method)
target (sqlalchemy.events.DDLEvents.after_create parameter)
(sqlalchemy.events.DDLEvents.after_drop parameter)
(sqlalchemy.events.DDLEvents.after_parent_attach parameter)
target_class (sqlalchemy.ext.associationproxy.AssociationProxyInstance attribute)
target_collection (sqlalchemy.ext.associationproxy.association_proxy parameter)
(sqlalchemy.ext.associationproxy.AssociationProxy parameter)
target_fullname (sqlalchemy.schema.ForeignKey attribute)
TEXT (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Text (class in sqlalchemy.types)
text (sqlalchemy.sql.expression.column parameter)
(sqlalchemy.sql.expression.literal_column parameter)
(sqlalchemy.sql.expression.text parameter)
text() (in module sqlalchemy.sql.expression)
text_type (sqlalchemy.dialects.postgresql.HSTORE parameter)
TextClause (class in sqlalchemy.sql.expression)
TextualSelect (class in sqlalchemy.sql.expression)
TextualSelect.memoized_attribute (class in sqlalchemy.sql.expression)
thread safety
Connection
Transaction
ThreadLocalMetaData (class in sqlalchemy.schema)
ThreadLocalRegistry (class in sqlalchemy.util)
TIME (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.dialects.sqlite)
Time (class in sqlalchemy.types)
timeout (sqlalchemy.pool.QueuePool parameter)
TimeoutError
TIMESTAMP (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
timetuple (sqlalchemy.orm.RelationshipProperty.Comparator attribute)
(sqlalchemy.sql.expression.ColumnElement attribute)
(sqlalchemy.sql.expression.ColumnOperators attribute)
timezone (sqlalchemy.dialects.mssql.SMALLDATETIME parameter)
(sqlalchemy.dialects.mysql.DATETIME parameter)
(sqlalchemy.dialects.mysql.TIME parameter)
TINYBLOB (class in sqlalchemy.dialects.mysql)
TINYINT (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
TINYTEXT (class in sqlalchemy.dialects.mysql)
to_metadata() (sqlalchemy.schema.Table method)
to_offline_string() (sqlalchemy.sql.expression.CacheKey method)
to_query() (sqlalchemy.ext.baked.BakedQuery method)
tometadata() (sqlalchemy.schema.Table method)
Transaction (class in sqlalchemy.engine)
transaction (sqlalchemy.orm.Session attribute)
(sqlalchemy.orm.SessionEvents.after_begin parameter)
(sqlalchemy.orm.SessionEvents.after_transaction_create parameter)
transaction() (sqlalchemy.engine.Connection method)
(sqlalchemy.engine.Engine method)
transient
(sqlalchemy.orm.InstanceState attribute)
transient_to_pending() (sqlalchemy.orm.SessionEvents method)
translate_connect_args() (sqlalchemy.engine.URL method)
translate_select_structure (sqlalchemy.sql.compiler.SQLCompiler attribute)
traverse() (in module sqlalchemy.sql.visitors)
(sqlalchemy.sql.visitors.ExternalTraversal method)
traverse_using() (in module sqlalchemy.sql.visitors)
Traversible (class in sqlalchemy.sql.visitors)
TraversibleType (class in sqlalchemy.sql.visitors)
true() (in module sqlalchemy.sql.expression)
True_ (class in sqlalchemy.sql.expression)
try_cast() (in module sqlalchemy.dialects.mssql)
TSRANGE (class in sqlalchemy.dialects.postgresql)
TSTZRANGE (class in sqlalchemy.dialects.postgresql)
TSVECTOR (class in sqlalchemy.dialects.postgresql)
Tuple (class in sqlalchemy.sql.expression)
tuple_() (in module sqlalchemy.sql.expression)
twophase (sqlalchemy.orm.Session parameter)
TwoPhaseTransaction (class in sqlalchemy.engine)
type (sqlalchemy.dialects.postgresql.hstore attribute)
(sqlalchemy.sql.expression.column parameter)
(sqlalchemy.sql.expression.ColumnElement attribute)
type_ (sqlalchemy.orm.Mapper.cascade_iterator parameter)
(sqlalchemy.schema.Column parameter)
(sqlalchemy.sql.expression.bindparam parameter)
type_coerce() (in module sqlalchemy.sql.expression)
type_compiler (sqlalchemy.engine.default.DefaultDialect attribute)
type_descriptor() (sqlalchemy.engine.default.DefaultDialect method)
(sqlalchemy.engine.Dialect class method)
type_engine() (sqlalchemy.types.TypeDecorator method)
TypeCoerce (class in sqlalchemy.sql.expression)
typecolname (sqlalchemy.orm.polymorphic_union parameter)
TypeDecorator (class in sqlalchemy.types)
TypeDecorator.Comparator (class in sqlalchemy.types)
TypeEngine (class in sqlalchemy.types)
TypeEngine.Comparator (class in sqlalchemy.types)

U

UnaryExpression (class in sqlalchemy.sql.expression)
UnboundExecutionError
undefer() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
undefer_group() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
unformat_identifiers() (sqlalchemy.sql.compiler.IdentifierPreparer method)
Unicode (class in sqlalchemy.types)
unicode (sqlalchemy.dialects.mysql.ENUM parameter)
(sqlalchemy.dialects.mysql.LONGTEXT parameter)
(sqlalchemy.dialects.mysql.MEDIUMTEXT parameter)
unicode_error (sqlalchemy.dialects.mssql.CHAR parameter)
(sqlalchemy.dialects.mssql.TEXT parameter)
(sqlalchemy.dialects.mssql.VARCHAR parameter)
UnicodeText (class in sqlalchemy.types)
uninstall_descriptor() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
uninstall_member() (sqlalchemy.ext.instrumentation.InstrumentationManager method)
union() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
union_all() (in module sqlalchemy.sql.expression)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
unique (sqlalchemy.schema.Column parameter)
(sqlalchemy.schema.Index parameter)
(sqlalchemy.sql.expression.bindparam parameter)
unique constraint
unique key index
unique() (sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.MappingResult method)
(sqlalchemy.engine.Result method)
unique_params() (sqlalchemy.sql.expression.ClauseElement method)
(sqlalchemy.sql.expression.ColumnElement method)
(sqlalchemy.sql.expression.TextualSelect method)
UniqueConstraint (class in sqlalchemy.schema)
UNIQUEIDENTIFIER (class in sqlalchemy.dialects.mssql)
unit of work
unloaded (sqlalchemy.orm.InstanceState attribute)
unloaded_expirable (sqlalchemy.orm.InstanceState attribute)
UnmappedClassError
UnmappedColumnError
UnmappedError
UnmappedInstanceError
unmodified (sqlalchemy.orm.InstanceState attribute)
unmodified_intersection() (sqlalchemy.orm.InstanceState method)
unpickle() (sqlalchemy.orm.InstanceEvents method)
UnreflectableTableError
unregister() (sqlalchemy.orm.ClassManager method)
unsigned (sqlalchemy.dialects.mysql.BIGINT parameter)
(sqlalchemy.dialects.mysql.DECIMAL parameter)
(sqlalchemy.dialects.mysql.DOUBLE parameter)
UnsupportedCompilationError
UOWTransaction (class in sqlalchemy.orm)
Update (class in sqlalchemy.sql.expression)
update() (in module sqlalchemy.sql.expression)
(sqlalchemy.ext.mutable.MutableDict method)
(sqlalchemy.ext.mutable.MutableSet method)
update_args (sqlalchemy.orm.Query.update parameter)
update_changed_only (sqlalchemy.orm.scoping.scoped_session.bulk_save_objects parameter)
(sqlalchemy.orm.Session.bulk_save_objects parameter)
update_context (sqlalchemy.orm.QueryEvents.before_compile_update parameter)
(sqlalchemy.orm.SessionEvents.after_bulk_update parameter)
update_delete_options (sqlalchemy.orm.ORMExecuteState attribute)
update_execution_options() (sqlalchemy.engine.Engine method)
(sqlalchemy.ext.asyncio.AsyncEngine method)
update_expression() (sqlalchemy.ext.hybrid.hybrid_property method)
update_from_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
(sqlalchemy.sql.compiler.StrSQLCompiler method)
update_limit_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
update_query_dict() (sqlalchemy.engine.URL method)
update_query_pairs() (sqlalchemy.engine.URL method)
update_query_string() (sqlalchemy.engine.URL method)
update_tables_clause() (sqlalchemy.sql.compiler.SQLCompiler method)
update_url() (sqlalchemy.engine.CreateEnginePlugin method)
UpdateBase (class in sqlalchemy.sql.expression)
upper_bound (sqlalchemy.sql.expression.between parameter)
URL (class in sqlalchemy.engine)
url (sqlalchemy.create_mock_engine parameter)
(sqlalchemy.engine.CreateEnginePlugin parameter)
(sqlalchemy.engine.default.DefaultDialect.create_connect_args parameter)
use_alter (sqlalchemy.schema.ForeignKey parameter)
(sqlalchemy.schema.ForeignKeyConstraint parameter)
use_labels (sqlalchemy.sql.expression.Select.create_legacy_select parameter)
use_lifo (sqlalchemy.pool.QueuePool parameter)
uselist (sqlalchemy.orm.relationship parameter)
user (class in sqlalchemy.sql.functions)
user_defined_options (sqlalchemy.orm.ORMExecuteState attribute)
UserDefinedType (class in sqlalchemy.types)
username (sqlalchemy.engine.URL attribute)
(sqlalchemy.engine.URL.create parameter)
(sqlalchemy.engine.URL.set parameter)
uses_inspection (sqlalchemy.sql.expression.ColumnElement attribute)
uses_objects (sqlalchemy.orm.SynonymProperty attribute)
using (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
UUID (class in sqlalchemy.dialects.postgresql)

V

validate_sql_phrase() (sqlalchemy.sql.compiler.IdentifierPreparer method)
validate_strings (sqlalchemy.types.Enum parameter)
validates() (in module sqlalchemy.orm)
validators (sqlalchemy.orm.Mapper attribute)
vals() (sqlalchemy.dialects.postgresql.HSTORE.Comparator method)
value (sqlalchemy.ext.mutable.Mutable.coerce parameter)
(sqlalchemy.ext.mutable.MutableBase.coerce parameter)
(sqlalchemy.orm.AttributeEvents.append parameter)
value() (sqlalchemy.orm.Query method)
Values (class in sqlalchemy.sql.expression)
values (sqlalchemy.dialects.mysql.insert parameter)
(sqlalchemy.dialects.mysql.SET parameter)
(sqlalchemy.dialects.postgresql.insert parameter)
values() (in module sqlalchemy.sql.expression)
(sqlalchemy.engine.LegacyRow method)
(sqlalchemy.engine.RowMapping method)
values_callable (sqlalchemy.types.Enum parameter)
ValuesBase (class in sqlalchemy.sql.expression)
VARBINARY (class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
VARCHAR (class in sqlalchemy.dialects.mssql)
(class in sqlalchemy.dialects.mysql)
(class in sqlalchemy.types)
Variant (class in sqlalchemy.types)
version id column
version_id_col (sqlalchemy.orm.mapper parameter)
version_id_generator (sqlalchemy.orm.mapper parameter)
viewonly (sqlalchemy.orm.relationship parameter)
views (sqlalchemy.schema.MetaData.reflect parameter)
visitor_iterator (sqlalchemy.sql.visitors.ExternalTraversal attribute)
visitors (sqlalchemy.sql.visitors.traverse parameter)
(sqlalchemy.sql.visitors.traverse_using parameter)

W

was_already_deleted() (sqlalchemy.orm.UOWTransaction method)
was_deleted (sqlalchemy.orm.InstanceState attribute)
was_deleted() (in module sqlalchemy.orm.util)
where (sqlalchemy.dialects.postgresql.ExcludeConstraint parameter)
(sqlalchemy.dialects.postgresql.Insert.on_conflict_do_update parameter)
(sqlalchemy.dialects.sqlite.Insert.on_conflict_do_update parameter)
WHERE clause
where() (sqlalchemy.orm.AppenderQuery method)
(sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Delete method)
where_criteria (sqlalchemy.orm.with_loader_criteria parameter)
whereclause (sqlalchemy.orm.Query attribute)
(sqlalchemy.schema.Table.select parameter)
(sqlalchemy.sql.expression.delete parameter)
with_criteria() (sqlalchemy.ext.baked.BakedQuery method)
with_dialect_options() (sqlalchemy.sql.expression.UpdateBase method)
with_entities() (sqlalchemy.orm.Query method)
with_expression() (in module sqlalchemy.orm)
(sqlalchemy.orm.Load method) [0]
with_for_update (sqlalchemy.orm.scoping.scoped_session.refresh parameter)
(sqlalchemy.orm.Session.get parameter)
(sqlalchemy.orm.Session.refresh parameter)
with_for_update() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.GenerativeSelect method)
(sqlalchemy.sql.expression.Select method)
with_hint() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
(sqlalchemy.sql.expression.UpdateBase method)
with_labels (sqlalchemy.orm.Query.subquery parameter)
with_labels() (sqlalchemy.orm.Query method)
with_loader_criteria() (in module sqlalchemy.orm)
with_only_columns() (sqlalchemy.sql.expression.Select method)
with_parent() (in module sqlalchemy.orm)
(sqlalchemy.orm.Query method)
with_polymorphic (sqlalchemy.orm.mapper parameter)
with_polymorphic() (in module sqlalchemy.orm)
(sqlalchemy.orm.Query method)
with_polymorphic_mappers (sqlalchemy.orm.Mapper attribute)
with_post_criteria() (sqlalchemy.ext.baked.Result method)
with_session() (sqlalchemy.orm.Query method)
with_statement_hint() (sqlalchemy.orm.Query method)
(sqlalchemy.sql.expression.Select method)
with_ties (sqlalchemy.sql.expression.GenerativeSelect.fetch parameter)
(sqlalchemy.sql.expression.Select.fetch parameter)
with_transformation() (sqlalchemy.orm.Query method)
with_variant() (sqlalchemy.types.TypeEngine method)
(sqlalchemy.types.Variant method)
within_group() (in module sqlalchemy.sql.expression)
(sqlalchemy.sql.functions.FunctionElement method)
within_group_type() (sqlalchemy.sql.functions.FunctionElement method)
(sqlalchemy.sql.functions.OrderedSetAgg method)
WithinGroup (class in sqlalchemy.sql.expression)
WrapsColumnExpression (class in sqlalchemy.sql.elements)

X

xid (sqlalchemy.engine.Connection.begin_twophase parameter)
(sqlalchemy.engine.default.DefaultDialect.do_begin_twophase parameter)
(sqlalchemy.engine.default.DefaultDialect.do_commit_twophase parameter)
XML (class in sqlalchemy.dialects.mssql)

Y

YEAR (class in sqlalchemy.dialects.mysql)
yield_per() (sqlalchemy.engine.ChunkedIteratorResult method)
(sqlalchemy.engine.CursorResult method)
(sqlalchemy.engine.Result method)

Z

zero_indexes (sqlalchemy.dialects.postgresql.ARRAY parameter)
(sqlalchemy.types.ARRAY attribute)
(sqlalchemy.types.ARRAY parameter)
zerofill (sqlalchemy.dialects.mysql.BIGINT parameter)
(sqlalchemy.dialects.mysql.DECIMAL parameter)
(sqlalchemy.dialects.mysql.DOUBLE parameter)