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.CompoundSelect.group_by parameter) (sqlalchemy.sql.expression.CompoundSelect.order_by parameter) (sqlalchemy.sql.expression.GenerativeSelect.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.ext.asyncio.async_scoped_session method) (sqlalchemy.orm.scoped_session method) (sqlalchemy.orm.sessionmaker 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.IMAGE method) (sqlalchemy.dialects.mssql.JSON 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) _asdict() (sqlalchemy.engine.Row 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) (sqlalchemy.orm.with_polymorphic parameter) adapt_to_emulated() (sqlalchemy.types.Interval method) adapt_to_entity() (sqlalchemy.orm.PropComparator method) (sqlalchemy.orm.QueryableAttribute method) (sqlalchemy.orm.RelationshipProperty.Comparator method) AdaptedConnection (class in sqlalchemy.engine) adapter (sqlalchemy.orm.PropComparator attribute) (sqlalchemy.orm.QueryableAttribute attribute) (sqlalchemy.orm.RelationshipProperty.Comparator attribute) add() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.ext.mutable.MutableSet method) add_all() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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) (sqlalchemy.sql.expression.StatementLambdaElement method) add_cte() (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.HasCTE method) (sqlalchemy.sql.expression.Select 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.dialects.mysql.match parameter) 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.CompoundSelect 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_mappers (sqlalchemy.orm.ORMExecuteState attribute) 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_key_label (sqlalchemy.schema.Column attribute) (sqlalchemy.sql.expression.ColumnElement attribute) 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) 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) append_group_by() (sqlalchemy.sql.expression.CompoundSelect method) append_order_by() (sqlalchemy.sql.expression.CompoundSelect method) append_wo_mutation() (sqlalchemy.orm.AttributeEvents method) appender() (sqlalchemy.orm.collections.collection static method) AppenderQuery (class in sqlalchemy.orm) apply_labels() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect 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) 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_generic() (sqlalchemy.types.TypeEngine method) as_immutable() (sqlalchemy.sql.expression.ColumnCollection method) as_integer() (sqlalchemy.types.JSON.Comparator method) as_json() (sqlalchemy.types.JSON.Comparator method) as_mutable() (sqlalchemy.ext.mutable.Mutable class method) as_numeric() (sqlalchemy.types.JSON.Comparator method) as_scalar() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.Select 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.oracle.DOUBLE_PRECISION parameter) (sqlalchemy.dialects.postgresql.DOUBLE_PRECISION parameter) (sqlalchemy.dialects.postgresql.REAL 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) async_engine_from_config() (in module sqlalchemy.ext.asyncio) async_object_session() (in module sqlalchemy.ext.asyncio) async_scoped_session (class in sqlalchemy.ext.asyncio) async_session (sqlalchemy.orm.InstanceState attribute) async_session() (in module sqlalchemy.ext.asyncio) 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 attached 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.async_scoped_session.expire parameter) (sqlalchemy.ext.asyncio.AsyncSession.expire parameter) (sqlalchemy.orm.scoped_session.expire 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.ext.asyncio.async_scoped_session attribute) (sqlalchemy.orm.Session parameter) (sqlalchemy.orm.sessionmaker parameter) autoflush() (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) AwaitRequired

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) 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) Base20DeprecationWarning 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncConnection method) begin_twophase() (sqlalchemy.engine.Connection method) (sqlalchemy.events.ConnectionEvents method) Best effort 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.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.scoped_session.connection parameter) bind_expression() (sqlalchemy.types.TypeDecorator method) (sqlalchemy.types.TypeEngine method) bind_mapper (sqlalchemy.orm.ORMExecuteState attribute) 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) BLOB (class in sqlalchemy.types) bool_op() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method) (sqlalchemy.orm.PropComparator method) (sqlalchemy.orm.QueryableAttribute method) BOOLEAN (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.scoped_session method) (sqlalchemy.orm.Session method) bulk_replace() (in module sqlalchemy.orm.collections) (sqlalchemy.orm.AttributeEvents method) bulk_save_objects() (sqlalchemy.orm.scoped_session method) (sqlalchemy.orm.Session method) bulk_update_mappings() (sqlalchemy.orm.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) cache_ok (sqlalchemy.types.ExternalType attribute) (sqlalchemy.types.Interval attribute) (sqlalchemy.types.PickleType attribute) 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) 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.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) classname_for_table (sqlalchemy.ext.automap.AutomapBase.prepare parameter) classname_for_table() (in module sqlalchemy.ext.automap) clause (sqlalchemy.ext.horizontal_shard.ShardedSession.get_bind parameter) (sqlalchemy.orm.scoped_session.connection parameter) (sqlalchemy.orm.scoped_session.get_bind parameter) ClauseElement (class in sqlalchemy.sql.expression) clauseelement (sqlalchemy.events.ConnectionEvents.after_execute parameter) (sqlalchemy.events.ConnectionEvents.before_execute parameter) ClauseList (class in sqlalchemy.sql.expression) clauses (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.Engine.dispose parameter) close() (sqlalchemy.engine.Connection method) (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.FilterResult method) close_all() (sqlalchemy.ext.asyncio.async_scoped_session class method) (sqlalchemy.ext.asyncio.AsyncSession class method) (sqlalchemy.orm.scoped_session class method) close_all_sessions() (in module sqlalchemy.orm) close_detached() (sqlalchemy.events.PoolEvents method) close_with_result (sqlalchemy.orm.scoped_session.connection parameter) (sqlalchemy.orm.Session.connection parameter) closed (sqlalchemy.engine.Connection attribute) (sqlalchemy.engine.FilterResult attribute) (sqlalchemy.engine.IteratorResult 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_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) (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.dialects.mysql.match parameter) (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_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) column_valued() (sqlalchemy.sql.functions.FunctionElement 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) 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.CheckConstraint attribute) columns clause columns() (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.MappingResult method) (sqlalchemy.engine.Result method) columns_clause_froms (sqlalchemy.sql.expression.Select attribute) comment (sqlalchemy.schema.Column parameter) (sqlalchemy.schema.Table parameter) commit() (sqlalchemy.engine.NestedTransaction method) (sqlalchemy.engine.RootTransaction method) (sqlalchemy.engine.Transaction 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) (sqlalchemy.sql.compiler.DDLCompiler 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.ext.asyncio.async_scoped_session method) (sqlalchemy.orm.registry method) (sqlalchemy.orm.scoped_session 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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.close 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 (sqlalchemy.schema.Table attribute) 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) 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.schema.CheckConstraint method) (sqlalchemy.schema.Column method) (sqlalchemy.schema.ColumnCollectionConstraint 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.CompoundSelect method) count (class in sqlalchemy.sql.functions) (sqlalchemy.engine.Row attribute) (sqlalchemy.sql.expression.CompoundSelect.fetch parameter) count() (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.mssql.BIT parameter) (sqlalchemy.dialects.mysql.BOOLEAN parameter) (sqlalchemy.types.Boolean 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.CompoundSelect 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.oracle) (class in sqlalchemy.dialects.sqlite) (class in sqlalchemy.types) 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.oracle.DOUBLE_PRECISION parameter) (sqlalchemy.dialects.postgresql.DOUBLE_PRECISION parameter) (sqlalchemy.dialects.postgresql.REAL parameter) declarative declarative_base (sqlalchemy.ext.automap.automap_base parameter) declarative_base() (in module sqlalchemy.orm) declarative_mixin() (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_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) defer() (in module sqlalchemy.orm) (sqlalchemy.orm.Load method) 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.async_scoped_session attribute) (sqlalchemy.ext.asyncio.AsyncSession 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.Base20DeprecationWarning 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.schema.Table attribute) (sqlalchemy.sql.expression.AliasedReturnsRows attribute) (sqlalchemy.sql.expression.ColumnElement 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.async_scoped_session attribute) (sqlalchemy.ext.asyncio.AsyncSession attribute) (sqlalchemy.orm.scoped_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.orm.registry 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 dml_compile_state (sqlalchemy.engine.Compiled attribute) (sqlalchemy.sql.compiler.DDLCompiler attribute) 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) do_terminate() (sqlalchemy.engine.default.DefaultDialect method) (sqlalchemy.engine.Dialect method) doc (sqlalchemy.orm.column_property parameter) (sqlalchemy.orm.composite parameter) (sqlalchemy.orm.relationship parameter) domain model DontWrapMixin (class in sqlalchemy.exc) DOUBLE_PRECISION (class in sqlalchemy.dialects.oracle) 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) driver_connection (sqlalchemy.engine.AdaptedConnection attribute) (sqlalchemy.pool._ConnectionFairy attribute) (sqlalchemy.pool._ConnectionRecord 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) echo_pool (sqlalchemy.create_engine parameter) effective_value (sqlalchemy.sql.expression.BindParameter attribute) element (sqlalchemy.orm.aliased parameter) (sqlalchemy.schema.CreateIndex parameter) (sqlalchemy.schema.CreateTable parameter) 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) enable_tracking (sqlalchemy.sql.expression.lambda_stmt parameter) 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.Engine attribute) (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_description (sqlalchemy.sql.expression.UpdateBase attribute) entity_namespace (sqlalchemy.schema.Table attribute) (sqlalchemy.sql.expression.ColumnElement attribute) (sqlalchemy.sql.expression.FromClause 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) 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) (sqlalchemy.events.PoolEvents.soft_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.async_scoped_session 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.InstanceEvents method) expire_all() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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.CompoundSelect attribute) (sqlalchemy.sql.expression.FromClause attribute) expr (sqlalchemy.orm.with_expression parameter) (sqlalchemy.sql.expression.between parameter) (sqlalchemy.sql.expression.extract parameter) expression (sqlalchemy.orm.ColumnProperty attribute) (sqlalchemy.orm.QueryableAttribute 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_session method) expunge_all() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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.ext.hybrid.hybrid_method attribute) (sqlalchemy.ext.hybrid.hybrid_property attribute) ExternalTraversal (class in sqlalchemy.sql.visitors) ExternalType (class in sqlalchemy.types) 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.CompoundSelect method) (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) field (sqlalchemy.sql.expression.extract parameter) fields (sqlalchemy.dialects.postgresql.INTERVAL parameter) filestream (sqlalchemy.dialects.mssql.VARBINARY parameter) filter() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.FunctionFilter method) (sqlalchemy.sql.expression.Select method) filter_by() (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) FilterResult (class in sqlalchemy.engine) 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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.Column attribute) (sqlalchemy.schema.Table attribute) ForeignKey (class in sqlalchemy.schema) ForeignKeyConstraint (class in sqlalchemy.schema) format_column() (sqlalchemy.sql.compiler.IdentifierPreparer method) format_label_name() (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) 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) Fully tested in CI func (in module sqlalchemy.sql.expression) funcfilter() (in module sqlalchemy.sql.expression) Function (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.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession 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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.ext.horizontal_shard.ShardedSession method) get_check_constraints() (sqlalchemy.engine.default.DefaultDialect method) (sqlalchemy.engine.Dialect method) (sqlalchemy.engine.reflection.Inspector method) get_children() (sqlalchemy.schema.CheckConstraint method) (sqlalchemy.schema.Column method) (sqlalchemy.schema.ColumnCollectionConstraint 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_default_isolation_level() (sqlalchemy.engine.default.DefaultDialect method) (sqlalchemy.engine.Dialect method) get_dialect() (sqlalchemy.engine.URL method) get_dialect_cls() (sqlalchemy.engine.default.DefaultDialect class method) (sqlalchemy.engine.Dialect class method) get_driver_connection() (sqlalchemy.engine.default.DefaultDialect method) (sqlalchemy.engine.Dialect 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_final_froms() (sqlalchemy.sql.expression.Select 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_label_style (sqlalchemy.orm.Query attribute) get_label_style() (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect method) (sqlalchemy.sql.expression.Select method) get_lastrowid() (sqlalchemy.engine.default.DefaultExecutionContext method) get_nested_transaction() (sqlalchemy.engine.Connection method) (sqlalchemy.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession 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_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.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession 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) global_track_bound_values (sqlalchemy.sql.expression.lambda_stmt parameter) 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.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect 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_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)

HasCacheKey (class in sqlalchemy.sql.traversals) HasCTE (class in sqlalchemy.sql.expression) HasDescriptionCode (class in sqlalchemy.exc) hashable (sqlalchemy.dialects.postgresql.HSTORE attribute) (sqlalchemy.types.ARRAY attribute) (sqlalchemy.types.JSON 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.scoped_session.get parameter) (sqlalchemy.orm.Session.get parameter) Identified (class in sqlalchemy.log) IdentifierError IdentifierPreparer (class in sqlalchemy.sql.compiler) Identity (class in sqlalchemy.schema) identity (sqlalchemy.orm.InstanceState attribute) identity key identity map identity_key (sqlalchemy.orm.InstanceState attribute) identity_key() (in module sqlalchemy.orm.util) (sqlalchemy.ext.asyncio.async_scoped_session class method) (sqlalchemy.ext.asyncio.AsyncSession 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.ext.asyncio.async_scoped_session attribute) (sqlalchemy.orm.Session attribute) IdentityMap (class in sqlalchemy.orm) if_exists (sqlalchemy.schema.DropIndex parameter) (sqlalchemy.schema.DropTable parameter) if_not_exists (sqlalchemy.schema.CreateIndex parameter) (sqlalchemy.schema.CreateTable parameter) 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) imperative impl (sqlalchemy.types.Interval attribute) (sqlalchemy.types.PickleType attribute) (sqlalchemy.types.PickleType parameter) implicit_returning (sqlalchemy.create_engine parameter) (sqlalchemy.schema.Table attribute) (sqlalchemy.schema.Table parameter) in_() (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance method) (sqlalchemy.orm.PropComparator method) (sqlalchemy.orm.QueryableAttribute method) in_boolean_mode (sqlalchemy.dialects.mysql.match parameter) in_boolean_mode() (sqlalchemy.dialects.mysql.match method) in_natural_language_mode (sqlalchemy.dialects.mysql.match parameter) in_natural_language_mode() (sqlalchemy.dialects.mysql.match method) in_nested_transaction() (sqlalchemy.engine.Connection method) (sqlalchemy.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession method) in_transaction() (sqlalchemy.engine.Connection method) (sqlalchemy.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession 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.async_scoped_session.is_modified parameter) (sqlalchemy.ext.asyncio.AsyncSession.is_modified parameter) (sqlalchemy.orm.scoped_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.engine.Row attribute) 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) indexes (sqlalchemy.schema.Table attribute) INET (class in sqlalchemy.dialects.postgresql) info (sqlalchemy.engine.Connection attribute) (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.ext.associationproxy.AssociationProxy parameter) inherit_cache (sqlalchemy.dialects.mysql.Insert attribute) (sqlalchemy.dialects.mysql.match attribute) (sqlalchemy.dialects.postgresql.hstore 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.append_wo_mutation parameter) (sqlalchemy.orm.AttributeEvents.bulk_replace 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 (sqlalchemy.event.listen parameter) 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.async_object_session parameter) (sqlalchemy.ext.asyncio.async_scoped_session.expire parameter) (sqlalchemy.ext.asyncio.async_scoped_session.is_modified 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.async_scoped_session 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.async_scoped_session attribute) (sqlalchemy.ext.asyncio.AsyncSession attribute) (sqlalchemy.orm.scoped_session attribute) is_aliased_class (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.orm.Bundle attribute) (sqlalchemy.orm.InspectionAttr attribute) is_attribute (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.ext.hybrid.hybrid_method attribute) (sqlalchemy.ext.hybrid.hybrid_property attribute) is_bound() (sqlalchemy.schema.MetaData method) (sqlalchemy.schema.ThreadLocalMetaData method) is_bundle (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.orm.Bundle attribute) (sqlalchemy.orm.InspectionAttr attribute) is_clause_element (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.orm.Bundle attribute) (sqlalchemy.orm.InspectionAttr attribute) is_column_load (sqlalchemy.orm.ORMExecuteState 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) (sqlalchemy.orm.InstanceState attribute) is_instrumented() (in module sqlalchemy.orm.instrumentation) is_literal (sqlalchemy.sql.expression.column parameter) is_mapper (sqlalchemy.ext.associationproxy.AssociationProxy attribute) (sqlalchemy.orm.Bundle attribute) (sqlalchemy.orm.InspectionAttr attribute) is_modified() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.scoped_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.orm.QueryableAttribute 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.sql.expression.ColumnCollection 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.Query method) join_depth (sqlalchemy.orm.relationship parameter) join_from() (sqlalchemy.sql.expression.Select method) joinedload() (in module sqlalchemy.orm) (sqlalchemy.orm.Load method) joins_implicitly (sqlalchemy.sql.functions.FunctionElement.alias parameter) (sqlalchemy.sql.functions.FunctionElement.column_valued parameter) (sqlalchemy.sql.functions.FunctionElement.table_valued parameter) 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.CompoundSelect.with_for_update parameter) (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) LABEL_STYLE_DEFAULT (in module sqlalchemy.sql.expression) LABEL_STYLE_DISAMBIGUATE_ONLY (in module sqlalchemy.sql.expression) LABEL_STYLE_NONE (in module sqlalchemy.sql.expression) LABEL_STYLE_TABLENAME_PLUS_COL (in module sqlalchemy.sql.expression) lambda_cache (sqlalchemy.sql.expression.lambda_stmt 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.CompoundSelect 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) left (sqlalchemy.sql.expression.join parameter) (sqlalchemy.sql.expression.outerjoin parameter) left_index (sqlalchemy.sql.functions.FunctionElement.as_comparison parameter) legacy_is_orphan (sqlalchemy.orm.mapper parameter) LegacyAPIWarning 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.CompoundSelect.limit parameter) (sqlalchemy.sql.expression.GenerativeSelect.limit parameter) (sqlalchemy.sql.expression.Select.create_legacy_select parameter) limit() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect method) link_to_name (sqlalchemy.schema.ForeignKey parameter) (sqlalchemy.schema.ForeignKeyConstraint parameter) listen() (in module sqlalchemy.event) listeners (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) lmb (sqlalchemy.sql.expression.lambda_stmt parameter) Load (class in sqlalchemy.orm) load (sqlalchemy.orm.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) load_options (sqlalchemy.orm.ORMExecuteState 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) logging_token (sqlalchemy.engine.Connection.execution_options 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) MACADDR8 (class in sqlalchemy.dialects.postgresql) maintain_column_froms (sqlalchemy.sql.expression.Select.with_only_columns parameter) 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 in sqlalchemy.orm) 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.horizontal_shard.ShardedSession.get_bind parameter) (sqlalchemy.orm.declarative_base parameter) (sqlalchemy.orm.InstanceState attribute) mapper() (in module sqlalchemy.orm) mapper_configured() (sqlalchemy.orm.MapperEvents method) MapperEvents (class in sqlalchemy.orm) MapperProperty (class in sqlalchemy.orm) mappers (sqlalchemy.orm.registry attribute) mapping (sqlalchemy.types.Variant parameter) MappingResult (class in sqlalchemy.engine) mappings (sqlalchemy.orm.scoped_session.bulk_insert_mappings parameter) (sqlalchemy.orm.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 (class in sqlalchemy.dialects.mysql) (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) max_row_buffer (sqlalchemy.engine.Connection.execution_options 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.ext.asyncio.AsyncMappingResult class method) (sqlalchemy.ext.asyncio.AsyncResult class method) (sqlalchemy.ext.asyncio.AsyncScalarResult class method) merge() (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.Result method) (sqlalchemy.ext.asyncio.async_scoped_session 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) MissingGreenlet 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.mssql.BIT parameter) (sqlalchemy.dialects.mysql.BOOLEAN parameter) (sqlalchemy.dialects.postgresql.ExcludeConstraint 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) named (sqlalchemy.event.listen parameter) 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.mysql) (class in sqlalchemy.types) NCLOB (class in sqlalchemy.dialects.oracle) nested (sqlalchemy.orm.scoped_session.begin parameter) (sqlalchemy.orm.Session.begin parameter) (sqlalchemy.orm.SessionTransaction attribute) NestedTransaction (class in sqlalchemy.engine) nesting (sqlalchemy.sql.expression.CompoundSelect.cte parameter) (sqlalchemy.sql.expression.HasCTE.cte parameter) (sqlalchemy.sql.expression.Select.cte parameter) new (sqlalchemy.ext.asyncio.async_scoped_session attribute) (sqlalchemy.ext.asyncio.AsyncSession attribute) (sqlalchemy.orm.scoped_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.async_scoped_session attribute) (sqlalchemy.ext.asyncio.AsyncSession attribute) (sqlalchemy.orm.scoped_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) 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 Normal support 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.CompoundSelect.with_for_update parameter) (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.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.async_scoped_session class method) (sqlalchemy.ext.asyncio.AsyncSession class method) object_state() (in module sqlalchemy.orm.util) ObjectAssociationProxyInstance (class in sqlalchemy.ext.associationproxy) ObjectDeletedError ObjectDereferencedError ObjectNotExecutableError objects (sqlalchemy.orm.scoped_session.bulk_save_objects parameter) (sqlalchemy.orm.scoped_session.flush parameter) (sqlalchemy.orm.Session.bulk_save_objects parameter) of (sqlalchemy.sql.expression.CompoundSelect.with_for_update parameter) (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) offset (sqlalchemy.sql.expression.CompoundSelect.offset parameter) (sqlalchemy.sql.expression.GenerativeSelect.offset parameter) (sqlalchemy.sql.expression.Select.create_legacy_select parameter) offset() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect method) OID (class in sqlalchemy.dialects.postgresql) oldvalue (sqlalchemy.orm.AttributeEvents.set parameter) omit_aliases (sqlalchemy.types.Enum parameter) omit_join (sqlalchemy.orm.relationship parameter) on (sqlalchemy.schema.CreateIndex parameter) (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_connect_url() (sqlalchemy.engine.default.DefaultDialect method) (sqlalchemy.engine.Dialect method) on_duplicate_key_update() (sqlalchemy.dialects.mysql.Insert method) on_null (sqlalchemy.schema.Identity parameter) once (sqlalchemy.event.listen 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.scoped_session.get parameter) (sqlalchemy.orm.scoped_session.merge parameter) (sqlalchemy.orm.Session.get parameter) options() (sqlalchemy.orm.Load method) (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect 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.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect method) order_by_clause() (sqlalchemy.sql.compiler.SQLCompiler method) ordered_values() (sqlalchemy.sql.expression.Update method) 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.Query method) outerjoin_from() (sqlalchemy.sql.expression.Select 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) 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.orm.Query method) (sqlalchemy.schema.Column method) (sqlalchemy.schema.Table 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 pep-249 percent (sqlalchemy.sql.expression.CompoundSelect.fetch parameter) (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-enabled 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.collections.MappedCollection method) populate_existing (sqlalchemy.orm.scoped_session.get parameter) (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) positiontup (sqlalchemy.sql.compiler.SQLCompiler attribute) 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) precedence (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance.op parameter) (sqlalchemy.orm.PropComparator.op parameter) (sqlalchemy.orm.QueryableAttribute.op parameter) precision (sqlalchemy.dialects.mysql.DECIMAL parameter) (sqlalchemy.dialects.mysql.DOUBLE parameter) (sqlalchemy.dialects.mysql.FLOAT 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.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) process_compile_state_replaced_entities() (sqlalchemy.orm.Load method) process_literal_param() (sqlalchemy.types.TypeDecorator method) process_result_value() (sqlalchemy.types.TypeDecorator method) ProgrammingError propagate (sqlalchemy.event.listen parameter) (sqlalchemy.orm.AttributeEvents parameter) (sqlalchemy.orm.InstanceEvents parameter) propagate_to_loaders (sqlalchemy.orm.Load attribute) (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] [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] 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.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.scoped_session method) query_string (sqlalchemy.engine.URL.update_query_string parameter) QueryableAttribute (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) 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.CompoundSelect.with_for_update parameter) (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.types) 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.AssertionPool method) (sqlalchemy.pool.NullPool method) (sqlalchemy.pool.Pool method) recursive (sqlalchemy.sql.expression.CompoundSelect.cte parameter) (sqlalchemy.sql.expression.HasCTE.cte parameter) (sqlalchemy.sql.expression.Select.cte parameter) recycle (sqlalchemy.pool.Pool 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) reflect() (sqlalchemy.schema.MetaData method) reflect_table() (sqlalchemy.engine.reflection.Inspector method) reflected reflection reflection_options (sqlalchemy.ext.automap.AutomapBase.prepare parameter) reflecttable() (sqlalchemy.engine.reflection.Inspector method) refresh() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncSession method) (sqlalchemy.orm.InstanceEvents 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.asyncio.async_scoped_session method) (sqlalchemy.ext.mutable.MutableList 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_derived() (sqlalchemy.sql.expression.TableValuedAlias method) render_literal_execute() (sqlalchemy.sql.expression.BindParameter method) render_literal_value() (sqlalchemy.sql.compiler.SQLCompiler method) render_nulls (sqlalchemy.orm.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.CompoundSelect method) (sqlalchemy.sql.expression.Select 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.CompoundSelect.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) 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) 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.scoped_session.bulk_insert_mappings parameter) (sqlalchemy.orm.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_column_descriptions (sqlalchemy.sql.expression.UpdateBase attribute) 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) retval (sqlalchemy.event.listen parameter) (sqlalchemy.events.ConnectionEvents parameter) (sqlalchemy.orm.AttributeEvents 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.NestedTransaction method) (sqlalchemy.engine.RootTransaction method) (sqlalchemy.engine.Transaction method) rollback_savepoint() (sqlalchemy.events.ConnectionEvents method) rollback_twophase() (sqlalchemy.events.ConnectionEvents method) rollup (class in sqlalchemy.sql.functions) RootTransaction (class in sqlalchemy.engine) 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_async() (sqlalchemy.engine.AdaptedConnection method) run_callable() (sqlalchemy.engine.Connection method) (sqlalchemy.engine.Engine method) (sqlalchemy.future.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.CompoundSelect method) (sqlalchemy.sql.expression.Select method) scalar_table_valued() (sqlalchemy.sql.functions.FunctionElement method) ScalarResult (class in sqlalchemy.engine) scalars() (sqlalchemy.engine.Connection method) (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.Result 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) [0] (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) ScopedRegistry (class in sqlalchemy.util) scopefunc (sqlalchemy.ext.asyncio.async_scoped_session parameter) (sqlalchemy.orm.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.Query attribute) (sqlalchemy.orm.with_polymorphic 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) selectinload() (in module sqlalchemy.orm) (sqlalchemy.orm.Load method) 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.ext.asyncio.async_session parameter) (sqlalchemy.orm.InstanceState attribute) (sqlalchemy.orm.ORMExecuteState attribute) session_factory (sqlalchemy.ext.asyncio.async_scoped_session parameter) (sqlalchemy.orm.scoped_session attribute) (sqlalchemy.orm.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_label_style() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect 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.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.CompoundSelect.with_for_update parameter) (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.Query method) (sqlalchemy.sql.expression.CompoundSelect 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.TypeDecorator attribute) (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.DDLCompiler 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.aiomysql module sqlalchemy.dialects.mysql.asyncmy module sqlalchemy.dialects.mysql.base module sqlalchemy.dialects.mysql.cymysql module sqlalchemy.dialects.mysql.mariadbconnector 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.aiosqlite 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.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.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession method) stream_results (sqlalchemy.engine.Connection.execution_options parameter) stream_scalars() (sqlalchemy.ext.asyncio.async_scoped_session method) (sqlalchemy.ext.asyncio.AsyncConnection method) (sqlalchemy.ext.asyncio.AsyncSession method) 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) stringify_dialect (sqlalchemy.schema.CreateSchema attribute) (sqlalchemy.schema.DropSchema attribute) (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.CompoundSelect method) (sqlalchemy.sql.expression.Select method) subqueryload() (in module sqlalchemy.orm) (sqlalchemy.orm.Load method) subtransactions (sqlalchemy.orm.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_default_metavalue (sqlalchemy.engine.default.DefaultDialect attribute) supports_default_values (sqlalchemy.engine.default.DefaultDialect attribute) supports_empty_insert (sqlalchemy.engine.default.DefaultDialect attribute) 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) supports_statement_cache (sqlalchemy.engine.default.DefaultDialect attribute) (sqlalchemy.engine.Dialect attribute) symmetric (sqlalchemy.sql.expression.between parameter) symmetric_difference_update() (sqlalchemy.ext.mutable.MutableSet method) sync_backref (sqlalchemy.orm.relationship parameter) sync_connection (sqlalchemy.ext.asyncio.AsyncConnection attribute) sync_engine (sqlalchemy.ext.asyncio.AsyncConnection attribute) (sqlalchemy.ext.asyncio.AsyncEngine attribute) sync_session (sqlalchemy.ext.asyncio.AsyncSession attribute) sync_session_class (sqlalchemy.ext.asyncio.AsyncSession attribute) (sqlalchemy.ext.asyncio.AsyncSession 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_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) (sqlalchemy.future.Engine method) table_valued() (sqlalchemy.schema.Table method) (sqlalchemy.sql.expression.FromClause method) (sqlalchemy.sql.expression.TableClause method) TableClause (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) TableValuedAlias (class in sqlalchemy.sql.expression) 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) (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance attribute) (sqlalchemy.ext.associationproxy.ObjectAssociationProxyInstance attribute) target_collection (sqlalchemy.ext.associationproxy.association_proxy parameter) (sqlalchemy.ext.associationproxy.AssociationProxy parameter) target_fullname (sqlalchemy.schema.ForeignKey attribute) TEXT (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) 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.postgresql) 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.dialects.postgresql) timetuple (sqlalchemy.ext.associationproxy.ColumnAssociationProxyInstance attribute) (sqlalchemy.orm.PropComparator attribute) (sqlalchemy.orm.QueryableAttribute 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) track_bound_values (sqlalchemy.sql.expression.lambda_stmt parameter) track_closure_variables (sqlalchemy.orm.with_loader_criteria parameter) (sqlalchemy.sql.expression.lambda_stmt parameter) 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) (sqlalchemy.future.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) undefer_group() (in module sqlalchemy.orm) (sqlalchemy.orm.Load method) 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.CTE method) union_all() (in module sqlalchemy.sql.expression) (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CTE method) unique (sqlalchemy.schema.Column attribute) (sqlalchemy.schema.Column parameter) (sqlalchemy.schema.Index parameter) unique constraint unique key index unique() (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.MappingResult method) (sqlalchemy.engine.Result method) unique_params() (sqlalchemy.schema.Column method) (sqlalchemy.schema.Table method) (sqlalchemy.sql.expression.ClauseElement 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.ext.instrumentation.InstrumentationManager method) (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.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.types) VARCHAR (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.Query method) (sqlalchemy.sql.expression.Delete method) (sqlalchemy.sql.expression.Exists 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) with_for_update (sqlalchemy.orm.scoped_session.get parameter) (sqlalchemy.orm.scoped_session.refresh parameter) (sqlalchemy.orm.Session.get parameter) with_for_update() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.CompoundSelect method) (sqlalchemy.sql.expression.GenerativeSelect 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_ordinality (sqlalchemy.sql.functions.FunctionElement.table_valued parameter) 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_query_expansion (sqlalchemy.dialects.mysql.match parameter) with_query_expansion() (sqlalchemy.dialects.mysql.match method) with_session() (sqlalchemy.orm.Query method) with_statement_hint() (sqlalchemy.orm.Query method) (sqlalchemy.sql.expression.Select method) with_ties (sqlalchemy.sql.expression.CompoundSelect.fetch parameter) (sqlalchemy.sql.expression.GenerativeSelect.fetch parameter) (sqlalchemy.sql.expression.Select.fetch parameter) with_transformation() (sqlalchemy.orm.Query method) with_types (sqlalchemy.sql.expression.TableValuedAlias.render_derived parameter) 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) 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.Connection.execution_options parameter) yield_per() (sqlalchemy.engine.ChunkedIteratorResult method) (sqlalchemy.engine.CursorResult method) (sqlalchemy.engine.FilterResult 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)