JezK
Edit File: searchindex.js
Search.setIndex({docnames:["api/autogenerate","api/commands","api/config","api/ddl","api/index","api/operations","api/overview","api/runtime","api/script","autogenerate","batch","branches","changelog","cookbook","front","index","naming","offline","ops","tutorial"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":5,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":3,"sphinx.domains.rst":2,"sphinx.domains.std":2,sphinx:56},filenames:["api/autogenerate.rst","api/commands.rst","api/config.rst","api/ddl.rst","api/index.rst","api/operations.rst","api/overview.rst","api/runtime.rst","api/script.rst","autogenerate.rst","batch.rst","branches.rst","changelog.rst","cookbook.rst","front.rst","index.rst","naming.rst","offline.rst","ops.rst","tutorial.rst"],objects:{"alembic.autogenerate":[[0,3,1,"","compare_metadata"],[0,3,1,"","produce_migrations"],[0,3,1,"","render_python_code"]],"alembic.autogenerate.api":[[0,0,1,"","AutogenContext"]],"alembic.autogenerate.api.AutogenContext":[[0,1,1,"","connection"],[0,1,1,"","dialect"],[0,1,1,"","imports"],[0,1,1,"","metadata"],[0,1,1,"","migration_context"],[0,2,1,"","run_filters"],[0,2,1,"","run_name_filters"],[0,2,1,"","run_object_filters"],[0,1,1,"","sorted_tables"],[0,1,1,"","table_key_to_table"]],"alembic.autogenerate.compare_metadata.params":[[0,4,1,"","context"],[0,4,1,"","metadata"]],"alembic.autogenerate.rewriter":[[0,0,1,"","Rewriter"]],"alembic.autogenerate.rewriter.Rewriter":[[0,2,1,"","chain"],[0,2,1,"","rewrites"]],"alembic.autogenerate.rewriter.Rewriter.chain.params":[[0,4,1,"","other"]],"alembic.command":[[1,3,1,"","branches"],[1,3,1,"","current"],[1,3,1,"","downgrade"],[1,3,1,"","edit"],[1,3,1,"","ensure_version"],[1,3,1,"","heads"],[1,3,1,"","history"],[1,3,1,"","init"],[1,3,1,"","list_templates"],[1,3,1,"","merge"],[1,3,1,"","revision"],[1,3,1,"","show"],[1,3,1,"","stamp"],[1,3,1,"","upgrade"]],"alembic.command.branches.params":[[1,4,1,"","config"],[1,4,1,"","verbose"]],"alembic.command.current.params":[[1,4,1,"","config"],[1,4,1,"","verbose"]],"alembic.command.downgrade.params":[[1,4,1,"","config"],[1,4,1,"","revision"],[1,4,1,"","sql"],[1,4,1,"","tag"]],"alembic.command.edit.params":[[1,4,1,"","config"],[1,4,1,"","rev"]],"alembic.command.ensure_version.params":[[1,4,1,"","config"],[1,4,1,"","sql"]],"alembic.command.heads.params":[[1,4,1,"","config"],[1,4,1,"","resolve_dependencies"],[1,4,1,"","verbose"]],"alembic.command.history.params":[[1,4,1,"","config"],[1,4,1,"","indicate_current"],[1,4,1,"","rev_range"],[1,4,1,"","verbose"]],"alembic.command.init.params":[[1,4,1,"","config"],[1,4,1,"","directory"],[1,4,1,"","package"],[1,4,1,"","template"]],"alembic.command.list_templates.params":[[1,4,1,"","config"]],"alembic.command.merge.params":[[1,4,1,"","branch_label"],[1,4,1,"","config"],[1,4,1,"","message"],[1,4,1,"","rev_id"]],"alembic.command.revision.params":[[1,4,1,"","autogenerate"],[1,4,1,"","branch_label"],[1,4,1,"","config"],[1,4,1,"","depends_on"],[1,4,1,"","head"],[1,4,1,"","message"],[1,4,1,"","process_revision_directives"],[1,4,1,"","rev_id"],[1,4,1,"","splice"],[1,4,1,"","sql"],[1,4,1,"","version_path"]],"alembic.command.show.params":[[1,4,1,"","config"],[1,4,1,"","revision"]],"alembic.command.stamp.params":[[1,4,1,"","config"],[1,4,1,"","purge"],[1,4,1,"","revision"],[1,4,1,"","sql"],[1,4,1,"","tag"]],"alembic.command.upgrade.params":[[1,4,1,"","config"],[1,4,1,"","revision"],[1,4,1,"","sql"],[1,4,1,"","tag"]],"alembic.config":[[2,0,1,"","Config"],[2,3,1,"","main"]],"alembic.config.Config":[[2,1,1,"","attributes"],[2,1,1,"","cmd_opts"],[2,1,1,"","config_file_name"],[2,1,1,"","config_ini_section"],[2,1,1,"","file_config"],[2,2,1,"","get_main_option"],[2,2,1,"","get_section"],[2,2,1,"","get_section_option"],[2,2,1,"","get_template_directory"],[2,2,1,"","print_stdout"],[2,2,1,"","set_main_option"],[2,2,1,"","set_section_option"]],"alembic.config.Config.params":[[2,4,1,"","attributes"],[2,4,1,"","config_args"],[2,4,1,"","file_"],[2,4,1,"","ini_section"],[2,4,1,"","output_buffer"],[2,4,1,"","stdout"]],"alembic.config.Config.set_main_option.params":[[2,4,1,"","name"],[2,4,1,"","value"]],"alembic.config.Config.set_section_option.params":[[2,4,1,"","name"],[2,4,1,"","section"],[2,4,1,"","value"]],"alembic.ddl":[[3,5,0,"-","base"],[3,5,0,"-","impl"],[3,5,0,"-","mssql"],[3,5,0,"-","mysql"],[3,5,0,"-","postgresql"],[3,5,0,"-","sqlite"]],"alembic.ddl.base":[[3,0,1,"","AddColumn"],[3,0,1,"","AlterColumn"],[3,0,1,"","AlterTable"],[3,0,1,"","ColumnComment"],[3,0,1,"","ColumnDefault"],[3,0,1,"","ColumnName"],[3,0,1,"","ColumnNullable"],[3,0,1,"","ColumnType"],[3,0,1,"","ComputedColumnDefault"],[3,0,1,"","DropColumn"],[3,0,1,"","IdentityColumnDefault"],[3,0,1,"","RenameTable"],[3,3,1,"","add_column"],[3,3,1,"","alter_column"],[3,3,1,"","alter_table"],[3,3,1,"","drop_column"],[3,3,1,"","format_column_name"],[3,3,1,"","format_server_default"],[3,3,1,"","format_table_name"],[3,3,1,"","format_type"],[3,3,1,"","quote_dotted"],[3,3,1,"","visit_add_column"],[3,3,1,"","visit_column_default"],[3,3,1,"","visit_column_name"],[3,3,1,"","visit_column_nullable"],[3,3,1,"","visit_column_type"],[3,3,1,"","visit_computed_column"],[3,3,1,"","visit_drop_column"],[3,3,1,"","visit_identity_column"],[3,3,1,"","visit_rename_table"]],"alembic.ddl.impl":[[3,0,1,"","DefaultImpl"],[3,0,1,"","ImplMeta"],[3,0,1,"","Params"]],"alembic.ddl.impl.DefaultImpl":[[3,2,1,"","add_column"],[3,2,1,"","add_constraint"],[3,2,1,"","alter_column"],[3,2,1,"","autogen_column_reflect"],[3,6,1,"","bind"],[3,2,1,"","bulk_insert"],[3,2,1,"","cast_for_batch_migrate"],[3,1,1,"","command_terminator"],[3,2,1,"","compare_server_default"],[3,2,1,"","compare_type"],[3,2,1,"","correct_for_autogen_constraints"],[3,2,1,"","correct_for_autogen_foreignkeys"],[3,2,1,"","create_column_comment"],[3,2,1,"","create_index"],[3,2,1,"","create_table"],[3,2,1,"","create_table_comment"],[3,2,1,"","drop_column"],[3,2,1,"","drop_constraint"],[3,2,1,"","drop_index"],[3,2,1,"","drop_table"],[3,2,1,"","drop_table_comment"],[3,2,1,"","emit_begin"],[3,2,1,"","emit_commit"],[3,2,1,"","execute"],[3,2,1,"","get_by_dialect"],[3,1,1,"","identity_attrs_ignore"],[3,2,1,"","prep_table_for_batch"],[3,2,1,"","rename_table"],[3,2,1,"","render_ddl_sql_expr"],[3,2,1,"","render_type"],[3,2,1,"","requires_recreate_in_batch"],[3,2,1,"","start_migrations"],[3,2,1,"","static_output"],[3,1,1,"","transactional_ddl"],[3,1,1,"","type_arg_extract"],[3,1,1,"","type_synonyms"]],"alembic.ddl.impl.Params":[[3,1,1,"","args"],[3,1,1,"","kwargs"],[3,1,1,"","token0"],[3,1,1,"","tokens"]],"alembic.ddl.mssql":[[3,0,1,"","MSSQLImpl"],[3,3,1,"","mssql_add_column"],[3,3,1,"","visit_add_column"],[3,3,1,"","visit_column_default"],[3,3,1,"","visit_column_nullable"],[3,3,1,"","visit_column_type"],[3,3,1,"","visit_rename_column"],[3,3,1,"","visit_rename_table"]],"alembic.ddl.mssql.MSSQLImpl":[[3,2,1,"","alter_column"],[3,1,1,"","batch_separator"],[3,2,1,"","bulk_insert"],[3,2,1,"","compare_server_default"],[3,2,1,"","create_index"],[3,2,1,"","drop_column"],[3,2,1,"","emit_begin"],[3,2,1,"","emit_commit"],[3,1,1,"","identity_attrs_ignore"],[3,1,1,"","memo"],[3,1,1,"","transactional_ddl"],[3,1,1,"","type_synonyms"]],"alembic.ddl.mysql":[[3,0,1,"","MariaDBImpl"],[3,0,1,"","MySQLAlterDefault"],[3,0,1,"","MySQLChangeColumn"],[3,0,1,"","MySQLImpl"],[3,0,1,"","MySQLModifyColumn"]],"alembic.ddl.mysql.MariaDBImpl":[[3,1,1,"","memo"]],"alembic.ddl.mysql.MySQLImpl":[[3,2,1,"","alter_column"],[3,2,1,"","compare_server_default"],[3,2,1,"","correct_for_autogen_constraints"],[3,2,1,"","correct_for_autogen_foreignkeys"],[3,2,1,"","drop_constraint"],[3,1,1,"","memo"],[3,1,1,"","transactional_ddl"],[3,1,1,"","type_arg_extract"],[3,1,1,"","type_synonyms"]],"alembic.ddl.postgresql":[[3,0,1,"","CreateExcludeConstraintOp"],[3,0,1,"","PostgresqlColumnType"],[3,0,1,"","PostgresqlImpl"],[3,3,1,"","visit_column_comment"],[3,3,1,"","visit_column_type"],[3,3,1,"","visit_identity_column"],[3,3,1,"","visit_rename_table"]],"alembic.ddl.postgresql.CreateExcludeConstraintOp":[[3,2,1,"","batch_create_exclude_constraint"],[3,1,1,"","constraint_type"],[3,2,1,"","create_exclude_constraint"],[3,2,1,"","from_constraint"],[3,2,1,"","to_constraint"]],"alembic.ddl.postgresql.PostgresqlImpl":[[3,2,1,"","alter_column"],[3,2,1,"","autogen_column_reflect"],[3,2,1,"","compare_server_default"],[3,2,1,"","correct_for_autogen_constraints"],[3,2,1,"","create_index"],[3,1,1,"","identity_attrs_ignore"],[3,1,1,"","memo"],[3,2,1,"","prep_table_for_batch"],[3,2,1,"","render_type"],[3,1,1,"","transactional_ddl"],[3,1,1,"","type_synonyms"]],"alembic.ddl.sqlite":[[3,0,1,"","SQLiteImpl"],[3,3,1,"","visit_rename_table"]],"alembic.ddl.sqlite.SQLiteImpl":[[3,2,1,"","add_constraint"],[3,2,1,"","autogen_column_reflect"],[3,2,1,"","cast_for_batch_migrate"],[3,2,1,"","compare_server_default"],[3,2,1,"","drop_constraint"],[3,1,1,"","memo"],[3,2,1,"","render_ddl_sql_expr"],[3,2,1,"","requires_recreate_in_batch"],[3,1,1,"","transactional_ddl"]],"alembic.operations":[[18,0,1,"","BatchOperations"],[18,0,1,"","Operations"],[5,5,0,"-","ops"]],"alembic.operations.BatchOperations":[[18,2,1,"","add_column"],[18,2,1,"","alter_column"],[18,2,1,"","create_check_constraint"],[18,2,1,"","create_exclude_constraint"],[18,2,1,"","create_foreign_key"],[18,2,1,"","create_index"],[18,2,1,"","create_primary_key"],[18,2,1,"","create_table_comment"],[18,2,1,"","create_unique_constraint"],[18,2,1,"","drop_column"],[18,2,1,"","drop_constraint"],[18,2,1,"","drop_index"],[18,2,1,"","drop_table_comment"]],"alembic.operations.BatchOperations.alter_column.params":[[18,4,1,"","insert_before"]],"alembic.operations.BatchOperations.create_table_comment.params":[[18,4,1,"","comment"],[18,4,1,"","existing_comment"]],"alembic.operations.BatchOperations.drop_table_comment.params":[[18,4,1,"","existing_comment"]],"alembic.operations.BatchOperations.params":[[18,4,1,"","migration_context"]],"alembic.operations.Operations":[[18,2,1,"","add_column"],[18,2,1,"","alter_column"],[18,2,1,"","batch_alter_table"],[18,2,1,"","bulk_insert"],[18,2,1,"","create_check_constraint"],[18,2,1,"","create_exclude_constraint"],[18,2,1,"","create_foreign_key"],[18,2,1,"","create_index"],[18,2,1,"","create_primary_key"],[18,2,1,"","create_table"],[18,2,1,"","create_table_comment"],[18,2,1,"","create_unique_constraint"],[18,2,1,"","drop_column"],[18,2,1,"","drop_constraint"],[18,2,1,"","drop_index"],[18,2,1,"","drop_table"],[18,2,1,"","drop_table_comment"],[18,2,1,"","execute"],[18,2,1,"","f"],[18,2,1,"","get_bind"],[18,2,1,"","get_context"],[18,2,1,"","implementation_for"],[18,2,1,"","inline_literal"],[18,2,1,"","invoke"],[18,2,1,"","register_operation"],[18,2,1,"","rename_table"]],"alembic.operations.Operations.add_column.params":[[18,4,1,"","column"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.alter_column.params":[[18,4,1,"","autoincrement"],[18,4,1,"","column_name"],[18,4,1,"","comment"],[18,4,1,"","existing_autoincrement"],[18,4,1,"","existing_comment"],[18,4,1,"","existing_nullable"],[18,4,1,"","existing_server_default"],[18,4,1,"","existing_type"],[18,4,1,"","new_column_name"],[18,4,1,"","nullable"],[18,4,1,"","postgresql_using"],[18,4,1,"","schema"],[18,4,1,"","server_default"],[18,4,1,"","table_name"],[18,4,1,"","type_"]],"alembic.operations.Operations.batch_alter_table.params":[[18,4,1,"","copy_from"],[18,4,1,"","naming_convention"],[18,4,1,"","partial_reordering"],[18,4,1,"","recreate"],[18,4,1,"","reflect_args"],[18,4,1,"","reflect_kwargs"],[18,4,1,"","schema"],[18,4,1,"","table_args"],[18,4,1,"","table_kwargs"],[18,4,1,"","table_name"]],"alembic.operations.Operations.bulk_insert.params":[[18,4,1,"","multiinsert"],[18,4,1,"","rows"],[18,4,1,"","table"]],"alembic.operations.Operations.create_check_constraint.params":[[18,4,1,"","condition"],[18,4,1,"","deferrable"],[18,4,1,"","initially"],[18,4,1,"","name"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.create_exclude_constraint.params":[[18,4,1,"","deferrable"],[18,4,1,"","elements"],[18,4,1,"","initially"],[18,4,1,"","name"],[18,4,1,"","schema"],[18,4,1,"","table_name"],[18,4,1,"","where"]],"alembic.operations.Operations.create_foreign_key.params":[[18,4,1,"","constraint_name"],[18,4,1,"","deferrable"],[18,4,1,"","local_cols"],[18,4,1,"","ondelete"],[18,4,1,"","onupdate"],[18,4,1,"","referent_schema"],[18,4,1,"","referent_table"],[18,4,1,"","remote_cols"],[18,4,1,"","source_schema"],[18,4,1,"","source_table"]],"alembic.operations.Operations.create_index.params":[[18,4,1,"","**kw"],[18,4,1,"","columns"],[18,4,1,"","index_name"],[18,4,1,"","quote"],[18,4,1,"","schema"],[18,4,1,"","table_name"],[18,4,1,"","unique"]],"alembic.operations.Operations.create_primary_key.params":[[18,4,1,"","columns"],[18,4,1,"","constraint_name"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.create_table.params":[[18,4,1,"","**kw"],[18,4,1,"","*columns"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.create_table_comment.params":[[18,4,1,"","comment"],[18,4,1,"","existing_comment"],[18,4,1,"","table_name"]],"alembic.operations.Operations.create_unique_constraint.params":[[18,4,1,"","columns"],[18,4,1,"","deferrable"],[18,4,1,"","initially"],[18,4,1,"","name"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.drop_column.params":[[18,4,1,"","column_name"],[18,4,1,"","mssql_drop_check"],[18,4,1,"","mssql_drop_default"],[18,4,1,"","mssql_drop_foreign_key"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.drop_constraint.params":[[18,4,1,"","constraint_name"],[18,4,1,"","schema"],[18,4,1,"","table_name"],[18,4,1,"","type_"]],"alembic.operations.Operations.drop_index.params":[[18,4,1,"","**kw"],[18,4,1,"","index_name"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.drop_table.params":[[18,4,1,"","**kw"],[18,4,1,"","schema"],[18,4,1,"","table_name"]],"alembic.operations.Operations.drop_table_comment.params":[[18,4,1,"","existing_comment"],[18,4,1,"","table_name"]],"alembic.operations.Operations.execute.params":[[18,4,1,"","execution_options"],[18,4,1,"","sqltext"]],"alembic.operations.Operations.inline_literal.params":[[18,4,1,"","type_"],[18,4,1,"","value"]],"alembic.operations.Operations.params":[[18,4,1,"","migration_context"]],"alembic.operations.Operations.rename_table.params":[[18,4,1,"","new_table_name"],[18,4,1,"","old_table_name"],[18,4,1,"","schema"]],"alembic.operations.ops":[[5,0,1,"","AddColumnOp"],[5,0,1,"","AddConstraintOp"],[5,0,1,"","AlterColumnOp"],[5,0,1,"","AlterTableOp"],[5,0,1,"","BulkInsertOp"],[5,0,1,"","CreateCheckConstraintOp"],[5,0,1,"","CreateForeignKeyOp"],[5,0,1,"","CreateIndexOp"],[5,0,1,"","CreatePrimaryKeyOp"],[5,0,1,"","CreateTableCommentOp"],[5,0,1,"","CreateTableOp"],[5,0,1,"","CreateUniqueConstraintOp"],[5,0,1,"","DowngradeOps"],[5,0,1,"","DropColumnOp"],[5,0,1,"","DropConstraintOp"],[5,0,1,"","DropIndexOp"],[5,0,1,"","DropTableCommentOp"],[5,0,1,"","DropTableOp"],[5,0,1,"","ExecuteSQLOp"],[5,0,1,"","MigrateOperation"],[5,0,1,"","MigrationScript"],[5,0,1,"","ModifyTableOps"],[5,0,1,"","OpContainer"],[5,0,1,"","RenameTableOp"],[5,0,1,"","UpgradeOps"]],"alembic.operations.ops.AddColumnOp":[[5,2,1,"","add_column"],[5,2,1,"","batch_add_column"]],"alembic.operations.ops.AlterColumnOp":[[5,2,1,"","alter_column"],[5,2,1,"","batch_alter_column"]],"alembic.operations.ops.BulkInsertOp":[[5,2,1,"","bulk_insert"]],"alembic.operations.ops.CreateCheckConstraintOp":[[5,2,1,"","batch_create_check_constraint"],[5,2,1,"","create_check_constraint"]],"alembic.operations.ops.CreateForeignKeyOp":[[5,2,1,"","batch_create_foreign_key"],[5,2,1,"","create_foreign_key"]],"alembic.operations.ops.CreateIndexOp":[[5,2,1,"","batch_create_index"],[5,2,1,"","create_index"]],"alembic.operations.ops.CreatePrimaryKeyOp":[[5,2,1,"","batch_create_primary_key"],[5,2,1,"","create_primary_key"]],"alembic.operations.ops.CreateTableCommentOp":[[5,2,1,"","batch_create_table_comment"],[5,2,1,"","create_table_comment"],[5,2,1,"","reverse"]],"alembic.operations.ops.CreateTableOp":[[5,2,1,"","create_table"]],"alembic.operations.ops.CreateUniqueConstraintOp":[[5,2,1,"","batch_create_unique_constraint"],[5,2,1,"","create_unique_constraint"]],"alembic.operations.ops.DropColumnOp":[[5,2,1,"","batch_drop_column"],[5,2,1,"","drop_column"]],"alembic.operations.ops.DropConstraintOp":[[5,2,1,"","batch_drop_constraint"],[5,2,1,"","drop_constraint"]],"alembic.operations.ops.DropIndexOp":[[5,2,1,"","batch_drop_index"],[5,2,1,"","drop_index"]],"alembic.operations.ops.DropTableCommentOp":[[5,2,1,"","batch_drop_table_comment"],[5,2,1,"","drop_table_comment"],[5,2,1,"","reverse"]],"alembic.operations.ops.DropTableOp":[[5,2,1,"","drop_table"]],"alembic.operations.ops.ExecuteSQLOp":[[5,2,1,"","execute"]],"alembic.operations.ops.MigrateOperation":[[5,1,1,"","info"]],"alembic.operations.ops.MigrationScript":[[5,6,1,"","downgrade_ops"],[5,6,1,"","downgrade_ops_list"],[5,6,1,"","upgrade_ops"],[5,6,1,"","upgrade_ops_list"]],"alembic.operations.ops.RenameTableOp":[[5,2,1,"","rename_table"]],"alembic.runtime":[[7,5,0,"-","environment"],[7,5,0,"-","migration"]],"alembic.runtime.environment":[[7,0,1,"","EnvironmentContext"]],"alembic.runtime.environment.EnvironmentContext":[[7,2,1,"","begin_transaction"],[7,1,1,"","config"],[7,2,1,"","configure"],[7,2,1,"","execute"],[7,2,1,"","get_bind"],[7,2,1,"","get_context"],[7,2,1,"","get_head_revision"],[7,2,1,"","get_head_revisions"],[7,2,1,"","get_revision_argument"],[7,2,1,"","get_starting_revision_argument"],[7,2,1,"","get_tag_argument"],[7,2,1,"","get_x_argument"],[7,2,1,"","is_offline_mode"],[7,2,1,"","is_transactional_ddl"],[7,2,1,"","run_migrations"],[7,1,1,"","script"],[7,2,1,"","static_output"]],"alembic.runtime.environment.EnvironmentContext.configure.params":[[7,4,1,"","alembic_module_prefix"],[7,4,1,"","compare_server_default"],[7,4,1,"","compare_type"],[7,4,1,"","connection"],[7,4,1,"","dialect_name"],[7,4,1,"","dialect_opts"],[7,4,1,"","downgrade_token"],[7,4,1,"","include_name"],[7,4,1,"","include_object"],[7,4,1,"","include_schemas"],[7,4,1,"","literal_binds"],[7,4,1,"","mssql_batch_separator"],[7,4,1,"","on_version_apply"],[7,4,1,"","oracle_batch_separator"],[7,4,1,"","output_buffer"],[7,4,1,"","output_encoding"],[7,4,1,"","process_revision_directives"],[7,4,1,"","render_as_batch"],[7,4,1,"","render_item"],[7,4,1,"","sqlalchemy_module_prefix"],[7,4,1,"","starting_rev"],[7,4,1,"","tag"],[7,4,1,"","target_metadata"],[7,4,1,"","template_args"],[7,4,1,"","transaction_per_migration"],[7,4,1,"","transactional_ddl"],[7,4,1,"","upgrade_token"],[7,4,1,"","url"],[7,4,1,"","user_module_prefix"],[7,4,1,"","version_table"],[7,4,1,"","version_table_pk"],[7,4,1,"","version_table_schema"]],"alembic.runtime.environment.EnvironmentContext.params":[[7,4,1,"","**kw"],[7,4,1,"","config"],[7,4,1,"","script"]],"alembic.runtime.migration":[[7,0,1,"","MigrationContext"]],"alembic.runtime.migration.MigrationContext":[[7,2,1,"","autocommit_block"],[7,2,1,"","begin_transaction"],[7,6,1,"","bind"],[7,6,1,"","config"],[7,2,1,"","configure"],[7,2,1,"","execute"],[7,2,1,"","get_current_heads"],[7,2,1,"","get_current_revision"],[7,2,1,"","run_migrations"],[7,2,1,"","stamp"]],"alembic.runtime.migration.MigrationContext.configure.params":[[7,4,1,"","connection"],[7,4,1,"","dialect_name"],[7,4,1,"","opts"],[7,4,1,"","url"]],"alembic.runtime.migration.MigrationContext.run_migrations.params":[[7,4,1,"","**kw"]],"alembic.script":[[8,0,1,"","Script"],[8,0,1,"","ScriptDirectory"],[8,5,0,"-","revision"],[8,5,0,"-","write_hooks"]],"alembic.script.Script":[[8,6,1,"","doc"],[8,6,1,"","longdoc"],[8,1,1,"","module"],[8,1,1,"","path"]],"alembic.script.ScriptDirectory":[[8,2,1,"","as_revision_number"],[8,2,1,"","from_config"],[8,2,1,"","generate_revision"],[8,2,1,"","get_base"],[8,2,1,"","get_bases"],[8,2,1,"","get_current_head"],[8,2,1,"","get_heads"],[8,2,1,"","get_revision"],[8,2,1,"","get_revisions"],[8,2,1,"","iterate_revisions"],[8,2,1,"","run_env"],[8,2,1,"","walk_revisions"]],"alembic.script.ScriptDirectory.generate_revision.params":[[8,4,1,"","head"],[8,4,1,"","message"],[8,4,1,"","refresh"],[8,4,1,"","revid"],[8,4,1,"","splice"]],"alembic.script.ScriptDirectory.walk_revisions.params":[[8,4,1,"","base"],[8,4,1,"","head"]],"alembic.script.revision":[[8,7,1,"","CycleDetected"],[8,7,1,"","DependencyCycleDetected"],[8,7,1,"","DependencyLoopDetected"],[8,7,1,"","LoopDetected"],[8,7,1,"","MultipleHeads"],[8,7,1,"","RangeNotAncestorError"],[8,7,1,"","ResolutionError"],[8,0,1,"","Revision"],[8,7,1,"","RevisionError"],[8,0,1,"","RevisionMap"]],"alembic.script.revision.Revision":[[8,1,1,"","branch_labels"],[8,1,1,"","dependencies"],[8,1,1,"","down_revision"],[8,6,1,"","is_base"],[8,6,1,"","is_branch_point"],[8,6,1,"","is_head"],[8,6,1,"","is_merge_point"],[8,1,1,"","nextrev"],[8,1,1,"","revision"]],"alembic.script.revision.RevisionMap":[[8,2,1,"","add_revision"],[8,1,1,"","bases"],[8,2,1,"","get_current_head"],[8,2,1,"","get_revision"],[8,2,1,"","get_revisions"],[8,1,1,"","heads"],[8,2,1,"","iterate_revisions"]],"alembic.script.revision.RevisionMap.get_current_head.params":[[8,4,1,"","branch_label"]],"alembic.script.revision.RevisionMap.params":[[8,4,1,"","generator"]],"alembic.script.write_hooks":[[8,3,1,"","register"]],alembic:[[1,5,0,"-","command"],[2,5,0,"-","config"],[3,5,0,"-","ddl"],[18,5,0,"-","operations"],[8,5,0,"-","script"]]},objnames:{"0":["py","class","Python class"],"1":["py","attribute","Python attribute"],"2":["py","method","Python method"],"3":["py","function","Python function"],"4":["py","parameter","Python parameter"],"5":["py","module","Python module"],"6":["py","property","Python property"],"7":["py","exception","Python exception"]},objtypes:{"0":"py:class","1":"py:attribute","2":"py:method","3":"py:function","4":"py:parameter","5":"py:module","6":"py:property","7":"py:exception"},terms:{"0":[0,3,7,8,9,10,11,13,14,15,16,18,19],"01":12,"02":[11,12,19],"03":[11,13],"04":[12,13],"05":[12,13,18],"07":[12,13],"08":[9,12,18,19],"089406":[9,19],"1":[1,3,7,8,9,10,11,13,14,15,16,18,19],"10":[15,16,18],"100":13,"1001":13,"1002":13,"1004":12,"101":12,"1021":12,"1025":12,"1026":12,"1027":12,"103":12,"1034":12,"1037":12,"104":12,"1065":12,"107":12,"108":12,"109":12,"109e":11,"109ec7d132bf":11,"109ec7d132bf_add_ip_number_t":11,"10g":16,"11":[3,9,11,13,15,19],"110":12,"112":12,"115":12,"12":[7,12,19],"120":12,"123":12,"124":12,"125":12,"13":[11,12,19],"131":12,"135":12,"137":12,"14":12,"145":12,"15":[12,18],"152":12,"157":12,"16":[12,13],"160":12,"163":12,"164":12,"167":12,"168":12,"1684":12,"17":12,"170":12,"171":12,"172":12,"174":12,"175":12,"178":12,"179":12,"18":[12,13],"183":12,"185":12,"186":12,"19":12,"190":12,"191a2d20b025":13,"194":12,"195":12,"196":12,"197":12,"1975":[11,19],"1975ea83b712":[11,17,19],"1975ea83b712_add_account_t":[11,19],"1975ea83b712_create_accoun":19,"1975ea83b712_create_account_t":19,"199":12,"199028bf9856":13,"2":[0,1,3,7,8,9,11,13,14,15,16,18,19],"20":[0,11,12,13,19],"200":[9,12,17,18,19],"2000":13,"2007":18,"2008":18,"201":12,"2010":18,"2011":[9,12,19],"2012":12,"2013":12,"2014":[11,12,13,19],"2015":[12,13],"2016":12,"2017":12,"2018":12,"2019":12,"202":12,"2020":12,"2021":12,"2022":12,"203":12,"205":12,"208":12,"209":12,"21":12,"212":12,"219":12,"22":[12,13],"222":12,"229":12,"23":12,"230":12,"234":12,"24":[12,13],"240":12,"241":12,"243":12,"245":12,"2461":12,"247":12,"248":12,"249":12,"25":[12,13],"251":12,"253":12,"254":12,"255":[12,13],"257104":[11,19],"258":12,"259":12,"26":[12,13],"260":12,"261":12,"266":12,"267":12,"269":12,"27":[9,12,13,18,19],"276":12,"277326":13,"27c":11,"27c6":11,"27c6a":11,"27c6a30d7c24":[9,11],"27c6a30d7c24_add_shopping_cart_t":11,"28":12,"282":12,"284":12,"287":12,"289":12,"28af9800143":13,"28af9800143f":13,"29":12,"290696571ad2":13,"292":12,"296":12,"297":12,"298":12,"29f8":11,"29f859a13ea":11,"2a95":11,"2a95102259b":11,"2a95102259be_add_ip_account_t":11,"2b1ae634e5cd_add_order_id":19,"2d":19,"2d_":19,"2to3":12,"3":[3,10,13,14,15,16,18,19],"30":12,"300":12,"301":12,"302":12,"3023":12,"305":12,"306":12,"307":12,"31":[11,12,13],"310":12,"311":12,"314":12,"3147":12,"315":12,"317":12,"318":12,"32":[12,17],"321":12,"324":12,"33":12,"332":12,"333":12,"335":12,"336":12,"337":12,"338":12,"34":12,"341":12,"344504":13,"345":12,"34e094ad6ef1":11,"34e094ad6ef1_more_account_chang":11,"35":12,"3512b954651e_add_account":19,"354":12,"355":12,"356":12,"36":[13,19],"361":12,"365":12,"367":12,"369":12,"37":19,"377":12,"378":12,"3782":11,"379":12,"38":12,"391":12,"392":12,"393":12,"395":12,"3ab8b2dfb055":13,"3adcc9a56557_rename_username_field":19,"3ba2b522d10d":13,"3cac04ae8714":11,"3cac04ae8714_create_networking_branch":11,"3rd":12,"3x":12,"4":[9,10,13,15,16,18],"40":[8,9,12,19],"402":12,"406":12,"41":12,"411":12,"412":12,"413":12,"417":12,"419":12,"421":12,"422":12,"424":12,"425":12,"429":12,"43":12,"431":12,"433":12,"436407":11,"44":[12,13],"441":12,"442":12,"447":12,"449":12,"455":12,"456":12,"457":12,"458":12,"46":[11,19],"461":12,"463":12,"464":12,"468":12,"472":12,"473":12,"478":12,"479":12,"480":12,"481":12,"481b13bc369a_rev1":9,"482":12,"483":12,"484":12,"487":12,"49":12,"491":12,"494":12,"497":12,"5":[7,9,10,13,14,15,18,19],"50":[0,9,10,11,13,16,17,18,19],"502":12,"505":12,"507":12,"512":12,"513":12,"515":12,"516":12,"518":12,"528":12,"529":12,"534":12,"53fffde5ad5":11,"53fffde5ad5_merge_ae1_and_27c":11,"54":[11,19],"541":12,"548":12,"549":12,"55":12,"550":12,"551":12,"552":12,"553":12,"5534":12,"554":12,"55af":11,"55af2cb":11,"55af2cb1c267":11,"55af2cb1c267_add_another_account_column":11,"5618":12,"562":12,"563":12,"564":12,"571":12,"579":12,"58":12,"589867":13,"59":[12,13],"592":12,"594":12,"5s":19,"6":[1,14,15,16,18],"601":12,"605":12,"608":12,"62":12,"621":12,"624":12,"63":12,"635":12,"637":12,"64":12,"640":12,"647":12,"648":12,"650":12,"654":12,"655":12,"66":12,"661":12,"663":12,"668":12,"669":12,"670":12,"671":12,"674":12,"694":12,"697":12,"7":[1,10,11,14,15],"70":12,"71":12,"711":12,"714947":19,"716":12,"72":12,"721":12,"73":12,"730":12,"736":12,"748":12,"753":[12,13],"757":12,"76":12,"761":12,"764":12,"765":12,"77":12,"773":12,"780":12,"782":12,"784":12,"786":12,"787":12,"788":12,"789":12,"79":[9,19],"797":12,"799":12,"8":[2,7,8,13,14,15,18,19],"803":12,"81":12,"811663":11,"812":12,"813":12,"816":12,"819":12,"822":12,"827":12,"829":12,"838":12,"839":12,"842":12,"843":12,"844":12,"848":12,"849":12,"849677":[11,19],"85":12,"855":12,"856":12,"874":12,"879":12,"883":12,"884":12,"885":12,"893":12,"895":12,"896":12,"897":12,"9":[10,15,16,18],"90":12,"900":12,"914":12,"918507":13,"92":12,"920":12,"93":12,"934":12,"94":12,"944":12,"95":12,"96":12,"964":12,"968":12,"977":12,"98":12,"982":12,"986":12,"987":12,"99":12,"992867":13,"\u0142ukasz":12,"abstract":12,"bo\u0142di":12,"boolean":[7,9,12,15,16,18],"break":[11,12,18],"byte":12,"case":[0,1,2,5,7,8,9,10,11,12,13,16,18,19],"catch":12,"char":9,"class":[0,1,2,3,4,5,6,7,8,9,12,13,17,18,19],"const":3,"default":[0,2,3,5,7,8,9,10,11,12,13,14,16,17,18,19],"do":[0,6,7,9,10,11,12,13,16,18,19],"enum":[9,12,15,18],"final":[7,10,12,13,14],"float":[3,12],"function":[1,2,3,4,5,6,7,8,11,12,13,15,16,17,18,19],"import":[0,1,2,5,7,8,9,10,11,12,13,15,17,18,19],"int":[8,12,13,18],"long":[9,10,11,12,13,14,19],"new":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,16,18,19],"null":[0,10,12,13,17,18],"public":[0,4,8,12,13,18],"ram\u00edrez":12,"return":[0,2,3,5,7,8,9,10,12,13,18],"sebasti\u00e1n":12,"short":[7,9,12],"static":12,"switch":[12,13],"true":[0,1,3,5,7,8,9,10,12,13,16,18,19],"try":[11,12,13,17],"while":[0,3,8,9,10,11,12,13,14,16,17,18,19],A:[0,2,3,5,6,7,8,9,10,11,12,13,17,18,19],AND:[9,16],AS:[12,13],ASE:12,As:[4,7,9,10,11,12,14,16,19],At:[7,11,12,16,18,19],But:16,By:[0,7,9,12],For:[0,1,2,3,5,7,9,10,11,12,13,16,17,18,19],IF:13,INTO:[10,11,13,17,18],If:[0,5,7,8,9,10,11,12,13,14,16,18,19],In:[0,1,5,6,7,8,9,10,11,12,13,18,19],It:[1,6,7,8,9,10,11,12,13,16,17,18,19],NO:12,NOT:[10,12,13,17,18],ON:[5,12,13,16,18],On:[10,12],One:[13,17],Or:[11,12,13,16,18],TO:[10,12],That:[7,11,13],The:[0,1,2,3,4,5,6,8,9,10,11,12,14,15,17,18],Then:[13,14],There:[10,13,14,16,18],These:[0,3,5,7,8,9,11,12,19],To:[1,7,9,10,11,12,13,14,18,19],Tos:13,Will:[7,11,13,17,19],With:[2,5,11,12,15,19],_:[3,12,18],__doc__:12,__file__:12,__future__:12,__init__:[1,5,12,13],__main__:12,__module__:[7,9,12],__pycache__:12,__repr__:9,__table_args__:13,__tablename__:13,_alembic_batch_temp:[10,12],_collect:2,_constraints_includ:5,_copi:12,_exec:12,_filter_drop_index:13,_get_object_from_vers:13,_immutabledict_py_fallback:2,_io:2,_literal_bindparam:18,_namespace_metadata:5,_orig_constraint:3,_per_migr:7,_proxytransact:7,_replac:8,_revers:5,_revisionorbas:8,_serverdefault:3,a1:18,a2:18,abc:12,abil:[0,10,19],abl:[0,4,8,13,16],about:[0,7,11,12,14,16,19],abov:[0,5,7,9,10,11,12,13,14,16,18,19],abramowitz:12,absenc:[10,12,17],absolut:[12,19],accept:[1,7,9,10,12,13,17,18,19],access:[0,2,5,6,7,8,9,10,12,13,14,17,19],accessor:12,accommod:[9,10,12,13],accompani:[12,18],accomplish:17,accord:[12,18],account:[3,9,11,12,17,18,19],account_id:18,account_t:18,accounts_t:18,accur:9,accuraci:7,achiev:[1,9,11,12,13],acquir:19,across:[0,1,2,7,9,10,11,12,15,18],act:[7,12,13,18],action:[12,13,18],activ:[14,19],actual:[0,2,5,6,7,8,9,10,11,12,13,17,18],acycl:11,ad:[0,2,7,8,9,11,12,13,16,18,19],adapt:[12,13],add:[0,5,7,8,9,10,11,12,13,14,16,17,18,19],add_column:[0,3,5,9,10,12,13,16,18,19],add_column_idx:0,add_column_nul:0,add_constraint:3,add_customer_sp:13,add_index:12,add_revis:8,add_sequence_to_model:0,add_tabl:0,addcolumn:[0,3],addcolumnop:[0,5],addconstraint:18,addconstraintop:[3,5],addiion:12,addit:[0,2,7,8,9,11,12,13,14,18,19],addition:[5,9,12,18],address:[10,18],adequ:13,adjust:[0,9,10,12,13],adopt:12,advanc:18,advantag:[11,13],ae1027:[11,19],ae1027a6acf:[11,17,19],ae1027a6acf_add_a_column:[11,19],ae102:11,ae10:[11,12,19],ae1:[11,19],affect:[0,7,10,11,12,13,15],affin:12,after:[0,7,11,12,13,18,19],after_cr:12,after_drop:12,after_parent_attach:[9,16],afterward:[10,12],again:[0,9,10,11,12,13,16,19],against:[0,2,5,7,8,9,10,11,12,13,17,18,19],aggreg:0,agnost:12,ago:19,ahead:12,aim:0,aiosqlit:13,albeit:19,albert:12,alemb:[0,1,2,3,4,5,6,7,8,9,10,11,12,14,16,17,18,19],alembic_cfg:[1,2,13],alembic_config:[12,19],alembic_module_prefix:[0,7,12],alembic_revis:12,alembic_util:13,alembic_vers:[7,11,12,13,17,19],alexand:12,algorithm:[11,12],alia:[3,11],all:[0,1,2,5,6,7,8,9,10,12,13,14,15,16,17,18,19],all_conn_sequ:0,all_constraint:16,allow:[0,2,3,5,7,8,9,10,11,12,13,14,17,18,19],almo:12,almost:[10,12],alon:[10,11,12],along:[0,1,5,7,10,11,12,13,18,19],alongsid:12,alpha:12,alphabet:12,alphanumer:16,alreadi:[0,1,2,3,9,10,11,12,13,16,18],also:[0,2,5,6,7,8,9,10,11,12,13,14,16,17,18,19],alter:[0,1,3,5,6,7,9,10,11,12,13,16,17,18,19],alter_column:[3,5,7,10,12,18],alter_column_op:0,alter_t:3,altercolumn:3,altercolumnop:[0,5,12],altern:[0,7,9,10,11,12,18],altert:3,altertableop:5,altogeth:13,alwai:[0,5,9,10,11,12,13,17,18],ambigu:12,among:[11,12],an:[0,1,2,3,5,6,7,8,9,10,11,12,15,16,18],analyz:9,ancestor:[11,12],andrea:12,andrei:12,ani:[0,1,2,3,5,7,8,9,10,11,12,14,15,16,17,18,19],ann:12,annot:12,anonym:[9,18],anoth:[0,2,6,9,10,11,12,13,19],anscestor:11,anticip:12,antti:12,antukh:12,anyth:[0,2,12,18,19],anywai:[12,19],anywher:13,api:[0,1,2,3,5,6,7,12,15,18],appar:12,appear:[12,18],appeas:12,append:[0,9,12],append_column:12,append_constraint:12,appli:[0,1,5,7,8,10,11,12,15,16,18,19],applic:[1,4,6,7,9,10,11,12,13,16,18,19],applybatchimpl:3,approach:[0,10,12,13,14,19],appropri:[0,6,7,8,9,11,12,14,16,18,19],apr:12,april:12,ar:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18,19],arbitrari:[1,2,5,9,12],architectur:[10,12],area:[0,9,19],aren:[9,10,11,12,18],arg:[2,3,8,12,19],argnam:18,argpars:[2,7,12,19],argument:[0,1,2,5,7,8,9,10,11,12,13,18,19],argv:2,aris:[10,12],arithmet:12,aros:12,around:[7,12,13],arrai:12,as_dictionari:[7,13],as_revision_numb:[8,12],as_sql:[3,7],asc:12,ascend:19,ascii:12,ash:12,ask:[11,12],aspect:[7,12,13,18],assert:12,assert_relative_length:8,assign:[10,11,13,16],assist:[7,8,12,13],associ:[0,10,11,12,13,16,18],assort:12,assum:[0,9,10,11,12,13,14,16,17,19],astext_typ:12,astimezon:19,async:[12,13,19],async_engin:13,async_engine_from_config:13,asyncio:15,asyncpg:13,atsushi:12,attach:[0,3,9,12,13],attempt:[9,10,11,12,13,18,19],attribut:[0,1,2,5,7,10,11,12,13],attributeerror:12,aug:12,august:12,author:[9,12],auto:[0,7,10,12,13,15,18,19],auto_incr:[12,18],autocommit:[7,12],autocommit_block:[7,12],autodetect:12,autogen:[7,12],autogen_column_reflect:3,autogen_context:[0,3,7,9],autogencontext:[0,3,9,12],autogener:[1,3,4,5,6,7,12,15,18,19],autogenrendertest:12,autoincr:[3,12,13,18],autoload:[10,13],autoload_with:13,autom:[10,12,13,16,18],automat:[9,10,11,12,18,19],autopep8:[9,12],avail:[0,1,2,5,7,9,12,13,14,18,19],aviskar:12,avoid:[0,12,18],awai:0,await:13,awkward:12,axel:12,b:[10,13,18],back:[0,7,8,9,11,12,13,19],backend:[0,3,6,7,9,10,12,16,18],background:9,backslash:18,backward:[7,12],bad:9,badli:12,bagnoli:12,bar:[0,2,10,13,18,19],bartosz:12,base:[0,2,3,5,6,7,8,12,13,15,16,17,18,19],basemost:11,basi:[5,8,9,12],basic:[0,2,8,11,12,13,15,17,18,19],bat:[0,13,19],batch:[3,5,7,12,13,15,18],batch_add_column:5,batch_alter_column:5,batch_alter_t:[7,10,12,13,18],batch_create_check_constraint:[5,12],batch_create_exclude_constraint:3,batch_create_foreign_kei:[5,12],batch_create_index:5,batch_create_primary_kei:5,batch_create_table_com:5,batch_create_unique_constraint:[5,12],batch_drop_column:5,batch_drop_constraint:5,batch_drop_index:[5,12],batch_drop_table_com:5,batch_impl:3,batch_op:[3,10,12,13,18],batch_separ:3,batchoper:[3,5,10,12,18],batchoperationsimpl:[3,18],bayer:14,beafc7d709f:0,becaus:[0,9,10,11,12],bechtold:12,becom:[11,13],becott:12,been:[6,7,9,11,12,13,14,16,18,19],befor:[1,2,3,7,10,11,12,13,18,19],before_cr:12,before_drop:12,began:[11,12],begin:[0,1,2,3,7,10,12,13,17,18,19],begin_transact:[0,3,7,9,12,13],behav:10,behavior:[0,3,5,6,7,9,10,12,18,19],behind:[12,16],being:[0,1,2,4,7,8,9,10,11,12,13,14,16,18],belong:[10,12],below:[0,5,8,9,10,12,13,14,17,18,19],berlin:12,besid:11,best:[9,11,16,18],beta:12,better:[12,16],between:[0,3,7,9,10,11,12,13,19],beyond:[9,12,16],bflag:10,bi:12,big:12,bigint:[9,12],biginteg:12,bigseri:12,bin:[14,19],binaryexpress:[3,5,18],bind:[0,3,7,18],binet:12,bit:[7,12,13],black:[9,12,19],blank:[0,12,13,19],block:[7,10,12,18],blown:[7,12],blume:12,board:10,bog:12,boilerpl:0,bolt:7,bool:[0,1,3,5,7,8,13,18],bootstrap:[12,13],both:[9,11,12,13,16,17,18],bottom:17,bound:[7,12,18],bowli:12,box:6,brackin:12,branch:[0,1,7,8,12,13,15,19],branch_label:[1,5,8,11,13,19],branchnam:11,branchpoint:[8,11,12],brief:18,bring:11,broken:[12,17],brokenpipeerror:12,bronson:12,bruno:12,brycelohr:12,buffer:[2,7],bug:[3,15,19],bugtrack:12,build:[0,1,3,5,9,11,12,14,15,19],built:[0,1,4,6,9,12,13,15],bulk:[3,5,12,18],bulk_insert:[3,5,12,13,18],bulkinsertop:5,bump:12,bundl:12,burclaf:12,bypass:[10,18],c:[0,10,12,13,16,18],cach:[3,12],caio:12,calcul:[7,12,19],call:[1,2,3,5,6,7,8,9,10,11,12,13,16,18,19],callabl:[0,1,7,8,9,12,18],callback:[7,12],can:[0,1,2,3,4,5,7,8,9,10,11,12,13,14,16,17,18,19],candid:[7,9,12],caniart:12,cannot:[7,9,10,11,12,18],capabl:[0,1,2,5,6,7,10,12,13,17,19],care:0,carefulli:[11,19],carlo:12,cart:11,carvalho:12,cascad:[13,18],caselli:12,cast:[3,12],cast_for_batch_migr:3,catalog:16,catalogu:13,categori:10,caus:[12,13],caveat:[7,10,13,18],cd:[14,19],ce:12,center:9,certain:[0,7,12,13],certainli:16,cfg:[12,13],chain:0,challeng:[9,10,11,17],chanc:[0,7],chang:[0,1,7,9,11,13,14,15,18,19],changelog:15,changeset:1,channel:12,charact:[3,8,12,18,19],charl:12,charset:[12,13],check:[5,7,9,11,12,13,15,16,18,19],check_constraint:18,check_current_head:13,checkconstraint:[10,12,16,18],choic:0,choos:11,chosen:14,chri:12,christian:12,chronolog:[1,19],circumst:[12,18],ck1:10,ck:[16,18],ck_:16,ck_bool_:18,ck_bool_t_x:18,ck_sometable_q_bool:16,ck_user_name_len:18,cl:[5,13],clariti:12,classmethod:[3,5,7,8,13,18],classnam:3,claus:[12,18],clauseel:3,clean:[11,12,19],clear:[11,12,13],clearer:12,cli:12,client:[13,17],close:[11,12],cmd_line_url:7,cmd_opt:[2,7,12,13],cname:0,cockroachdb:12,code:[0,5,6,11,12,15,16,19],codepath:12,coerc:18,coerce:18,col1:9,col2:9,col:[7,12,13],collat:[0,3,12],collect:[0,6,7,8,12,13,15,18],colon:[12,18,19],colon_valu:18,cols_by_kei:13,column:[0,3,5,7,9,10,11,12,15,16,17,18,19],column_0_label:16,column_0_nam:[10,16],column_info:[3,10],column_nam:[3,5,18],column_reflect:[3,9,10],columnclaus:3,columncom:3,columndefault:3,columnel:[3,5],columnnam:3,columnnul:3,columntyp:3,com:[12,13,14],combin:[0,9,11,12,13,18],come:[8,9,12,19],comma:19,command:[0,2,4,5,6,7,8,9,10,11,12,14,15,17,18,19],command_termin:3,commanderror:[7,12],commandlin:[12,13,19],comment:[3,5,7,9,12,18,19],commit:[3,7,9,12,13,17],common:[7,11,12,13,14],commonli:[0,10,12],commun:[5,6,15],compar:[0,7,12,13,15],compare_against_backend:[9,12],compare_column_level:0,compare_metadata:[0,12,13],compare_schema_level:0,compare_sequ:0,compare_server_default:[3,7,9,12],compare_table_level:0,compare_to:[0,7,9,13],compare_typ:[3,7,9],comparison:[6,7,9,12,13],compat:[2,7,9,10,12,18],compil:[3,7,12],compiler_toplevel:[3,5],complain:[12,13],complement:12,complet:[0,7,10,11,12,13,16,18],complex:12,complic:16,compon:[12,19],compos:19,composit:12,comprehens:[5,9],comput:[3,5,12,18],computedcolumndefault:3,concaten:[0,9],concept:[9,11,12,13],concern:10,condit:[5,12,15,18],config:[1,2,6,7,8,9,12,13,17,19],config_arg:[2,12],config_file_nam:[2,12,17],config_ini_sect:[2,7,9,13],configpars:[2,19],configur:[0,1,4,6,7,10,12,13,15,16,17,18,19],conflict:[10,12],confus:[11,12],conjunct:[6,9,12,18],conn:[0,7,13,18],conn_col:0,conn_fk:3,conn_index:3,conn_tabl:0,conn_typ:9,conn_uniqu:3,conn_unique_constraint:3,connam:16,connect:[0,1,2,3,6,7,9,10,12,15,16,17,18,19],conrelid:16,consid:[0,7,8,9,11,12,13,18],consider:[12,13],consist:[0,10,12,18],consol:[2,9,19],console_script:[9,12,19],constant:12,constraint:[0,3,5,7,9,12,13,15,18],constraint_nam:[3,5,10,12,16,18],constraint_naming_convent:[16,18],constraint_typ:[3,16],construct:[0,1,2,3,5,7,8,9,12,13,18],constructor:[2,7,9],consult:[0,7,9,12],consum:[1,12,13,19],consumpt:7,contain:[0,5,6,7,8,9,11,12,13,18,19],content:[0,7,9,12],context:[0,2,3,4,9,10,11,12,13,14,15,16,17,18,19],context_opt:3,contextmanag:7,contextu:[7,12],continu:[9,10,11,12,13,19],contract:12,control:[7,12,15,18,19],contyp:16,conv:[5,18],convei:6,conveni:[0,9,11,12,13,16],convent:[10,12,15,18],convert:[0,7,8,9,12,16,18],convert_spaces_to_tab:9,cookbook:[12,15],coomber:12,cooper:12,copi:[2,3,10,12,13,18],copy_from:[10,12,18],core:[18,19],correct:[0,9,10,12,19],correct_for_autogen_constraint:3,correct_for_autogen_foreignkei:3,correctli:[9,12],correspond:[0,5,7,9,10,12,13,18],could:[0,9,11,12,13,19],count:12,cours:[0,7,9,11,18],courtesi:12,cover:[11,12],cr:12,crazi:11,creat:[1,2,3,4,5,6,7,8,9,10,12,15,16,17,18],create_al:[7,13],create_async_engin:13,create_check_constraint:[5,12,18],create_column_com:3,create_constraint:10,create_d:[12,13,18],create_engin:[0,7,12,13],create_exclude_constraint:[3,12,18],create_foreign_kei:[0,5,12,18],create_index:[3,5,12,13,18],create_new:13,create_primary_kei:[5,12,18],create_sequ:[0,5],create_sp:13,create_t:[0,3,5,7,9,12,13,18,19],create_table_com:[3,5,12,18],create_unique_constraint:[5,12,16,18],create_view:13,createcheckconstraintop:5,created_at:13,createexcludeconstraintop:3,createforeignkeyop:[0,5],createindexop:[0,5,12,13],createprimarykeyop:5,createsequenceop:[0,5],createspop:13,createtablecommentop:5,createtableop:[0,5,12,13],createuniqueconstraintop:5,createviewop:13,creation:[12,13,19],criteria:12,critic:[9,12,17],cross:[11,12],crud:18,ctx:[7,18],cumbersom:9,current:[0,1,3,5,7,8,9,10,11,12,14,15,17,18,19],current_rev:7,current_ten:13,current_timestamp:12,current_vers:17,cursor:18,custom:[1,4,5,7,8,12,15,18,19],customari:7,customer_view:13,customiz:19,cwd:[9,12],cycl:[3,12],cycledetect:[8,12],d747:11,d747a8a8879:11,d747a8a8879_add_a_shopping_cart_column:11,d747a:11,d:[0,9,10,11,12,13,16,17,18,19],d_:19,dai:[12,19],damien:12,danjou:12,dash:[12,19],data:[0,9,10,12,13,18],data_downgrad:13,data_upgrad:13,databas:[0,1,3,5,6,7,8,9,11,12,14,15,16,17,18,19],datamemb:[9,18],datatyp:[0,7,9,12,15,18],date:[7,9,11,12,15,18,19],datefmt:19,datetim:[9,12,13,18,19],dateutil:[12,19],david:12,db1:17,db2:[13,17],db:12,db_1:17,db_2:17,dba:[12,17],dbapi:[7,12,13,18,19],dbname:[7,19],ddl:[0,4,5,6,7,9,10,11,12,13,15,16,17,18,19],ddlcompil:3,ddlelement:3,ddlevent:9,deal:[0,5,11,12,13,15,18],debug:0,dec:12,decemb:12,decid:12,decim:[3,9,12,19],decis:12,declar:[9,12,13],declarative_bas:16,decod:12,decor:[0,5,8,9,12],dedic:12,dedup:12,dedupl:12,deep:12,deepli:12,def:[0,5,7,9,10,11,12,13,16,17,19],default_constraint:18,default_schema_nam:[0,13],defaultclaus:[12,18],defaultimpl:[3,6,7],defens:12,defer:12,deferr:[5,12,18],defin:[0,5,7,8,9,11,12,13,16,18,19],definit:[9,10,12,13,18],degre:[0,12,18],dein:12,delet:[1,11,12,13,18],deliv:[0,5,12],delta:11,demarc:[6,7],demonstr:13,den:12,deni:12,denot:[1,7,16],depend:[1,7,8,9,12,15],dependencycycledetect:8,dependencyloopdetect:8,depends_on:[1,5,8,11,12,13],deploy:12,deprec:[8,12],derek:12,deriv:[7,12,18,19],desc:12,descend:[5,11],describ:[1,5,7,10,11,12,13,17,18,19],descript:[9,12,17,18,19],design:[17,18,19],desir:[9,10,11,12,13,18,19],destin:[0,7,18],destination_rev:7,detail:[0,1,7,9,10,12,15,16,18,19],detect:[10,12,13,15,19],determin:[0,7,8,9,12,13,17,19],determinist:12,dev:12,develop:[0,1,2,5,6,11,12,14,19],devis:13,dhillon:12,dialect:[0,2,3,7,9,10,12,13,18],dialect_kw:[5,18],dialect_nam:[7,17],dialect_opt:[7,12],dialect_toplevel:18,dialectnam:18,diamond:11,dict:[0,2,3,5,7,8,10,13,18],dict_:3,dictionari:[0,1,2,5,7,9,12,13,16,18],did:[9,11,12],didn:[11,12],diff:[4,12,15],differ:[0,2,3,5,7,9,10,11,12,13,17,19],differenti:12,difficult:[9,12],digit:12,dimitri:12,dir:8,direct:[1,2,3,4,6,7,9,10,11,12,14,15,16,17,18,19],directli:[0,1,2,5,7,9,10,11,12,15,18,19],directori:[1,2,4,7,9,12,13,14,15,19],dirnam:17,disabl:[5,7,10,12],disadvantag:16,disallow:12,disambigu:18,discourag:18,discrep:11,discuss:[0,1,2,4,5,9,11,12,14],dispar:12,dispatch_for:0,displai:[1,11,12,19],display_width:13,dispos:13,distinct:[0,11,12,18],distinguish:12,distribut:12,distutil:12,diverg:11,dj:12,dn:11,do_run_migr:13,doc:[8,12],docstr:[8,12],document:[0,1,2,5,7,8,9,12,14,18,19],doe:[0,3,5,6,7,10,11,12,13,15,16,19],doesn:[1,2,7,9,10,12,16],domk:12,don:[0,1,11,12,14,15,18,19],done:[0,7,9,10,11,12,19],dot:[3,9,12,13],doubl:[0,3,12],down:[1,7,8,9,11,12,13,19],down_revis:[0,8,9,11,13,19],downgrad:[0,1,5,6,7,9,11,12,13,15,17,18],downgrade_op:[0,5,7,12,13],downgrade_ops_list:[0,5],downgrade_token:[0,5,7,12],downgradeop:[0,5,7,12],downrev:12,downsid:12,draw:19,driven:12,driver:[7,12,14,19],drop:[0,3,5,9,12,14,15,16,18],drop_column:[0,3,5,10,12,13,18,19],drop_constraint:[0,3,5,10,12,16,18],drop_index:[3,5,12,13,18],drop_old:13,drop_sequ:[0,5],drop_sp:13,drop_tabl:[0,3,5,9,12,13,18,19],drop_table_com:[3,5,12,18],drop_view:13,dropcolumn:3,dropcolumnop:[0,5],dropconstraintop:[0,5],dropindex:12,dropindexop:[5,13],dropsequenceop:[0,5],dropspop:13,droptablecommentop:5,droptableop:[0,5,12,13],dropviewop:13,due:[8,12,19],dummi:12,dump:[1,12,17,19],duplic:[0,12],dure:[3,6,7,9,12,13,18,19],dynam:[5,12,18],e:[0,2,5,6,7,8,9,10,11,12,13,14,18,19],each:[0,6,7,8,9,11,12,13,16,17,18,19],earli:12,earlier:[11,12],earliest:13,easi:[0,13,16,17],easier:[0,19],easiest:3,easili:[12,13,14],eced083f5df:0,echo:13,ed:18,edigaryev:12,edit:[1,9,11,12,13,14,15,16],editor:[1,12],effect:[7,11,12,13,16,18],effici:7,effort:[12,16],eg:12,egg:19,either:[0,7,9,11,12,13,18,19],elad:12,elect:3,elem:13,element:[0,3,5,6,7,9,12,15,18],elif:[9,13],elimin:12,els:[0,2,5,7,8,9,12,13,17,18,19],emac:12,email:13,embed:12,emit:[0,3,7,10,11,12,15,16,18],emit_begin:[3,7],emit_commit:[3,7],emit_ev:12,emphasi:[10,12],emploi:13,empti:[0,7,8,9,12,15,19],enabl:[7,9,12,17,18],encapsul:8,enclos:[7,12],encod:[2,7,12,19],encount:[0,5,9,12],encourag:[12,17,19],encourgag:16,end:[0,4,5,6,7,8,9,11,12,13,17,18,19],end_vers:17,endless:12,endpoint:[8,11],enforc:[10,12],engin:[1,2,6,7,9,12,13,17,18,19],engine1:0,engine1_downgrad:0,engine1_upgrad:0,engine2:0,engine2_downgrad:0,engine2_upgrad:0,engine_from_config:[7,9,13,19],engine_nam:0,enhanc:[12,14],enorm:[12,18],enough:[9,13,16],ensur:[0,7,9,11,12,13,14,16,18],ensure_vers:[1,12],entail:12,enter:[7,10,12],entir:[3,8,10,12,13,16,18,19],entireti:12,entri:[0,1,11,12,13],entrypoint:[3,9,19],enumer:[9,10,13],env:[0,1,2,4,5,6,7,8,9,10,12,13,16,17,18,19],environ:[0,1,2,4,6,8,9,11,12,14,15,18],environment_context:7,environmentcontext:[0,1,2,3,4,6,7,9,10,12,13,17,18],epoch:[12,19],equal:[11,18,19],equival:[3,7,9,12],eras:[0,12],erdfelt:12,err:12,erron:12,error:[8,9,10,11,12,17,19],escap:[2,12,18,19],especi:[11,12],essenti:[0,10,12],est5edt:19,establish:[0,5,7,9,11,12],etc:[0,3,7,12,18,19],evalu:12,even:[7,10,11,12,13,16,19],event:[3,9,10,12,16,18],eventu:9,ever:0,everi:[0,12,16,19],everyth:[12,19],exact:[12,19],exactli:[8,18],examin:0,exampl:[0,1,5,7,8,9,10,11,12,13,16,17,18,19],exceedingli:12,except:[0,7,8,9,10,11,12,13,17,18],exclud:[3,9,12,13,18],excludeconstraint:[3,12,18],exclus:[6,8,9],exec:[12,18],execut:[0,3,5,7,12,13,17,18],executemani:18,executesqlop:[5,12],execution_opt:[3,5,7,12,18],exercis:12,exist:[0,1,2,3,7,8,10,11,12,13,17,18,19],existing_autoincr:[3,18],existing_com:[3,5,12,18],existing_nul:[3,5,12,18],existing_server_default:[0,3,5,12,18],existing_transf:3,existing_typ:[0,3,5,10,12,18],exit:[12,13],expand:12,expect:[7,10,11,12],expens:9,experiment:13,explcitli:12,explicit:[0,9,10,12,13,15],explicitli:[0,9,10,11,12,13,18,19],expos:[4,7],expr:3,express:[3,9,12,16,18],ext:[3,5,13],extend:[0,1,2,4,5,6,7,13],extens:[0,5,6,9,12,13,18],extent:12,extern:[12,18],extra:[10,12,13],extract:12,extran:9,f:[12,13,16,18],fa4456a9201:11,fa445:11,fabric:10,facad:[6,7],face:8,facilit:[12,18],fact:[9,11,12],factori:7,fail:[10,11,12],failur:12,faithfulli:9,fall:19,fals:[0,1,3,5,7,8,9,10,12,13,17,18,19],familiar:11,far:[10,12],fashion:12,favor:[9,12],fcntl:12,feasibl:1,featur:[0,1,6,7,9,10,11,13,14,15,16,17,18,19],februari:12,federico:12,few:[9,10,11,12,19],field:[3,12,13,19],figur:[6,16],file:[0,1,2,5,6,7,8,9,10,11,12,14,15,17,18],file_:[2,9,17],file_config:2,file_templ:[8,12,19],fileconfig:[2,12,19],filenam:[2,7,9,12,19],filesystem:[2,8,19],filter:[0,7,9,12,13],find:19,fine:[5,7,9,11,12,13,14,18],finish:[9,13],fire:18,firebird:12,first:[0,1,2,5,7,9,10,11,12,13,14,15,16,17,18],fit:0,fix:[7,9,12,13,14,18],fixabl:13,fk:[10,12,16,18],fk_:[10,16],fk_bar_foo_id_foo:10,fk_user_address:18,fk_user_order_id:16,flag:[0,2,6,7,9,10,12,13,16,17,18,19],flake8:12,flat:10,flexibl:[12,13],floer:12,flow:12,fn:7,focu:12,folder:19,follow:[0,2,6,7,8,9,10,11,12,13,14,16,18,19],foo:[0,2,9,10,11,12,13,18],forc:[7,12,18],forego:16,foreign:[5,9,12,13,15,16,18],foreign_kei:[7,12,18],foreign_key_column:18,foreign_key_constraint:7,foreignkeconstraint:12,foreignkei:[10,12,16,18],foreignkeyconstraint:[0,3,7,10,12,13,18],forest:11,forgot:12,form:[0,1,8,9,10,12,13,18],format:[0,2,7,9,11,12,13,19],format_column_nam:3,format_server_default:3,format_table_nam:3,format_typ:3,formatargspec:12,formatt:[12,15,19],formatter_:19,formatter_gener:19,former:[12,19],formula:12,forth:11,forward:[7,12],found:[2,7,9,12,13],four:[9,12],fragment:[0,9],framework:12,frazer:12,free:[9,19],freeli:[7,11],fresh:[11,13],fri:12,from:[0,1,2,3,5,7,8,10,11,12,14,15,16,17,18,19],from_config:[7,8,13],from_constraint:3,from_engin:12,from_index:13,from_tabl:13,front:[7,12,13,15],frozenbal:12,frozenset:8,frustratingli:10,full:[0,3,7,8,9,10,11,12,13,18,19],fulli:[8,9,10,12,13,18,19],func:[12,18],functool:3,fundament:[0,12],further:[12,17,18,19],futur:[7,12],g:[0,2,5,6,7,8,9,10,11,12,18,19],gain:0,garaud:12,gatewai:[6,10],gather:[3,12],gave:11,genener:12,gener:[1,2,3,4,5,6,7,8,10,11,12,15,16,18,19],generate_revis:[8,12],get:[4,7,8,9,11,12,13,15,16],get_bas:[8,12],get_bind:[7,18],get_by_dialect:3,get_column:[7,9],get_context:[7,13,18],get_current_head:[7,8,12,13],get_current_revis:[7,12],get_foreign_kei:9,get_head:[8,12,13],get_head_revis:[7,12],get_index:9,get_main_opt:[2,19],get_revis:[8,12,13],get_revision_argu:[7,12,17],get_schema_nam:[7,9,12],get_sect:[2,7,9,13],get_section_opt:2,get_starting_revision_argu:[7,12],get_table_nam:9,get_tag_argu:[1,7],get_template_directori:2,get_unique_constraint:[9,12],get_x_argu:[2,7,12,13],getargspec:12,getattr:13,getfullargspec:12,gettz:19,giacomo:12,gilcreas:12,git:[9,12],github:[12,13,14],give:[0,9,11,12,13,16],given:[0,1,2,3,7,8,9,10,11,12,13,16,18,19],glitch:12,global:[12,13,16,19],go:[0,3,7,9,11,12,13,16],goal:12,goe:12,gone:10,good:[0,1,7,16,19],googl:9,got:12,grain:[7,9,12,13],grant:13,granular:12,graph:[11,12],great:12,greater:[11,12,13,18],greatest:18,group:[7,9,18],grow:0,grown:4,guarante:[7,11],guess:9,guid:[12,19],guidanc:[5,9],guidelin:0,guilherm:12,h:19,ha:[0,4,6,7,8,9,10,11,12,13,14,16,18,19],haapala:12,hack:17,hackeri:12,had:[11,12,13,18,19],hand:[9,12,17,19],handl:[0,5,7,10,12,18],handler:[0,7,19],handler_:19,handler_consol:19,hard:12,hardcod:[1,12,13],harland:12,hart:12,hasattr:13,hash:12,hasn:[9,12],have:[0,1,7,8,9,10,11,12,13,14,16,17,18,19],head:[0,1,2,5,7,8,12,15,19],head_onli:12,head_revis:8,header:19,heavi:[12,19],help:[9,12,13],helper:[0,7],helptext:12,henc:[11,12],here:[0,2,3,4,7,8,9,10,11,12,13,16,18,19],hex:7,hierarchi:12,high:18,higher:[3,12],highli:12,highlight:13,hint:[11,16],histori:[1,8,11,12,13,15],hoc:[7,12,18],hold:[12,13,19],hole:18,home:19,homepag:15,hong:12,honor:12,hook:[0,3,4,7,12,13,15,19],hook_config:8,host:[7,12,14],hostnam:13,hour:[12,19],how:[0,5,6,7,9,10,12,13,16,19],howev:[0,4,5,7,8,9,10,11,12,13,16,18,19],hstore:12,http:[3,12,13,14],huge:12,hugo:12,hundr:13,hypothet:13,i:[7,8,9,12,13,18,19],ibrahim:12,id:[0,1,8,9,10,11,12,13,16,17,18,19],id_:8,idea:[1,9,13,16,19],ident:[3,5,12,13,18],identif:12,identifi:[0,1,7,8,9,10,11,12,13,15,18],identity_attrs_ignor:3,identitycolumndefault:3,idx:13,idx_op:0,ignor:[7,12],ijl:12,ik_test:18,illustr:[0,5,9,11,12,13,17,19],immedi:[9,12,18],immutabledict:2,imp:12,impact:12,impl:[3,11,12,13,18],implement:[0,3,5,6,7,9,12,13,14,18,19],implementation_for:[5,13,18],impli:[9,12],implicit:[12,13,15],implicit_bas:8,implicitli:12,implmeta:3,importantli:12,importlib:12,imposs:[11,12],impress:12,improv:12,in_nam:13,in_order_count:13,inadvert:12,inappropri:12,incept:12,includ:[0,2,3,5,7,8,9,11,12,13,14,15,18,19],include_nam:[0,7,9,12],include_object:[0,7,9,12,13],include_schema:[7,9,12,13],include_symbol:12,inclus:[8,9],incom:12,incompat:[11,12],inconsist:10,incorrect:12,incorrectli:[11,12],increment:13,incur:12,indent:[0,12],independ:[11,12,13],index:[0,3,5,7,9,12,15,16,18],index_nam:[5,12,18],indic:[0,1,2,7,8,9,12,13,18,19],indicate_curr:1,individu:[0,3,7,11,12,13,18,19],inevit:9,infer:7,info:[0,5,7,9,11,12,13,17,19],inform:[1,3,5,7,8,11,12,13,14,15],infrastructur:12,ini:[1,2,7,9,11,12,14,15],ini_sect:2,init:[1,2,9,12,13,14,19],initi:[1,5,11,12,15,18,19],inlin:[12,18],inline_liter:[7,12,18],inner:12,innodb:[10,13],input:[2,9,18],insert:[3,5,10,11,12,13,17,18],insert_aft:[5,12,18],insert_befor:[5,12,18],insid:[0,7,8,9,11,12,13,19],inspect:[0,7,12,13],inspected_column:[7,9],inspected_default:7,inspected_typ:9,inspector:[3,7,9,10,12],inspector_column:3,inspir:9,instal:[12,13,15,19],instanc:[0,1,3,5,6,7,8,9,12,13,18],instant:7,instanti:[2,6,7],instead:[1,5,6,7,9,10,11,12,13,17,19],instruct:[0,3,5,11,12,13,18,19],intact:12,integ:[0,7,9,10,12,13,16,18,19],integr:[0,4,10,12,13,15,18],intend:[0,6,7,9,10,11,12,13],intent:[9,12],interact:[13,18],intercept:[1,9,12,16],interdepend:12,interfac:[1,2,6,12,13,18],interfer:12,interim:13,intermediari:12,intern:[0,1,2,4,5,6,12,15,16,18],interpol:2,interpret:[12,14,19],interstingli:11,interv:[7,12],intervent:12,intric:13,introduc:[11,12,13],introduct:[12,19],invalid:12,invari:11,invoc:[1,7,12,19],invok:[0,2,5,6,7,9,10,11,12,13,18,19],invoke_for_target:13,involv:[7,9,11,12,13,18],io:12,ioctl:12,ioerror:12,ip:11,is_bas:8,is_branch_point:8,is_empti:13,is_head:8,is_merge_point:8,is_offline_mod:[7,13,17],is_server_default:3,is_transactional_ddl:7,is_view:13,isinst:[7,9,13],isn:[0,10,11,12,13],isol:[7,12],issu:[5,9,10,12,13,14,18],issue10740:3,item:[0,7,9,12],iter:[0,7,8,12,13,18],iterate_revis:[8,12],its:[0,1,4,5,7,9,10,11,12,13,18],itself:[1,7,8,9,10,11,12,13,14,18,19],ivan:12,ix:16,ix_:16,ix_b_aid:13,ixc:0,jacob:12,jan:12,januari:12,javier:12,jess:12,jet:12,jiri:12,job:[0,19],johann:12,john:[12,18],join:[0,9,11,13,16,17],jone:18,json:[3,12],jsonb:12,jul:12,juli:12,julien:12,jun:12,june:12,just:[1,2,5,9,10,11,12,13,16,18,19],k:15,kahlert:12,kai:12,kamyshnikova:12,kataev:12,kazutaka:12,kc:12,ke:12,keep:[12,13],kei:[0,2,5,7,8,9,11,12,13,15,16,17,18,19],kelli:12,keyerror:12,keyword:[7,9,12,13,18],kick:12,kind:[0,5,7,9,10,11,12,13,14,18],know:[0,6,10,11,16,19],knowledg:[0,16],known:[0,9,10,11,12,13,16,18,19],koichiro:12,koizumi:12,kolov:12,konstantin:12,kuncar:12,kuzminski:12,kw:[0,3,5,7,8,12,13,18],kwarg:[2,3,7,12],l:[9,19],label:[1,9,15],lack:13,lambda:[9,13],land:12,languag:[12,13,18],larg:[9,17],larger:12,last:[0,9,11,17,18],last_transaction_d:[9,17,19],latenc:19,later:[0,1,9,11,12,17],latest:12,latin1:13,latter:[5,12],laydai:12,layer:12,layout:11,lead:[11,12],leak:12,learn:[0,13],least:[5,7,10,12,16,18,19],leav:19,lebedev:12,left:[7,11,12,18,19],legaci:[0,12,19],legacy_schema_alias:12,legal:18,len:[9,18],length:[0,7,8,9,10,12,13,19],less:[11,12,18],lesser:[0,12],let:[0,11,13,16,19],level:[0,3,5,7,9,10,12,15,18,19],levelnam:19,leverag:12,lib:12,liber:12,librari:[12,14,18,19],lieu:[12,13,18],lift:12,lightweight:15,like:[0,2,7,9,10,11,12,13,16,17,18,19],limit:[7,8,9,10,11,12,13],line:[1,2,7,9,10,11,12,13,14,17,19],lineag:[11,12,13],link:[1,5,8,10,11,19],link_to_nam:12,linter:9,list:[0,1,3,5,6,7,8,9,11,12,13,16,18,19],list_templ:[1,2,12,19],listen:[10,18],listen_for_reflect:10,liter:[3,5,7,12,18],literal_bind:[7,12,18],littl:[12,13],live:[10,11,17,18,19],ll:[0,8,10,11,13],load:[7,9,10,11,12,13,19],load_dialect_impl:12,local:[0,2,7,9,12,13,14,17,19],local_col:[5,12,18],localhost:[11,13,19],localtim:19,locat:[0,1,7,9,11,12,13,19],log:[2,12,13,17,19],logger:[0,19],logger_:19,logger_alemb:19,logger_root:19,logger_sqlalchemi:19,logic:[7,8,9,10,12,13],longdoc:8,longer:[11,12,13,16,19],longtext:[3,12],look:[0,9,11,12,13,16,19],lookup:12,loop:[12,13],loopdetect:8,lost:12,lot:[9,11,12,16],lower:[8,12,18],luca:12,m:[1,8,9,11,12,13,19],maarten:12,made:[1,7,9,10,11,12,18,19],magnitud:12,magnusson:12,mai:[0,1,2,5,7,8,9,10,11,12,13,17,18,19],main:[2,6,11,12],maintain:[0,8,11,12,13,18,19],major:[3,4,9,12,17,19],make:[0,1,2,6,7,9,11,12,13,16,17,18,19],mako:[0,7,8,9,11,12,13,19],malt:12,manag:[7,8,11,12,18,19],mani:[1,4,7,8,9,10,12,13,14],manipul:[7,10,12],manner:12,mansur:12,manual:[7,9,10,11,12,16,18],map:[8,18],mar:12,marc:12,march:12,marcin:12,mariadb:12,mariadbimpl:3,marker:8,marku:12,marquard:12,martin:12,match:[5,8,9,10,12,18,19],matt:12,matter:15,matthew:12,max:19,maximum:12,maxvalu:3,mayb:16,mc:[0,13],mclean:12,mean:[0,7,9,10,11,12,13,17,18],meaning:7,meant:11,mechan:[7,8,12,19],mediumtext:13,meet:12,member:12,memo:3,memoiz:12,memori:[12,17],mention:[10,11,16,18,19],mercuri:12,merg:[1,8,12,15,19],mergepoint:[11,12],messag:[0,1,2,5,8,9,12,13,19],meta:[10,16],metadata:[0,3,5,7,10,12,13,15,16,18,19],metadata_col:0,metadata_column:[3,7,9],metadata_default:7,metadata_fk:3,metadata_index:3,metadata_sequ:0,metadata_t:0,metadata_typ:9,metadata_unique_constraint:3,meth:12,method:[0,1,2,3,4,5,6,7,8,9,10,12,13,18,19],methodolog:9,mi:12,michael:12,michal:12,michel:12,microsoft:18,might:[9,10,12,13,16],migrat:[0,1,2,3,4,5,6,8,11,12,15,16,18],migrateoper:[0,5,12,13,18],migratin:13,migration_context:[0,3,7,18],migration_script:0,migration_typ:9,migrationcontext:[0,1,2,3,5,6,7,12,13,18],migrationinfo:[7,12],migrationscontext:16,migrationscript:[0,5,7,12,13],mike:14,million:12,mind:16,minhe:12,minimalist:19,minimum:12,minor:12,minut:[12,19],minvalu:3,misc:15,mise:12,misinterpret:12,miss:12,mistaken:12,mistakenli:12,mix:12,mmelnychuk:12,mock:7,mode:[1,2,3,6,7,12,13,14,15,18],model1bas:9,model2bas:9,model:[7,9,11,12,13,16,19],model_metadata:0,modern:10,modif:12,modifi:[0,2,3,7,9,10,12,13,18,19],modify_:0,modify_com:5,modify_nam:5,modify_nul:[0,5],modify_op:0,modify_server_default:5,modify_typ:5,modifytableop:[0,5,12,13],modul:[0,2,5,6,7,8,11,12,13,15,18,19],modular:12,moduletyp:8,moment:[11,12,13,18],mon:12,month:[12,19],mood:7,more:[0,1,2,4,5,7,8,9,10,12,14,15,16,18,19],moretto:12,moriyoshi:12,most:[0,5,7,8,9,10,11,12,13,14,16,18,19],mostli:[10,12],mount:12,move:[9,10,12,18,19],movement:[12,13],ms:[4,12,15],msddlcompil:3,mssql:[3,7,12],mssql_add_column:3,mssql_batch_separ:7,mssql_drop_check:[12,18],mssql_drop_default:[12,18],mssql_drop_foreign_kei:[12,18],mssql_includ:12,mssqlimpl:3,much:[7,9,10,12,13,16,18],mueller:12,mulipl:12,multi:[0,8,15,19],multidb:[0,5,9,12,19],multiinsert:[3,5,12,18],multipl:[1,5,7,8,12,15,17,18,19],multiplehead:8,must:[0,2,7,8,9,10,11,12,13,17,18,19],mutablemap:5,mutat:[10,12],my:2,my_column:9,my_compare_server_default:7,my_compare_typ:9,my_enum:10,my_funct:7,my_metadata:13,my_nam:9,my_render_column:7,my_seq:0,my_seq_1:0,my_sequ:[0,5],my_sequence_1:0,my_tabl:[13,18],my_view:13,myapp:[2,7,8,9,16,17],mybranch:0,mycolumn:9,mycustomtyp:9,mydatabas:[7,13],myengin:18,mymodel1:9,mymodel2:9,mymodel:[9,16],myotherdatabas:13,mypackag:9,mypi:12,myproject:13,mysect:2,myspecialcol:7,myspecialtyp:9,mysql:[4,10,12,13,15,18],mysql_com:13,mysql_default_charset:13,mysql_engin:[12,13],mysqlalterdefault:3,mysqlchangecolumn:3,mysqlclient:12,mysqldb:12,mysqlimpl:3,mysqlmodifycolumn:3,mytabl:7,myview:13,n:[0,2,12,13,16,19],name:[0,1,2,3,5,7,8,11,12,13,15,17,18,19],namespac:[2,7,9,12,13,18],naming_convent:[10,12,16,18],narrow:11,nativ:[12,16,18],natur:[11,12],navig:8,nearli:12,necessari:[6,7,9,10,12,13,18,19],necessarili:[9,12],need:[0,2,3,4,5,7,8,9,10,11,12,13,16,17,18,19],neg:19,nest:[7,12],net:12,network:11,never:[12,18],new_column_nam:[5,10,12,18],new_table_nam:[3,5,18],new_typ:3,newer:[7,11,12,14],newli:[9,12,18,19],newnam:3,next:[5,7,9,11,12,14,15],nextrev:8,nextval:12,nice:13,nicola:12,nikita:12,nikolai:12,nil:12,no_paramet:12,no_tag:12,node:[11,12],nomaxvalu:3,nominvalu:3,non:[0,2,9,12,13,18,19],none:[0,1,2,3,5,7,8,9,10,11,12,13,16,17,18,19],nonetyp:12,nonexist:12,nonzero:12,nor:[10,12],normal:[0,3,4,5,7,8,9,10,11,12,13,16,18,19],nose:12,notabl:[8,12],notat:12,note:[0,1,2,7,8,9,10,11,12,13,18,19],noth:[7,8,11,12,19],notic:[17,19],notimplementederror:[12,13],notion:12,notset:19,noufal:12,nov:12,novemb:12,now:[0,5,9,10,11,12,13,14,18,19],nspname:0,nullabl:[0,3,5,7,9,10,12,13,18,19],nullpool:[7,12,13],number:[0,3,7,8,9,11,12,13,19],numer:[3,9,12,18],nut:7,nvarchar:[3,18],obj:[9,13],object:[1,2,3,4,6,8,10,12,15,16,18,19],object_:0,objnam:13,obscur:12,observ:12,obtain:0,obviou:9,occasion:7,occur:[0,5,7,9,10,11,12,19],occurr:12,oct:12,octob:12,odagiri:12,odd:[10,11],off:[3,7,9,10,11,12,17,18],offer:[12,13],offlin:[2,3,6,7,12,15,18],often:[1,9,11,12,13],oh:16,oid:[0,13,16],ok:[12,16],old:[9,10,12,13,18,19],old_data:[0,13],old_obj:13,old_table_nam:[3,5,18],older:[11,12,13,14,18],oleg:12,oliric:13,oliv:12,omit:[2,7,10,12,15,18,19],on_nul:3,on_version_appli:[7,12],onc:[0,7,12,13,15,18,19],ondelet:[5,12,13,18],one:[0,1,2,3,4,5,7,8,9,10,11,12,14,15,16,18,19],ones:12,ongo:12,onli:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,17,18,19],onlin:[7,10,12,13,17,18],onto:[0,11,12,13,19],onupd:[5,12,18],op:[0,3,5,7,9,10,11,12,13,16,18,19],op_cl:18,opcontain:5,open:[2,7,9,12,17],oper:[2,3,4,6,7,8,9,10,11,12,14,15,19],operar:13,opportun:0,oppos:[7,12],opposit:9,opt:[0,7],option:[0,1,2,3,5,7,8,9,11,12,13,14,17,18,19],oracl:[7,9,12,16],oracle_batch_separ:7,order:[0,1,3,5,6,7,9,10,11,12,13,16,18,19],order_column:13,order_count:13,ordinarili:7,org:[3,12,14],org_fk:0,organ:[0,5,11,12,13,14,17,18],organization_id:0,orient:[12,18],origin:[5,10,11,12,13],os:[11,12,17,19],other:[0,1,3,6,7,8,9,11,12,13,14,15,16,18,19],otherwis:[2,7,8,10,12,13,14,16,18],our:[5,9,10,11,13,14,15,16,17,18],out:[1,2,5,6,9,11,12,13,16,19],outer:[7,9,12],output:[0,1,2,5,6,7,9,11,12,13,17,18,19],output_buff:[2,3,7,17],output_encod:[7,8,12,19],outright:12,outsid:[0,4,7,12,13,18],over:[7,9,10,11,12],overal:[0,7,12,13],overcom:10,overhaul:12,overkil:13,overlap:12,overrid:[2,7,9,10,18],overridden:[7,12],overview:[4,5,13,15,19],overwhelm:12,own:[1,9,11,12,13,16,18],p:12,packag:[1,9,12,19],page:15,pair:[9,12],paradoxxxzero:12,parallel:12,param:3,paramet:[0,1,2,4,7,8,9,10,12,13,16,17,18],parameter:18,paramstyl:12,parent:[1,7,11,12,16,18,19],parent_nam:[0,7,9],parenthes:12,parenthesi:12,pars:[2,7,12],parse_encod:12,part:[0,2,5,6,9,10,11,12,13,14,18,19],parth:12,parths007:12,parti:[9,12],partial:[3,8,9,11,12,15],partial_reord:[12,18],particip:10,particular:[3,4,7,9,10,12,15,16,18,19],particularli:[7,9,12,13],pass:[0,2,4,5,6,7,8,9,10,11,12,13,16,17,18,19],passaro:12,patch:12,path:[0,1,2,8,9,11,12,13,14,17,19],pathnam:19,pathsep:[11,12,19],patienc:12,pattern:[10,12],paul:12,pedro:12,pep3147:12,pep3149:12,pep484:12,pep488:12,pep8:12,pep:12,per:[3,6,7,9,12,18],percent:[2,12],perfect:9,perfectli:18,perform:[0,3,7,9,10,11,12],perhap:1,period:18,perman:[11,13],persist:12,perspect:[2,7,11],pertin:11,petrucha:12,pg:[0,3,12],pg_catalog:[12,13,16],pg_class:[0,13,16],pg_constraint:16,pg_namespac:[0,13,16],pg_table_is_vis:13,pgddlcompil:3,phase:12,philippsen:12,philosoph:10,philosophi:18,phrase:12,pick:12,pickl:9,pip:[12,14,19],pipe:[9,12],pk:16,pk_:16,pk_my_tabl:18,pkg_resourc:12,place:[0,3,5,7,9,10,11,12,13,16,18,19],placehold:13,plai:[7,19],plain:[7,9,12,18],plan:[0,12],platform:[7,12],pleas:[0,1,2,5,7,9,10,11,12,13,19],plpgsql:13,plu:[12,19],plug:0,plugin:[0,4,12,13,15,18],podoliaka:12,point:[0,1,4,8,10,11,12,13,19],pool:[7,13],poolclass:[7,13],pop:13,popul:[2,8,12,13,18,19],popular:13,portabl:12,portion:12,posit:[7,9,12,18,19],posix:12,possibl:[2,5,10,12,13,17,18,19],post:[12,15],post_write_hook:[9,12,19],poster:11,postgreql:12,postgresql:[0,2,4,7,9,10,11,12,15,16,18,19],postgresql_concurr:12,postgresql_includ:12,postgresql_us:[12,18],postgresqlcolumntyp:3,postgresqlcontext:[17,19],postgresqlimpl:[3,11,13],potenti:[12,14],pound:12,pprint:0,pr:12,practic:[7,13,18,19],pragma:[10,12],pre:[9,10,12],preced:[0,7,9,10,11,12,19],precis:[3,9,12],predict:10,prefer:[7,8,9,10,12,19],prefix:[0,7,12,13,15,19],prematur:12,prep_table_for_batch:3,prepend:[12,19],prepend_sys_path:[12,14,19],presenc:[0,13],present:[0,3,5,6,7,8,9,10,11,12,13,17,18,19],preserv:[12,14],pretti:[10,11,12,13,18],preval:12,prevent:[9,10,12,13,19],previou:[1,9,11,12,13,18],previous:[0,12,13],primari:[0,5,6,7,9,10,12,13,16,17,18],primarili:[0,12],primary_kei:[0,7,10,12,13,16,18,19],primarykeyconstraint:[0,9,12,13,16,18],print:[0,2,12,15],print_stdout:[2,12],prior:[7,10,11,12],probabl:[11,12,19],problem:[12,13],proce:[3,7,9,10,11,12,13,14,18],procedur:[10,13],proceed:[13,16,19],process:[0,1,3,10,11,12,13,14,15,18,19],process_revision_direct:[0,1,7,12,13],procur:19,produc:[0,6,7,8,9,10,12,13,18,19],produce_migr:[0,13],product:[5,7,9,12,13,16],prog:2,program:[5,12],programat:2,programmat:[0,1,2,3,4,7,8,12,15],progress:12,prohibit:12,project:[4,9,11,12,13,15,19],promin:6,prompt:16,prone:12,proof:7,propag:12,properli:[10,12],properti:[3,5,7,8,9,13],property_nam:13,property_name_users_id:13,property_valu:13,propos:[0,13],provid:[0,2,3,4,6,7,8,9,10,11,12,13,14,16,17,18,19],proxi:[3,5,7,18],prune:[13,19],pseudo:12,psycogp2:7,psycopg2:12,publish:14,pull:[11,12,17],purg:[1,12],purpos:[0,4,6,10,12,13,17],pursu:11,put:[0,11,13],py2k:12,py3:12,py3k:12,py:[0,1,2,4,5,6,7,8,9,10,11,12,13,14,16,17,18,19],pyc:[12,19],pycharm:12,pyformat:2,pyi:12,pylon:[12,19],pyo:[12,19],pypa:12,pypi:[12,14],pyramid:12,pysqlit:[3,12],pytest:12,python2:12,python3:12,python3x:12,python:[0,2,3,5,6,7,8,10,12,14,15,18,19],pythonoptim:12,q:[10,16],q_bool:16,qualifi:[9,12],qualnam:19,queri:[12,13],question:12,quirk:12,quit:[10,11,13,16],quot:[3,12,18,19],quote_dot:3,quoted_nam:[3,5,12,18],r1975ea:19,r:[0,9,11,12,16,19],race:12,radic:12,rais:[0,7,8,9,10,12,13,17],ran:[0,11],rang:[1,12,15,17],rangenotancestorerror:[8,12],rare:12,rather:[1,7,9,10,11,12,13,18,19],rational:[9,10,12],raw:[2,12,18],rb:12,rcurrent:12,re:[0,4,9,10,11,12,13,19],reach:[11,12],read:[2,6,12,17,19],readabl:12,readm:[12,19],real:[4,7,11,12,18],realli:11,rearrang:12,reason:[5,7,9,10,11,12],reassign:13,rec:0,receiv:[0,7,11,12,18],recent:[7,8,12,13,14,18,19],recip:[1,12,13],recogn:12,recommend:[7,9,12,18],reconcil:11,reconcili:11,recreat:[3,10,12,13,18],recurs:13,redirect:[2,17],reduc:0,redund:12,refactor:[9,12],refer:[0,2,5,6,7,8,9,10,12,13,15,16,17,19],referenc:[12,15,18,19],referent_schema:[5,18],referent_t:[5,12,18],referenti:[10,12],referred_table_nam:[10,16],refin:12,reflect:[0,3,7,9,12,13,15,18],reflect_arg:[10,12,18],reflect_kwarg:[10,12,18],reflect_t:9,reformat:9,refresh:8,regard:[0,1,2,5,9,12,18],regardless:[7,9,10,12,18,19],regener:10,regexp:12,regist:[5,8,9,12,18],register_oper:[5,13,18],registr:[0,5,9,12],registri:19,regress:12,regular:[6,7,8,10,11,12,18],reject:12,rel:[7,9,11,12,15],relat:[10,12,16,19],relax:12,releas:[9,12,14,16],releg:13,reli:[10,12,17],reliabl:[9,12],relianc:19,relkind:0,relnam:[0,13,16],relnamespac:[0,13,16],relnum:11,remain:[10,11,12,13,18],rememb:16,remot:[12,18],remote_col:[5,18],remov:[5,9,10,13,15,18,19],remove_column:0,remove_constraint:12,remove_index:12,remove_t:0,renam:[5,10,12,18],rename_t:[3,5,12,18],renamet:3,renametableop:5,render:[2,3,5,6,7,10,12,13,15,16,18,19],render_as_batch:[0,7,10,12],render_create_sequ:0,render_ddl_sql_expr:3,render_drop_sequ:0,render_item:[0,7,9,12],render_python_cod:[0,12,13],render_typ:3,rendered_inspector_default:3,rendered_metadata_default:[3,7],reorder:[12,13],reorgan:[7,12,13],repair:12,replac:[0,2,3,9,10,12,15,19],replace_sp:13,replace_view:13,replace_with:13,replaceableobject:13,report:[9,12,14],repositori:[9,11,12],repr:[7,11,12,13],repres:[0,1,2,3,5,6,7,8,10,12,13,18,19],represent:[9,12],reproduc:9,repurpos:12,req:12,request:[8,12,13,19],requir:[1,3,7,8,10,12,13,16,18,19],requires_recreate_in_batch:3,resembl:12,reserv:18,reset:13,resili:12,resolut:[11,12],resolutionerror:8,resolv:[8,11,12],resolve_depend:1,resourc:[12,19],resource_filenam:[12,19],respect:[0,7],rest:13,restrict:[12,17,18],result:[0,7,8,9,11,12,13,18,19],resum:12,retriev:[7,9,12,17,18],retrospect:3,reusabl:12,rev1:[9,13],rev:[1,7,8,11,12,13,17,19],rev_id:[1,5,8],rev_rang:1,reveal:12,revers:[0,5,12,13,18],reversibleop:13,revert:[1,12],revid:8,review:[9,13],revis:[1,4,5,6,7,12,15,17],revision_environ:[7,9,12,19],revision_script_filenam:[9,12,19],revisionerror:8,revisionmap:[8,12],rework:[9,12],rewrit:[7,9,12,13],rewritten:12,rice:12,right:[7,11,12,16,18],rivera:12,robbi:12,robust:12,rock:19,rodrigo:12,role:[9,12],roll:[7,13],rollback:[12,17],roman:12,romano:12,root:[8,11,19],round:12,rout:[3,7],routin:[0,7,12],row:[0,3,5,11,12,16,17,18],rowan:12,rowcount:12,rudiment:15,rudimentari:[0,4,9,19],rule:[6,9,12,18],run:[1,2,3,4,5,6,7,8,9,12,14,15,16,17,18],run_arg:7,run_async_migr:13,run_async_upgrad:13,run_env:[7,8],run_filt:0,run_migr:[3,5,7,9,12,13,17,18],run_migrations_offlin:[13,17,19],run_migrations_onlin:[0,7,9,13,16,17,19],run_name_filt:0,run_object_filt:0,run_sync:13,run_test:12,run_upgrad:13,runner:[2,6,9,12,19],runtim:[4,5,12,13,15],ryan:12,s:[0,1,2,3,4,5,6,7,8,9,10,11,12,14,16,17,18,19],s_:[8,10,16,18,19],s_downgrad:0,s_upgrad:0,sa:[0,7,9,10,11,12,13,19],safe:[10,12,18],safeconfigpars:19,sai:[11,13],said:11,same:[0,1,3,7,9,10,11,12,13,16,17,18,19],sampl:[9,12],saniti:12,santacruz:12,sap:12,sat:12,satisfi:11,scale:[9,12],scan:[7,9,12],scenario:[8,10,11,12,13],scene:[12,16],sch:0,schaik:12,schema1:13,schema2:13,schema3:13,schema:[0,2,3,5,7,10,12,15,18],schema_downgrad:13,schema_nam:[7,9],schema_on:[7,9],schema_qualified_table_nam:9,schema_table_schema_nam:9,schema_translate_map:13,schema_two:[7,9],schema_upgrad:13,schemaitem:[0,7],schemanam:[0,9,13],scheme:[0,8,9,12,13,16,17,18,19],scope:[0,7,9,10,12,13],scott:[11,13,19],scratch:[12,15,19],screen:19,script:[0,1,2,4,5,6,7,9,10,11,12,13,15,16,18],script_directori:[7,12],script_directory_her:13,script_loc:[2,7,8,12,13,19],scriptabl:19,scriptdirectori:[1,2,6,7,8,12,13],search:[9,13,15],search_path:13,second:[0,10,11,12,13,15,18],section:[0,1,2,4,5,6,7,9,10,11,12,13,17,18,19],secur:18,see:[0,1,2,3,5,7,8,9,10,11,12,13,16,18,19],seek:10,seem:[12,16],seen:[9,10,11,12],segment:12,select:[0,8,9,10,11,12,13,16,17,18],select_for_downgrad:8,self:[5,9,10,12,13,18],semant:11,semi:11,semicolon:7,send:[10,12,13],sensit:[12,18],sent:[1,2,5,7,12],separ:[7,8,9,11,12,13,18,19],septemb:12,sequenc:[0,3,5,7,8,9,12,13,18,19],sequence_nam:[0,5],sequent:11,sequenti:9,seri:[0,1,6,7,9,10,11,12,13,18],serial:[0,12,13,17],serv:[0,5,8,9,11,12],server:[0,3,7,9,12,17,18],server_default:[3,5,7,12,18],server_version_info:12,servic:[10,12],session:17,set:[0,2,3,5,6,7,8,9,10,12,13,15,17,18,19],set_main_opt:[2,7,8,12],set_section_opt:[2,12],setdefault:0,setup:[2,12,13,14,18],setuptool:[9,12],sever:[11,12,19],shallow:12,shandilya:12,share:[1,2,9,11,12,15],shell:[9,14],shgoh:12,shigorin:12,shlex:12,shop:[10,11],shopping_cart:11,shoppingcart:11,shorthand:11,shot:13,should:[0,1,5,7,8,9,11,12,13,14,18,19],shouldn:12,show:[0,1,7,11,12,13,19],sibl:[11,12],side:[0,7,11,12,18],sign:[2,12,19],signal:12,signatur:12,signific:12,significantli:12,silent:[10,12],sill:12,similar:[10,11,12,16,18],similarli:12,simon:12,simpl:[0,5,7,9,10,12,13,16,18,19],simpler:[2,11],simplest:[0,5],simpli:[2,9,12,13],simplic:9,simplifi:12,simplist:13,simultan:[11,13,19],sinc:[0,10,11,12,13,18],singl:[0,1,5,7,8,9,11,12,13,18,19],sit:11,situat:12,size:12,skip:[7,9,12,13],skip_autogener:[7,9],slice:[12,19],slightli:[10,12],slower:12,slug:[8,12,19],small:[1,6,9,12,13],smallint:9,smallinteg:12,smith:18,so:[0,5,7,8,9,10,11,12,13,14,16,17,18,19],sobolev:12,softwar:12,sok:12,sole:13,solut:16,some:[0,2,3,7,9,10,11,12,13,16,17,18,19],some_create_index_op:12,some_oper:5,some_param:2,some_schema:13,some_t:[10,16,18],some_valu:2,somecolumn:7,somefunct:12,somenam:7,somet:[9,16],sometag:7,someth:[7,9,11,12,13,16,19],sometim:13,somewher:[9,13],sort:[0,11,12,15],sorted_t:0,soso:7,sourc:[9,10,11,12,13,14,18,19],source_schema:[5,12,18],source_t:[5,12,18],sourceless:[8,12,19],sourcenam:18,sp:13,sp_renam:12,space:[7,9,12,19],spaces_to_tab:9,special:[0,3,7,8,9,10,11,12,13,16,18,19],special_nam:13,specif:[0,1,3,5,6,7,9,12,13,14,15,17,18,19],specifc:11,specifi:[0,1,7,9,10,11,12,18,19],spit:12,splice:[1,5,8,11,19],split:[12,13,19],sporad:12,spuriou:13,sql:[1,4,5,6,7,9,10,11,12,13,15,16,18,19],sqla:[9,12,16,18],sqlalchemi:[0,2,3,5,7,9,10,11,12,13,14,15,16,18,19],sqlalchemy_module_prefix:[0,7,9,12],sqlexpression_toplevel:[7,18],sqlite:[0,4,7,12,13,15,18],sqliteimpl:3,sqllchemi:18,sqltext:[5,13,18],src:12,stack:[12,13],stamp:[1,7,12,13],stand:[9,12,14],standalon:[12,18],standard:[2,5,7,9,10,12,17,18,19],standpoint:8,start:[6,7,8,9,10,11,12,13,15,19],start_migr:3,starting_rev:[7,17],startup:19,state:[0,2,3,5,7,10,11,12,18,19],statement:[3,7,10,12,15,16,17,18],static_output:[3,7],statu:[9,11,12,14],std:12,stderr:[17,19],stdout:[1,2,7,12],stem:10,step:[0,3,5,7,9,10,11,12,13,14,15,18],steven:12,still:[7,10,11,12,13,18],stop:[11,19],stopiter:12,storag:2,store:[0,2,5,11,12,13],str:[0,1,2,3,5,7,8,12,18],straight:[12,13,19],straightforward:[12,13],stream:[0,5,6,7,11,12,18,19],streamhandl:19,street:10,strict:12,strictli:[8,19],string:[0,1,2,3,7,8,9,10,11,12,13,16,18,19],stringif:12,stringio:[3,12],strongli:12,structur:[0,1,7,10,11,12,15,18,19],stub:[12,13,18],style:[1,5,7,9,10,12,13,18],sub:[9,11,12],subclass:[0,5,6,8,12,18],subject:[11,12],subopt:12,subprocess:9,subsect:4,subsequ:[9,11,12],subset:[7,12],substitut:[2,11,12,19],substr:12,succe:12,succeed:8,success:0,successfulli:12,suffici:[5,10],suggest:[11,18],suit:[12,13,17,19],suitabl:[7,9,12,18],summar:0,sun:12,supersed:12,suppli:[6,12,19],support:[0,2,3,5,7,8,9,10,11,12,13,14,15,16,18,19],suppos:[0,9,10,13,16,19],suppress:12,sure:[2,9,11,19],surpris:12,surround:[12,18],sweep:[7,12],sy:[2,7,12,14,17,18,19],sybas:12,symbol:[1,2,8,11,12,18,19],symlink:12,sync:13,synonym:[7,9],syntact:18,syntax:[10,12,13,15,17,19],sys_c0029334:16,system:[0,1,3,5,6,7,9,10,11,12,13,14,18],systemwid:14,szotten:12,szymanski:12,t1:18,t:[0,1,2,7,9,10,11,12,14,15,16,17,18,19],t_tabl:19,tab:9,tabl:[0,1,3,5,6,7,11,12,16,17,18,19],table_arg:[10,18],table_elem:13,table_key_to_t:0,table_kw:5,table_kwarg:18,table_nam:[0,3,5,7,9,10,12,13,16,18],tableclaus:[3,5,18],tablenam:[0,9,12,13,16],tables_drop:13,tackl:12,tag:[1,7,12],tailor:[12,13],take:[1,3,7,9,10,12,13,16,18,19],taken:[0,10,12,18],talk:[0,16],target:[0,1,2,7,9,10,11,12,15,18,19],target_metadata:[0,7,9,10,12,13,16,18],task:[0,9],taylor:12,technic:6,techniqu:[0,5,12,13],tediou:[10,16],tell:[11,12,13,19],temp:10,templat:[0,1,2,5,7,8,9,12,13,19],template_arg:[7,12],temporari:[12,18],temptabl:12,tenanc:15,tenant:13,tend:12,term:[0,11,13,14,18,19],termin:12,termwidth:12,test:[0,8,9,11,12,15,16,19],test_autogener:12,test_render_fk_constraint_kwarg:12,text:[0,2,3,6,7,9,12,13,18],text_typ:12,textclaus:[3,5,18],textio:[2,7],textiowrapp:2,textual:[7,12,13],than:[1,3,7,8,9,11,12,13,14,15,18,19],thank:12,thei:[0,1,5,7,9,10,11,12,13,18,19],them:[0,7,9,10,11,12,13,16,17,18,19],themselv:[0,5,6,7,8,10,12,13,15,19],theodor:12,theoret:[12,19],theori:[13,19],therebi:12,therefor:[2,10,12,13,18],thereof:0,thi:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18,19],thing:[0,7,11,12,13,16,18,19],think:[11,13],third:[0,9,11,12],thoma:12,those:[2,3,7,8,9,10,11,12,13,14,16,18],though:[2,7,10,11,12,13,16,18,19],thoughtfulli:11,thousand:19,three:[0,12,13,19],through:[0,7,8,9,10,11,12,13,14,17],throughout:12,thu:[11,12],ticket:12,tiger:[13,19],tilmank:12,time:[0,5,7,9,10,11,12,13,16,17,19],timestamp:[12,17,18,19],timezon:[8,12,19],tinyint:[3,12],tname:0,to_constraint:3,to_writ:9,todo:18,togeth:[1,11,13,18,19],token0:3,token:[0,3,9,12,16,18,19],too:[11,12,13,16],tool:[9,10,12,13,14,15,19],toolkit:15,top:[9,11,12],topic:[9,16],topolog:11,tos:13,total:[8,19],tougher:13,toward:[7,9,11,12,13,18],tox:12,trace:12,track:[10,12],tracker:[12,14],tradit:[12,18],transact:[1,3,6,7,10,11,12,13,17,19],transaction_per_migr:[7,12],transactional_ddl:[3,7,12,17],transfer:[10,12],translat:12,transpar:12,travers:[0,8,11,12,13],treat:[1,7,11,12,13,17,18],treatment:12,tree:[11,12,13,19],tri:12,trigger:[0,12,13],trip:12,tripl:0,trivial:12,truncat:[12,19],truncate_slug_length:[8,12,19],tty:12,tue:12,tune:7,tupl:[0,3,7,8,11,12,13,18],turn:[2,7,10,11,12,18],tutori:[1,2,15],twice:12,twist:11,two:[0,1,3,5,7,9,11,12,13,16,17,18,19],txt:17,type:[0,2,3,5,7,12,13,15,16,18,19],type_:[0,3,5,7,9,10,12,13,18],type_arg_extract:3,type_obj:3,type_synonym:[3,9],typedecor:[9,12],typeengin:[0,3,5,7,18],typeerror:[12,13],typic:[3,6,7,8,9,10,11,12,13,16,18,19],typo:12,typograph:12,tz:[12,19],tzinfo:19,tzutc:19,u:[0,12,13],ultim:[0,6,7,9,12,13,18],un:[9,11],unaffect:12,unambigu:11,unchang:12,uncom:19,uncommon:12,uncondition:[7,10,12,19],undefin:[12,18],under:[7,9,12,14,18],underli:[2,7,18,19],underneath:11,underscor:12,understand:19,understood:[12,18],unfortun:13,unicod:[12,19],unicodetext:13,unimpl:12,union:[0,1,3,5,7,8,18],union_upd:12,uniqu:[5,7,9,12,13,15,16,18,19],unique_constraint:[7,12],uniqueconstraint:[0,3,7,9,10,12,13,16,18],unit:[6,12],unittest:12,univers:12,unknown:12,unless:[2,8,13,19],unlik:[1,10],unmerg:[7,8,12],unnam:[12,15,16,18],unnecessari:12,unnecessarili:12,unpredict:16,unreport:12,unsign:12,until:[11,12,13],untrust:18,unus:12,unusu:12,unvers:[12,19],unwant:[9,12],up:[0,3,4,6,7,10,12,15,16,17,19],up_or_down_op:0,up_revis:[11,13],up_revision_id:12,upcom:12,updat:[0,3,5,7,11,12,13,18],updated_at:13,upgrad:[0,1,2,5,6,7,9,10,11,12,13,16,17,18,19],upgrade_:12,upgrade_engine1:19,upgrade_engine2:19,upgrade_op:[0,5,7,12,13],upgrade_ops_list:[0,5],upgrade_token:[0,5,7,12],upgradeop:[0,5,7,12,13],upon:[0,1,6,7,8,9,10,11,12,13,17,19],upper:[8,18],uppercas:12,upstream:12,upward:11,uq:16,uq_:16,uq_const_x:16,uq_data:13,uq_user_account_nam:16,uq_user_nam:18,uri:[12,19],url:[2,7,12,13,17,19],us:[0,1,2,3,4,5,6,7,8,9,10,11,12,14,15,16,17,18,19],usabl:[12,13],usag:[0,1,2,3,7,10,12,14,15,16,18,19],use_alt:12,use_batch:13,usecas:15,user:[0,4,5,6,7,9,12,13,14,17,18,19],user_account:16,user_account_id:16,user_excl:18,user_id:18,user_module_prefix:[7,9,12],user_ord:16,user_order_id:16,user_order_user_account_id_fkei:16,user_properti:13,user_properties_ibfk_1:13,user_property_t:13,user_t:13,usernam:10,users_id:13,usual:[0,1,4,7,9,10,11,12,13,18,19],utc:19,utcnow:19,utf8:13,utf:[2,8,12,19],util:[2,7,8,9,12,13,19],uuid4:12,uuid:[7,9,12],valid:[12,19],valu:[0,2,7,9,11,12,13,16,17,18,19],van:12,varchar:[0,3,9,13,17,18],vari:7,variabl:[0,2,7,9,12,13,18,19],varianc:3,variant:12,varieti:[9,10,12,19],variou:[6,12,13,18,19],vast:[4,9,12,19],ve:[0,10,11,13,16,19],vendor:12,venv:[14,19],verbatim:2,verbos:[1,11,12,19],veri:[0,5,7,9,11,12,13,19],verifi:[12,18],versa:12,version:[1,3,6,7,8,9,10,12,13,14,15,18,19],version_fil:17,version_loc:[8,11,12,19],version_num:[11,12,13,17],version_path:[1,5,8],version_path_separ:[11,12,19],version_t:[7,12],version_table_pk:[7,12],version_table_schema:[7,12],versionchang:12,versu:[11,18],via:[0,1,2,3,5,7,9,10,12,17,18,19],vice:12,view:[0,9,11,12,15],virtual:[14,19],virtualenv:[14,19],visit_add_column:3,visit_column_com:3,visit_column_default:3,visit_column_nam:3,visit_column_nul:3,visit_column_typ:3,visit_computed_column:3,visit_drop_column:3,visit_identity_column:3,visit_rename_column:3,visit_rename_t:3,visual:6,vs:[9,10,12],vscode:12,w:[2,3,9,17],wa:[0,2,7,9,11,12,13,14,17,18,19],wai:[0,4,10,11,12,13,16,17,18,19],walk:13,walk_revis:8,want:[0,7,8,9,11,12,13,16,17,18,19],warn:[12,19],wasn:12,wb:12,we:[0,2,5,9,10,11,12,13,14,16,17,18,19],web:12,websit:12,wed:12,weed:12,week:12,welcom:12,well:[0,1,4,5,7,9,11,12,14,15,16,17,18,19],wendi:18,were:[2,7,9,10,11,12],weren:[11,12],what:[0,7,10,11,12,13,15,16,18,19],whatev:[0,2,9,19],wheel:12,when:[0,1,2,3,4,5,6,7,8,9,10,11,12,15,16,17,18,19],whenev:[10,19],where:[0,1,2,3,7,8,9,10,11,12,13,14,16,17,18,19],wherea:[7,9,12,13],wherebi:[10,12],whether:[0,1,7,8,9,10,12,18],which:[0,2,4,5,6,7,8,9,10,11,12,13,16,17,18,19],whichev:[11,13],whitelist:13,whitespac:12,who:[0,1,2,5,6,14],whole:[0,11,12,13,16,18],whose:[6,12],wide:[0,9,12,14],width:[0,12],wiki:12,wilk:12,william:18,window:12,wish:[0,1,2,5,6,7,11,13,16],with_stat:12,with_vari:12,within:[0,2,5,6,7,8,9,10,11,12,14,15,17,18,19],without:[0,2,7,9,10,11,12,13,14,17,18,19],won:12,word:[12,18],work:[0,1,2,7,9,12,13,14,15,16,17,18,19],workaround:[10,12,13,18],workflow:[10,12],world:4,wors:16,worth:16,would:[0,3,5,7,9,10,11,12,13,14,16,17,18,19],wouldn:12,wow:19,wrap:12,write:[1,4,12,13,15,16,19],write_hook:[8,9],writer1:0,writer2:0,writer:[0,13],written:[7,9,12,13,19],wrong:[12,16],wrongli:12,wrote:17,www:12,x:[0,7,10,12,13,16,18],xdist:12,xmin:12,xtenant:13,xxxxx:[11,19],xyz:[12,13],yaml:9,yap:12,year:[12,16,19],yet:[7,9,11,12,18,19],yield:[7,8,12,13],you:[2,7,8,9,11,12,13,14,16,19],your:[9,11,12,13,14,16,19],yourapp:[1,2,13,19],yourproject:19,yourself:12,zeidler:12,zero:[0,8,12],zhou:12,zhu:12,zimport:9,zone:17},titles:["Autogeneration","Commands","Configuration","DDL Internals","API Details","Operation Directives","Overview","Runtime Objects","Script Directory","Auto Generating Migrations","Running \u201cBatch\u201d Migrations for SQLite and Other Databases","Working with Branches","Changelog","Cookbook","Front Matter","Welcome to Alembic\u2019s documentation!","The Importance of Naming Constraints","Generating SQL Scripts (a.k.a. \u201cOffline Mode\u201d)","Operation Reference","Tutorial"],titleterms:{"0":12,"1":12,"10":12,"11":12,"2":12,"3":12,"4":12,"5":12,"6":12,"7":12,"8":12,"9":12,"boolean":10,"enum":10,"function":[0,9],"import":16,It:0,The:[7,13,16,19],With:13,across:13,affect:9,alemb:[13,15],all:11,an:[13,19],ani:13,api:[4,13],appli:[9,13],asyncio:13,auto:9,autogener:[0,9,10,13,16],base:[9,11],basic:9,batch:10,branch:11,bug:[12,14],build:13,built:5,call:0,chang:[10,12],changelog:12,check:10,code:[9,13],collect:9,column:13,command:[1,13],commun:14,compar:9,comparison:0,condit:13,configur:[2,9],connect:13,constraint:[10,16],context:7,control:[9,10],convent:16,cookbook:13,creat:[0,11,13,19],current:13,custom:[0,9,13,17],databas:[10,13],datatyp:10,date:13,ddl:3,deal:10,depend:[11,14],detail:4,detect:9,diff:0,direct:[0,5,13],directli:13,directori:[8,11],document:15,doe:9,don:13,downgrad:19,drop:[10,13],edit:19,element:13,emit:13,empti:13,engin:0,environ:[7,13,17,19],explicit:11,featur:12,file:[13,19],fine:0,first:19,foreign:10,formatt:9,from:[9,13],front:14,gener:[0,9,13,17],get:[0,17,19],grain:0,head:[11,13],histori:19,homepag:14,hook:[8,9],identifi:19,implicit:10,includ:10,index:13,indic:15,inform:19,ini:[13,19],initi:13,instal:14,integr:16,intern:3,k:17,kei:10,label:11,level:13,matter:14,mechan:11,merg:11,metadata:9,migrat:[7,9,10,13,17,19],misc:12,mode:[10,17],model:0,modul:9,more:[11,13],ms:3,multi:13,multipl:[0,9,11,13],mysql:3,name:[9,10,16],next:19,object:[0,5,7,9,13],offlin:[10,17],omit:9,onc:11,one:13,oper:[0,5,13,16,18],other:10,our:[0,19],overview:6,partial:19,particular:13,plugin:5,post:9,postgresql:[3,13],prefix:9,print:13,process:9,programmat:13,project:14,python:[9,13],rang:19,refer:[11,18],referenc:10,reflect:10,regist:0,rel:19,remov:12,render:[0,9],replac:13,revis:[0,8,9,11,13,19],rewrit:0,rudiment:13,run:[0,10,11,13,19],run_migr:0,runtim:7,s:[13,15],schema:[9,13],scratch:13,script:[8,17,19],second:19,set:11,share:13,sort:13,specif:11,sql:[3,17],sqlite:[3,10],start:17,statement:13,step:19,structur:13,support:17,syntax:11,t:13,tabl:[9,10,13,15],target:13,tenanc:13,test:13,than:10,themselv:9,track:0,tutori:19,type:[9,10],uniqu:10,unnam:10,up:[11,13],us:13,usecas:12,version:[11,17],view:[13,19],welcom:15,well:13,what:9,when:13,within:13,work:[10,11],write:[8,9,17]}})