Search.setIndex({objects:{"":{vertical:[23,0,1],derived_attributes:[23,0,1],poly_assoc:[23,0,1],beaker_caching:[23,0,1],inheritance:[23,0,1],nested_sets:[23,0,1],postgis:[23,0,1],adjacency_list:[23,0,1],graphs:[23,0,1],large_collection:[23,0,1],custom_attributes:[23,0,1],dynamic_dict:[23,0,1],sharding:[23,0,1],elementtree:[23,0,1],association:[23,0,1],versioning:[23,0,1]},"sqlalchemy.sql.expression.TableClause":{count:[26,3,1],insert:[26,3,1],update:[26,3,1],"__init__":[26,3,1],"delete":[26,3,1]},"sqlalchemy.sql.expression.FunctionElement":{"__init__":[26,3,1]},"sqlalchemy.schema.DDL":{"__init__":[31,3,1]},"sqlalchemy.types.TypeDecorator":{result_processor:[39,3,1],process_bind_param:[39,3,1],is_mutable:[39,3,1],compare_values:[39,3,1],type_engine:[39,3,1],dialect_impl:[39,3,1],compile:[39,3,1],bind_processor:[39,3,1],get_dbapi_type:[39,3,1],adapt:[39,3,1],copy_value:[39,3,1],load_dialect_impl:[39,3,1],coerce_compared_value:[39,3,1],copy:[39,3,1],"__init__":[39,3,1],process_result_value:[39,3,1]},"sqlalchemy.engine.reflection":{Inspector:[31,4,1]},"sqlalchemy.dialects.mysql.MEDIUMBLOB":{"__init__":[2,3,1]},"sqlalchemy.sql.expression.ColumnElement":{compare:[26,3,1],shares_lineage:[26,3,1],anon_label:[26,5,1]},"sqlalchemy.dialects.mysql.TIMESTAMP":{"__init__":[2,3,1]},"sqlalchemy.sql.functions":{count:[26,4,1],sysdate:[26,4,1],max:[26,4,1],ReturnTypeFromArgs:[26,4,1],GenericFunction:[26,4,1],min:[26,4,1],current_time:[26,4,1],AnsiFunction:[26,4,1],sum:[26,4,1],random:[26,4,1],localtimestamp:[26,4,1],session_user:[26,4,1],char_length:[26,4,1],coalesce:[26,4,1],current_date:[26,4,1],current_timestamp:[26,4,1],user:[26,4,1],current_user:[26,4,1],now:[26,4,1],concat:[26,4,1],localtime:[26,4,1]},"sqlalchemy.ext.sqlsoup":{SqlSoup:[0,4,1]},"sqlalchemy.dialects.postgresql.REAL":{"__init__":[30,3,1]},"sqlalchemy.pool.SingletonThreadPool":{"__init__":[7,3,1]},"sqlalchemy.types.String":{"__init__":[39,3,1]},"sqlalchemy.dialects.sybase":{mxodbc:[12,0,1],pysybase:[12,0,1],base:[12,0,1],pyodbc:[12,0,1]},"sqlalchemy.orm.collections.MappedCollection":{set:[1,3,1],remove:[1,3,1],"__init__":[1,3,1]},"sqlalchemy.orm.session":{sessionmaker:[33,2,1],object_session:[33,2,1],Session:[33,4,1],make_transient:[33,2,1]},"sqlalchemy.orm.util":{AliasedClass:[21,4,1],polymorphic_union:[19,2,1],identity_key:[19,2,1]},"sqlalchemy.dialects.mysql.BLOB":{"__init__":[2,3,1]},"sqlalchemy.engine.url.URL":{get_dialect:[27,3,1],translate_connect_args:[27,3,1],"__init__":[27,3,1]},"sqlalchemy.sql.expression.ColumnOperators":{startswith:[26,3,1],concat:[26,3,1],in_:[26,3,1],like:[26,3,1],distinct:[26,3,1],contains:[26,3,1],ilike:[26,3,1],endswith:[26,3,1],asc:[26,3,1],"__init__":[26,5,1],collate:[26,3,1],timetuple:[26,5,1],between:[26,3,1],operate:[26,3,1],reverse_operate:[26,3,1],op:[26,3,1],match:[26,3,1],desc:[26,3,1]},"sqlalchemy.ext.sqlsoup.SqlSoup":{engine:[0,5,1],map:[0,3,1],execute:[0,3,1],join:[0,3,1],expunge:[0,3,1],bind:[0,5,1],clear:[0,3,1],expunge_all:[0,3,1],connection:[0,3,1],rollback:[0,3,1],map_to:[0,3,1],with_labels:[0,3,1],flush:[0,3,1],commit:[0,3,1],entity:[0,3,1],"__init__":[0,3,1],"delete":[0,3,1]},"sqlalchemy.schema.ForeignKey":{get_referent:[31,3,1],column:[31,5,1],references:[31,3,1],copy:[31,3,1],"__init__":[31,3,1],target_fullname:[31,5,1]},"sqlalchemy.pool":{NullPool:[7,4,1],clear_managers:[7,2,1],manage:[7,2,1],StaticPool:[7,4,1],SingletonThreadPool:[7,4,1],QueuePool:[7,4,1],AssertionPool:[7,4,1],Pool:[7,4,1]},"sqlalchemy.orm.attributes.History":{non_deleted:[33,3,1],non_added:[33,3,1],deleted:[33,5,1],unchanged:[33,5,1],added:[33,5,1],has_changes:[33,3,1],sum:[33,3,1],empty:[33,3,1]},"sqlalchemy.dialects.mysql.SMALLINT":{"__init__":[2,3,1]},"sqlalchemy.sql.expression":{ColumnClause:[26,4,1],Executable:[26,4,1],exists:[26,2,1],Insert:[26,4,1],TableClause:[26,4,1],text:[26,2,1],not_:[26,2,1],ColumnElement:[26,4,1],and_:[26,2,1],union_all:[26,2,1],table:[26,2,1],ClauseElement:[26,4,1],except_:[26,2,1],"null":[26,2,1],extract:[26,2,1],ColumnCollection:[26,4,1],tuple_:[26,2,1],Function:[26,4,1],outparam:[26,2,1],type_coerce:[26,2,1],cast:[26,2,1],distinct:[26,2,1],Update:[26,4,1],label:[26,2,1],literal:[26,2,1],bindparam:[26,2,1],intersect:[26,2,1],between:[26,2,1],outerjoin:[26,2,1],Selectable:[26,4,1],FunctionElement:[26,4,1],intersect_all:[26,2,1],Delete:[26,4,1],collate:[26,2,1],"case":[26,2,1],select:[26,2,1],Join:[26,4,1],ColumnOperators:[26,4,1],or_:[26,2,1],update:[26,2,1],asc:[26,2,1],Alias:[26,4,1],"_CompareMixin":[26,4,1],alias:[26,2,1],func:[26,7,1],union:[26,2,1],desc:[26,2,1],literal_column:[26,2,1],insert:[26,2,1],join:[26,2,1],FromClause:[26,4,1],"_BindParamClause":[26,4,1],column:[26,2,1],CompoundSelect:[26,4,1],except_all:[26,2,1],subquery:[26,2,1],"_SelectBaseMixin":[26,4,1],Select:[26,4,1],"delete":[26,2,1]},"sqlalchemy.sql.expression.FromClause":{count:[26,3,1],is_derived_from:[26,3,1],join:[26,3,1],description:[26,5,1],c:[26,5,1],correspond_on_equivalents:[26,3,1],corresponding_column:[26,3,1],alias:[26,3,1],foreign_keys:[26,5,1],select:[26,3,1],outerjoin:[26,3,1],replace_selectable:[26,3,1],columns:[26,5,1],primary_key:[26,5,1]},"sqlalchemy.ext.associationproxy":{association_proxy:[6,2,1],AssociationProxy:[6,4,1]},"sqlalchemy.orm.mapper.Mapper":{get_property:[19,3,1],compile:[19,3,1],get_property_by_column:[19,3,1],self_and_descendants:[19,5,1],polymorphic_iterator:[19,3,1],identity_key_from_primary_key:[19,3,1],primary_key_from_instance:[19,3,1],add_properties:[19,3,1],cascade_iterator:[19,3,1],iterate_properties:[19,5,1],common_parent:[19,3,1],identity_key_from_instance:[19,3,1],primary_mapper:[19,3,1],identity_key_from_row:[19,3,1],isa:[19,3,1],add_property:[19,3,1],"__init__":[19,3,1]},"sqlalchemy.dialects.mysql.DATE":{"__init__":[2,3,1]},"sqlalchemy.sql.expression._SelectBaseMixin":{autocommit:[26,3,1],order_by:[26,3,1],apply_labels:[26,3,1],offset:[26,3,1],label:[26,3,1],group_by:[26,3,1],limit:[26,3,1],"__init__":[26,3,1],append_group_by:[26,3,1],append_order_by:[26,3,1],as_scalar:[26,3,1]},"sqlalchemy.dialects.mssql.DATETIMEOFFSET":{"__init__":[4,3,1]},"sqlalchemy.sql.expression.Alias":{"__init__":[26,3,1]},"sqlalchemy.dialects.postgresql.INET":{"__init__":[30,3,1]},"sqlalchemy.dialects.mysql.VARBINARY":{"__init__":[2,3,1]},"sqlalchemy.orm.interfaces":{AttributeExtension:[13,4,1],PropComparator:[19,4,1],SessionExtension:[13,4,1],InstrumentationManager:[13,4,1],MapperExtension:[13,4,1]},"sqlalchemy.types.TypeEngine":{result_processor:[39,3,1],is_mutable:[39,3,1],compare_values:[39,3,1],dialect_impl:[39,3,1],compile:[39,3,1],bind_processor:[39,3,1],get_dbapi_type:[39,3,1],adapt:[39,3,1],copy_value:[39,3,1],"__init__":[39,3,1]},"sqlalchemy.dialects.mssql.TIME":{"__init__":[4,3,1]},"sqlalchemy.dialects.informix":{informixdb:[3,0,1],base:[3,0,1]},"sqlalchemy.dialects.mysql.ENUM":{"__init__":[2,3,1]},"sqlalchemy.dialects.mssql.REAL":{"__init__":[4,3,1]},"sqlalchemy.dialects.mssql.SQL_VARIANT":{"__init__":[4,3,1]},"sqlalchemy.types.Boolean":{"__init__":[39,3,1]},"sqlalchemy.dialects.mysql.FLOAT":{"__init__":[2,3,1]},"sqlalchemy.sql.expression.Delete":{where:[26,3,1]},"sqlalchemy.dialects.oracle.BFILE":{"__init__":[37,3,1]},"sqlalchemy.types.LargeBinary":{"__init__":[39,3,1]},"sqlalchemy.dialects.mysql.BINARY":{"__init__":[2,3,1]},"sqlalchemy.orm.collections":{collection:[1,4,1],column_mapped_collection:[1,2,1],MappedCollection:[1,4,1],mapped_collection:[1,2,1],collection_adapter:[1,2,1],attribute_mapped_collection:[1,2,1]},"sqlalchemy.schema":{Index:[31,4,1],DropConstraint:[31,4,1],CheckConstraint:[31,4,1],DDL:[31,4,1],DefaultGenerator:[31,4,1],ForeignKeyConstraint:[31,4,1],CreateTable:[31,4,1],CreateIndex:[31,4,1],PassiveDefault:[31,4,1],ForeignKey:[31,4,1],DefaultClause:[31,4,1],DDLElement:[31,4,1],DropIndex:[31,4,1],DropSequence:[31,4,1],FetchedValue:[31,4,1],MetaData:[31,4,1],ColumnDefault:[31,4,1],ThreadLocalMetaData:[31,4,1],UniqueConstraint:[31,4,1],Constraint:[31,4,1],Column:[31,4,1],CreateSequence:[31,4,1],ColumnCollectionConstraint:[31,4,1],DropTable:[31,4,1],Sequence:[31,4,1],AddConstraint:[31,4,1],Table:[31,4,1],PrimaryKeyConstraint:[31,4,1]},"sqlalchemy.dialects.postgresql.UUID":{"__init__":[30,3,1]},"sqlalchemy.dialects.mysql.INTEGER":{"__init__":[2,3,1]},"sqlalchemy.ext.orderinglist":{ordering_list:[24,2,1]},"sqlalchemy.dialects.mssql":{REAL:[4,4,1],DATETIMEOFFSET:[4,4,1],SMALLDATETIME:[4,4,1],TEXT:[4,4,1],CHAR:[4,4,1],TINYINT:[4,4,1],mxodbc:[4,0,1],pyodbc:[4,0,1],VARCHAR:[4,4,1],IMAGE:[4,4,1],DATETIME2:[4,4,1],BIT:[4,4,1],NTEXT:[4,4,1],zxjdbc:[4,0,1],adodbapi:[4,0,1],base:[4,0,1],pymssql:[4,0,1],NVARCHAR:[4,4,1],NCHAR:[4,4,1],UNIQUEIDENTIFIER:[4,4,1],SQL_VARIANT:[4,4,1],MONEY:[4,4,1],SMALLMONEY:[4,4,1],TIME:[4,4,1]},"sqlalchemy.dialects.postgresql.BIT":{"__init__":[30,3,1]},"sqlalchemy.types.Float":{"__init__":[39,3,1]},"sqlalchemy.dialects":{sqlite:[42,0,1]},"sqlalchemy.engine":{base:[15,0,1]},"sqlalchemy.schema.Table":{append_column:[31,3,1],primary_key:[31,5,1],exists:[31,3,1],bind:[31,5,1],create:[31,3,1],drop:[31,3,1],get_children:[31,3,1],add_is_dependent_on:[31,3,1],tometadata:[31,3,1],key:[31,5,1],append_ddl_listener:[31,3,1],"__init__":[31,3,1],append_constraint:[31,3,1]},"sqlalchemy.dialects.mssql.NVARCHAR":{"__init__":[4,3,1]},"sqlalchemy.types.PickleType":{is_mutable:[39,3,1],impl:[39,5,1],"__init__":[39,3,1]},"sqlalchemy.sql.expression.Join":{alias:[26,3,1],"__init__":[26,3,1],select:[26,3,1]},"sqlalchemy.schema.DropConstraint":{"__init__":[31,3,1]},"sqlalchemy.dialects.mysql.TEXT":{"__init__":[2,3,1]},"sqlalchemy.sql.expression.ColumnClause":{"__init__":[26,3,1]},"sqlalchemy.orm.interfaces.InstrumentationManager":{manage:[13,3,1],dict_getter:[13,3,1],instrument_attribute:[13,3,1],uninstall_member:[13,3,1],dispose:[13,3,1],post_configure_attribute:[13,3,1],initialize_instance_dict:[13,3,1],install_member:[13,3,1],uninstall_descriptor:[13,3,1],install_state:[13,3,1],instrument_collection_class:[13,3,1],state_getter:[13,3,1],remove_state:[13,3,1],get_instance_dict:[13,3,1],manager_getter:[13,3,1],"__init__":[13,3,1],install_descriptor:[13,3,1]},"sqlalchemy.ext.horizontal_shard.ShardedSession":{"__init__":[25,3,1]},"sqlalchemy.dialects.postgresql":{REAL:[30,4,1],ARRAY:[30,4,1],INTERVAL:[30,4,1],UUID:[30,4,1],zxjdbc:[30,0,1],psycopg2:[30,0,1],ENUM:[30,4,1],DOUBLE_PRECISION:[30,4,1],BIT:[30,4,1],pypostgresql:[30,0,1],BYTEA:[30,4,1],base:[30,0,1],pg8000:[30,0,1],CIDR:[30,4,1],MACADDR:[30,4,1],INET:[30,4,1]},"sqlalchemy.orm":{contains_eager:[20,2,1],defer:[19,2,1],subqueryload_all:[20,2,1],aliased:[21,4,1],dynamic_loader:[1,2,1],validates:[19,2,1],object_mapper:[19,2,1],session:[33,0,1],relation:[22,2,1],joinedload_all:[20,2,1],contains_alias:[20,2,1],joinedload:[20,2,1],subqueryload:[20,2,1],outerjoin:[21,2,1],eagerload:[20,2,1],undefer_group:[19,2,1],column_property:[19,2,1],relationship:[22,2,1],composite:[19,2,1],interfaces:[13,0,1],class_mapper:[19,2,1],clear_mappers:[19,2,1],compile_mappers:[19,2,1],join:[21,2,1],scoped_session:[33,2,1],reconstructor:[19,2,1],mapper:[19,2,1],synonym:[19,2,1],exc:[35,0,1],comparable_property:[19,2,1],undefer:[19,2,1],deferred:[19,2,1],with_parent:[21,2,1],lazyload:[20,2,1],eagerload_all:[20,2,1],backref:[22,2,1]},"sqlalchemy.sql.expression.Update":{where:[26,3,1],values:[26,3,1]},"sqlalchemy.dialects.postgresql.INTERVAL":{"__init__":[30,3,1]},"sqlalchemy.engine.base.Transaction":{commit:[15,3,1],rollback:[15,3,1],"__init__":[15,3,1],close:[15,3,1]},"sqlalchemy.ext":{associationproxy:[6,0,1],orderinglist:[24,0,1],sqlsoup:[0,0,1],horizontal_shard:[25,0,1],declarative:[41,0,1],serializer:[8,0,1],compiler:[43,0,1]},"sqlalchemy.schema.DDLElement":{bind:[31,5,1],execute:[31,3,1],execute_at:[31,3,1],against:[31,3,1]},"sqlalchemy.types.Unicode":{"__init__":[39,3,1]},"sqlalchemy.dialects.mysql.REAL":{"__init__":[2,3,1]},"sqlalchemy.dialects.mssql.NCHAR":{"__init__":[4,3,1]},"sqlalchemy.types.UserDefinedType":{result_processor:[39,3,1],is_mutable:[39,3,1],compare_values:[39,3,1],dialect_impl:[39,3,1],compile:[39,3,1],bind_processor:[39,3,1],get_dbapi_type:[39,3,1],adapt:[39,3,1],copy_value:[39,3,1],adapt_operator:[39,3,1],"__init__":[39,3,1]},"sqlalchemy.dialects.postgresql.MACADDR":{"__init__":[30,3,1]},"sqlalchemy.engine.base.ResultProxy":{fetchall:[15,3,1],last_updated_params:[15,3,1],last_inserted_ids:[15,3,1],is_insert:[15,5,1],keys:[15,3,1],fetchone:[15,3,1],supports_sane_rowcount:[15,3,1],returns_rows:[15,5,1],last_inserted_params:[15,3,1],lastrow_has_defaults:[15,3,1],rowcount:[15,5,1],scalar:[15,3,1],supports_sane_multi_rowcount:[15,3,1],postfetch_cols:[15,3,1],close:[15,3,1],lastrowid:[15,5,1],inserted_primary_key:[15,5,1],fetchmany:[15,3,1],"__init__":[15,3,1],first:[15,3,1]},"sqlalchemy.schema.Column":{append_foreign_key:[31,3,1],copy:[31,3,1],references:[31,3,1],"__init__":[31,3,1],get_children:[31,3,1]},"sqlalchemy.types.Time":{"__init__":[39,3,1]},"sqlalchemy.types":{FLOAT:[39,4,1],TypeEngine:[39,4,1],CLOB:[39,4,1],UnicodeText:[39,4,1],TEXT:[39,4,1],DateTime:[39,4,1],CHAR:[39,4,1],BIGINT:[39,4,1],DATE:[39,4,1],VARBINARY:[39,4,1],INTEGER:[39,4,1],AbstractType:[39,4,1],SMALLINT:[39,4,1],VARCHAR:[39,4,1],String:[39,4,1],Enum:[39,4,1],NUMERIC:[39,4,1],Concatenable:[39,4,1],TypeDecorator:[39,4,1],BOOLEAN:[39,4,1],Date:[39,4,1],Integer:[39,4,1],SchemaType:[39,4,1],Text:[39,4,1],LargeBinary:[39,4,1],BLOB:[39,4,1],UserDefinedType:[39,4,1],BINARY:[39,4,1],DECIMAL:[39,4,1],Interval:[39,4,1],DATETIME:[39,4,1],PickleType:[39,4,1],Time:[39,4,1],NullType:[39,4,1],NVARCHAR:[39,4,1],NCHAR:[39,4,1],SmallInteger:[39,4,1],BigInteger:[39,4,1],INT:[39,5,1],TIMESTAMP:[39,4,1],Float:[39,4,1],Numeric:[39,4,1],Boolean:[39,4,1],MutableType:[39,4,1],Unicode:[39,4,1],TIME:[39,4,1]},"sqlalchemy.orm.attributes.sqlalchemy.orm.attributes":{PASSIVE_NO_INITIALIZE:[33,5,1],PASSIVE_OFF:[33,5,1],PASSIVE_NO_FETCH:[33,5,1]},"sqlalchemy.util.ScopedRegistry":{clear:[33,3,1],has:[33,3,1],set:[33,3,1],"__init__":[33,3,1]},"sqlalchemy.engine.reflection.Inspector":{get_table_names:[31,3,1],get_foreign_keys:[31,3,1],get_indexes:[31,3,1],from_engine:[31,6,1],get_pk_constraint:[31,3,1],get_view_definition:[31,3,1],get_schema_names:[31,3,1],get_primary_keys:[31,3,1],get_view_names:[31,3,1],default_schema_name:[31,5,1],reflecttable:[31,3,1],get_columns:[31,3,1],"__init__":[31,3,1],get_table_options:[31,3,1]},"sqlalchemy.dialects.mysql.TINYINT":{"__init__":[2,3,1]},"sqlalchemy.ext.associationproxy.AssociationProxy":{contains:[6,3,1],target_class:[6,5,1],has:[6,3,1],any:[6,3,1],"__init__":[6,3,1]},"sqlalchemy.dialects.mysql.NVARCHAR":{"__init__":[2,3,1]},"sqlalchemy.dialects.mysql":{REAL:[2,4,1],DOUBLE:[2,4,1],TEXT:[2,4,1],CHAR:[2,4,1],TINYINT:[2,4,1],mysqldb:[2,0,1],DATE:[2,4,1],VARBINARY:[2,4,1],pyodbc:[2,0,1],SMALLINT:[2,4,1],MEDIUMBLOB:[2,4,1],SET:[2,4,1],VARCHAR:[2,4,1],NUMERIC:[2,4,1],BIGINT:[2,4,1],MEDIUMINT:[2,4,1],INTEGER:[2,4,1],BIT:[2,4,1],zxjdbc:[2,0,1],DECIMAL:[2,4,1],ENUM:[2,4,1],DATETIME:[2,4,1],base:[2,0,1],YEAR:[2,4,1],NVARCHAR:[2,4,1],NCHAR:[2,4,1],BINARY:[2,4,1],TINYTEXT:[2,4,1],TIMESTAMP:[2,4,1],LONGTEXT:[2,4,1],FLOAT:[2,4,1],MEDIUMTEXT:[2,4,1],BOOLEAN:[2,4,1],BLOB:[2,4,1],TIME:[2,4,1],oursql:[2,0,1],TINYBLOB:[2,4,1],mysqlconnector:[2,0,1],LONGBLOB:[2,4,1]},"sqlalchemy.engine.base":{Engine:[15,4,1],Transaction:[15,4,1],RowProxy:[15,4,1],Connectable:[15,4,1],Connection:[15,4,1],ResultProxy:[15,4,1]},"sqlalchemy.dialects.mysql.TINYTEXT":{"__init__":[2,3,1]},"sqlalchemy.sql.expression.CompoundSelect":{"__init__":[26,3,1]},"sqlalchemy.ext.horizontal_shard.ShardedQuery":{set_shard:[25,3,1],"__init__":[25,3,1]},"sqlalchemy.sql":{functions:[26,0,1],expression:[26,0,1]},"sqlalchemy.dialects.oracle":{INTERVAL:[37,4,1],BFILE:[37,4,1],zxjdbc:[37,0,1],cx_oracle:[37,0,1],NUMBER:[37,4,1],DOUBLE_PRECISION:[37,4,1],RAW:[37,4,1],base:[37,0,1],LONG:[37,4,1],NCLOB:[37,4,1]},"sqlalchemy.dialects.mysql.VARCHAR":{"__init__":[2,3,1]},"sqlalchemy.dialects.postgresql.BYTEA":{"__init__":[30,3,1]},"sqlalchemy.dialects.oracle.INTERVAL":{"__init__":[37,3,1]},"sqlalchemy.dialects.postgresql.ENUM":{"__init__":[30,3,1]},"sqlalchemy.orm.collections.collection":{replaces:[1,8,1],adds:[1,8,1],iterator:[1,8,1],internally_instrumented:[1,8,1],removes:[1,8,1],remover:[1,8,1],removes_return:[1,8,1],on_link:[1,8,1],appender:[1,8,1],converter:[1,8,1]},"sqlalchemy.dialects.mssql.DATETIME2":{"__init__":[4,3,1]},"sqlalchemy.dialects.firebird":{kinterbasdb:[29,0,1],base:[29,0,1]},"sqlalchemy.engine.base.Engine":{contextual_connect:[15,3,1],table_names:[15,3,1],transaction:[15,3,1],name:[15,5,1],raw_connection:[15,3,1],text:[15,3,1],create:[15,3,1],drop:[15,3,1],dispose:[15,3,1],execute:[15,3,1],echo:[15,5,1],connect:[15,3,1],reflecttable:[15,3,1],update_execution_options:[15,3,1],driver:[15,5,1],"__init__":[15,3,1]},"sqlalchemy.orm.interfaces.MapperExtension":{before_delete:[13,3,1],append_result:[13,3,1],create_instance:[13,3,1],translate_row:[13,3,1],after_delete:[13,3,1],init_failed:[13,3,1],after_insert:[13,3,1],init_instance:[13,3,1],before_update:[13,3,1],populate_instance:[13,3,1],after_update:[13,3,1],before_insert:[13,3,1],reconstruct_instance:[13,3,1],instrument_class:[13,3,1]},"sqlalchemy.sql.functions.AnsiFunction":{"__init__":[26,3,1]},"sqlalchemy.sql.expression.Select":{append_column:[26,3,1],intersect_all:[26,3,1],froms:[26,5,1],except_:[26,3,1],select_from:[26,3,1],"__init__":[26,3,1],union_all:[26,3,1],prefix_with:[26,3,1],except_all:[26,3,1],distinct:[26,3,1],append_from:[26,3,1],get_children:[26,3,1],with_only_columns:[26,3,1],intersect:[26,3,1],append_prefix:[26,3,1],with_hint:[26,3,1],self_group:[26,3,1],union:[26,3,1],correlate:[26,3,1],append_correlation:[26,3,1],column:[26,3,1],append_having:[26,3,1],inner_columns:[26,5,1],append_whereclause:[26,3,1],locate_all_froms:[26,5,1],where:[26,3,1],having:[26,3,1]},"sqlalchemy.engine.url":{URL:[27,4,1]},"sqlalchemy.dialects.mssql.BIT":{"__init__":[4,3,1]},"sqlalchemy.orm.scoping":{ScopedSession:[33,4,1]},"sqlalchemy.interfaces":{PoolListener:[38,4,1],ConnectionProxy:[38,4,1]},"sqlalchemy.dialects.mysql.SET":{"__init__":[2,3,1]},"sqlalchemy.orm.interfaces.SessionExtension":{after_bulk_delete:[13,3,1],after_begin:[13,3,1],after_flush_postexec:[13,3,1],before_commit:[13,3,1],after_attach:[13,3,1],after_flush:[13,3,1],after_rollback:[13,3,1],after_bulk_update:[13,3,1],before_flush:[13,3,1],after_commit:[13,3,1]},"sqlalchemy.interfaces.ConnectionProxy":{execute:[38,3,1],rollback:[38,3,1],commit_twophase:[38,3,1],prepare_twophase:[38,3,1],release_savepoint:[38,3,1],savepoint:[38,3,1],begin:[38,3,1],cursor_execute:[38,3,1],rollback_twophase:[38,3,1],commit:[38,3,1],rollback_savepoint:[38,3,1],begin_twophase:[38,3,1]},"sqlalchemy.dialects.mssql.VARCHAR":{"__init__":[4,3,1]},"sqlalchemy.dialects.mysql.BIGINT":{"__init__":[2,3,1]},"sqlalchemy.dialects.oracle.RAW":{"__init__":[37,3,1]},"sqlalchemy.dialects.mssql.MONEY":{"__init__":[4,3,1]},"sqlalchemy.types.AbstractType":{result_processor:[39,3,1],is_mutable:[39,3,1],compare_values:[39,3,1],compile:[39,3,1],bind_processor:[39,3,1],get_dbapi_type:[39,3,1],copy_value:[39,3,1],"__init__":[39,3,1]},sqlalchemy:{exc:[9,0,1],create_engine:[27,2,1],interfaces:[38,0,1],orm:[22,0,1],pool:[7,0,1],engine_from_config:[27,2,1],types:[39,0,1],schema:[31,0,1]},"sqlalchemy.types.Interval":{impl:[39,5,1],"__init__":[39,3,1]},"sqlalchemy.dialects.mssql.UNIQUEIDENTIFIER":{"__init__":[4,3,1]},"sqlalchemy.sql.functions.concat":{"__init__":[26,3,1]},"sqlalchemy.pool.QueuePool":{"__init__":[7,3,1]},"sqlalchemy.dialects.mssql.TINYINT":{"__init__":[4,3,1]},"sqlalchemy.schema.MetaData":{is_bound:[31,3,1],bind:[31,5,1],clear:[31,3,1],remove:[31,3,1],reflect:[31,3,1],create_all:[31,3,1],sorted_tables:[31,5,1],append_ddl_listener:[31,3,1],"__init__":[31,3,1],drop_all:[31,3,1]},"sqlalchemy.orm.interfaces.AttributeExtension":{set:[13,3,1],remove:[13,3,1],append:[13,3,1],active_history:[13,5,1]},"sqlalchemy.orm.mapper":{Mapper:[19,4,1]},"sqlalchemy.dialects.mssql.TEXT":{"__init__":[4,3,1]},"sqlalchemy.dialects.oracle.NUMBER":{"__init__":[37,3,1]},"sqlalchemy.dialects.mysql.DOUBLE":{"__init__":[2,3,1]},"sqlalchemy.ext.horizontal_shard":{ShardedQuery:[25,4,1],ShardedSession:[25,4,1]},"sqlalchemy.pool.Pool":{recreate:[7,3,1],dispose:[7,3,1],connect:[7,3,1],"__init__":[7,3,1]},"sqlalchemy.dialects.access":{base:[16,0,1]},"sqlalchemy.orm.scoping.ScopedSession":{mapper:[33,3,1],query_property:[33,3,1],remove:[33,3,1],"__init__":[33,3,1],configure:[33,3,1]},"sqlalchemy.exc":{CircularDependencyError:[9,1,1],InternalError:[9,1,1],NoSuchColumnError:[9,1,1],DisconnectionError:[9,1,1],SQLError:[9,5,1],SQLAlchemyError:[9,1,1],UnboundExecutionError:[9,1,1],CompileError:[9,1,1],ProgrammingError:[9,1,1],DataError:[9,1,1],TimeoutError:[9,1,1],IdentifierError:[9,1,1],NoReferencedTableError:[9,1,1],NotSupportedError:[9,1,1],IntegrityError:[9,1,1],SAPendingDeprecationWarning:[9,1,1],InvalidRequestError:[9,1,1],NoSuchTableError:[9,1,1],SADeprecationWarning:[9,1,1],ResourceClosedError:[9,1,1],NoReferencedColumnError:[9,1,1],SAWarning:[9,1,1],InterfaceError:[9,1,1],NoReferenceError:[9,1,1],DBAPIError:[9,1,1],OperationalError:[9,1,1],ArgumentError:[9,1,1],DatabaseError:[9,1,1]},"sqlalchemy.sql.expression.ClauseElement":{execute:[26,3,1],unique_params:[26,3,1],bind:[26,5,1],compare:[26,3,1],get_children:[26,3,1],compile:[26,3,1],scalar:[26,3,1],params:[26,3,1],self_group:[26,3,1]},"sqlalchemy.engine.base.Connectable":{contextual_connect:[15,3,1],create:[15,3,1],drop:[15,3,1]},"sqlalchemy.dialects.mysql.LONGBLOB":{"__init__":[2,3,1]},"sqlalchemy.types.SchemaType":{bind:[39,5,1],create:[39,3,1],drop:[39,3,1],"__init__":[39,3,1]},"sqlalchemy.dialects.postgresql.ARRAY":{"__init__":[30,3,1]},"sqlalchemy.dialects.postgresql.CIDR":{"__init__":[30,3,1]},"sqlalchemy.schema.ForeignKeyConstraint":{"__init__":[31,3,1]},"sqlalchemy.interfaces.PoolListener":{first_connect:[38,3,1],checkin:[38,3,1],checkout:[38,3,1],connect:[38,3,1]},"sqlalchemy.dialects.mysql.YEAR":{"__init__":[2,3,1]},"sqlalchemy.orm.session.Session":{add_all:[33,3,1],expunge_all:[33,3,1],scalar:[33,3,1],flush:[33,3,1],close:[33,3,1],"__init__":[33,3,1],close_all:[33,6,1],prepare:[33,3,1],add:[33,3,1],query:[33,3,1],"new":[33,5,1],begin:[33,3,1],rollback:[33,3,1],deleted:[33,5,1],is_active:[33,5,1],object_session:[33,6,1],is_modified:[33,3,1],expire:[33,3,1],bind_table:[33,3,1],execute:[33,3,1],bind_mapper:[33,3,1],prune:[33,3,1],expunge:[33,3,1],expire_all:[33,3,1],refresh:[33,3,1],merge:[33,3,1],connection:[33,3,1],dirty:[33,5,1],begin_nested:[33,3,1],commit:[33,3,1],get_bind:[33,3,1],"delete":[33,3,1]},"sqlalchemy.sql.functions.random":{"__init__":[26,3,1]},"sqlalchemy.sql.functions.count":{"__init__":[26,3,1]},"sqlalchemy.ext.declarative":{"_declarative_constructor":[41,2,1],instrument_declarative:[41,2,1],comparable_using:[41,2,1],synonym_for:[41,2,1],has_inherited_table:[41,2,1],declarative_base:[41,2,1],declared_attr:[41,4,1]},"sqlalchemy.dialects.mysql.LONGTEXT":{"__init__":[2,3,1]},"sqlalchemy.engine.base.RowProxy":{keys:[15,3,1],items:[15,3,1],has_key:[15,3,1]},"sqlalchemy.dialects.mssql.SMALLMONEY":{"__init__":[4,3,1]},"sqlalchemy.dialects.mysql.DECIMAL":{"__init__":[2,3,1]},"sqlalchemy.dialects.postgresql.DOUBLE_PRECISION":{"__init__":[30,3,1]},"sqlalchemy.dialects.oracle.DOUBLE_PRECISION":{"__init__":[37,3,1]},"sqlalchemy.sql.expression.Function":{"__init__":[26,3,1]},"sqlalchemy.sql.expression._BindParamClause":{compare:[26,3,1],"__init__":[26,3,1]},"sqlalchemy.dialects.mysql.DATETIME":{"__init__":[2,3,1]},"sqlalchemy.types.Enum":{"__init__":[39,3,1]},"sqlalchemy.dialects.mysql.NUMERIC":{"__init__":[2,3,1]},"sqlalchemy.engine.base.Connection":{invalidate:[15,3,1],in_transaction:[15,3,1],invalidated:[15,5,1],scalar:[15,3,1],connect:[15,3,1],close:[15,3,1],"__init__":[15,3,1],execution_options:[15,3,1],create:[15,3,1],closed:[15,5,1],begin_twophase:[15,3,1],dialect:[15,5,1],begin:[15,3,1],detach:[15,3,1],contextual_connect:[15,3,1],execute:[15,3,1],transaction:[15,3,1],drop:[15,3,1],connection:[15,5,1],info:[15,5,1],begin_nested:[15,3,1],reflecttable:[15,3,1]},"sqlalchemy.orm.query":{Query:[21,4,1]},"sqlalchemy.dialects.oracle.LONG":{"__init__":[37,3,1]},"sqlalchemy.dialects.sqlite":{DATE:[42,4,1],base:[42,0,1],TIME:[42,4,1],pysqlite:[42,0,1],DATETIME:[42,4,1]},"sqlalchemy.dialects.mysql.BOOLEAN":{"__init__":[2,3,1]},"sqlalchemy.dialects.mysql.CHAR":{"__init__":[2,3,1]},"sqlalchemy.sql.expression._CompareMixin":{startswith:[26,3,1],operate:[26,3,1],distinct:[26,3,1],contains:[26,3,1],label:[26,3,1],asc:[26,3,1],endswith:[26,3,1],in_:[26,3,1],collate:[26,3,1],between:[26,3,1],op:[26,3,1],reverse_operate:[26,3,1],match:[26,3,1],desc:[26,3,1]},"sqlalchemy.dialects.mssql.SMALLDATETIME":{"__init__":[4,3,1]},"sqlalchemy.dialects.mysql.BIT":{"__init__":[2,3,1]},"sqlalchemy.types.UnicodeText":{"__init__":[39,3,1]},"sqlalchemy.sql.expression.Executable":{execute:[26,3,1],execution_options:[26,3,1],scalar:[26,3,1]},"sqlalchemy.schema.ThreadLocalMetaData":{is_bound:[31,3,1],dispose:[31,3,1],"__init__":[31,3,1],bind:[31,5,1]},"sqlalchemy.util":{ScopedRegistry:[33,4,1],ThreadLocalRegistry:[33,4,1]},"sqlalchemy.dialects.mysql.TINYBLOB":{"__init__":[2,3,1]},"sqlalchemy.dialects.mssql.CHAR":{"__init__":[4,3,1]},"sqlalchemy.dialects.mssql.NTEXT":{"__init__":[4,3,1]},"sqlalchemy.orm.exc":{ObjectDeletedError:[35,1,1],DetachedInstanceError:[35,1,1],MultipleResultsFound:[35,1,1],UnmappedClassError:[35,1,1],NoResultFound:[35,1,1],StaleDataError:[35,1,1],UnmappedError:[35,1,1],UnmappedInstanceError:[35,1,1],UnmappedColumnError:[35,1,1],FlushError:[35,1,1],NO_STATE:[35,7,1],ConcurrentModificationError:[35,5,1]},"sqlalchemy.types.Concatenable":{"__init__":[39,5,1]},"sqlalchemy.types.MutableType":{is_mutable:[39,3,1],compare_values:[39,3,1],"__init__":[39,5,1],copy_value:[39,3,1]},"sqlalchemy.types.DateTime":{"__init__":[39,3,1]},"sqlalchemy.sql.functions.char_length":{"__init__":[26,3,1]},"sqlalchemy.orm.query.Query":{all:[21,3,1],intersect_all:[21,3,1],filter_by:[21,3,1],instances:[21,3,1],scalar:[21,3,1],from_statement:[21,3,1],value:[21,3,1],except_:[21,3,1],select_from:[21,3,1],enable_assertions:[21,3,1],add_entity:[21,3,1],union_all:[21,3,1],filter:[21,3,1],enable_eagerloads:[21,3,1],slice:[21,3,1],execution_options:[21,3,1],distinct:[21,3,1],yield_per:[21,3,1],limit:[21,3,1],label:[21,3,1],with_entities:[21,3,1],whereclause:[21,5,1],group_by:[21,3,1],params:[21,3,1],"__init__":[21,3,1],intersect:[21,3,1],add_column:[21,3,1],values:[21,3,1],with_polymorphic:[21,3,1],populate_existing:[21,3,1],statement:[21,5,1],get:[21,3,1],update:[21,3,1],with_lockmode:[21,3,1],outerjoin:[21,3,1],column_descriptions:[21,5,1],merge_result:[21,3,1],with_labels:[21,3,1],offset:[21,3,1],order_by:[21,3,1],one:[21,3,1],union:[21,3,1],count:[21,3,1],join:[21,3,1],correlate:[21,3,1],with_hint:[21,3,1],having:[21,3,1],from_self:[21,3,1],add_columns:[21,3,1],options:[21,3,1],autoflush:[21,3,1],except_all:[21,3,1],subquery:[21,3,1],with_parent:[21,3,1],first:[21,3,1],reset_joinpoint:[21,3,1],as_scalar:[21,3,1],"delete":[21,3,1]},"sqlalchemy.dialects.maxdb":{base:[10,0,1]},"sqlalchemy.ext.serializer":{dumps:[8,2,1],Deserializer:[8,2,1],loads:[8,2,1],Serializer:[8,2,1]},"sqlalchemy.dialects.mysql.TIME":{"__init__":[2,3,1]},"sqlalchemy.dialects.mysql.MEDIUMINT":{"__init__":[2,3,1]},"sqlalchemy.sql.functions.ReturnTypeFromArgs":{"__init__":[26,3,1]},"sqlalchemy.types.Numeric":{"__init__":[39,3,1]},"sqlalchemy.orm.attributes":{init_collection:[33,2,1],is_instrumented:[33,2,1],get_attribute:[33,2,1],set_committed_value:[33,2,1],manager_of_class:[33,2,1],set_attribute:[33,2,1],get_history:[33,2,1],del_attribute:[33,2,1],instance_state:[33,2,1],History:[33,4,1]},"sqlalchemy.sql.expression.Insert":{prefix_with:[26,3,1],values:[26,3,1]},"sqlalchemy.sql.functions.GenericFunction":{"__init__":[26,3,1]},"sqlalchemy.dialects.mssql.IMAGE":{"__init__":[4,3,1]},"sqlalchemy.schema.AddConstraint":{"__init__":[31,3,1]},"sqlalchemy.sql.expression.ColumnCollection":{add:[26,3,1],"__init__":[26,3,1],replace:[26,3,1]},"sqlalchemy.dialects.mysql.NCHAR":{"__init__":[2,3,1]},"sqlalchemy.dialects.oracle.NCLOB":{"__init__":[37,3,1]},"sqlalchemy.dialects.mysql.MEDIUMTEXT":{"__init__":[2,3,1]}},terms:{base_mapp:19,child:[21,22,1,23,15,26,33,31,45,41,18,19,20],soliddb:2,interchang:15,four:[31,27,23,42],prefix:[2,26,27,39,31,43,19],sleep:7,createindex:31,whose:[22,0,26,33,38,31,18,45],accur:39,emailaddress:19,immediateload:20,illustr:[22,23,34,15,27,33,38,39,31,5,7,18,19],concret:[21,23,36,44,41,19,45],somewidget:22,under:[26,4,19,37],merchant:14,digit:[2,37],uninstanti:41,onclaus:[21,34,0,26],rel:[26,27,33,39,42,18,19,20],edspassword:34,"_execution_opt":15,adodbapi:[4,27,44],droptabl:31,quantiz:39,jack:[34,18,1,20],appar:[4,18,33],sqltext:31,by_person:23,highest_protocol:39,cmd:43,drop_al:[30,31,39],factori:[34,1,23,24,6,19],autoinc:42,child_tabl:22,require_embed:26,categori:[13,38],associt:19,abil:[34,13,23,26,27,33,37,31,43,18,45],naiv:23,direct:[22,1,23,34,2,15,37,33,36,31,39,45,41,18,19,44],twophas:33,second:[22,23,34,27,33,37,29,39,4,31,45,42,7,18,19,43,20],street:19,before_delet:[21,13],aggreg:[26,0,19,20],threadlocalregistri:33,after_flush:13,input:27,even:[21,22,45,1,2,15,27,33,37,39,4,31,20,41,42,18,19,10,13],user_pref:31,myuppercasecompar:41,hide:6,item2:33,item3:33,asid:31,weren:[34,33],update_cascad:37,char_length:26,"new":[0,1,5,6,7,44,13,15,18,19,21,22,23,25,26,27,33,30,31,34,36,37,38,39,41,42,43,45],net:[12,13,2,3,37,33,39,4],ever:[6,33],topolog:9,corresponding_column:26,metadata:[0,2,4,6,8,44,15,18,19,21,22,24,26,28,30,31,33,34,37,39,41,42,43,45],ongo:[15,13,33],elimin:[39,41],centric:[11,5],log_tabl:15,some_dsn:27,displai:[2,26,41,23,24],internalerror:9,never:[22,1,34,15,26,33,42,7,19],chang:[0,1,2,5,6,44,13,15,10,18,19,20,21,22,23,24,26,27,28,30,31,33,34,36,39,43],here:[0,1,5,11,13,15,17,18,19,20,21,22,26,27,33,29,30,31,34,39,41,45],repeatable_read:30,met:41,typeerror:[43,1],column_properti:[19,13,41],"_read_prop":41,path:[23,27,29,20,42,45],anonym:[21,23,26,31,18,19,20],interpret:[39,26,27,33,37,30,5],forum:10,fkei:31,"_attr":41,myextens:13,everyon:33,precis:[34,39,2,37,30,4,18,10],datetim:[0,2,26,31,37,29,39,4,41,42,6,18],keymap:15,postalcod:23,yield:[21,4,26],other_id:2,permit:14,bayer:14,allevi:29,portabl:[2,15],custom_manag:23,flinston:34,nchar:[2,39,4,12],unix:27,org:[12,23,14,39,2,27,33,37,30,4,5,42,18],total:[24,2,31,45,7,19,20],unit:[22,0,23,34,33,41,6,18,19],type_descriptor:39,asynchron:29,describ:[11,45,0,13,23,22,33,15,26,27,28,38,34,39,31,5,44,41,18,19,20],would:[1,4,6,7,10,13,15,18,19,20,21,22,23,24,26,27,33,31,34,37,39,41,42,45],allow_null_pk:19,afterward:[31,33],call:[0,1,4,6,7,10,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,37,38,39,41,43,45],recommend:[2,37,33,38,39,4,41,42,18,19,10],type:[0,1,2,4,6,9,44,11,12,15,10,18,19,20,21,22,23,26,27,28,29,30,31,34,35,36,37,38,39,40,41,42,43,45],until:[22,1,34,15,27,33,29,6,7],locate_all_from:26,uix_1:31,relat:[0,2,5,6,7,44,11,15,18,19,20,21,22,23,24,33,31,34,36,41,42,45],yahoo:[34,18,20],notic:[34,14,30,39,31,18,45],warn:[21,24,37,33,27,39,42,10],pref_valu:31,"__iter__":1,mycolumncompar:19,herebi:14,must:[0,1,2,5,8,10,15,18,19,21,22,23,24,26,33,29,30,31,37,39,41,45],mapping_spec:1,join:[21,22,45,0,23,44,33,26,37,28,36,34,10,41,18,19,20],room:21,some_t:[41,33],setup:[22,34,33,5,45,41,6,19,44],work:[0,1,2,4,5,6,44,11,15,10,18,19,20,21,22,23,27,28,30,31,33,34,36,37,39,41,43,45],out_paramet:26,some_c:45,sep:37,coalesc:[43,26],introduc:[11,23,34,33,29,5,41,18,19,20],akin:[0,19],root:[21,22,43,45,33],could:[34,24,26,33,31,10,41,6,20],overrid:[21,22,23,15,26,37,33,39,31,45,43,19,20],defer:[21,22,36,37,33,41,19,44],give:[34,13,27,39,41,6,7,18],characterencod:2,shopping_cart_item:31,indic:[21,22,13,44,34,15,26,27,33,37,45,31,20,41,7,18,19,9,10,1],clariti:41,somefil:23,liter:[21,34,2,15,26,37,33,31,7,18,19],caution:[21,1],want:[21,11,45,0,1,22,15,33,34,39,31,5,20,41,6,7,18,19,43,10],ddl_listen:31,type1:31,fake_us:34,dprop:41,end:[21,34,23,24,26,27,33,39,41,18,19],hoc:[26,33],quot:[39,2,26,37,30,31],easili:[34,31,33,4,5,10],ordinari:[22,23,34],ilik:26,relationshipproperti:[22,19],mschar:4,how:[21,22,0,1,23,34,15,26,27,33,45,6,18,19,20,13],enforc:[22,18,19],sever:[22,1,34,15,37,30,31,5,45,41,7,18,19,10],abstracttyp:[39,31],answer:15,verifi:[34,18],ancestor:[26,20],perspect:[18,15,34],updat:[0,1,2,4,6,44,11,13,15,18,19,21,22,24,26,28,29,30,31,33,34,35,36,37,41],anon_1:[34,18,20],dialect:[2,3,4,5,10,44,11,12,15,16,18,26,27,28,29,30,31,37,38,39,42,43,40],rise:18,recogn:[0,19,13],lai:18,timedelta:39,tablenam:[21,0,26,31,41,10],after:[1,2,6,7,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,38,39,41,45],lump:18,less:[21,34,0,27,33,45,41,18,10],befor:[21,22,0,13,34,15,41,27,33,37,29,30,31,5,39,7,18,19,10],wrong:33,employee_id:[31,45],with_only_column:26,synchronize_sess:21,irrelev:30,averag:33,posts_bodi:34,attempt:[21,22,35,23,34,2,15,26,27,33,37,39,4,31,41,18,9],third:[34,23,24,27,33,42],no_stat:35,classmethod:[31,33],bootstrap:23,zzzeek:23,exclud:[21,19,41],alias:[21,22,44,34,26,28,10,18,19,20],type_:[26,39,31,41,18,19],maintain:[21,34,1,23,15,27,33,29,39,42,7,13],environ:[33,23,37],enter:0,exclus:[34,0,1,22,41,18],mechan:[39,15,41,42],smallinteg:[2,39],lambda:[19,1,41],engine_from_config:27,order:[0,1,44,11,13,15,10,18,19,20,21,22,23,24,25,26,33,30,31,32,34,36,37,39,41,42,43],wind:33,origin:[22,23,39,15,26,27,33,37,30,4,31,42,7,19,43,20],its_wood:6,macaddr:30,composit:[22,34,36,26,31,45,42,18,19,44],notes_t:1,mycompositecompar:19,somedata:[8,45],over:[22,1,23,34,26,31,33,37,30,4,39,42,6,20],fall:[18,19,1,33,41],zen:[36,44,20],becaus:[34,1,15,31,33,37,30,4,6,43,18,19,20],demarc:33,affect:[13,24,2,15,26,27,33,37,39,45,6,19,20],get_instance_dict:13,flexibl:[34,0,13,23,38,6,45],vari:[30,31,37,23,39],"_bindparamclaus":26,smallint:[39,2,31,30,4,42],poly_assoc_fk:23,column_descript:21,uuid:[26,39,19,30],fit:14,fix:[1,23,2,39,4,19],distrbut:25,kirtland:24,fetchal:[0,15,37,29,30,18],"_history_mapp":23,condition:31,persist:[21,11,0,1,23,22,36,25,33,38,31,34,42,18,7,8,19,44,13],comprehens:[6,31,5,19,23],mydb:[2,7],easier:[15,33,41,6,43,18],"_query__context":21,sessiontransact:13,them:[21,22,0,1,34,26,37,33,30,31,39,41,6,7,18,19,20],poolclass:[7,27],thei:[1,2,4,5,6,7,8,10,13,18,19,20,21,22,26,33,30,31,34,37,38,41,42,45],proce:[11,13,22,15,33,31,5,19],slate:19,safe:[34,39,2,15,31,33,37,30,4,18,19],nosuchcolumnerror:9,"break":22,sqlite3:[27,42],after_attach:13,"_autoclose_connect":15,manager_gett:13,updated_bi:6,choic:[33,43,1,20],subqueri:[21,22,0,34,26,31,37,45,4,10,41,18,19,20],mytabl:[1,2,15,26,31,33,37,39,4,43,19],session_factori:33,column_collect:[31,26],uncondtion:4,odbc:[2,4,27,10],unpickl:8,bonu:34,accommod:[31,15,41,24],kwarg1:41,timeout:[2,7,15,27,44],use_binds_for_limit:37,debug:[7,15,27,41],sawarn:9,secretpow:31,preferred_recr:41,side:[21,22,1,34,2,26,31,37,30,4,39,7,18,19],mstinyinteg:2,mean:[21,22,0,13,24,26,27,33,37,30,31,34,45,42,18,7,8,19,39,1],last_modifi:31,enable_assert:21,"0xb7b396ec":6,resum:33,told:[22,34],oppos:[21,37],append_from:26,thorugh:37,foreignkeyconstraint:[2,22,31,1,41],unbound:[39,31,33],emul:[6,15],goe:[22,37,34],newli:[21,34,13,39,15,26,27,33,38,30,4,31,41,7,18,45],"_gener":26,content:[34,23,26,33,38,41,18,44],posts_user_id:34,adapt:[12,1,23,2,33,39,18,19],reader:18,got:[34,18],forth:33,"_write_prop":41,optin:4,rail:23,employees_typ:45,free:[34,31,19,33,14],parenthesi:[31,18,26],mydsn:[4,27],small:[39,2,37,30,4,45,7,18,20],"__setitem__":1,"__ne__":19,infix:26,do_stuff:1,reftargetmixin:41,md5:2,reconfigur:[34,33],connam:31,created:31,hostnam:[2,27],traceback:41,my_procedural_th:26,filter:[21,22,0,1,23,34,27,33,37,39,31,45,41,8,19,20],iso:42,isoutparam:26,createt:31,guesswork:1,isa:19,onto:[22,0,34,33,29,42,7,18,45],setlik:1,get_primary_kei:31,rang:[21,1,2,39,20,45],collectionadapt:1,render:[21,11,26,31,37,39,4,41,42,18,19],isolation_level:[30,42],update_execution_opt:15,independ:[34,39,33,30,31,5,19,10],adalia:[34,20],restrict:[22,1,14,26,33,31,7,8,19,10],hook:[21,13,2,33,38,39,6,7,19,43],unlik:[6,26,31,19],alreadi:[0,1,2,5,7,8,10,13,15,18,19,20,21,22,23,26,27,33,31,34,37,39,41,42,43,45],"06d":42,usefullli:10,wasn:33,primari:[0,2,4,44,12,13,15,18,19,20,21,22,24,26,27,33,30,31,34,36,37,39,41,42,45],hexstr:[39,7,27],read_committed_snapshot:4,broker_id:6,cartesian:[18,20],xid:[15,33,38],messag:[34,15,26,30,31,18,9],genericfunct:26,ordering_func:24,poollisten:[7,15,9,38,27],top:[0,23,2,31,33,37,30,4,42,18,19,10],common_par:19,master:[31,0],too:[34,23,26,33,39,31,43,18],similarli:[22,0,26,33,39,31,41,19,45],notes3:1,my_view:31,john:[15,23],listen:[22,13,23,2,27,28,38,31,33,7,19,44],clauseleft:26,single_par:[22,33],namespac:[15,26,27,41,7,8],tool:[18,31,5,33,10],setuptool:[5,44],noninfring:14,sqlalchemyerror:[35,9],aptli:31,horizontal_shard:25,incur:[22,37,39],def:[22,1,23,34,15,26,27,33,38,39,31,41,6,7,19,43,45,13],somewhat:[0,33,42,6,7,19],conserv:[19,27],technic:22,get_view_definit:31,sql_variant:4,peril:7,target:[21,22,1,23,24,26,27,33,30,31,34,45,39,6,41,18,19,20],keyword:[1,4,6,7,13,18,19,20,21,22,24,26,27,33,29,30,31,34,37,39,41,42,43,45],penalti:[30,39],provid:[0,1,2,5,6,7,11,14,15,18,19,20,21,22,23,24,26,27,33,31,34,37,38,39,41,42,43,45],expr:[21,39,26],tree:22,j25:[34,20],"final":[18,15,13,33,27],project:2,matter:27,ddlelement:[31,15,43],entri:[22,24,33,31,6,18,20],minut:42,beginn:20,fashion:[15,26,23,20],behavior:[1,2,4,6,7,44,13,15,18,19,20,21,22,23,26,27,33,29,30,31,32,34,36,37,38,39,41,42,43,45],boston:22,modern:[2,4],mind:42,raw:[34,0,23,38,26,27,37,8,9,20],pessimist:39,manner:[22,26,33,20,34],increment:[24,2,15,31,37,4,42,44],"__main__":[6,33],seen:18,seem:[2,37,10,41],incompat:29,"_sa_instance_st":33,minu:22,dozen:[31,23],recreat:[7,19,31,41],unresolv:[2,27],latter:[4,26,33],cope:24,meta1:31,meta2:31,weakli:33,useexist:31,pool_recycl:[2,7,27],transmit:[33,20],cleft:26,count_from:24,methodolog:[31,13,37],eagerli:[21,22,13,34,36,33,44,19,20],expens:[7,33,23,42],blue:1,current_d:[26,42],mutual:[22,0,1,36,31,44],plenti:33,shall:[22,14],attribute_nam:33,object:[0,1,4,5,6,7,8,9,44,11,13,15,10,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,35,36,37,38,39,41,42,43,45],server_side_cursor:30,what:[21,22,45,13,34,36,15,26,27,33,37,30,4,5,31,44,39,41,18,19,20],lexic:[18,26],regular:[22,18,1,34,2,15,26,27,33,31,41,42,6,8,19,13],mysqlset:41,letter:[18,27],phase:[2,15,26,37,33,30],insul:15,prematur:33,tradit:41,transat:0,paradigm:[11,5,18,33],don:[21,22,0,34,26,27,33,37,30,31,39,18,19,20],secondaryjoin:[22,1],doc:[22,1,23,27,33,37,39,31,45,42,19,10],lose:18,doe:[0,1,2,4,7,9,44,12,15,10,18,19,20,21,22,24,26,27,33,29,30,31,34,35,36,37,39,41,42,45],declar:[11,0,23,22,36,31,33,4,34,32,45,41,8,19,44],tech:37,my_str:26,unchang:33,section:[0,1,4,5,7,11,13,15,18,19,21,22,26,27,33,30,31,34,37,38,39,40,42,45],dot:[31,26,20],yank:10,columnnam:[21,31,26],pragma:[2,34,31,18,42],unmappedclasserror:[35,19],visitor:[39,26],random:[18,15,26],syntax:[34,2,26,29,30,4,42,18],append_foreign_kei:31,poison:23,self_and_descend:19,protocol:[39,8],select_from:[21,34,18,26,45],init_collect:33,oci:37,absolut:[39,42,19,27,37],mediumblob:2,bind:[21,34,0,23,39,15,26,27,33,37,30,4,31,41,42,18,8,10],acquir:[34,15,26,33,18,19],delet:[21,22,0,1,23,34,36,15,26,31,28,29,30,4,35,33,41,18,19,44,13],field2:23,init_on_load:19,explain:0,configur:[0,1,2,4,5,7,44,11,15,18,19,20,21,22,23,27,28,30,31,33,34,36,37,39,41,42,45],createfunc:33,restaur:33,is_insert:15,theme:[18,33],busi:[34,18],defaultgener:[31,15],"__call__":33,constant:[31,26,43],primary_kei:[22,0,1,23,24,2,15,26,31,33,37,30,4,34,45,41,42,6,18,19,39],serv:[34,0,26],intersect:[21,18,26,23],stop:[21,22,13,34,31,18,20],relatedinfo:41,insertfromselect:43,fetchedvalu:31,pg8000:[30,27,44],report:[22,15,37,42],reconstruct:19,punion:41,employees_employee_id:45,useraddress:19,receiv:[22,1,38,26,27,33,37,30,39,41,42,7,18,19,13],bat:[34,15,33,20],caching_queri:23,bar:[21,34,13,39,2,26,27,33,30,41,18,20],emb:[31,18,43,23],last_pric:6,user_keyword:6,baz:2,method:[0,1,4,6,7,13,15,18,19,21,22,23,26,27,33,29,30,31,34,37,38,39,41,42,43,45],sauc:41,twice:[34,18,33],bad:10,favorite_entri:22,emp:26,oursql:[2,27,44],unicode_error:[39,37],odbc_connect:4,higher:[11,34,22,2,15,39,31,5,18],widget:[22,41,34],datatyp:[11,23,34,37,30,31,39,18,19,45],collection_class:[22,13,24,6,45,1],num:10,result:[1,4,5,7,9,10,13,15,18,19,20,21,22,23,25,26,27,33,29,30,31,34,35,37,39,41,42],respons:[26,22,19,33,24],fail:[22,35,15,33,4,9],themselv:[22,8,23,36,26,33,31,18,19,44],charact:[37,39,2,31,27,30,4,42,9],best:[34,2,15,37,33,29,39,31,43,19],subject:[21,22,14,2,26,33,39,31,19],awar:[22,23,34,26,27,37,30,31,39,18,19,10],said:33,identifiererror:9,hopefulli:0,"_id":18,databas:[0,1,2,3,4,5,10,7,8,9,44,11,12,13,15,16,18,19,21,22,23,25,26,27,28,29,30,31,33,34,35,37,39,40,42,43,45],posts_tabl:1,urllib:4,nodemap:1,figur:[22,18,30],after_commit:13,simplest:31,drawn:18,awai:34,previous:[22,31,33],approach:[21,34,1,23,37,33,30,31,5,41,7,18,19],concurrentmodificationerror:35,attribut:[0,1,6,9,44,13,15,18,19,20,21,22,23,24,25,26,27,33,31,34,35,36,37,38,39,41,43,45],somethingmixin:41,accord:[2,31,1,33,27],extend:[11,1,22,29,31,43,19],newnam:18,optimist:33,weak:33,bullets_t:24,extens:[41,11,13,23,22,2,39,31,28,37,34,30,4,5,32,33,36,43,8,19,44],lazi:[21,22,1,23,34,36,33,44,6,19,20,13],preprocessor:5,recent:[2,21,31,33,34],article_id:21,"_integertyp":2,mysqlconnector:[2,27],accident:15,expos:29,hashabl:[30,33],regularpric:26,howev:[21,22,45,1,23,34,15,33,38,29,30,31,39,20,18,19,10,13],param_1:[18,26],against:[21,22,45,35,23,34,36,25,26,37,33,39,31,44,41,18,19,10],param_2:18,logic:[22,26,27,37,31,41,19],somelist:39,countri:23,login:[39,4],com:[34,2,37,33,4,18,19,20],col:[26,19,41,10],anon_label:26,querytest:31,assur:34,allow_twophas:37,foobar:34,"_dateaffin":39,loader:[21,22,1,34,36,33,44,20],ddl_event:31,multipleresultsfound:[21,34,35],guid:[11,5,42,44,39],assum:[21,22,1,23,34,15,26,27,33,37,39,31,5,45,42,18,19,20],summar:27,sortkei:8,duplic:[27,41],code:[34,0,23,2,26,33,39,5,41,7,18,19,44],liabil:14,strong:[19,45,33],mydatabas:[4,27],union:[21,26,39,45,18,19,20],oldpost:1,implicit_return:[30,4,31,27],been:[0,1,2,6,7,10,13,15,18,19,20,21,22,26,27,33,29,31,34,37,38,41,45],dict_gett:13,trigger:[22,1,15,31,33,37,39,4,44,6,19,20],someothert:[19,23],interest:[39,31,18,10],basic:[22,0,1,23,34,2,15,28,38,36,31,45,41,18,19,44],quickli:[29,1,42],"_set_statu":19,life:1,rather:[26,27,33,30,19,10],deeper:[23,20],suppress:[21,39,27,37],worker:42,inherit_condit:19,ani:[0,1,2,6,7,8,9,10,12,13,14,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,37,38,39,41,42,43,45],multithread:[7,37,33,42],lift:10,disconnectionerror:[9,38],lethan10:26,shardedqueri:25,dynamic_load:1,execution_opt:[21,15,26,27,29,4],ident:[21,22,0,13,34,25,26,31,33,39,4,45,41,7,19,9,20],engine1:33,userdefinedtyp:39,engine3:33,engine2:33,hat:23,servic:[11,15,26,33,38,5,10],properti:[0,1,2,4,6,9,44,13,15,19,20,21,22,24,26,27,33,31,34,36,41,45],sourceforg:[2,3,4,12,37],viewonli:[22,41],calcul:[18,26,33],neat:19,myarrai:30,pypostgresql:[30,27],occas:39,"_set":6,have:[0,1,2,4,6,7,10,13,15,18,19,20,21,22,23,24,26,27,33,30,31,34,35,37,38,39,41,42,43,45],tabl:[0,1,2,4,6,8,9,44,11,13,15,10,18,19,20,21,22,23,24,26,27,28,29,30,31,33,34,36,37,39,41,42,43,45],toolkit:5,uselist:[6,22],need:[0,1,4,5,6,7,8,10,13,15,18,19,20,21,22,23,24,26,27,33,30,31,34,37,38,39,41,42,43,45],cant:18,kwarg:[21,22,0,13,39,2,25,15,26,27,33,30,4,31,41,42,6,19,20],conf:30,varchar:[34,12,39,2,31,37,30,4,42,43,18,45],tediou:18,conn:[0,15,26,33,38,29,7,18],perform:[0,1,2,4,7,13,15,18,19,20,21,22,23,24,26,27,33,30,31,37,38,39,42],suggest:[2,39],make:[21,22,0,13,34,15,26,31,33,37,30,4,39,45,41,42,43,18,19,20],format:[21,34,2,26,27,33,37,39,31,42,18,19],amount:[22,20,39],constrained_column:31,complex:[22,0,23,31,6,19,20],descend:[21,26,18,19],big:[45,43,33,20],rownum:37,complet:[34,0,1,23,39,2,15,33,30,31,41,18,19,13],pool_logging_nam:27,yield_curv:26,process_result_valu:[39,26],drivernam:27,create_engin:[34,38,2,3,15,27,33,37,30,4,39,31,41,42,7,18],hand:[1,2,26,37,33,31,18,45],fairli:39,rais:[0,1,2,4,7,9,10,13,15,19,21,22,27,33,29,30,31,34,35,37,38,39,42,43],employee_nam:31,manager_data:45,tune:7,redefin:[39,19],kept:[39,7,18,33],undesir:31,scenario:[22,34,31,33,37,4,41,42,18,19,45],some_id_seq:30,thu:[31,33],myindex:31,inherit:[21,11,1,23,36,31,29,4,45,41,19,44],instrument_collection_class:13,client:[2,31,37,30,4,20],wherebi:[21,22],thi:[0,1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,35,37,38,39,41,42,43,45],everyth:[21,23,28,33,18,19,44],rollback_twophas:38,sqlcli:10,attribute_mapped_collect:[6,1],left:[21,22,45,0,34,2,26,37,30,31,39,10,18,19,20],native_odbc_execut:4,expert:0,stringent:[34,18],identifi:[21,22,35,23,34,15,26,27,33,37,30,4,31,44,42,7,18,19,20],just:[22,0,1,34,15,26,27,33,31,5,45,41,42,6,43,18,19,20,13],engineers_t:45,photo:19,datasourc:27,"_compile_mapp":19,"__dict__":33,shorthand:[22,34,15,26,31,45],yet:[34,1,39,15,27,33,30,31,20,41,42,7,18,19,10],languag:[11,34,15,26,31,28,4,5,41,18,44],tuple_:26,group_bi:[21,34,0,26,18,19],easi:[6,18,0],road_geom:23,columnel:[26,22,43,19],had:[34,33,31,41,6,18],get_children:[31,26],dblink:[37,44],spread:31,simplejson:39,board:27,els:[15,26,28,39,31,33,41,42,43,18,19,44],"__history_mapper__":23,correpond:26,sqlite_db:27,"_constraint":31,opt:[31,15],applic:[21,22,0,34,2,15,26,27,33,39,4,5,31,41,42,6,18,7,8,19],mayb:31,preserv:21,managers_t:45,map_to:0,background:[4,31,42],id_seq:37,stpz:6,scopedsess:[0,33],measur:2,semi:[39,13,10],specif:[2,4,8,9,44,11,12,15,18,19,21,22,26,27,28,29,30,31,33,34,36,37,39,40,41,42,43,45],arbitrari:[21,0,1,36,26,44,18,19,20],proxy_bulk_set:6,negat:26,remove_st:13,off:[21,34,1,23,38,25,15,26,27,33,37,30,4,39,31,18,13],astext:23,unnecessari:[31,15],underli:[21,34,0,1,23,2,15,26,27,33,39,4,31,41,6,7,18,19,9],makedsn:37,right:[21,22,0,13,14,34,26,33,39,31,42],old:[13,24,15,26,33,29,10,1],deal:[14,37,33,39,5,18],should_drop:31,manual:[22,45,0,24,2,27,33,37,39,31,20,6,18,10],interv:[30,37,39],excerpt:19,somehow:42,intern:[21,34,1,15,26,37,33,38,39,31,41,42,9],oracle_db:27,favorite_entry_id:22,item_typ:30,nvarchar2:37,autocommit:[0,2,15,26,28,33,41,44],insensit:[31,15,19,37],represent:[29,34,18,26,23],query_context:13,establish:[21,22,0,13,23,26,27,33,31,41,7,18,19,43,45],yield_per:21,subclass:[21,34,45,13,23,15,26,27,28,38,39,31,33,41,43,19,9,44,1],primary_mapp:19,cnf:2,track:[22,1,34,15,33,18,19],equal:[34,0,39,18,19,20],py2k:27,baseinterv:23,query_choos:[25,23],condit:[22,0,14,34,36,26,31,35,45,41,18,19,9,44],foo:[21,34,18,1,23,39,2,26,27,33,29,30,31,20,41,7,8,19,43,10,13],my_tabl:[30,41],localhost:[2,7,15,27,41],core:[11,13,28,38,31,5,32,9,44],plu:[4,18,31,20],who:[34,31,18,27,33],biginteg:[2,39],someclass:[21,33,13,23,41],nodes_1:22,itemassoci:23,nodes_2:22,someinfo:45,promot:33,repositori:18,post:[21,34,1,23,15,26,33,31,10,13],"super":[18,0,1,10],chapter:[34,31,18,39],ucs2:2,obj:[35,26,33,6,8,19],conceal:[21,18],invoice_id:31,slightli:[13,33,41,42,6,19,10],choke:39,surround:[2,31,33],unfortun:[0,27,42],unsav:33,fromcach:23,instance_st:33,pool_timeout:[7,27],coars:0,commit:[21,22,0,13,23,34,15,26,33,38,30,6,18],touch:18,produc:[21,34,23,24,2,15,26,27,33,37,30,4,39,31,41,6,7,18,19,43,45],queuepool:[7,27,38],match:[21,34,35,1,2,26,33,31,42,19,9,20],subchild1:22,subchild2:22,rudiment:[25,0,23],subq:21,curiou:0,"float":[39,2,37,30,4,42],encod:[39,2,27,37,30,4,18],www:[14,23,2,37,33,4,5,42,18],down:[34,1,26,39,18,20],creativ:1,unique_connect:7,formerli:33,wrap:[21,34,0,1,15,37,33,39,19,9,20],opportun:13,storag:[22,0,24,2,33,38,34,42,18,44],somedict:39,auto_setinputs:37,accordingli:29,jdbc:[2,30,4,27,37],suffici:[2,6,39],support:[1,2,3,4,5,10,7,44,12,15,16,18,19,22,25,26,27,28,29,30,31,33,34,37,39,40,41,42,43,45],frill:31,transform:[39,18,28,44],"class":[0,1,2,4,6,7,8,9,44,13,15,18,19,20,21,22,23,24,25,26,27,28,30,31,33,34,35,36,37,38,39,41,42,43,45],gig:18,width:2,reli:[22,23,15,37,33,31,18],gid:2,fraction:[39,37],add_column:21,overhead:[21,1,39,27,33,37,30,42,7,38],constantli:31,addgeometrycolumn:23,oramag:37,fork:15,basepair:0,mycol:[15,26],form:[21,22,8,12,34,2,26,27,33,29,30,4,39,31,45,41,7,18,19,20],offer:[21,34,33,29,31,7,19],forc:[1,39,26,37,33,30,31,42,9],fold_equival:26,sqlalchemi:[0,1,2,3,4,5,6,7,8,9,10,11,44,13,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,45],auto_incr:2,right_tabl:22,synonym:[21,22,0,15,37,44,41,19,20],cidr:30,"true":[0,1,2,4,6,7,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,37,39,41,42,43,45],connectionless:[18,31,15,28,44],query2:8,userland:[19,13],anscestor:26,attr:[0,23,24,31,41,6],arrays:[15,37],maximum:[2,4,7],tell:[18,0,45,34],url:[0,2,15,27,28,37,29,30,4,31,42,7,38,44],zark:1,nohostnam:27,emit:[22,1,23,34,26,27,33,30,31,39,18,19,20],shardedsess:25,copy_valu:39,featur:[21,22,45,34,2,15,26,31,33,37,30,4,44,41,43,18,19,20],classic:[22,41,34],hardcod:6,"abstract":[34,39,41,6,7,18],quantize_int:39,myotherclass:1,sale:29,exist:[0,1,2,8,9,44,13,15,18,19,20,21,22,26,27,28,30,31,33,34,39,41,42,43,45],request:[21,35,23,2,15,33,31,45,42,7,9,20],address_count:[34,18,19,41],ship:5,adjac:[36,22,44,23],check:[40,34,39,2,15,27,28,38,30,31,5,44,36,42,7,18,19,43,20,33],assembl:[18,19,13],translate_connect_arg:27,readonli:21,index:[21,11,1,24,15,26,31,28,37,30,4,18,44],dialects_toplevel:[39,27],elementtre:23,entrypoint:[26,33],classdecor:41,jone:[18,0,34],test:[34,23,2,15,26,27,33,37,29,4,31,16,41,6,7,18,19,40,10],snapshot:[4,44],dbapi_con:38,executioncontext:15,roll:[34,0,36,15,33,29,44],runtim:[39,0,9],node:[22,31,1,23],labeled_loan:0,intend:[21,22,13,23,34,15,33,31,41,43,19],table_map:19,dialect_nam:[21,26],put:[18,19,41,24],kinterbasedb:29,asterisk:34,acollect:1,increas:2,intens:[18,20],intent:37,consid:[21,22,1,34,2,26,37,33,30,31,39,6,19,45,13],sql:[0,2,4,5,8,9,44,11,15,10,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,36,37,38,39,40,41,43,45],transferr:33,counter_plus_twelv:31,sessionawaremapp:33,constrain:[39,31,33,24],optimize_limit:37,mytable_id:[2,31],mediuminteg:2,longer:[22,12,13,37,33,31,41,43,10],bullet:24,anywher:[4,18],regexp:[2,42],"__clause_element__":19,bidirection:45,tinyint:[2,4],ignor:[22,13,24,15,33,29,30,31,39,1],time:[0,1,2,4,6,7,8,9,44,12,13,15,18,19,20,21,22,23,26,27,33,30,31,34,37,39,41,42],push:1,lastrowid:[31,15],backward:[4,33],breadth:[11,5],concept:[34,0,33,31,18,20],chain:[22,26,13,34],addresses_2:[34,18],skip:[34,33,31,5,18,10],addresses_1:[34,18,20],focus:41,is_act:33,functionel:[43,15,26],signific:[13,37,39,5,18,20],stumbl:18,informix:[11,3,27,39,44,40],per:[34,13,23,39,2,15,26,27,33,29,30,4,31,42,7,18,19,9,20],visit_varchar:43,usersaddress:19,compani:[21,45],row:[0,1,2,44,13,15,10,18,19,20,21,22,23,24,26,27,33,29,30,31,34,35,36,37,39,41,42,45],hierarch:[22,23],decid:34,hold:[22,1,34,37,33,29,39,31,42,6],depend:[21,22,13,24,36,37,33,39,31,5,44,41,19,9,10],dbo:31,zone:33,graph:[36,22,19,44,23],decim:[2,37,29,39,4,42],text:[21,34,0,12,24,2,15,26,31,28,37,30,4,33,44,39,42,18,19,10],dropindex:31,opstr:26,aspx:4,isinst:39,multivalu:33,child1:22,child2:22,sourc:[21,22,1,23,25,15,27,31,19,20],rowno:10,string:[0,2,4,6,7,12,15,18,19,20,21,22,23,24,25,26,27,33,30,31,34,37,39,41,42,43,45],unnam:[31,26],passive_upd:[22,19,37],addresses_t:[22,31,19,20,34],somehistoryclass:23,word:[4,18,26,31,45],exact:[7,26,31,37],parent_t:[22,20],"_datetimebas":4,solver:33,did:[18,15],tip:33,restor:19,brother:34,iter:[21,22,1,34,26,33,31,18,19],item:[21,22,1,23,34,15,26,33,30,31,45,6,19,20],expunge_al:[0,33],"_create_rul":31,operationalerror:9,compileerror:9,quick:[22,23,34,26,33,18,19],collection_adapt:[1,33],unaccount:[21,35],round:[29,34,25,39],dict:[1,26,29,39,31,41,6],declarative_bas:[22,19,41,23,34],prevent:[22,15,1,33],peek:[6,18],pickleabl:[39,8],hack:26,"_createdropbas":31,cost:7,bake:18,port:[2,27,37,29,30,4,16,40,10],user_orders_t:33,lazili:[22,15,33,20],discourag:19,staticpool:[7,42],myenum:2,current:[0,1,2,5,6,7,10,12,15,19,20,21,22,23,26,27,33,29,31,34,35,37,38,39,40,41,42,45],loans_user_nam:0,"__instrumentation__":1,retain_schema:31,eagerload:20,pbxt:2,assertionpool:7,boost:5,meld:18,xml:[36,22,44,23],deriv:[34,1,23,36,15,26,45,31,10,43,44,13],gener:[0,1,2,4,5,7,9,44,11,13,15,10,18,19,21,22,23,24,26,27,28,29,30,31,33,34,37,39,41,42,43,45],stmt:[29,15,0,34],satisfi:31,normalize_whitespac:[34,18,20],generic:31,explicitli:[21,22,0,1,34,15,26,37,33,38,30,31,5,39,42,41,18,19,20],modif:[21,34,23,33,20,45],identity_kei:19,address:[21,22,23,34,33,31,41,18,19,20],along:[21,22,23,24,33,39,31,34,45,6,43,18,20],"_will_":1,wait:[7,31,27],box:42,preorder:22,step:[34,18,37,33],weakref:[7,15],behav:[34,37,33,39],overriden:2,extrem:[22,0,34,33,19,20],else_:26,boe:33,commonli:[21,22,23,26,27,33,31,18,19],novic:0,semant:[22,1,26,33,30,41,19],regardless:[21,25,15,26,37,33,39,31,42],session2:33,extra:[22,13,39,5,42,18,20],circumv:[2,19,23],msset:2,modul:[22,0,23,34,15,26,27,33,37,29,30,31,39,42,18,7,8,19],prefer:[22,31,39],and_:[22,0,23,34,26,18,19,45],my_string_1:26,my_string_2:26,my_string_3:26,marker:[31,15,33],instal:[11,13,23,22,2,27,37,30,5,42,7,38,44],"_valuesbas":26,append_constraint:31,include_properti:19,from_engin:31,memori:[8,22,0,1,34,2,27,33,31,42,7,18,19],sake:33,visit:[39,26],widget_id:[22,34],connector:[39,2,27,37,30,4,44],msn:18,live:[37,33,38],handler:[37,1,13],bindparam:[18,26],criteria:[21,34,26,33,31,41,45],msg:35,scope:[0,15,33,38,42,7,19],checkout:[7,27,38],plug:[5,27],integrityerror:[9,33],peopl:[21,29,41],con_record:38,claus:[21,22,0,34,25,15,26,27,33,37,30,4,31,41,43,18,19,45],enhanc:[22,19,33,10],user_id_seq:[34,18],appendix:14,accept:[0,2,4,7,10,15,18,19,20,21,26,27,33,30,31,34,37,38,39,41,42,45],examin:33,postgresql:[11,41,22,27,33,30,31,34,40,39,7,18,19,43,44],easiest:18,behalf:15,users_admin:0,fly:[30,33,42],graphic:33,ibm:27,nextval:[37,10],prepar:[4,33,24],constraint:[11,1,22,2,24,26,41,28,30,31,34,33,39,43,44],uniqu:[21,34,0,24,26,27,33,31,18,45],wendi:[34,18],mycolumn:43,descriptor:[21,22,13,23,34,33,41,6,19,20],whatev:[21,34,2,25,26,27,33,39,31,18,19],purpos:[21,22,1,14,27,33,31,7,19,45,13],echo_uow:27,fget:41,claim:14,dropper:31,stream:[21,26,27],startswith:26,predict:33,related_th:31,backslash:42,critic:[18,15,45],abort:[31,38],phrase:[31,26,37],recycl:[7,27],addresses_user_id:[34,18,20],occur:[21,22,13,23,34,26,27,33,37,29,39,31,7,18,19,9,1],alwai:[21,22,1,34,2,26,27,33,37,39,4,31,45,41,42,6,18,20,13],differenti:41,lxml:23,multipl:[21,22,45,0,13,23,34,2,25,15,26,28,36,31,33,44,41,6,18,19,20],unsign:2,process_bind_param:[39,26],idl:2,utf8:[2,4,37],write:[22,1,34,37,33,39,31,41,6,18,19,10],criterion:[21,22,1,34,26,33,6,18,19,45,13],actual:[21,22,1,34,15,26,27,33,39,31,5,41,42,7,18,20,13],pure:[34,19],sysdba:37,dropsequ:31,somevalu:[39,26],multiparam:[15,26,38],map:[0,1,6,8,9,44,11,13,15,19,20,21,22,23,24,25,26,33,29,30,31,34,35,36,41,42,45],product:[34,18],autoincr:[22,2,31,37,4,42,10],max:[26,43,18,19,9,10],sql_mode:2,aol:18,postgresql_wher:30,usabl:[26,27,39,31,41,7,19,45],spow:31,pattern:[21,11,1,23,24,36,15,41,33,31,34,45,22,6,18,19,44],mixin:[39,43,26,41],date:[23,39,2,26,31,33,37,30,4,42,18,44],latin1_general_ci_a:4,data:[0,1,2,4,8,44,11,15,18,19,20,22,23,26,27,28,30,31,33,34,37,39,41,42,43,45],grow:[7,27],autoload_with:31,geneat:31,explicit:[21,22,1,23,34,36,15,26,31,33,30,4,44,41,18,19,20],pysybas:[12,27],before_insert:13,predic:[39,31,26],inform:[1,2,4,7,10,13,15,18,19,23,24,26,27,33,30,31,34,37,39,41,42,43,45],"switch":[7,0,31,28,44],columnclaus:[31,26,43],combin:[22,0,23,34,25,26,27,37,31,5,41,18,19,45],callabl:[22,1,25,27,33,37,39,31,41,6,7,19,43,13],longhand:45,column_prefix:19,ordinarili:29,talk:[34,31,27,33],passive_no_initi:33,cute:23,detect_typ:42,mapped_collect:1,chanc:[31,33],connect_arg:[27,42],clausetest:26,mappedcollect:1,still:[21,22,0,13,34,15,37,33,39,45,41,42,6,7,18,20],freetd:[4,27],dynam:[22,0,1,23,34,36,27,4,31,44,41,20],entiti:[21,22,0,1,23,34,15,33,31,19,20],conjunct:[21,22,1,23,34,33,37,28,31,44,41,18,20],group:[21,34,1,26,30,31,42,43,18,19,45],thank:18,addres:18,polici:29,jim:18,defin:[0,1,6,8,44,13,15,18,19,20,22,25,26,33,31,28,34,36,39,41,43,45],init_inst:[19,13],tort:14,window:[34,27,37,4,42,18],main:[26,41,20],pointcompar:19,non:[0,2,4,6,7,12,13,15,19,21,22,23,26,27,33,29,30,31,34,37,39,41,42,45],initd:42,recal:[18,15],namespace_url:26,enable_rowcount:29,mapper:[0,1,5,6,8,44,11,13,18,19,20,21,22,23,24,25,27,33,34,36,41,45],col6:31,savepoint:[30,15,33,10,38],supersed:21,col2:[39,15,26,29,30,31],col3:[31,15],initi:[21,0,13,23,36,26,27,33,37,39,31,41,7,19,44],col1:[39,15,26,29,30,31],underneath:27,therebi:33,now:[34,15,26,33,30,31,41,6,18,19,45],discuss:[22,31,15,1,33],nor:[42,30,18,19,24],introduct:[21,11,0,34,36,26,28,18,44],outweigh:39,term:[21,34,1,23,38,18,45],should_creat:31,native_datetim:42,name:[0,1,2,4,6,7,9,10,12,15,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,37,38,39,41,42,43,45],returntypefromarg:26,config:27,drop:[23,39,15,26,29,30,31,43],revert:[34,33],separ:[22,23,34,2,15,26,31,33,4,5,45,41,18,19,20],cascade_iter:19,clauseright:26,rock:1,myobj:1,exclude_properti:[19,41],seldom:6,compil:[21,22,15,26,37,28,38,39,31,44,41,42,43,18,19,9,10],domain:[11,5,18,34],email_addresses_1:20,replac:[21,22,1,23,15,26,37,39,7,19,45],individu:[1,2,4,5,7,11,13,15,18,19,20,21,22,23,26,27,33,30,31,34,37,39,45],continu:[22,2,15,37,33,19],users_email:0,keyfunc:1,current_tim:26,significantli:[18,13,38],begun:[34,26,13,33],year:[2,0,37,42],set_shard:25,happen:[18,31,15,33,35],dispos:[13,15,33,38,31,42,7,19],foreign_kei:[22,31,26,1],shown:22,accomplish:[34,4,18,41,33],lastrow_has_default:15,joinedload:[21,34,20],space:[22,31,26],oracle_resolve_synonym:37,urlencod:4,sqldescribeparam:4,drop_spow:31,colleciton:20,rational:[29,33],toggleabl:2,large_collect:23,pjoin_engineer_info:45,correct:[29,18,33],integr:[11,0,13,23,22,36,27,33,31,5,44,7,19,10],append_result:13,earlier:[34,18,10],resourceclosederror:9,state:[21,22,35,13,23,34,36,25,15,27,33,29,39,44,7,18,19,9,10,1],migrat:[11,5,44],unit_pric:26,american_america:37,headlin:[34,1],orm:[0,1,2,5,6,8,44,11,13,15,10,18,19,20,21,22,23,26,27,33,29,30,31,32,34,35,36,37,38,39,41,42],mysqld:2,mysessionextens:13,columncollectionconstraint:31,"byte":[2,39,27,37],server_version_info:4,care:[21,22,33,39],reusabl:0,fixture_data:23,wai:[21,22,0,13,23,34,15,26,27,33,29,39,31,45,41,42,6,7,18,19,20],littl:[6,22,18,1,41],synchron:[21,22,1,24,15,33,34],thing:[21,34,0,1,15,39,31,42,7,18],place:[21,22,45,13,23,34,26,31,33,37,30,4,39,20,7,18,19,43,10,1],firstpost:34,imposs:[21,22,4],frequent:[39,4,33],first:[0,2,7,11,13,15,18,19,20,21,22,23,26,27,33,29,31,34,37,38,39,42,45],oper:[0,1,2,5,6,7,9,44,13,15,10,18,19,21,22,23,24,25,26,27,28,30,31,33,34,35,37,38,39,41,45],user_mapp:33,reimplement:19,directli:[0,1,2,4,7,8,13,15,18,19,21,22,23,26,27,33,29,30,31,34,37,39,41,43,45],qmark:18,spoken:23,onc:[0,7,9,44,13,15,10,18,19,21,22,23,26,27,33,29,31,34,36,38,39,41,45],arrai:[30,39,1,34],yourself:[31,18],walkthrough:[21,22],"long":[1,23,15,26,37,33,38,4,10],engine_or_metadata:0,except_:[21,18,26],custom:[1,6,7,44,11,13,19,21,22,23,24,27,28,31,33,34,36,39,41,42,43,45],open:[34,15,27,33,42,7],zap:1,size:[15,26,27,39,7,20],avail:[0,1,2,3,4,5,9,10,13,15,18,19,20,21,22,23,24,26,27,33,30,31,32,34,37,38,39,41,42,45],given:[0,2,6,7,9,13,15,18,19,20,21,23,25,26,27,33,31,34,37,38,39,41,42,45],posts_id:34,breviti:23,convent:2,stuck:18,teardown:33,classmanag:33,users_1:34,largebinari:[2,30,4,37,39],type_engin:39,citi:[22,19,23],necessarili:[4,0],individ:19,conveni:[21,22,0,34,26,33,38,39,31,41,6,7],friend:21,includ:[1,2,4,5,7,10,14,15,18,19,20,21,22,23,25,26,27,33,31,34,37,38,39,41,42,43,45],stocks_tabl:6,last_updated_param:[31,15],uniqueconstraint:[31,41],grant:14,especi:33,copi:[21,14,39,15,26,33,30,31,41,18],specifi:[0,1,2,4,7,44,13,15,18,19,20,21,22,23,26,27,33,30,31,34,36,37,39,41,42,45],optionaldict:26,enclos:[21,18,15,26,33],mostli:[3,15,26,27,31,5],users_classnam:0,pendingdeprecationwarn:9,holder:14,than:[21,22,45,35,34,15,26,27,33,30,4,39,31,20,41,42,6,7,18,19,10],someengin:31,wide:[2,27,33,4,5,20],setattr:[6,19],last_inserted_param:[31,15],nodes_parent_id:22,users_t:[22,1,34,15,33,31,6,19,20,13],prefix_insert:43,keywords_t:[6,22],bag:1,were:[21,22,0,13,34,33,31,35,18,19,20],posit:[21,1,24,15,26,27,33,39,31,41,18,19],outparam:26,seri:[21,34,33,20],pre:[21,22,13,26,33,29,30,31,20,41,7,10],xpath:23,sai:[39,22,18,33,34],not_:[18,26],argument:[0,1,2,4,6,7,9,44,13,15,18,19,20,21,22,24,26,27,28,29,30,31,33,34,37,38,39,41,43,45],delin:[31,33],utf8_bin:26,deliv:[15,26,27],sap:10,rollback_savepoint:38,collat:[21,2,26,39,4,41,44],dbapi:[2,3,4,5,7,9,44,11,15,10,18,20,21,26,27,28,29,30,31,33,37,39,42,40],bitwis:[18,26],engin:[0,2,3,4,5,7,8,44,11,13,15,18,19,21,23,25,26,27,28,29,31,33,34,37,38,39,41,42,45],techniqu:[21,11,1,23,22,36,33,30,31,34,44,41,18,19,20],an_engin:31,scoped_sess:[8,0,41,33],note:[0,1,2,3,4,5,7,9,44,11,12,13,15,10,18,19,20,21,22,26,27,33,30,31,34,35,37,38,39,40,41,42,45],map_column:[19,41],dispar:33,take:[21,22,0,13,24,2,15,26,27,33,30,31,34,39,42,6,41,18,19,20,1],advis:[22,7,45],left_tabl:22,noth:[15,33,41,42,6,20],nosuchtableerror:9,begin:[34,15,26,27,33,38,31,5,7,18,10],sure:[30,43,39,19,24],employee_mapp:45,othermapp:19,mycomparatortyp:41,normal:[21,22,0,1,34,15,26,33,39,31,45,41,7,18,19,20,13],multipli:20,price:[19,23],my_model:41,clearer:31,fakeus:34,thirdparti:27,sublicens:14,pair:[21,1,15,26,33,31,19],asdecim:[2,30,37,39],method_b:[15,33],validate_address:19,renam:[18,41],correctli:[21,22,37,10],synonyn:22,release_savepoint:38,keysowrd:4,later:[34,33,30,31,18,19,45],drive:42,quantiti:6,create_al:[34,39,30,31,41,18],mysql_db:27,namingconvent:41,shop:5,serializ:[30,42],show:[33,34,18,13,10],ansi_quot:2,my_index:30,atob:20,concurr:[22,15,27,33,4,42,7],fk_node_element_id:31,permiss:[2,21,14],new_from_blammo:6,relationship_cach:23,label:[21,34,0,39,26,27,30,31,18,19,20],read_uncommit:[30,42],cx_oracl:[27,44,37],slot:[1,38],onli:[0,1,2,4,6,7,8,10,12,13,15,18,19,20,21,22,23,24,26,27,33,30,31,34,37,38,39,41,42,43,45],snack:6,nice:42,undefer_group:19,mydata:31,transact:[21,11,0,13,34,2,15,26,27,28,37,29,30,4,31,33,36,42,7,19,44],activ:[1,23,27,33,31,42,7,18,19,45,13],localtimestamp:26,"__bases__":41,black:18,analyz:[34,18],outerjoin:[21,22,34,26,45,18,20],element_id:31,offici:[2,30,37],overwritten:[21,31],reset:[21,30,7,33],post_configure_attribut:13,uniqueidentifi:4,nearli:[39,8,33],variou:[11,13,34,15,27,38,31,41,18,19,40],get:[0,1,4,6,7,9,44,11,15,18,19,20,21,22,23,24,27,33,31,34,36,41,43,45],from_stat:[21,34,20],repr:[6,27],secondari:[22,1,34,2,33,41,6,19],sysdat:[31,26],xyz_my_goofy_funct:18,engineers_employee_id:45,cannot:[21,22,1,31,33,4,42,18,19,9,20],smalldatetim:4,myepochtyp:39,jtd:[4,27],self_group:26,derived_attribut:[19,23],requir:[0,1,2,4,6,7,10,13,15,18,19,20,21,22,24,26,27,33,29,30,31,34,35,37,39,41,42,45],truli:37,remote_bank:31,reveal:20,item_nam:31,held:[15,33,4,42,6,7],its_big:6,dramat:34,intrins:33,across:[34,23,25,15,27,33,39,31,41,42,7,18,20],second_precis:[39,37],current_paramet:31,nested_set:23,scott:[2,15,27,31,41,7],where:[0,1,4,8,10,15,18,19,20,21,22,23,25,26,27,33,29,30,31,34,37,39,41,43,45],summari:19,wiki:[23,2,37,33,5,41,45],target_collect:6,sql_compil:43,mess:18,sometest:33,placehold:39,adr_count:34,unmappedcolumnerror:35,testcas:33,progress:[34,15,26,33,31,43],concern:[34,26],detect:[22,35,13,15,27,33,37,29,39,4,31,41,42,7,19,9,1],"__all__":39,get_table_opt:31,slides_t:24,enumer:[30,39],"_create_uk_by_keyword":6,behind:[18,15,20,34],identity_key_from_inst:19,between:[21,22,1,34,15,26,33,31,45,41,42,6,7,18,19,43,20],"import":[0,1,2,4,5,6,7,8,13,15,18,19,22,23,26,27,33,30,31,34,37,39,41,42,43],iterate_properti:19,message_id:31,"_user_id":19,visit_insert_from_select:43,assumpt:[21,33],grandpar:22,parent:[21,22,1,23,34,15,26,33,31,45,41,6,18,19,20,13],"__emulates__":1,pypi:[2,30,4,12],cycl:[22,0,9],uncondition:[15,31,33,37,4,7],come:[34,35,23,2,27,4,18,20],compare_valu:39,"_connectionrecord":38,region:[0,23],contract:[21,30,14,39],tour:34,tutori:[21,11,34,33,15,26,28,36,5,44,18,19,20],psycopg2:[21,39,26,27,30,7,44],mani:[21,22,45,1,23,34,2,15,26,27,33,36,31,39,44,41,6,18,19,20,13],remote_user_id:31,check1:31,"0xb791ea0c":6,among:[21,34,23,15,26,33,18],address_id:[31,19,41,20],tnsname:27,color:1,overview:[11,5,44,10],link_to_nam:31,thing_id:31,period:[37,20],pop:1,"__class__":45,photo2:19,photo3:19,photo1:19,colon:[18,0,34],item1:33,cancel:[21,15,33],association_proxi:6,coloni:21,damag:14,better:[34,0,13,22,37,38,39,42,18],ultim:[21,22,13,15,26,27,33,39,41,18],three:[34,23,27,33,4,5,31,45,41,6,18,19,20],cursor_execut:38,resort:[39,7,19,37],mari:[34,18],its_heavi:6,pend:[21,22,0,34,15,26,33,18],addit:[1,4,7,13,15,18,19,20,21,22,23,26,27,33,31,32,34,37,39,41,42,45],bypass:[21,22,7,1,27],anon_1_id:34,thousand:39,resolut:[31,33],rubi:23,tiger:[2,7,15,27,41],catastroph:33,doesn:[21,22,1,24,37,33,39,31,34,41,18,19,10],workspac:33,"0x1298f50":33,"__eq__":[26,18,19,23,39],former:[21,4],those:[1,2,4,6,7,10,13,15,18,19,20,21,22,26,27,33,30,31,34,37,39,41,45],"case":[0,1,4,6,7,8,44,13,15,10,18,19,20,21,22,23,26,27,33,29,30,31,34,37,39,41,42,45],query_cl:[25,33],sapdb:[27,10],trick:[45,18,1,10],cast:[39,26,45,10,42],invok:[1,23,26,27,33,30,31,5,41,42,43,19,13],outcom:13,invoc:33,install_st:13,tiddlywink:18,after_delet:[21,13],anytim:18,advantag:[22,0,26,31,33,4,45,41,7,18,20],stdout:27,surpass:7,canon:33,"_user_nam":19,worri:18,destin:[27,41],blah:[34,4],endswith:26,anim:23,eras:19,ascii:[2,30,12],"__init__":[0,1,2,4,6,7,13,15,19,21,23,25,26,27,33,30,31,34,37,39,41,43,45],filter_bi:[21,34,0,33,19,20],develop:[27,23],cpickl:39,author:[34,0,1,14,24,41],contains_alia:20,intermediari:[22,1,23],same:[0,1,2,4,6,7,8,9,10,13,15,18,19,20,21,22,23,26,27,33,30,31,34,39,41,42,45],trip:29,fragment:23,epoch:39,use_threadloc:7,pad:2,pai:34,paj:6,document:[0,2,4,5,44,11,13,14,15,19,21,23,25,27,33,30,31,37,38,39,42,40],exhaust:15,finish:0,twophasetransact:33,nest:[21,22,23,2,15,26,33,36,18,44],oid:19,driver:[12,39,2,15,27,37,30,4,42,9,10],pg_db:27,columnoper:[26,19],capabl:[34,2,37,38,39,31,42,18],label_length:27,improv:[21,22,4,41,23],extern:[36,31,0,33,44],somecolumn:[39,31,18,26],ntext:4,"3bdatabas":4,appropri:[21,22,18,1,15,26,27,33,39,31,45,41,42,7,8,19,43,20],sql_small_result:2,cherri:6,compoundselect:26,facad:23,without:[0,1,7,9,10,14,15,18,20,21,22,23,26,27,33,30,31,34,38,41,42,45],argument2:27,argument1:27,deferr:[31,37],model:[22,0,23,34,33,6,7,18],myconstraint:43,populate_inst:13,dereferenc:[15,0,33],newyork_address:22,declarativeabstractconcretebas:45,set_attribut:33,execut:[0,2,4,5,6,7,9,44,13,15,18,19,20,21,26,27,28,29,30,31,33,34,38,39,41,42,43],freshli:1,when:[0,1,2,4,5,6,7,8,9,10,13,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,35,37,38,39,41,42,43,45],unflush:[22,33],is_prepar:38,noreferenceerror:9,halfwai:18,aspect:[18,33,20],"_branch":15,monei:4,flavor:18,"_selectbasemixin":[21,26],pickletyp:39,close_al:33,set_isolation_level:30,versu:[18,0,34],bfile:37,hint:[21,39,31,26],except:[0,1,2,4,7,9,44,11,13,15,10,18,19,20,21,22,26,28,30,31,33,34,35,36,37,39,45],parse_decltyp:42,desktop:33,identif:39,instrument:[34,35,1,23,36,33,39,7,19,44,13],bind_processor:39,blob:[23,39,2,37,30,4,42],versa:22,role:[26,41,45],begin_nest:[15,33],unittest:33,table_nam:[31,15],jake:18,around:[1,2,15,26,33,7,18,45],circulardependencyerror:9,read:[11,0,1,22,15,26,37,33,30,31,39,41,42,6,7,18,19,10],outermost:[18,15,33],is_modifi:[13,33],get_current_uid:6,msnvarchar:4,world:33,oldnam:18,create_inst:13,presum:2,some_engin:[4,8,41,33],mod:10,make_url:27,sessionextens:[21,13,33],threadsaf:15,shares_lineag:26,changelog:10,btoc:20,integ:[1,2,4,6,15,18,19,21,22,23,24,26,27,33,30,31,34,37,39,41,42,45],server:[21,11,12,39,2,26,27,33,30,4,31,44,7,40,10],getconn:7,benefit:41,either:[21,22,18,1,34,2,38,15,26,27,33,37,30,4,31,45,41,6,8,10],cascad:[21,22,0,1,23,34,36,37,33,31,19,44],argumenterror:9,output:[34,1,15,26,27,37,4,31,7,18],coerce_compared_valu:39,realiti:33,visit_xxx:43,fulfil:[22,38,39,30],concurrency_level:29,myproxi:38,orderlin:26,column_mapped_collect:1,ascend:[18,26],sql_ascii:30,unitext:12,adequ:19,assert_unicod:[39,27,37],rowid:[19,42],loop:43,egenix:4,pickler:39,comparable_us:41,simplefilt:39,ondelet:[31,1],slice:[21,34,1,23],confirm:[31,10],columncollect:[31,26],definit:[11,0,23,24,33,15,28,39,31,34,44,41,18,19,20],elment:26,legal:15,ctest:26,use_ansiquot:2,dbname:[2,3,27,37,30,4,7],inject:27,ddl:[11,23,39,2,15,31,28,37,30,4,44,42,43,10],engineer_info:45,reset_on_return:7,complic:[22,45,34],refer:[0,5,6,8,9,44,11,15,18,19,20,21,22,23,24,26,27,33,31,28,34,36,37,39,40,41,45],postfetch:31,arrow:5,inetaddr:39,garbag:[15,33,29,7,18,19,10],each:[1,2,4,6,7,13,15,18,19,20,21,22,23,24,26,27,33,30,31,34,37,38,39,40,41,43,45],sess:[21,33,23,20],freetds_nam:4,cumbersom:18,broken:[37,10],fulli:[21,11,1,22,2,34,26,27,33,37,29,30,31,5,40,39,42,8,19,20],immut:[39,1],cornerston:18,"throw":[22,18,19,10],use_ansi:[18,37],referred_column:31,passivedefault:[31,10],firebird:[11,34,27,29,31,40,18,44],firstnam:[19,41],addconstraint:31,schemanam:[30,31,39],degre:[34,41,33,42],stand:39,neighbor:23,act:[0,1,33,39,31,6,18,19],processor:15,road:23,everi:[21,1,39,33,30,31,45,42,18,19,10],routin:[23,41,6,43,19,7],convert_unicod:[30,4,39,27,37],"__set__":19,effici:[21,0,23,15,33,38,30,45,42,19,20],checkconstraint:31,"_tabl":0,quietli:[19,1],introspect:[11,31,0],asfrom:43,sessionmak:[34,0,13,23,36,33,41,8,44],bhargan:0,mark:[22,0,1,34,25,26,33,39,31,41,18,19,13],your:[22,0,1,24,2,31,33,34,39,4,5,20,6,7,18,19,10,13],lob:37,log:[34,15,27,28,30,6,7,18,44],her:34,area:[18,31,5,38,34],aren:[26,31,19,13,10],hex:[39,19,27],renumb:24,overwrit:19,start:[21,11,13,23,24,15,26,27,33,4,34,31,42,18,19,20],interfac:[21,11,0,1,36,15,37,28,38,31,33,7,19,17,44,13],low:[31,19,38],lot:[34,0,37,4,6,18],addresses_1_email_address:[34,18,20],strictli:[22,27,33],hey_use_this_instead_for_iter:1,treat:[22,34,2,26,33,39,31,41],enough:[18,0,41,33],tupl:[21,34,25,15,26,33,30,31,41,42,6,18,19,45],bundl:[31,19],regard:[21,11,39,26,37,33,29,30,31,5,42,7],adjacency_list:23,procedur:[15,26,33,39,31,43],buggi:27,congratul:7,smallmonei:4,behaivor:19,pull:[0,23,33,31,41,7,45],dirti:[33,34,13,23],possibl:[1,7,9,10,13,15,18,19,20,21,22,24,25,26,27,33,29,31,34,39,41,45],"default":[0,1,2,4,5,6,7,44,11,13,15,10,18,19,20,21,22,23,24,26,27,28,29,30,31,33,34,37,38,39,41,42,43],insert:[0,1,2,4,44,11,13,15,10,18,19,22,23,24,26,27,28,29,30,31,33,34,36,37,41,43],"_compiled_cache_s":19,pref_id:31,foreignkei:[22,24,26,37,33,31,34,41,6,18,19,9,45],embed:[21,34,36,26,33,31,45,43,18,44],deadlock:4,connect:[0,2,3,4,5,7,9,44,11,12,13,14,15,10,18,20,21,26,27,28,29,30,31,33,34,36,37,38,41,42],excess:42,gone:[15,23],uid:[6,4,31],creat:[0,1,2,4,6,7,44,11,13,15,10,18,19,20,21,22,23,24,26,27,28,30,31,33,34,36,37,38,39,41,42,43,45],multibyt:[4,12],certain:[21,34,23,39,2,26,37,33,30,4,18,19],threadloc:[15,27,33,28,7,44],deep:[22,31,23,39],strongli:[45,0,37,20,42],myregistri:33,intro:[33,18,28,44],scope_ident:4,file:[14,23,15,27,33,30,31,42,7,8],max_overflow:[7,27],trace:39,encompass:31,incorrect:[21,39,10],again:[21,22,0,34,2,15,33,39,18,10],collid:33,googl:[2,34,20],count_1:[34,18],discrimin:[21,41,45],extract:[6,26],hybrid:[43,18,19,41,23],event:[21,11,1,14,22,36,27,28,38,39,31,33,41,23,7,19,43,44,13],field:[34,0,26,27,37,39,4,31,41,6,7,18,19],valid:[21,22,1,34,2,31,37,30,4,42,18,19,10],presenc:[34,39,26,33,30,31,18],reconstructor:[19,13],you:[0,1,2,4,5,6,7,10,11,13,15,18,19,20,21,22,24,27,33,31,34,38,39,41,42,43,45],reconstitut:19,intention:18,freestand:42,poor:[4,37],version_id_col:[35,19,41],"_sa_adapt":1,custom_attribut:23,registri:[41,33],users_1_id:34,columnon:26,symbol:[6,31,13,33],vertex:19,validate_email:19,main_tabl:31,ansi:[2,18,26,37,10],vocabulari:18,unless:[21,22,1,24,15,37,33,39,31,41,42,18,19,45],golf_sw:41,concat:[18,26],"0x9272a4c":6,contextual_connect:[15,33],dict_of_properti:19,orderedproperti:26,allow_snapshot_isol:4,directori:[6,23],descript:[11,15,26,39,31,5,42],mysess:33,overload:26,mimic:[6,21],token:[26,37,33],potenti:[4,15,31,23],begin_twophas:[15,38],escap:[2,4,26,31],invoic:31,columnproperti:19,unset:27,loans_book_id:0,threadlocalmetadata:31,all:[0,1,2,4,5,6,7,8,9,44,11,13,14,15,10,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,36,37,38,39,40,41,42,43,45],somet:[13,23,26,30,41,42,18,19],dropconstraint:31,type_coerc:26,lack:[27,37],"__table_args__":[4,41],month:[37,42],scalar:[21,22,34,15,26,33,31,41,6,18,19,20],correl:[21,26,27,41,18,19,45],deprecationwarn:9,timetupl:26,follow:[0,2,4,7,14,15,18,19,20,21,22,23,26,27,33,30,31,34,37,39,40,43,45],add_is_dependent_on:31,children:[33,22,1,20,24],dsn:[4,12],snif:6,altercolumn:43,articl:[21,22],queri:[0,1,4,5,8,44,11,13,10,18,19,20,21,22,23,25,26,27,33,31,34,36,37,39,41,45],id_choos:[25,23],instruct:[22,34,15,37,33,39,31,18,19,45],neglig:39,mymixin:41,global:[31,15,33,23],straightforward:[22,41],getattr:6,evaul:19,checkin:[7,27,38],append_ddl_listen:31,pjoin_typ:45,util:[21,1,23,36,15,26,33,41,19,44],attrbut:33,get_property_by_column:19,rowproxi:[15,19,9,10,13],failur:33,veri:[22,0,23,34,15,33,31,42,6,18,19,10],ticket:10,sc1:23,get_schema_nam:31,scopefunc:33,polymorphic_iter:19,longtext:2,anon_1_user_id:34,list:[0,1,4,5,6,7,44,11,13,15,10,18,19,21,22,23,24,25,26,27,33,30,31,32,34,36,39,45],helloworld:23,create_row_processor:13,nulltyp:[39,26],adjust:29,plain:[21,22,23,26,27,28,39,31,33,7,19,44],user_nam:[31,0,19,20],users_trigg:31,node3:23,superced:26,flintston:18,unique_param:[18,26],datetimeoffset:4,enterpris:12,ten:[39,27],shard_choos:[25,23],sync:[6,22],disconnect:[7,9,27],past:22,zero:[2,18,24],design:[15,31,5,19,33],uuid3:26,pass:[0,1,2,4,6,7,8,13,15,18,19,20,21,22,24,25,26,27,33,30,31,34,37,39,41,42,43,45],innerjoin:[22,20],further:[22,45,1,23,34,36,15,26,27,28,39,4,31,33,6,18,19,44,13],pyodbc:[2,4,12,27,44],engineer_id:41,"_binaryexpress":18,iteself:41,connection_invalid:9,abc:[31,1],sub:[2,26,27,28,31,43,19,9,44],sqlite_autoincr:42,sum:[26,33,20],sqlite_memory_db:27,abl:[34,18,33,39],brief:[26,23],nodes_2_parent_id:22,day_precis:[39,37],version:[0,1,2,4,5,44,13,10,18,19,20,21,22,23,26,27,28,29,34,35,36,37,38,39,40,41,45],use_proxi:26,succinct:19,visit_alter_t:43,localtim:26,in_transact:15,or_:[18,0,26,45,34],"public":[21,23,15,26,27,38,39,31,5],contrast:[11,34,31,5,42,18],hasn:[34,31],full:[21,34,45,0,1,23,2,15,26,37,33,39,31,44,41,42,18,19,20],hash:26,situat:[34,0,15,37,33,31,6],sophist:[18,0],append_hav:26,schemaitem:31,behaviour:29,shouldn:33,connectionproxi:38,palia:21,soon:[15,0,42,33,34],noload:[22,1],modifi:[21,22,0,1,14,34,2,15,26,27,33,39,31,5,6,18,19,20,13],valu:[1,2,4,6,7,10,13,15,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,37,39,41,42,45],test_someth:33,search:[21,22,23,26,27,37,45,18,44],ahead:0,post_id:34,name_label:34,memcach:33,utc_timestamp:31,last_inserted_id:15,prior:[22,18,20,34],"__composite_values__":19,keyvalu:31,doctest:[18,5,20,34],pick:[2,6,31],action:[31,33,14],narrow:[34,45,23],get_bind:33,tkyte:37,via:[0,1,2,4,6,7,10,12,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,37,38,39,41,42,43],depart:31,someversionedclass:23,primit:[34,18],transit:2,managers_employee_id:45,"0xb79bbbec":6,deprec:[21,2,26,27,33,37,39,31,19,9],inappropri:1,suddenli:34,customiz:27,decrement:15,coercion:21,select:[0,2,4,6,7,44,15,10,18,19,20,21,22,23,25,26,27,28,29,30,31,33,34,36,37,39,41,43,45],aggress:29,proceed:[19,13,33],distinct:[21,34,23,26,27,33,29,45,31,5,10,41,7,18,20],regist:[43,42],two:[1,2,4,5,6,10,15,18,19,20,22,23,24,26,33,29,30,31,34,35,37,39,41,42,43],formul:[21,22,33],con_proxi:38,taken:[21,2,26,37,39,31,42,19],msnchar:4,mycompar:19,create_constraint:[2,39],more:[0,1,2,4,6,7,10,13,15,18,19,20,21,22,23,24,26,27,33,30,31,34,35,38,39,41,42,43,45],flat:22,desir:[21,22,13,34,15,26,33,39,31,45,7,19,20],mappedus:0,"_get_statu":19,someclasshistori:23,flag:[21,22,13,34,2,15,26,27,33,37,29,30,4,5,31,39,42,18,19,20],merge_result:21,parse_colnam:42,particular:[1,2,4,5,7,10,13,14,15,18,19,20,21,22,23,26,27,33,31,34,39,42,45],known:[0,1,2,4,44,15,18,19,20,22,23,26,27,33,30,31,34,35,37,39,42,45],post_keyword:34,cach:[0,23,36,15,26,33,31,44,18,10],mapper_arg:0,none:[0,1,2,4,6,7,8,13,15,18,19,21,22,24,25,26,27,33,30,31,34,35,37,38,39,41,42],endpoint:23,ix_mytable_col2:31,someindex:31,hour:[2,27,42],hous:21,attr_nam:1,"_polymorphic_map":19,dev:2,histori:[33,22,19,13,23],remain:[21,22,34,15,37,33,29,31,5,41,7,18,20],del:[34,0,33],addresses_1_id:[34,18,20],primary_languag:41,"__mapper_args__":[19,41],someobject:33,aliasedclass:[21,33],after_begin:13,prompt:[18,4,5,34],substanti:14,useabl:15,scan:39,challeng:45,flush_context:13,share:[15,26,33,38,41,42,6,7,19,45],remote_sid:[22,1],templat:31,minimum:[2,20],identity_key_from_row:19,duper:10,inspector:[6,31],with_label:[21,0,26],uncheck:21,huge:18,"0x4642670":41,cours:[0,1,2,15,33,31,42,18,45],awkward:6,secur:34,programmat:[18,5,26],anoth:[21,34,2,26,33,39,31,18,19,20],node1:23,fruition:23,perhap:[31,20],of_typ:45,columnkei:31,classproperti:41,"0x1298d10":33,simpl:[21,22,0,23,34,26,37,33,39,10,41,6,18,19,20],unabl:4,resourc:[34,0,2,15,33,38,29,7,18],referenc:[22,18,23,34,15,26,33,31,41,8,19,20],noreferencedtableerror:9,variant:[22,1,23,26,39,31,18,20],sneak:34,reflect:[11,0,22,2,15,26,27,28,37,39,4,34,31,33,41,6,18,8,19,44],catalog:[34,18],buffer:[21,30,15,26,33],offset:[21,34,1,44,26,37,4,20,18,10],prefix_with:[43,26],unlink:1,associ:[0,1,4,6,8,44,11,13,14,15,18,19,20,21,22,23,26,33,30,31,32,34,36,37,39,41,45],"_sa_initi":1,"short":[2,0],my_seq:37,confus:[21,29,31,10,42],created_at:[31,41],ambigu:[41,33],caus:[21,22,35,1,27,33,37,29,4,31,43,10],callback:[7,15],informixdb:[3,27,44],ddlcompil:43,non_ad:33,longblob:2,isout:[21,0,26],passive_off:33,referenti:[21,22,19,23],help:[23,26,33,39,41,18],refererenc:19,"0xff":[18,26],autoload:[2,31,37,41],ordering_list:24,trade:24,by_stock:6,through:[21,22,1,34,2,38,27,33,37,30,4,39,31,45,41,42,6,7,18,19,10],reconnect:[7,15],cextens:5,hierarchi:[23,36,15,44,41,19,45],variat:0,paramet:[0,1,2,4,6,7,9,10,13,15,18,19,20,21,22,25,26,27,33,30,31,34,37,38,39,41,42,45],style:[22,34,2,26,27,33,4,31,45,41,18,19,10],right_id:22,binari:[39,2,26,37,30,4,19,10],itervalu:1,ianywher:12,psycopg1:30,relev:1,late:41,harmless:10,html:[39,42,27,37],post_upd:[22,1],might:[22,34,25,15,26,33,31,41,42,6,18,20],alter:[43,4,15,31],append_column:[31,26],parent_node_id:31,recip:[1,37,33,39,19,45],good:[34,1,2,15,33,31,41,13],"return":[0,1,2,4,5,6,7,44,13,15,10,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,37,38,39,41,42,43,45],timestamp:[39,2,26,27,37,30,4,41,42,43,19],nospam:0,synopsi:[43,28,44,41],framework:[33,0,13,23],compound:18,ninja:6,detach:[21,35,15,33,38,18],bigger:[39,33],get_properti:19,eventu:19,treenod:23,stream_result:[21,30,15,26],troubleshoot:[2,44],level:[0,1,2,4,5,8,44,11,13,15,18,19,20,21,22,23,26,27,33,30,31,34,37,38,39,40,41,42,43,45],sole:[39,1,45],use_native_unicod:30,refresh:[21,22,35,34,33,18,19],tear:34,adalias_address_id:20,sadeprecationwarn:9,innodb:[22,1,2,31,41,19],compris:[26,31,19],found:[21,34,35,23,26,39,31,42,6,18,19,40],unicod:[21,12,39,2,26,27,37,29,30,4,31,41,42,18,44],truncat:[26,27],dump_tre:23,name_1:18,order_count:19,hard:18,idea:[31,15,33,23,41],sidnam:27,realli:[34,7,18,33],heavi:18,linkag:[31,1,37],except_al:[21,18,26],expect:[22,0,1,34,27,35,41,18,19,20],load_dialect_impl:39,mapperextens:[21,19,13],adalias_user_id:20,beyond:[22,19,9,33,27],orient:[39,26],standard:[11,45,18,34,23,24,38,27,28,37,39,4,5,31,33,42,7,8,19,9,44],existing_object:33,"try":[18,15,33,23,34],safeti:15,subqueryload_al:20,foolproof:[34,18],publish:14,research:10,specialpric:26,maxdb:[40,11,44,10,27],print:[21,22,0,13,23,34,15,26,27,33,38,29,30,31,6,18,43,8,1],add_ent:21,occurr:[34,26],cright:26,qualifi:[31,26],privat:15,proxi:[11,23,22,36,15,26,33,38,31,32,41,6,7,19,44],uncommit:42,advanc:[11,0,1,23,34,45,18,10],mypackag:33,view_id:31,differ:[21,34,45,1,23,43,26,27,33,37,39,31,20,41,42,6,7,18,19,9,10],pub:42,someon:33,join_to_left:21,thoroughli:0,reason:[21,22,27,33,29,4,31,42,7,43],base:[0,1,2,4,6,7,8,9,44,13,15,18,19,20,21,22,23,24,25,26,27,28,30,31,33,34,35,37,38,39,41,42,43,45],intric:[33,23],quicki:33,heroic:2,basi:[0,1,23,2,26,27,33,29,30,4,20],thrown:19,driven:41,secondary_t:22,thread:[0,36,15,37,33,29,31,42,7,19,44],ms175095:4,cls_or_mapp:21,omit:[37,39,2,31,27,30,4,45],success:[21,34,26,37,33,18],mediumtext:2,perman:19,lifetim:[38,15,19,1,13],assign:[21,22,1,23,24,26,33,39,31,34,41,6,18,19],datamodel:23,feed:18,major:[22,2,27,37,31,5],holdings_t:6,obviou:45,dialogu:33,feel:31,mysql_limit:2,lastnam:[19,41],number:[2,4,6,7,10,13,15,19,20,21,22,24,26,27,33,31,34,35,37,38,39,45],sometim:22,done:[22,1,33,29,31,41,6,7,18,10],least:[22,34,2,33,39,31,18],sqlerror:9,blank:[26,19,45,33,34],stabl:[2,13],implementor:41,miss:2,compile_varchar:43,is_bound:31,guess:[18,33],php:14,script:[31,5,23],column_kei:26,ipaddress:39,interact:[34,23,27,33,37,39,41,18],join_depth:22,reentrant:19,order_bi:[21,22,18,1,24,26,34,31,0,41,8,19,20],statement:[0,2,4,9,44,13,15,18,19,20,21,22,23,26,27,28,29,30,31,33,34,35,36,37,38,39,41,43,45],jek:6,scheme:[21,24,25,33,31,41,19,20],colnam:31,store:[22,0,23,24,2,15,26,37,33,39,31,34,7,18,19,43,45],schema:[41,11,0,34,23,22,2,15,26,31,28,37,30,4,5,44,39,43,18,9,10],option:[0,1,2,4,6,7,44,11,13,15,18,19,20,21,22,23,24,26,27,28,29,30,31,33,34,37,39,41,42,45],translate_row:13,asguid:26,left_id:22,users_user_id:20,part:[22,1,34,15,26,33,39,31,5,41,43,18,19,20],pars:[33,4,27,23,42],notes2:1,myclass:[1,33,4,41,8,19],fred:[34,18],king:15,kind:[21,22,45,12,23,14,36,26,27,33,37,29,30,31,44,7,18,19,20],simplist:[4,45],contrari:[34,18],whenev:[34,31,15,33],remot:[22,31,41],remov:[21,22,0,1,23,34,15,26,33,39,31,6,7,19,13],get_index:31,adapt_oper:39,horizont:[11,23,36,25,33,32,44],bridg:27,for_upd:[31,26],str:[34,2,26,31,39,4,43,18,19],reclaim:29,arrang:22,stale:[21,33],toward:[34,39,26,27,37,30,31,18],user_prefer:31,animalfact:23,comput:[21,22,41],deleg:[7,1],yeee:33,orig:9,packag:[34,1,2,26,27,33,31,5,41,43,19],expir:[21,22,15,33],requisit:21,"null":[22,1,34,2,26,31,33,45,4,20,18,19,10],mypool:7,sell:14,get_dialect:27,univarchar:12,joinedload_al:20,relationship:[21,11,0,13,23,24,36,26,37,33,45,31,34,44,22,6,41,18,19,20,1],equival:[21,34,0,1,15,26,33,39,31,18,19],nodes_data:22,self:[21,22,0,1,23,34,15,26,33,38,39,41,6,43,18,19,45,13],violat:[22,1,33],also:[0,1,2,4,5,6,7,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,35,37,38,39,41,42,43,45],exposit:33,build:[11,34,23,22,36,33,39,31,5,45,6,7,18,19,44],thenumber12:34,someurl:38,unicodetext:[39,4,37],proxy_factori:6,someaddress:[34,19],selectcontext:13,distribut:[14,23,25,5,42,6],exec:[26,13],previou:[21,22,1,34,2,15,31,33,4,41,8,19],reach:7,chart:40,most:[1,2,4,5,6,7,13,15,18,19,20,21,22,26,27,33,29,31,34,37,39,41,43,45],plai:[39,18,26],node_id:31,local_session_cach:23,server_default:[31,19],myisam:[22,0,2,33,31,19],corresond:42,promulg:1,charg:14,appear:[2,34,4,18,12],literal_column:26,max_identifier_length:27,exc:[21,34,35,33,38,9],clear:[21,18,31,0,33],bdb:2,cover:[18,0,5,27,34],on_upd:19,datetime2:4,roughli:[39,26],salari:[29,26],ext:[22,0,24,25,39,34,41,6,43,8,19],getter:[6,19,41,33],clean:39,resembl:[31,18],bidirect:34,usual:[21,22,45,1,39,2,15,26,37,33,29,30,31,20,41,6,7,18,19,10,13],microsoft:[11,44,27,4,16,40],visibl:[22,34,1,9],"0x12a25d0":33,carefulli:18,finer:31,consult:[1,27,33,4,7,40],"_binari":[2,39],session:[0,1,2,6,8,44,11,13,15,19,20,21,22,23,25,27,33,30,31,34,36,39,41,45],particularli:[22,7,31,33,42],shard_id:25,sqla:29,dimension:30,currval:10,find:[21,31,0,41,10],email1:34,impact:[39,15],coerc:[39,26,27,37],clob:[39,37],pretti:[41,20],visit_alter_column:43,solut:[37,33],queu:7,central:33,"_floattyp":2,determinist:[21,7,18,26],nosetest:23,users_1_password:34,unus:42,express:[0,1,2,4,5,8,44,11,14,15,18,19,21,22,23,26,28,31,33,34,36,39,41,42,43],coltyp:39,nativ:[23,39,37,27,30,4,42,10],use_unicod:2,celementtre:23,rest:[15,0,19,18,33],liabl:14,ambiti:[22,23],display_width:2,restart:38,ansifunct:26,has_inherited_t:41,retreiv:19,sorted_t:31,cyclic:22,mylisten:38,rfc:27,item_id:31,common:[22,34,26,27,33,29,39,31,41,7,18,19,43,45],as_scalar:[21,18,26],set:[1,2,4,5,6,7,44,11,13,15,10,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,36,37,39,41,42,43,45],version_uuid:19,seq:31,creator:[6,7,31,27,38],from_self:21,after_flush_postexec:13,mutabl:[22,1,24,36,30,39,44],get_dbapi_typ:39,see:[0,1,2,4,5,6,7,44,13,15,18,19,20,21,22,24,25,26,27,33,29,30,31,34,37,38,39,41,42,45],dropgeometrycolumn:23,signifi:31,cart_id_seq:31,mxodbc:[4,12,27,44],reserv:[30,31,18,39],clear_mapp:[34,19],local_t:19,users_fullnam:[34,18,20],analog:[21,18,19],simultan:[26,7,19,33],inconveni:6,tableclaus:[31,26],logging_nam:[7,15,27],someth:[34,1,39,31,41,18,19,9],particip:[13,2,25,15,33,31],financial_info:31,stringifi:39,reus:[21,4,19,7],idx_col34:31,pjoin_nam:45,nope:33,instrument_class:13,altern:[21,22,0,41,23,34,2,26,27,33,37,36,31,5,39,18,19,44],signatur:[26,39,19,38],popup:[34,18],syntact:26,numer:[34,39,2,26,37,30,4,42,6,18,10],complement:22,class_mapp:[19,33],isol:[15,31,33,30,4,42,18,44],querycontext:13,york:22,succeed:15,pymssql:[4,27,44],on_link:1,instrument_declar:41,relationshipcach:23,classnam:0,entitynam:23,popul:[21,22,13,34,33,31,45,6,19,20],both:[0,1,2,5,6,7,10,15,18,19,20,21,22,23,26,27,33,31,34,38,39,41,43,45],is_liter:26,last:[39,37,33,30,7,18,10],delimit:33,target_fullnam:31,noresultfound:[21,34,35],alon:[39,20],foreign:[21,22,0,1,23,34,2,26,33,31,45,41,18,19,20],context:[34,13,15,26,33,38,31,41,19,20],attrnam:0,author_id:41,whole:[34,23,15,33,4,18],load:[0,1,2,6,8,44,11,13,10,19,20,21,22,23,33,31,34,36,39,41,42,45],nodes_id:22,licens:14,simpli:[1,31,20,41,42,6,7,19,10],undefin:[41,33],point:[2,7,8,44,13,15,18,19,20,21,22,23,24,27,33,30,31,34,36,37,39,41],instanti:[34,15,27,33],schedul:33,loan:0,arbitrarili:0,header:23,param:[21,34,0,15,26,33,38,39,7,18,19,9,10],nodes_1_data:22,suppli:[21,1,24,2,15,26,29,39,31,20,41,6,19,9,10],managers_manager_data:45,throughout:[22,31,18,33,34],simpler:[6,19],backend:[34,39,15,26,27,33,37,29,30,31,5,18,40],blog:[34,1,23],vertic:[33,36,19,44,23],user_id:[22,34,15,26,33,31,41,6,18,19,20],addresses_1_user_id:[34,18,20],due:[34,18,37],empti:[1,15,27,33,31,41,20],implicit:[34,33,15,31,28,4,10,43,18,44],whom:14,secret:18,addressus:19,unambigu:37,double_precis:[30,37],adalias2:34,nonexist:9,strategi:[21,22,1,23,34,33,15,27,28,36,44,20],after_bulk_upd:[21,13],fire:[21,34,1,33,38,31,19,20,13],beforehand:[30,31,33],imag:4,inherit_foreign_kei:19,convert:[21,22,1,23,39,2,26,27,33,37,30,4,31,20,42,18,19,10],unnecessarili:[22,45],related_user_id:22,coordin:33,understand:[0,1,15,28,18,44],func:[21,34,0,2,15,26,39,31,41,42,18,19],demand:[6,22,10],repetit:31,convers:[34,1,39,2,27,33,37,30,31,18,10],acount:33,look:[22,0,1,34,33,31,45,41,42,6,18,19,20],employee_dept:31,solid:1,straight:[2,21,26,19,34],erron:34,histor:[22,42,23,34],oldvalu:13,durat:31,nls_lang:37,"while":[34,0,23,15,31,33,4,41,6,18,19,45],executemani:[30,31,18,10,38],smart:[0,10],abov:[0,1,2,4,5,6,14,15,18,19,20,21,22,24,26,27,33,29,31,34,39,41,42,43,45],error:[21,22,1,34,2,26,27,33,37,39,31,9,10],flusherror:[35,33],fixtur:[33,23],robin:25,awesomelist:1,pylon:0,subsect:39,propag:[22,19,45],ordereddict:1,readi:[34,15,19,33],readm:23,someentri:22,revers:[22,31,18,39,34],itself:[21,22,35,13,24,15,26,27,33,37,41,30,31,34,45,39,7,18,19,43,20],supports_sane_rowcount:15,limit:[0,1,2,4,7,9,44,14,10,18,20,21,22,23,24,25,26,27,33,31,34,37,41,42,45],"_statu":19,pref_nam:31,queue:[42,38],decor:[1,41,43,19,7,13],read_commit:30,myothert:1,sybas:[11,12,26,27,40,44],minim:[34,7,18,26,1],get_refer:31,remote_id:31,first_connect:38,libc:42,decod:[39,4,37],apply_label:[18,26,20],"3ddb":4,"_get_address":22,conflict:[34,18,26,9,33],rev_id:31,after_rollback:13,optim:[2,21,37,20],pysqlit:[27,44,42],mytyp:39,myawesomelist:1,alert:18,moment:22,temporari:33,user:[0,1,2,3,4,5,6,8,13,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,37,39,41,42],"__add__":19,remote_t:[31,41],my_mutating_procedur:15,stack:39,built:[11,0,1,34,15,26,33,39,31,5,42,43,19],enable_typecheck:1,stateless:33,travers:[6,39,31,26],task:[21,39,37,33,30,31,43,10],expire_al:[21,33],older:[2,22,4,19,29],prepare_twophas:38,elem:33,compile_mycolumn:43,pickl:[39,8,19,23],person:[21,23,14,41],chees:[6,5],picki:[18,10],init_fail:13,programmingerror:9,imit:23,know:[22,1,34,26,33,30,39,41,18,19,20],construct:[0,1,2,4,5,6,7,8,9,44,11,13,15,18,19,20,21,22,23,25,26,27,28,30,31,33,34,36,37,39,41,42,43,45],match_obj:42,existing_a1:33,relianc:[41,42],shape:1,mysql:[21,11,0,1,23,22,2,15,26,27,33,37,30,4,39,31,44,18,19,40,10],mapped_t:33,elect:2,eager_column:20,from_obj:[21,18,0,26,45],rundown:34,cut:26,users_table_2:31,queen:15,shortcut:[18,31,15,26,34],eager:[21,22,1,34,36,33,20,10,44],cue:22,invalidrequesterror:[35,9,33],email_address_2:18,email_address_1:18,subsequ:[21,34,24,25,37,33,30,18],posts_headlin:34,useless:42,saniti:18,dataerror:9,vendor:[33,11,28,44,39],obsolet:13,mapperproperti:[19,13,41],transpar:[34,1,23,33,31,7,18],non_delet:33,intuit:[31,0,41,45],datamapping_join:22,"__gt__":19,falcon:2,bit:[2,30,4,18],characterist:[30,34],table1:[15,26],engine_email_address:31,uninstall_descriptor:13,table_info:[34,31,18],bulkpric:26,tinytext:2,resolv:[21,31,9,33,41],resultproxi:[21,15,26,33,29,30,31,18],use_label:26,collect:[1,6,7,44,11,13,15,10,18,19,20,21,22,23,24,26,33,31,34,36,39,41,45],query_class:1,api:[0,1,2,4,5,6,7,9,44,11,13,15,10,18,19,20,21,22,23,24,25,26,27,28,30,31,33,36,38,39,41,43],get_pk_constraint:31,popular:[22,5],declared_attr:41,interestingli:18,default_charset:2,encount:[21,22,35,33,39,41,18],greaterthan100:26,myobject:[39,33],often:[21,34,0,24,26,33,29,30,41,18,19,20],simplifi:6,empl:29,creation:[13,2,15,27,33,38,39,31,7,43,45],some:[1,2,4,6,7,8,10,13,15,18,19,20,21,22,23,24,25,33,30,31,34,37,39,41,42,43,45],back:[21,22,0,41,34,2,15,37,33,38,29,36,4,35,45,39,42,6,18,44],understood:[21,4,26,33],sampl:[3,4,18],order_t:33,executedirect:4,child_id:22,surpris:[18,33],scale:[34,23,2,37,39,18],though:[13,15,26,37,33,39,31,41,7,18,19],pep:7,nodes_2_id:22,prop:[21,19,41],usernam:[22,12,34,2,15,27,4,7,18,10],substitut:[2,31,26,1],larg:[22,1,23,34,36,15,39,4,44,19,20],object_sess:[22,19,13,33],slash:[27,42],leftmost:21,primaryjoin:[22,1,41],myset:2,run:[34,13,23,15,27,33,37,4,5,18,19,10],mssql_db:27,bind_mapp:33,loans_loan_d:0,reverse_oper:26,"_null":26,deferredcolumnproperti:19,zzk:6,prerequisit:18,elixir:[34,23],from:[0,1,2,4,5,6,7,8,9,10,11,13,14,15,18,19,20,21,22,23,25,26,27,33,29,30,31,34,35,37,38,39,41,42,43,45],impos:[7,19],stepz:6,inter:[33,20],is_mut:39,internally_instru:1,employees_nam:45,varbinari:[2,30,4,37,39],materi:22,compile_binary_sqlit:39,manag:[0,13,23,24,36,15,26,33,38,31,5,45,41,7,18,19,44,1],rowcount:[29,15,10],bind_tabl:33,microsecond:42,sysop:37,featureset:31,assoc:22,reset_joinpoint:21,block:[15,33],plan:[18,19,13,37],"__repr__":[6,34,45],real:[21,34,0,2,31,33,30,4,42,7,18],moss:0,primarili:[21,34,31,18,26],pythonpath:23,within:[0,1,2,4,5,7,13,15,18,19,20,21,22,23,25,26,27,33,30,31,34,37,39,41,42,43,45],manager_of_class:33,geomfromtext:23,"_comparemixin":26,ref_num:31,ix_:31,contributor:14,nclob:[39,37],announc:23,anon_1_users_id:20,with_polymorph:[21,19,45],occupi:1,inclus:19,back_popul:[22,45],install_descriptor:13,few:[39,31,33,23],fledg:26,question:33,non_primari:19,textual:[15,0,26,18],beaker_cach:23,juicier:18,arithmet:39,maper:19,suit:[23,2,15,37,33,19,10],forward:[19,37],paren:1,datastructur:39,compositeproperti:19,clear_manag:7,whereclaus:[21,26],with_par:[21,22,34],msntext:4,properli:[22,15,33,10,41],repeatedli:[7,18,19,1,33],append_prefix:26,staledataerror:[35,19],enable_eagerload:21,pwd:4,use_decim:39,link:[34,1,27,31,18,20],translat:[13,39,26,27,30,42,18,19],newer:[29,33],atom:[2,33],ulist:20,article_keyword:21,line:[34,27,33,5,43,18,45],union_al:[21,26],info:[15,27,38,30,31,41],concaten:[30,18,26,39],utf:[39,2,27,37,30,4,18],consist:[21,13,15,26,37,33,38,39,31,18,45],from_joinpoint:[21,22],trusted_connect:4,dom:23,execute_at:[31,43],lifespan:[0,33],sinc:[21,22,0,1,24,27,33,37,29,31,34,41,42,7,18,19,43,45],someus:34,lazyload:[23,20],highlight:[34,18],similar:[22,18,1,34,2,15,26,27,39,4,31,41,8,19,45],mymodel:41,impl:[39,26],invoice_item:31,sort:[31,0,9,24],user2:[21,33],user1:33,parser:19,after_insert:13,repres:[0,1,5,6,15,18,19,20,21,22,23,26,27,33,30,31,34,37,38,39,41,42,43,45],"char":[12,39,2,37,30,4,42],typecolnam:19,supports_sane_multi_rowcount:15,guarante:[22,13,15,26,37,39,7,18,9],target_class:6,shopping_cart:31,mssql:[43,4,27],unalias:26,titl:[18,17,0,19],append_group_bi:26,invalid:[21,34,35,15,37,33,38,39,7,19,9],"_scalarselect":26,automag:4,edwardo:34,ellipsi:[34,18],mock:27,mymetadata:41,deseri:8,intersect_al:[21,18,26],note_id:31,active_histori:[22,19,13,33],"_create_hold":6,cst_user_name_length:31,totyp:26,william:[34,18],echo_pool:27,meaning:33,reportedli:10,frozendict:0,"_stringtyp":[2,4],algorithm:[19,42],vice:22,notion:[22,4],tradeoff:20,depth:[21,22,20],compatibil:4,came:18,far:[34,0,1,23,31,18,20],fresh:[45,33,38],crowbar:23,hello:33,usagerecip:[5,33,23,37],years_with_count:0,extrapol:[31,23],optimized_:23,edg:[21,9,23],scratch:5,"__mapper__":41,session_us:26,has_kei:15,last_upd:31,"__getattr__":[21,7],edu:0,superfici:[34,18],unmappederror:35,objectdeletederror:35,child3:22,procur:[7,15,27,33],current_us:26,asktom:37,elsewher:[22,1,41],company_id:45,send:[21,22,13,33,39,18,19],nose:23,cascade_backref:[22,33],lower:[23,37,27,41,19,10],becam:18,"__name__":[41,45],opposit:[31,8,1,33,37],aris:[31,18,41,14],fatal:2,use_alt:31,sent:[21,13,2,26,27,33,37,39,4,31,41,7,18,19],passiv:[1,33],gjffdd:34,datafil:23,inserted_primary_kei:[18,31,15],rollback:[21,34,0,13,15,33,38,7],engineer_mapp:45,after_upd:[21,13],mymappedclass:[19,33],theori:20,untouch:33,implicitli:[30,31,15,19,41],runnabl:23,tri:[19,33],span:[45,33,38],tran:[15,33],magic:[18,24],fromclaus:[21,26],notabl:33,michael:14,fewer:[18,19,45,20],unquot:2,somecol:[39,26,10],versionedlisten:23,get_col_spec:39,dealt:34,othercolumn:26,databaseerror:9,object_mapp:19,pleas:[21,4,0,33,23],comparator_factori:[22,19,1,41],impli:[22,14,34,15,26,39],smaller:39,"__metaclass__":[41,23],natur:[33,31,41,6,19,45],c_tabl:45,"11g":37,focu:18,somedb:31,mysqldb:[2,27],accomod:[30,42],download:[2,5],greaterthan10:26,fullnam:[22,34,33,31,41,18,19,20],click:[34,18],append:[21,22,13,23,24,26,33,39,31,34,6,19,1],compat:[41,22,1,23,44,2,15,27,33,37,30,4,34,20,39,42,7,18,19,40,10],all_peopl:23,compar:[22,23,26,33,39,31,19,20],subselect:45,fetchxxx:15,fine:[0,39,31,6,7,45],saw:34,createsequ:31,access:[0,1,6,44,11,15,16,18,19,20,21,22,23,27,33,31,34,35,36,37,39,40,41,42,43,45],experiment:[37,10],can:[0,1,2,4,5,6,7,8,9,10,13,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,37,38,39,40,41,42,43,45],involv:[34,35,15,33,31,5,41,43,18,19,45],inspect:[34,1,23,38,31,6,43],timeouterror:9,despit:[22,10],len:43,broker:6,othert:[2,31],intercept:[13,23,24,38,39,7,1],let:[34,0,33,31,6,18,20],get_view_nam:31,uc_nam:41,pysqlite2:42,becom:[34,31,18,19,33],accessor:[21,34,15,26,31,43],scopedregistri:33,visit_insert:43,some_sequ:31,great:[1,33],copyright:14,artifici:22,larger:[45,26,13,20],technolog:37,"_name":18,lockmod:33,id_1:18,declarativemeta:41,defeat:[21,33],opinion:[34,18],typic:[21,22,18,13,23,34,15,26,27,33,30,31,39,41,42,7,8,19,20],honor:21,passive_no_fetch:33,control:[21,22,23,34,2,15,27,33,37,29,39,4,31,45,41,42,18,20],eagerload_al:20,appli:[0,1,8,13,15,18,19,20,21,22,23,26,27,33,30,31,34,37,39,41,42,43],app:33,wil:31,gatewai:0,"boolean":[22,34,2,15,33,30,31,39,42],duck:[6,1],substut:31,refcolumn:31,"_immut":26,tailor:[30,37],ed_us:34,zerofil:2,zip:19,commun:[11,37,40,42],doubl:[2,42],correspond_on_equival:26,sapendingdeprecationwarn:9,next:[21,22,13,34,15,27,33,4,31,18,19,45],websit:34,modicum:18,call_operation3:15,call_operation2:15,save:[22,0,1,23,33,18,19,45],sesion:1,expiri:33,inet:[30,39],interbas:29,isam:22,clever:23,rich:[34,31],comparison:[22,0,26,33,39,43,19,10],initialize_instance_dict:13,mismatch:37,is_instru:33,with_hint:[21,26],"_email":19,identity_key_from_primary_kei:19,name2:18,name3:18,name1:18,poly_assoc_gener:23,quote_schema:31,greatli:[6,23],account:[21,26,33],merged_object:33,retriev:[34,0,24,15,26,33,38,30,31,35,7,18,19],augment:39,a_tabl:45,annot:1,with_lockmod:[21,33],get_foreign_kei:31,obvious:0,typedecor:[39,26],meet:[31,19,1],department_id:31,fetch:[21,22,1,34,15,27,33,37,29,30,4,39,31,20],employe:[21,31,41,45],sqlite:[11,0,1,23,22,15,27,33,37,39,31,34,40,41,42,7,18,19,44],plate:33,process:[22,1,34,38,15,26,27,33,37,30,4,39,31,42,43,18,19,13],lock:[21,15,26,33,29,4,7,44],compatibiil:4,high:[21,11,34,15,33,38,42,18,44],piecem:18,tag:[19,1],entry_id:22,opensourc:14,schemat:22,onlin:22,subsystem:33,serial:[11,13,23,39,33,28,30,31,44,8,10],urldecod:4,forese:[34,20],uuid4:19,filepath:42,european:37,removes_return:1,nvarchar:[2,39,4,12,37],varchar2:37,memoiz:39,instead:[21,22,0,23,39,2,15,26,27,33,37,30,31,45,6,18,7,8,19,43,20],partit:[36,33,44],inher:42,circular:9,columndefault:31,msdn:4,overridden:[26,4,19,31,39],append_whereclaus:26,lower_1:19,target_id:41,commit_twophas:38,began:18,insp:31,class_:[33,19,13,23],reconcil:[21,33],inst:13,schematyp:39,attent:34,redund:[22,20],defaultclaus:31,mere:26,check_same_thread:42,callable_:15,someset:39,noreferencedcolumnerror:9,orchestr:1,add_al:[34,33],our_us:34,loglevel:15,seriou:2,counter:[31,15,27],postgi:[36,44,23],correspond:[21,22,0,13,34,15,26,27,33,30,31,39,42,7,18,19,9,45],element:[21,22,45,23,34,15,26,28,39,31,33,41,43,18,19,44],issu:[2,4,7,9,44,13,15,10,18,19,20,21,22,23,25,27,33,29,30,31,34,37,39,41,42,43,45],addresses_2_email_address:34,mainten:33,allow:[1,2,4,7,8,10,13,15,18,19,21,22,23,25,26,27,33,31,34,38,39,41,42,43,45],myapplic:0,fallback:[21,30],comparable_properti:[19,41],asc:[18,26],furnish:14,"02d":42,elif:39,charset:[2,39,4],col4:31,jigger:18,tribe:18,popitem:1,own:[22,1,23,34,15,26,27,33,37,39,31,5,41,42,7,18,19,45,13],comma:[22,4,26,37,33],primarykeyconstraint:31,bunch:6,superior:19,outputtypehandl:37,ext3:13,ext2:13,ext1:13,disambigu:[21,0,19],yield_curve_2:26,yield_curve_1:26,pjoin_employee_id:45,myprop:19,"_updatebas":[30,26],purg:33,load_on_pend:22,therefor:[21,34,13,27,31,41,18,19,20],typemap:26,tometadata:31,crash:10,greater:[23,2,37,39,4,19],maxemail:18,zxjdbc:[2,27,37,30,4,44],python:[0,1,2,4,5,6,7,8,44,11,12,15,10,18,19,21,22,23,24,26,27,33,29,30,31,34,36,37,38,39,41,42,43],auto:[39,2,26,31,33,37,30,4,42,7,44],overal:[45,15,26,13,33],handi:[31,0,33],association_t:22,devel:10,some_key_func:1,mention:[18,15],front:[5,41,33],mylist:1,manager_mapp:45,close_with_result:[15,33],"enum":[2,30,39],minimalist:0,multiprocess:15,somewher:33,trac:[5,33,23,37],anyth:[34,31,18,19,43],edit:4,instrumentedattribut:1,shard:[11,23,36,25,33,32,44],autoflush:[21,22,0,1,33,39,41],oracledialect:18,slide:24,attributeextens:[22,19,13,23],mode:[21,11,0,2,15,26,27,33,37,30,4,5,44],batch:[21,26,19],myconnpi:2,stock:6,upward:31,subset:[1,23,26,33,39,31,18,19],published_year:0,view_nam:31,grok:23,intellig:41,strip:39,loan_dat:0,sql2000:4,dialect_impl:39,consum:[29,34,18,26,9],some_view:31,tablename_somecolumn:26,meta:[1,15,39,31,41,6],"static":[31,1],returns_row:15,password:[34,0,12,2,3,27,29,30,4,31,7,18,20],our:[34,0,15,33,39,31,18,19,45],special:[22,1,39,15,26,33,30,31,41,6,43,18,19,45],out:[0,1,2,6,7,9,14,15,18,19,20,21,22,26,27,33,30,31,34,38,39,41,42,45],variabl:[34,2,15,31,33,37,39,4,18],"__new__":[19,13],reload:[34,33],compiled_cach:26,cart_id:31,stub:12,typenam:39,suitabl:[34,27,1,24],user_t:31,merg:[21,22,13,14,33,19],metaclass:[41,23],defens:[34,33],math:[26,19],contains_eag:[34,20],high_prior:2,nodes_2_data:22,insid:[34,26,27,33,41,18,19,20],user_alia:[21,34,20],manipul:[18,5,1,13],standalon:[34,0,23,26,31,43],unboundexecutionerror:9,pjoin:45,dictionari:[0,1,6,7,44,13,15,18,19,21,23,25,26,27,33,31,34,36,37,38,39,41],releas:[22,13,2,15,26,27,33,29,39,31,7,19,10],higher_neighbor:23,shrew:23,always_refresh:[19,41],has_chang:33,b_tabl:45,blogpost:34,cartitem:31,ask:[9,33,27],keep:[22,15,27,33,31,42,6,19],counterpart:[26,19],unmappedinstanceerror:[35,19],length:[34,39,2,26,31,37,30,4,43,18,10],tack:18,bytea:[30,39],outsid:[21,1,4,33,31,19],append_correl:26,geometri:23,retain:33,timezon:[2,39,4],method_a:[15,33],softwar:[37,14,42],get_column:31,expire_on_commit:[0,33],poly_assoc:23,mustexist:31,ext_stop:13,scene:15,echo:[18,7,15,27,34],mai:[0,1,2,4,6,7,10,13,15,18,19,20,21,22,25,26,27,33,29,30,31,34,35,37,38,39,41,42,45],owner:31,auto_convert_lob:37,suffic:19,reflectt:[31,15],philosophi:20,"_numerictyp":2,dump:[39,8,23],strict:[2,33],conjunect:7,unknown:[26,35,19,27,39],instrument_attribut:13,perfectli:[39,7,10],system:[11,23,34,25,15,33,39,31,5,41,18,19,40],wrapper:38,attach:[22,13,23,34,33,31,6,18],eager_default:19,storage_format:42,inner:[21,22,34,15,26,18,20],userkeywords_t:[6,22],shell:4,gear:[34,18],boston_address:22,"__del__":[7,15,19],pool_siz:[7,27],gotcha:33,shallow:[30,39],fetchmani:[15,37],specfic:15,userkeyword:[6,19],primary_el:31,essenti:[22,0,27,33,30,19,10],query_properti:33,exactli:[21,22,0,23,34,2,26,33,38,31,7,18],haven:18,book_excerpt:19,get_histori:[22,19,33],unmap:[21,19],prune:33,cpython:7,morph:18,nodes_1_parent_id:22,sqlsoup:[36,11,0,32,44],many_a:45,pyweboff:0,psycopg:[7,27],sens:[39,18,33,20],engineers_engineer_info:45,sensit:[39,26,37,30,31,10],before_flush:13,other:[0,1,2,4,6,7,9,10,11,13,14,15,18,19,20,21,22,23,24,25,26,27,33,29,30,31,34,37,38,39,41,45],misunderstand:20,result_processor:39,opensql:[18,45],"06migrat":5,plaintext:2,thereaft:34,arg:[21,22,1,39,2,25,15,26,27,33,30,4,31,41,7,8,19,20,13],generate_cont:33,corrupt:[39,1,37],lightli:19,disadvantag:4,close:[34,0,2,15,33,38,29,31,42,7,18,9,10],as_uuid:30,turn:[22,0,15,26,27,33,37,39,31,41,18],border:33,somealia:19,users_password:[34,0,20],smallest:2,min:26,diverg:37,rout:[36,44,20,27],accuraci:[39,37],mix:[1,15,41,42,18,45],builtin:[28,39,7,18,19,44],preced:[34,2,26,33,31,42,18],polymorphic_ident:[19,41,45],which:[0,1,2,4,5,6,7,8,9,10,11,13,15,18,19,20,21,22,23,25,26,27,33,29,30,31,32,34,37,38,39,41,42,43,45],mapperopt:[19,23,20],mit:14,singl:[0,1,2,4,6,7,44,13,15,18,19,20,21,22,23,25,26,27,33,30,31,34,35,36,41,42,45],uppercas:[2,30,4,37,42],make_transi:33,subtransact:33,myrelationshipcompar:19,msenum:2,mymappedcollect:1,subtyp:[39,45,23],oracl:[11,22,26,27,33,37,39,31,34,10,43,18,40,44],synonym_for:41,mutablejsonencodeddict:39,instancest:[19,33],eight:[2,31,27],"_adapt_express":39,why:[7,18,33],sc1modifi:23,marshal:39,placement:[22,34],latin1:[2,39,27],default_schema_nam:31,clauseel:[21,15,26,33,38,31,43,18,19],setlevel:[30,27],test_vers:23,face:5,native_enum:[30,39],keyword_id:[21,34,22,41,6,19],type_conv:29,find_docu:23,determin:[21,22,23,34,2,26,27,33,37,30,31,39,41,6,18,45],server_onupd:[31,19],occasion:[18,0,10,34],"32x":39,"_cach":0,wow:18,fact:[21,34,23,15,33,38,41,18,19],primary_key_from_inst:19,o56asktom:37,dba:18,frmo:26,verbos:[34,18],some_table_id:41,watch:[34,18],bring:18,elig:26,join1:0,join2:0,fear:18,sqlcompil:43,trivial:[0,1],identityset:34,shield:33,inlin:[22,26,31,10,19,20],locat:[21,34,23,26,33,31,18,9,45],launchpad:2,geoalchemi:23,much:[22,13,23,34,38,45,20,41,6,18,10],notsupportederror:9,practic:[33,45,1,20],mug:23,should:[0,1,2,5,13,15,18,19,20,21,22,25,26,27,33,30,31,37,38,39,40,41,42,43,45],jan:39,users_1_nam:34,won:[1,24,2,27,33,38,6,18,19,10],suppos:[18,0,45,20,34],"__tablename__":[22,23,34,33,41,19],"__get__":19,local:[22,0,1,23,39,36,15,31,33,37,30,4,41,42,19,44],hope:23,obj1:[6,33],count:[21,22,0,34,15,26,31,41,42,18,19],kinterbasdb:[29,27,44],move:[22,13,34,33,42,7,17],contribut:23,polymorphic_on:[21,19,41,45],notat:45,familiar:[34,18,27,41],mappedjoin:0,adalias_email_address:20,autom:[11,23,24,33,41,18],joint:31,bean:34,ix_mytable_col1:31,tbl:[30,31],with_ent:21,db1:33,db2:[27,33],endless:43,nextid:31,enabl:[21,22,1,34,2,15,26,27,33,37,30,4,5,31,44,39,42,7,18,20],organ:23,granular:33,upper:[31,18,23,10,41],lala:[15,33],y_2:18,y_1:18,include_collect:[13,33],stuff:19,compliment:39,instrumentationmanag:[13,23],contain:[21,22,18,13,23,24,15,26,40,33,39,31,34,45,41,6,7,8,19,20,1],view:[11,22,33,30,31,34,6,18,19],somemappedclass:[21,33],particp:39,legaci:33,users_user_nam:20,orphan:[21,22,0,1,34,33],qty:26,referred_t:31,temporarili:[33,24],dynamic_dict:23,bytestr:[39,4],"_dbproxi":7,email_address:[34,31,18,33,20],book_id:[0,19],identity_insert:4,polymorph:[21,23,36,44,41,19,45],statu:19,wire:[30,20],brokers_t:6,closet:21,mainli:34,boundari:[15,33],tend:15,written:[22,18,1,10],advdatamapping_entitycollect:24,version_id_gener:[19,41],crude:31,theta:10,neither:[18,19],sqlj_jdbc:37,email:[21,22,0,34,31,41,18,19,10],speed:5,"_compared_to_typ":26,addresses_email_address:[34,18,20],bound:[21,34,0,15,26,37,33,39,31,41,18,19,20],del_attribut:33,kei:[0,1,2,4,6,44,13,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,36,37,38,39,41,42,45],quote_plu:4,call_operation1:15,sprinkl:33,getset_factori:6,job:[31,15,1,33],entir:[21,34,18,1,15,27,33,37,39,4,31,7,8,19,45,13],state_gett:13,joe:0,checkfirst:[39,31],outer:[21,22,0,34,26,37,45,10,18,19,20],users_id:[34,18,20],jsonencodeddict:39,polymorphic_union:[19,41,45],plugin:13,admin:0,mediumint:2,fk_element_parent_node_id:31,lowercas:[27,37],etc:[21,34,8,24,2,38,26,27,33,37,39,31,41,43,18,19],"_compared_to_oper":26,instanc:[0,1,4,6,7,8,13,15,18,19,21,22,23,25,26,27,33,31,34,35,39,41,43,45],grain:[31,0],equat:[22,18,19],freeli:[41,33],get_table_nam:31,mstext:4,comment:31,unimpl:39,detachedinstanceerror:35,after_bulk_delet:[21,13],someothernam:18,guidelin:[11,43,0,28,44],schema_visitor:31,before_commit:13,distinguish:34,onupd:[6,22,31],myothermixin:41,respect:[30,4,18,41,42],unreferenc:33,quit:[6,31,1,45],evalu:[21,34,18,19,41],platform:[26,39,12,27,37],addition:[22,1,23,34,37,33,29,39,31,42,7,18],decent:31,anon_1_address_count:34,trademark:14,compos:[26,18,0,19,34],compon:[23,15,27,31,5,18,19,10],json:39,disableautoflush:33,slide_id:24,immedi:[22,0,1,34,15,26,33,29,30,31,39,41,6,7,19],referred_schema:31,partial:[22,27,33,30,31,19],mappedloan:0,"__table__":[34,19,41],msstring:4,bindparamclaus:26,resolve_synonym:19,assert:[21,33,19,1,23],x_2:18,togeth:[34,13,23,25,15,26,27,31,5,41,18,19,45],x_1:[43,18],orderitem:23,employees_t:45,present:[0,1,4,6,8,10,13,15,18,19,20,21,22,23,24,25,26,27,33,30,31,34,35,37,39,41,42,45],populate_exist:[21,19],replic:33,multi:[2,30,31,33,42],compile_mapp:19,somemapp:33,pjoin_manager_data:45,apppropri:39,contextu:[0,36,15,33,8,44],implic:[30,39],cursor:[21,38,15,26,31,28,37,29,30,4,5,44,39,42,7,18,9,10],uninstall_memb:13,singletonthreadpool:[7,27,42],p_union:19,"3dmydsn":4,dbapi2:42,f8s7cc:34,observ:[18,37],accompani:31,get_attribut:33,dsnname:[2,4],layer:[2,19,23,10],orderinglist:24,helper:[39,41,45,24],is_derived_from:26,almost:[22,31,1,24],demo:23,techspot:23,pip:[5,44],mildli:4,bigint:[2,30,4,31,39],dual:37,lightweight:[15,26,1],incom:[39,42,19,13,37],revis:31,unneed:1,wherea:[21,34,15,20,18,45],timestampmixin:41,halt:[22,19,13],nullpool:[7,15,27,42],uniti:31,mutat:[22,1,26,39,6,19],providesus:41,parti:[34,27,23],refetch:22,install_memb:13,highli:[19,33,10,41],cross:[34,43,20],member:[34,1,15,26,33,39,31,41,6,43],handl:[21,22,1,23,34,2,15,27,37,30,4,39,31,44,42,6,7,38,19,10,13],largest:7,keywordus:19,"__version__":[18,5,34],fetchon:[29,18,15,39],infer:34,raw_connect:15,difficult:18,obj2:[6,33],col5:31,slave:31,structur:[21,22,8,23,34,27,33,39,31,18,19,45],denot:[31,19,42],append_order_bi:26,expans:31,py3k:27,upon:[22,13,23,34,15,26,27,33,37,29,39,31,45,41,7,18,19,43,20],effect:[21,22,0,1,39,2,15,26,27,33,37,30,31,42,6,18,19,45,13],dai:[39,37,42],column_nam:31,sqalchemi:4,exot:22,student:0,xxg527:34,nation:2,distutil:5,expand:[18,26,1,45,27],audit:6,items_t:[1,33],nowait:26,add_neighbor:23,subtre:22,bulk:[21,1,13],well:[1,2,5,7,11,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,37,39,40,41,43,45],mysql_engin:[2,31,41],concis:0,passive_delet:[22,1,23],exampl:[0,1,2,4,5,6,7,44,11,13,15,18,19,20,21,22,23,24,25,26,27,33,31,34,36,37,38,39,41,45],command:[34,31,30,4,5,42,18],achiev:[22,15,33,31,5,7,19],choos:[21,39,18,1,13],parent_assoc:22,position:[31,1,27],backref:[22,1,34,33,41,6,45],latest:5,"_label":26,"transient":[21,22,19,33],users_nam:[18,0,20,34],obtain:14,detail:[22,0,1,34,2,15,26,27,33,29,30,4,39,31,6,7,18,19],expung:[22,0,33],current_timestamp:[31,18,26,42],virtual:[31,45,33],caveat:[31,33],heavili:18,shuttl:19,"__lt__":19,glue:1,runtimewarn:9,web:[7,0,33],superset:26,alia:[21,22,0,34,26,39,35,20,18,19,9,10],idiom:41,nullabl:[22,34,31,33,4,45,41,6,18,19,44],smith:23,before_upd:[21,13],parent_id:[22,1],add:[0,1,6,7,13,18,19,20,21,22,23,26,33,31,32,34,37,38,39,41,42,43,45],associationproxi:6,mysql_charset:2,weak_identity_map:33,ado:1,logger:[30,7,15,27],bindaparam:18,kick:[34,1],wont:33,jython:[2,27],rememb:1,"__delitem__":1,agnost:[39,31],replace_select:[18,26],five:[7,27,42],as_tupl:[30,39],substit:31,append_without_ev:33,nvl:43,recurs:[26,19,23],"_enable_transaction_account":33,desc:[18,0,26,41],loss:[39,37],resid:[25,19,31],like:[0,1,2,4,5,6,7,10,12,13,15,18,19,20,21,22,23,24,26,33,30,31,34,37,38,39,41,42,43,45],lost:[1,42],newvalue1:1,windowfunctionsbydefault:37,ix_myt:26,dbapierror:9,compile_my_constraint:43,necessari:[0,23,39,37,33,30,45,42,18,20],messi:18,myattrext:13,listen_for_ev:23,page:[2,44],weasel:23,unreach:1,didn:[21,18],prepend:[22,19],allow_partial_pk:19,setter:[6,19,41],"04d":42,datamapping_inherit:23,us_english:4,nodealia:22,contin:23,"export":26,reconstruct_inst:[19,13],flush:[22,0,1,23,34,36,33,39,35,19,44,13],proper:[22,24,26,37,33,27,45],home:27,librari:[34,37,1,4,33,27,39,31,19],mustard:0,typeengin:[39,2,15,26,31,37,30,4],lead:[21,19,1],interfaceerror:9,leak:2,avoid:[18,19,1,27],add_properti:19,overlap:[34,18],leav:[15,33,41,42,7,19,45],sequenc:[22,1,34,26,31,33,37,30,4,44,43,18,10],mydefault:31,distinctli:19,customer_id:19,versionedmeta:23,aliasnam:[26,19],encourag:0,slight:[30,7],inner_column:26,pg_constraint:31,include_column:[31,15],usag:[1,2,4,5,7,8,9,44,11,12,13,15,18,19,21,22,23,25,26,27,28,29,30,31,33,34,37,38,39,41,42,43,40],collector:29,docstr:[22,26,33],host:[12,2,3,27,37,29,30,4,42,7,18,9],isn:[21,34,1,33,39,45,41,18,10,13],although:[22,13,27,33,31,18,19,20],interdepend:33,java:37,stage:19,beaker:[33,36,44,23],about:[21,22,1,23,34,2,33,31,43,18,10,13],rare:[22,1,33,39,19,20],anon_1_email_address:34,column:[0,1,2,4,6,8,9,44,11,13,15,10,18,19,20,21,22,23,24,26,27,28,30,31,33,34,35,36,37,39,41,42,43,45],joinpoint:21,http:[12,23,14,39,2,3,27,33,37,30,4,5,42],email2:34,lifecycl:[31,33,38],constructor:[0,13,24,2,15,26,37,33,30,31,39,36,41,42,6,43,19,44],fals:[0,1,2,4,6,7,9,13,15,18,19,20,21,22,23,26,27,33,29,30,31,34,37,39,41,42,45],discard:[0,1,15,33,7,18,19],users_1_fullnam:34,disabl:[21,22,1,39,2,26,27,33,37,29,30,4,41,42,7,18],outset:45,mutabletyp:[30,39],postfetch_col:[31,15],easy_instal:5,automat:[0,1,2,5,6,7,10,11,15,18,19,20,21,22,23,24,26,27,33,29,30,31,34,39,41,42,43,45],dataset:[7,0],warranti:14,weather:23,hang:[29,0],transction:0,leverag:0,undef:19,"6beta2":34,"6beta3":20,val:31,safenumer:39,transfer:33,sql2005:4,appl:42,pool:[11,34,2,15,27,28,38,29,5,33,42,7,18,9,44],rudimentari:[34,19,23],arg1:41,arg2:41,jason:24,"function":[0,1,2,3,4,5,6,7,9,44,12,15,10,18,19,20,21,22,23,24,26,27,28,30,31,32,33,34,36,37,38,39,41,42,43,45],reduc:[22,34,37,33,39,30],"_warn_on_bytestr":[39,37],unexpect:[35,33],select_argu:26,brand:[31,33],keyerror:9,neutral:[18,26],bodi:34,gain:[18,33],halt_on:19,"_password":19,overflow:[7,19,27],highest:[34,19],eat:33,wherev:18,bue:31,addresses_id:[34,18,20],basicconfig:27,made:[34,13,24,26,31,33,39,4,6,7,18,19,43],history_meta:23,cleanup:42,hop:22,whether:[21,22,13,14,39,31,33,37,30,4,42,7,19],wish:[34,33,41,18,19,45],unload:[22,35,13,33],writeabl:1,ext_continu:13,create_d:31,mappedbook:0,record:[34,23,27,33,38,7,19],below:[22,23,34,2,15,27,33,37,39,4,5,31,45,41,7,18,19,43,20],listlik:1,ensur:[21,22,1,34,2,15,26,27,33,37,39,31,18,19],adalias1:34,myschemanam:0,setinputs:[39,37],otherwis:[1,2,5,6,7,9,13,14,15,18,19,21,22,26,27,33,31,37,39,41,42,45],problem:[2,45,1,33],propcompar:19,oldinit:13,"int":[2,26,37,33,39,31,42],dure:[21,22,35,13,2,15,26,37,33,39,31,6,43,19,9,1],filenam:[27,42],updated_at:[6,26],implement:[1,4,5,6,7,9,44,13,15,10,18,19,21,22,23,24,26,27,33,29,31,28,35,36,37,38,39,41,42,43],hit:18,ing:[21,18],keynam:[26,19],probabl:[21,22,23,34,15,29,39,31,10,42,43,19,20],sessioncontext:33,spell:[21,45],in_:[34,26,10],"2to3":5,"__set_composite_values__":19,set_committed_valu:33,add_listen:38,newvalue2:1,book:[0,19],bool:[39,31],futur:[22,13,34,2,25,26,27,33,30,31,39,20,7,19,10],branch:22,varieti:[23,15,26,27,33,39,31,5,32,41,19],belong:33,stat:26,repeat:[15,26,33,4,7,20],row_numb:[4,37],referenceaddressmixin:41,"_declarative_constructor":41,superclass:[26,19],unichar:12,raiseerr:19,singleton:[7,31],nodes_1_id:22,stai:[26,1],kw1:6,degrad:39,subqueryload:[21,34,20],reliabl:[21,39],highest_ord:19,rule:[22,0,1,39,26,28,30,31,33,43,18,19,44],message_nam:31,portion:[14,26,27,33,5,42,18,19,20],ajoin:45,"_connectionfairi":38,rootnod:23,getlogg:[30,27],tinyblob:2},objtypes:{"0":"py:module","1":"py:exception","2":"py:function","3":"py:method","4":"py:class","5":"py:attribute","6":"py:classmethod","7":"py:data","8":"py:staticmethod"},titles:["SqlSoup","Collection Configuration and Techniques","MySQL","Informix","Microsoft SQL Server","Overview","Association Proxy","Connection Pooling","Expression Serializer Extension","Core Exceptions","MaxDB","SQLAlchemy Documentation","Sybase","ORM Event Interfaces","Appendix:  Copyright","Working with Engines and Connections","Microsoft Access","<no title>","SQL Expression Language Tutorial","Mapper Configuration","Relationship Loading Techniques","Querying","Relationship Configuration","Examples","Ordering List","Horizontal Sharding","SQL Statements and Expressions","Engine Configuration","SQLAlchemy Core","Firebird","PostgreSQL","Schema Definition Language","ORM Extensions","Using the Session","Object Relational Tutorial","ORM Exceptions","SQLAlchemy ORM","Oracle","Core Event Interfaces","Column and Data Types","Dialects","Declarative","SQLite","Custom SQL Constructs and Compilation Extension","Table of Contents","Mapping Class Inheritance Hierarchies"],objnames:{"0":"Python module","1":"Python exception","2":"Python function","3":"Python method","4":"Python class","5":"Python attribute","6":"Python class method","7":"Python data","8":"Python static method"},filenames:["orm/extensions/sqlsoup","orm/collections","dialects/mysql","dialects/informix","dialects/mssql","intro","orm/extensions/associationproxy","core/pooling","core/serializer","core/exceptions","dialects/maxdb","index","dialects/sybase","orm/interfaces","copyright","core/connections","dialects/access","orm/deprecated","core/tutorial","orm/mapper_config","orm/loading","orm/query","orm/relationships","orm/examples","orm/extensions/orderinglist","orm/extensions/horizontal_shard","core/expression_api","core/engines","core/index","dialects/firebird","dialects/postgresql","core/schema","orm/extensions/index","orm/session","orm/tutorial","orm/exceptions","orm/index","dialects/oracle","core/interfaces","core/types","dialects/index","orm/extensions/declarative","dialects/sqlite","core/compiler","contents","orm/inheritance"]})