Edit File: searchindex.js
Search.setIndex({envversion:46,filenames:["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"],objects:{"alembic.autogenerate":{compare_metadata:[0,1,1,""],produce_migrations:[0,1,1,""],render_python_code:[0,1,1,""]},"alembic.autogenerate.api":{AutogenContext:[0,2,1,""]},"alembic.autogenerate.api.AutogenContext":{connection:[0,5,1,""],dialect:[0,5,1,""],imports:[0,5,1,""],metadata:[0,5,1,""],migration_context:[0,5,1,""],run_filters:[0,3,1,""]},"alembic.autogenerate.rewriter":{Rewriter:[0,2,1,""]},"alembic.autogenerate.rewriter.Rewriter":{chain:[0,3,1,""],rewrites:[0,3,1,""]},"alembic.command":{branches:[1,1,1,""],current:[1,1,1,""],downgrade:[1,1,1,""],edit:[1,1,1,""],heads:[1,1,1,""],history:[1,1,1,""],init:[1,1,1,""],list_templates:[1,1,1,""],merge:[1,1,1,""],revision:[1,1,1,""],show:[1,1,1,""],stamp:[1,1,1,""],upgrade:[1,1,1,""]},"alembic.config":{Config:[2,2,1,""],main:[2,1,1,""]},"alembic.config.Config":{attributes:[2,5,1,""],cmd_opts:[2,5,1,""],config_file_name:[2,5,1,""],config_ini_section:[2,5,1,""],file_config:[2,5,1,""],get_main_option:[2,3,1,""],get_section:[2,3,1,""],get_section_option:[2,3,1,""],get_template_directory:[2,3,1,""],print_stdout:[2,3,1,""],set_main_option:[2,3,1,""],set_section_option:[2,3,1,""]},"alembic.ddl":{base:[3,0,0,"-"],impl:[3,0,0,"-"],mssql:[3,0,0,"-"],mysql:[3,0,0,"-"],postgresql:[3,0,0,"-"],sqlite:[3,0,0,"-"]},"alembic.ddl.base":{AddColumn:[3,2,1,""],AlterColumn:[3,2,1,""],AlterTable:[3,2,1,""],ColumnDefault:[3,2,1,""],ColumnName:[3,2,1,""],ColumnNullable:[3,2,1,""],ColumnType:[3,2,1,""],DropColumn:[3,2,1,""],RenameTable:[3,2,1,""],add_column:[3,1,1,""],alter_column:[3,1,1,""],alter_table:[3,1,1,""],drop_column:[3,1,1,""],format_column_name:[3,1,1,""],format_server_default:[3,1,1,""],format_table_name:[3,1,1,""],format_type:[3,1,1,""],quote_dotted:[3,1,1,""],visit_add_column:[3,1,1,""],visit_column_default:[3,1,1,""],visit_column_name:[3,1,1,""],visit_column_nullable:[3,1,1,""],visit_column_type:[3,1,1,""],visit_drop_column:[3,1,1,""],visit_rename_table:[3,1,1,""]},"alembic.ddl.impl":{DefaultImpl:[3,2,1,""],ImplMeta:[3,2,1,""]},"alembic.ddl.impl.DefaultImpl":{add_column:[3,3,1,""],add_constraint:[3,3,1,""],alter_column:[3,3,1,""],autogen_column_reflect:[3,3,1,""],bind:[3,5,1,""],bulk_insert:[3,3,1,""],command_terminator:[3,5,1,""],compare_server_default:[3,3,1,""],compare_type:[3,3,1,""],correct_for_autogen_constraints:[3,3,1,""],correct_for_autogen_foreignkeys:[3,3,1,""],create_index:[3,3,1,""],create_table:[3,3,1,""],drop_column:[3,3,1,""],drop_constraint:[3,3,1,""],drop_index:[3,3,1,""],drop_table:[3,3,1,""],emit_begin:[3,3,1,""],emit_commit:[3,3,1,""],execute:[3,3,1,""],get_by_dialect:[3,4,1,""],prep_table_for_batch:[3,3,1,""],rename_table:[3,3,1,""],requires_recreate_in_batch:[3,3,1,""],start_migrations:[3,3,1,""],static_output:[3,3,1,""],transactional_ddl:[3,5,1,""]},"alembic.ddl.mssql":{MSSQLImpl:[3,2,1,""],mssql_add_column:[3,1,1,""],visit_add_column:[3,1,1,""],visit_column_default:[3,1,1,""],visit_column_nullable:[3,1,1,""],visit_column_type:[3,1,1,""],visit_rename_column:[3,1,1,""],visit_rename_table:[3,1,1,""]},"alembic.ddl.mssql.MSSQLImpl":{alter_column:[3,3,1,""],batch_separator:[3,5,1,""],bulk_insert:[3,3,1,""],drop_column:[3,3,1,""],emit_begin:[3,3,1,""],emit_commit:[3,3,1,""],transactional_ddl:[3,5,1,""]},"alembic.ddl.mysql":{MySQLAlterDefault:[3,2,1,""],MySQLChangeColumn:[3,2,1,""],MySQLImpl:[3,2,1,""],MySQLModifyColumn:[3,2,1,""]},"alembic.ddl.mysql.MySQLImpl":{alter_column:[3,3,1,""],compare_server_default:[3,3,1,""],correct_for_autogen_constraints:[3,3,1,""],correct_for_autogen_foreignkeys:[3,3,1,""],transactional_ddl:[3,5,1,""]},"alembic.ddl.postgresql":{PostgresqlImpl:[3,2,1,""],visit_rename_table:[3,1,1,""]},"alembic.ddl.postgresql.PostgresqlImpl":{autogen_column_reflect:[3,3,1,""],compare_server_default:[3,3,1,""],correct_for_autogen_constraints:[3,3,1,""],prep_table_for_batch:[3,3,1,""],transactional_ddl:[3,5,1,""]},"alembic.ddl.sqlite":{SQLiteImpl:[3,2,1,""]},"alembic.ddl.sqlite.SQLiteImpl":{add_constraint:[3,3,1,""],compare_server_default:[3,3,1,""],correct_for_autogen_constraints:[3,3,1,""],drop_constraint:[3,3,1,""],requires_recreate_in_batch:[3,3,1,""],transactional_ddl:[3,5,1,""]},"alembic.operations":{BatchOperations:[18,2,1,""],MigrateOperation:[18,2,1,""],Operations:[18,2,1,""],ops:[5,0,0,"-"]},"alembic.operations.BatchOperations":{add_column:[18,3,1,""],alter_column:[18,3,1,""],create_check_constraint:[18,3,1,""],create_foreign_key:[18,3,1,""],create_index:[18,3,1,""],create_primary_key:[18,3,1,""],create_unique_constraint:[18,3,1,""],drop_column:[18,3,1,""],drop_constraint:[18,3,1,""],drop_index:[18,3,1,""]},"alembic.operations.MigrateOperation":{info:[18,5,1,""]},"alembic.operations.Operations":{add_column:[18,3,1,""],alter_column:[18,3,1,""],batch_alter_table:[18,3,1,""],bulk_insert:[18,3,1,""],create_check_constraint:[18,3,1,""],create_foreign_key:[18,3,1,""],create_index:[18,3,1,""],create_primary_key:[18,3,1,""],create_table:[18,3,1,""],create_unique_constraint:[18,3,1,""],drop_column:[18,3,1,""],drop_constraint:[18,3,1,""],drop_index:[18,3,1,""],drop_table:[18,3,1,""],execute:[18,3,1,""],f:[18,3,1,""],get_bind:[18,3,1,""],get_context:[18,3,1,""],implementation_for:[18,4,1,""],inline_literal:[18,3,1,""],invoke:[18,3,1,""],register_operation:[18,4,1,""],rename_table:[18,3,1,""]},"alembic.operations.ops":{AddColumnOp:[5,2,1,""],AddConstraintOp:[5,2,1,""],AlterColumnOp:[5,2,1,""],AlterTableOp:[5,2,1,""],BulkInsertOp:[5,2,1,""],CreateCheckConstraintOp:[5,2,1,""],CreateForeignKeyOp:[5,2,1,""],CreateIndexOp:[5,2,1,""],CreatePrimaryKeyOp:[5,2,1,""],CreateTableOp:[5,2,1,""],CreateUniqueConstraintOp:[5,2,1,""],DowngradeOps:[5,2,1,""],DropColumnOp:[5,2,1,""],DropConstraintOp:[5,2,1,""],DropIndexOp:[5,2,1,""],DropTableOp:[5,2,1,""],ExecuteSQLOp:[5,2,1,""],MigrateOperation:[5,2,1,""],MigrationScript:[5,2,1,""],ModifyTableOps:[5,2,1,""],OpContainer:[5,2,1,""],RenameTableOp:[5,2,1,""],UpgradeOps:[5,2,1,""]},"alembic.operations.ops.AddColumnOp":{add_column:[5,4,1,""],batch_add_column:[5,4,1,""]},"alembic.operations.ops.AlterColumnOp":{alter_column:[5,4,1,""],batch_alter_column:[5,4,1,""]},"alembic.operations.ops.BulkInsertOp":{bulk_insert:[5,4,1,""]},"alembic.operations.ops.CreateCheckConstraintOp":{batch_create_check_constraint:[5,4,1,""],create_check_constraint:[5,4,1,""]},"alembic.operations.ops.CreateForeignKeyOp":{batch_create_foreign_key:[5,4,1,""],create_foreign_key:[5,4,1,""]},"alembic.operations.ops.CreateIndexOp":{batch_create_index:[5,4,1,""],create_index:[5,4,1,""]},"alembic.operations.ops.CreatePrimaryKeyOp":{batch_create_primary_key:[5,4,1,""],create_primary_key:[5,4,1,""]},"alembic.operations.ops.CreateTableOp":{create_table:[5,4,1,""]},"alembic.operations.ops.CreateUniqueConstraintOp":{batch_create_unique_constraint:[5,4,1,""],create_unique_constraint:[5,4,1,""]},"alembic.operations.ops.DropColumnOp":{batch_drop_column:[5,4,1,""],drop_column:[5,4,1,""]},"alembic.operations.ops.DropConstraintOp":{batch_drop_constraint:[5,4,1,""],drop_constraint:[5,4,1,""]},"alembic.operations.ops.DropIndexOp":{batch_drop_index:[5,4,1,""],drop_index:[5,4,1,""]},"alembic.operations.ops.DropTableOp":{drop_table:[5,4,1,""]},"alembic.operations.ops.ExecuteSQLOp":{execute:[5,4,1,""]},"alembic.operations.ops.MigrateOperation":{info:[5,5,1,""]},"alembic.operations.ops.MigrationScript":{downgrade_ops:[5,5,1,""],downgrade_ops_list:[5,5,1,""],upgrade_ops:[5,5,1,""],upgrade_ops_list:[5,5,1,""]},"alembic.operations.ops.RenameTableOp":{rename_table:[5,4,1,""]},"alembic.runtime":{environment:[7,0,0,"-"],migration:[7,0,0,"-"]},"alembic.runtime.environment":{EnvironmentContext:[7,2,1,""]},"alembic.runtime.environment.EnvironmentContext":{begin_transaction:[7,3,1,""],config:[7,5,1,""],configure:[7,3,1,""],execute:[7,3,1,""],get_bind:[7,3,1,""],get_context:[7,3,1,""],get_head_revision:[7,3,1,""],get_head_revisions:[7,3,1,""],get_revision_argument:[7,3,1,""],get_starting_revision_argument:[7,3,1,""],get_tag_argument:[7,3,1,""],get_x_argument:[7,3,1,""],is_offline_mode:[7,3,1,""],is_transactional_ddl:[7,3,1,""],run_migrations:[7,3,1,""],script:[7,5,1,""],static_output:[7,3,1,""]},"alembic.runtime.migration":{MigrationContext:[7,2,1,""]},"alembic.runtime.migration.MigrationContext":{bind:[7,5,1,""],config:[7,5,1,""],configure:[7,4,1,""],execute:[7,3,1,""],get_current_heads:[7,3,1,""],get_current_revision:[7,3,1,""],run_migrations:[7,3,1,""],stamp:[7,3,1,""]},"alembic.script":{Script:[8,2,1,""],ScriptDirectory:[8,2,1,""],revision:[8,0,0,"-"]},"alembic.script.Script":{doc:[8,5,1,""],longdoc:[8,5,1,""]},"alembic.script.ScriptDirectory":{as_revision_number:[8,3,1,""],from_config:[8,4,1,""],generate_revision:[8,3,1,""],get_base:[8,3,1,""],get_bases:[8,3,1,""],get_current_head:[8,3,1,""],get_heads:[8,3,1,""],get_revision:[8,3,1,""],get_revisions:[8,3,1,""],iterate_revisions:[8,3,1,""],run_env:[8,3,1,""],walk_revisions:[8,3,1,""]},"alembic.script.revision":{Revision:[8,2,1,""],RevisionMap:[8,2,1,""]},"alembic.script.revision.Revision":{branch_labels:[8,5,1,""],dependencies:[8,5,1,""],down_revision:[8,5,1,""],is_base:[8,5,1,""],is_branch_point:[8,5,1,""],is_head:[8,5,1,""],is_merge_point:[8,5,1,""],nextrev:[8,5,1,""],revision:[8,5,1,""]},"alembic.script.revision.RevisionMap":{add_revision:[8,3,1,""],bases:[8,5,1,""],get_current_head:[8,3,1,""],get_revision:[8,3,1,""],get_revisions:[8,3,1,""],heads:[8,5,1,""],iterate_revisions:[8,3,1,""]},alembic:{command:[1,0,0,"-"],config:[2,0,0,"-"],ddl:[3,0,0,"-"],operations:[18,0,0,"-"],script:[8,0,0,"-"]}},objnames:{"0":["py","module","Python module"],"1":["py","function","Python function"],"2":["py","class","Python class"],"3":["py","method","Python method"],"4":["py","classmethod","Python class method"],"5":["py","attribute","Python attribute"]},objtypes:{"0":"py:module","1":"py:function","2":"py:class","3":"py:method","4":"py:classmethod","5":"py:attribute"},terms:{"109e":11,"109ec7d132bf":11,"109ec7d132bf_add_ip_number_t":11,"10g":16,"191a2d20b025":13,"1975ea83b712":[11,17,19],"1975ea83b712_add_account_t":[11,19],"1975ea83b712_create_accoun":19,"1975ea83b712_create_account_t":19,"199028bf9856":13,"27c":11,"27c6":11,"27c6a":11,"27c6a30d7c24":[9,11],"27c6a30d7c24_add_shopping_cart_t":11,"28af9800143":13,"28af9800143f":13,"290696571ad2":13,"29f8":11,"29f859a13ea":11,"2a95":11,"2a95102259b":11,"2a95102259be_add_ip_account_t":11,"2b1ae634e5cd_add_order_id":19,"2to3":12,"34e094ad6ef1":11,"34e094ad6ef1_more_account_chang":11,"3512b954651e_add_account":19,"3ab8b2dfb055":13,"3adcc9a56557_rename_username_field":19,"3ba2b522d10d":13,"3cac04ae8714":11,"3cac04ae8714_create_networking_branch":11,"3rd":12,"53fffde5ad5":11,"53fffde5ad5_merge_ae1_and_27c":11,"55af":11,"55af2cb":11,"55af2cb1c267":11,"55af2cb1c267_add_another_account_column":11,"\u0142ukasz":12,"__doc__":12,"__future__":12,"__init__":[5,12,13],"__module__":[7,9,12],"__pycache__":12,"__repr__":9,"_alembic_batch_temp":10,"_branch":11,"_exec":12,"_get_object_from_vers":13,"_orig_column":5,"_orig_constraint":5,"_orig_index":5,"_orig_t":5,"_replac":8,"bo\u0142di":12,"boolean":[10,12,16,18],"break":[11,18],"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,16,17,18,19],"enum":[9,10,12,18],"final":[10,12,13],"float":12,"import":[0,1,2,5,7,8,9,11,12,13,15],"long":[9,10,11,12,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,18],"return":[0,2,3,5,7,8,9,10,12,13,18,19],"short":12,"static":12,"switch":13,"true":[0,3,5,7,8,9,10,12,13,16,18,19],"try":[11,12,17],"while":[0,3,8,10,11,12,13,16,17,18,19],abil:[0,19],abl:[0,4,8,13,16],about:[0,7,11,12,14,16,19],abov:[0,5,7,9,10,11,13,14,16,18,19],abramowitz:12,absenc:17,absens:10,absolut:[12,19],accept:[1,7,9,10,12,13,17,18,19],access:[0,2,5,6,7,8,9,10,12,13,17],accessor:12,accommod:[0,10,12],accomod:9,accompani:[12,18],accomplish:17,accord:[12,18],account:[9,11,12,17,18,19],account_id:18,account_t:18,accounts_t:18,accur:9,accuraci:7,achiev:[1,9,11],across:[7,10,11,12,18],act:[7,13,18],action:[12,13,18],activ:13,actual:[0,2,5,6,7,8,9,11,12,13,17,18],acycl:11,adapt:12,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:5,addit:[0,2,7,8,9,11,12,13,14,18,19],addition:[5,9,10,12],address:[10,18],adjust:[0,9,10,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],after:[0,11,12,13],after_parent_attach:[9,16],afterward:[10,12],again:[0,9,10,11,12,13,16,19],against:[0,5,7,8,9,10,11,12,17,18,19],agnost:12,ago:19,aim:0,albeit:19,albert:12,alemb:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14],alembic_cfg:[1,2,13],alembic_module_prefix:[0,7,12],alembic_revis:12,alembic_vers:[7,11,12,13,17,19],alexand:12,algorithm:[11,12],alia:11,all:[0,1,2,5,6,7,8,9,10],all_conn_sequ:0,all_constraint:16,allow:[0,2,3,5,7,8,9,10,11,12,13,17,18,19],almost:[10,11,12],alon:[10,11,12],along:[0,1,5,7,10,11,12,13,18,19],alongsid:12,alpha:12,alphanumer:16,alreadi:[0,2,3,9,10,11,12,13,16,18],also:[0,2,5,6,7,8,9,10,11,12,13,16,17,18,19],alter:[0,3,5,6,7,9,10,11,12,13,16,17,18],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,alwai:[0,5,9,10,11,12,13,14,17,18],among:[11,12],ancestor:[11,12],andrea:12,andrei:12,ani:[0,1,2,3,7,8,9,10,11,12,13,16,17,18,19],ann:12,anonym:[9,18],anoth:[0,6,10,11,12,19],anscestor:11,anticip:12,antukh:12,anyth:[0,2,18,19],anywai:19,anywher:[13,19],api:[0,1,2,3],appar:12,append:[0,7,12],append_constraint:12,appli:[5,7,8,9,10,11,12,13,16,18,19],applic:[1,4,6,7,9,10,11,12,13,16,18,19],appopri:16,approach:[0,10,12,13,19],appropri:[0,6,7,8,9,11,12,18],apr:12,arbitrari:[2,5,12,18],architectur:10,area:[0,9,19],aren:[9,10,11,12,18],arg:[2,3,8,18,19],argnam:18,argpars:[7,12],argument:[0,1,5,7,8,9,10,11,12,13,18,19],argv:2,aris:[10,12],aros:12,around:12,arrai:12,as_dictionari:[7,13],as_revision_numb:8,as_sql:[3,7],ascend:19,ascii:12,ask:[11,12],aspect:[7,12,13,18],assert:12,assert_relative_length:8,assign:[10,11,16],assist:[7,8,12,18],associ:[0,11,12,14,16,18],assum:[0,11,12,13,16,17,19],atsushi:12,attach:[0,3,9,13],attempt:[10,11,12,18],attribut:[0,1,2,5,7,9,11,12,13],attributeerror:12,aug:12,august:12,author:12,auto:[0,7],auto_incr:[12,18],autodetect:12,autogen:[7,9,12],autogen_column_reflect:3,autogen_context:[0,7,9],autogencontext:[0,9,12],autogenerer:9,autogenrendertest:12,autoincr:[3,12,18],autoload:10,autom:[10,12,16,18],automat:[9,10,11,12,18,19],avail:[0,1,2,5,7,9,12,13,14,18,19],avoid:0,awai:0,awkward:12,axel:12,back:[0,7,8,11,12,13,19],backend:[0,3,6,7,9,10,12,16,18],background:9,backward:12,bad:9,badli:12,bagnoli:12,bar:[0,2,10,18,19],bartosz:12,base:[0,2,3,5,6,7,8,9],basemost:11,basi:[5,8,12,14],basic:[0,2,8,9,11,12,13,17,18,19],bat:[0,19],batch:[3,5,7],batch_add_column:5,batch_alter_column:5,batch_alter_t:[7,10,12,18],batch_create_check_constraint:5,batch_create_foreign_kei:5,batch_create_index:5,batch_create_primary_kei:5,batch_create_unique_constraint:5,batch_drop_column:5,batch_drop_constraint:5,batch_drop_index:5,batch_op:[3,10,12,18],batch_separ:3,batchoper:[5,10,12,18],batchoperationsimpl:3,bayer:14,beafc7d709f:0,becaus:[0,9,10,11,12],becom:[11,13],been:[6,7,11,12,16,18],befor:[2,3,10,11,12,13,18,19],began:11,begin:[1,2,3,7,10,12,13,17,18,19],begin_transact:[0,3,7,9,13],behav:10,behavior:[0,3,5,6,7,9,10,12,18],behind:[12,16],belong:12,below:[0,5,10,12,13,17],besid:11,best:[11,16],beta:[10,11,12,14],better:[12,16],between:[0,7,9,10,11,12,13,14,19],beyond:16,bflag:10,big:12,bigint:12,bigseri:12,bind:[0,3,7,18],binet:12,bit:[7,12],bitbucket:[12,14],blank:[0,13],block:[10,18],blown:[7,12],blume:12,board:10,bog:12,boilerpl:0,bolt:7,bool:18,both:[11,12,13,16,17,18],bottom:17,bound:[7,12,18],box:6,branch:[0,1,7,8],branch_label:[1,5,8,11,13,19],branchnam:11,branchpoint:[8,11],brief:18,bring:11,broken:[12,17],brokenpipeerror:12,bruno:12,brycelohr:12,buffer:[2,7],bug:3,bugtrack:12,build:[0,3,5,9,11,12],built:[0,1,4],bulk:[3,5,12,18],bulk_insert:[3,5,12,13,18],bulkinsertop:5,burclaf:12,bypass:[10,18],calcul:[7,19],callabl:[7,8,9,12],can:[0,1,2,3,4,5,7,8,9,10,11,12,13,16,17,18,19],candid:[7,9,12],cannot:[7,9,10,11,12,18],capabl:[0,1,2,5,6,7,12,13,17,19],care:[0,14],carefulli:[11,19],carlo:12,cart:11,cascad:18,cast:12,catalog:16,catalogu:13,caus:12,caveat:[7,10,18],center:9,certain:[0,7,13],certainli:16,cfg:13,chain:0,challeng:[9,10,11,17],chanc:[0,7],chang:[0,5,7,8,9,10,11],changeset:1,charact:[8,12,18,19],charl:12,check:[5,7,9],check_constraint:18,checkconstraint:[10,12,16,18],choic:0,choos:11,chri:12,christian:12,chronolog:1,circumst:18,ck_:16,ck_bool_:18,ck_bool_t_x:18,ck_sometable_q_bool:16,ck_user_name_len:18,classmethod:[3,5,7,8,13,18],classnam:3,claus:18,clean:[11,12,19],clear:[11,12,13],clearer:12,client:17,close:[11,12,13],cmd_line_url:7,cmd_opt:[2,7,12,13],cname:0,code:[0,5,6,9,11,12,13,14,16,19],col1:9,col2:9,col:[7,13,18],collect:[0,6,7,8,12,13,18],colon:[12,19],column:[0,3,5,7,9,10,11,12,13,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],columndefault:3,columnnam:3,columnnul:3,columntyp:3,combin:[0,9,11,12,18],come:[8,9,12,13],command:0,command_termin:3,commanderror:[7,12],commandlin:[12,13],comment:[7,9,12,19],commit:[3,7,12,13,17],common:[11,13],commonli:[0,12],commun:[5,6],compar:[0,7],compare_against_backend:[9,12],compare_column_level:0,compare_metadata:[0,12],compare_schema_level:0,compare_sequ:0,compare_server_default:[3,7,9],compare_table_level:0,compare_to:[0,7],compare_typ:[3,7,9],compat:[7,9,10,12,18],compatib:12,compil:[3,5,7,12],complement:12,complet:[0,7,10,12,16],complex:12,complic:16,compon:[12,19],compos:19,composit:12,comprehens:[5,9],concept:11,concern:10,condit:[5,12],config:[1,2,6,7,8,9,12,13,17,19],config_arg:[2,12],config_file_nam:[2,17],config_ini_sect:[2,7,9,13],configpars:[2,19],configur:0,conflict:[10,12],confus:[11,12],conjunct:[6,9,12,18],conn:[7,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],conrelid:16,consid:[0,7,8,10,11,12,13,18],consider:12,consist:[0,12,18],consol:[2,19],constraint:[0,3,5,7,9],constraint_nam:[5,12,16,18],constraint_typ:16,construct:[0,1,2,3,5,7,8,9,12,13,18],constructor:[2,9],consult:[0,7,9],consum:[1,12,13,19],consumpt:7,contain:[0,5,6,7,8,9,11,12,18,19],content:[0,7],context:[0,2,3,4],context_opt:3,contextu:[7,12],continu:[9,11,12,13,19],control:7,contyp:16,convei:6,conveni:[0,9,11,16],convent:[10,12,15],convert:[0,7,8,12,16,18],cookbook:12,coomber:12,cooper:12,copi:[2,3,10,12,13,18],copy_from:[10,12,18],correct:[0,9,10,12,19],correct_for_autogen_constraint:3,correct_for_autogen_foreignkei:3,correctli:12,correspond:[0,5,10,12,18],could:[0,9,11,12,13,19],count:12,cours:[0,7,9,11,18],courtesi:12,cover:[11,12],crazi:11,create_al:[7,13],create_check_constraint:[5,12,18],create_constraint:10,create_d:[13,18],create_engin:[0,7,12],create_foreign_kei:[0,5,12,18],create_index:[3,5,12,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_unique_constraint:[5,12,16,18],create_view:13,createcheckconstraintop:5,createforeignkeyop:[0,5],createindexop:[0,5],createprimarykeyop:5,createsequenceop:[0,5],createspop:13,createtableop:[0,5],createuniqueconstraintop:5,createviewop:13,creation:[5,12,19],critic:[9,12,17],cross:[11,12],crud:18,ctx:18,cumbersom:9,current:[0,1,3,5,7,8,9,10,11,12,14,17,18,19],current_rev:7,current_vers:17,cursor:18,customari:7,customer_view:13,customiz:[0,19],cycl:12,d747:11,d747a8a8879:11,d747a8a8879_add_a_shopping_cart_column:11,d747a:11,dai:[12,19],danjou:12,data:[0,9,10,12,13,18],data_downgrad:13,data_upgrad:13,databas:[0,1,3,5,6,7,8,9],databs:0,datamemb:[9,18],datatyp:[0,7,9,18],date:[7,9,11,12],datefmt:19,datetim:[9,18,19],david:12,db1:17,db2:17,db_1:17,db_2:17,dba:[12,17],dbapi:[12,18],dbname:[7,19],ddl:0,ddlelement:3,ddlevent:9,deal:[0,5],debug:0,dec:12,decemb:12,decim:[12,19],decis:12,declar:9,decod:12,decor:[0,5,12],dedup:12,deep:12,deepli:12,def:[0,5,7,9,10,11,12,13,16,17,19],default_constraint:18,default_schema_nam:0,defaultclaus:18,defaultimpl:[3,6,7],defens:12,defer:12,deferr:[5,12,18],defin:[0,5,7,8,9,12,13,16,18],definit:[9,10,13,18],degre:[0,12,18],dein:12,delet:[11,12,13,18],deliv:[0,5,12],delta:[11,19],demarc:[6,7],demonstr:13,denot:[1,7,16],depend:[7,8,9],depends_on:[1,5,8,11,12,13],deprec:[7,8,12],derek:12,deriv:[7,18,19],desc:12,descend:[5,11],describ:[5,7,10,11,12,17,18,19],descript:[9,12,17,18,19],design:[17,18,19],desir:[9,10,11,12,19],destin:[0,7,18],destination_rev:7,detail:[0,1],determin:[0,7,8,9,12,13,17,19],dev:12,develop:[0,1,2,5,6,11,14,19],devis:13,dialect:[0,2,3,7,9,10,12,18],dialect_kw:[5,18],dialect_nam:[7,17],dialectnam:18,diamond:11,dict:10,dict_:3,dictionari:[0,1,2,5,7,12,13,16,18],did:[9,11],didn:[11,12],differ:[0,2,3,5,7,9,10,11,12,17,19],differenti:12,difficult:12,dimitri:12,dir:8,directli:[0,1,2,5,7,9,10,11,12,13,18,19],directori:[1,2,4,7],dirnam:17,disabl:[5,7,10,12],disadvantag:16,disambigu:18,discrep:11,discuss:[0,1,2,4,5,11,14],dispar:12,dispatch_for:0,displai:[1,11,19],distinct:[0,11,12,18],distinguish:12,distribut:14,diverg:11,doc:[8,12],docstr:[8,12],document:[0,1,2,5,7,9,12,14],doe:[0,3,5,6,7],doesn:[2,7,9,10,11,12,13,16],don:[0,1,11,12],done:[0,7,9,10,11,12,19],dot:[3,12,13],doubl:[0,12],down:[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],downgrade_ops_list:[0,5],downgrade_token:[0,5,7,12],downgradeop:[0,5,7,12],downsid:12,draw:19,driven:12,driver:[12,19],drop:[3,5,9],drop_column:[0,3,5,10,12,13,18,19],drop_constraint:[0,3,5,10,12,16,18],drop_index:[3,5,12,18],drop_old:13,drop_sequ:[0,5],drop_sp:13,drop_tabl:[0,3,5,9,12,13,18,19],drop_view:13,dropcolumn:3,dropcolumnop:[0,5],dropconstraintop:[0,5],dropindexop:5,dropsequenceop:[0,5],dropspop:13,droptableop:[0,5],dropviewop:13,due:[8,12],dummi:12,dump:[12,17,19],duplic:12,dure:[3,6,7,12,13,18,19],dynam:[5,18],each:[0,6,7,8,11,12,16,17,18,19],earli:12,earlier:11,earliest:13,easi:[0,13,16,17],easier:[0,19],easiest:3,easili:13,eced083f5df:0,edit:[1,9,11,12,13,15,16],editor:[1,12],effect:[7,11,12,13,16,18],effort:[12,16],egg:19,either:[0,7,9,11,12,13,18,19],elect:3,element:[0,3,5,6,7,12],elif:13,els:[0,2,5,7,8,9,10,12,13,17,18,19],email:13,embed:12,emit:[3,7,10,11,12,13,16,18],emit_begin:[3,7],emit_commit:[3,7],emit_ev:12,emphasi:[10,11,12],empti:[0,7,8,9,12],enabl:[7,9,10,12,17,18],encapsul:8,enclos:7,encod:[7,12,19],encount:[0,5,9],encourag:[12,17],encourgag:16,end:[0,4,5,6,7,8,9,11,12,13,17,18,19],end_vers:17,endpoint:[8,11],enforc:10,engine1:0,engine1_downgrad:0,engine1_upgrad:0,engine2:0,engine2_downgrad:0,engine2_upgrad:0,engine_from_config:[7,9,13],engine_nam:0,enhanc:[12,14],enorm:[12,18],enough:[9,16],ensur:[0,9,11,12,14,16,18],enter:10,entir:[3,8,10,12,13,16,18,19],entireti:12,entri:[0,11],entrypoint:3,env:[0,1,2,4,5,6,7,8,9,10,12,13,16,17,18,19],enviro:19,enviromn:19,environ:[0,1,2,4,6],environment_context:7,environmentcontext:[0,2,3,4,6,7,9,10,12,13,17,18],equal:[11,18],equival:[3,7,9,12],eras:0,erdfelt:12,err:12,erron:12,error:[8,9,11,12,17,19],escap:12,especi:11,essenti:[0,10],establish:[0,5,7,9,11,12],etc:[0,7,12,18],evalu:12,even:[10,11,12,13,16,18,19],event:[3,9,10,12,16,18],eventu:9,ever:0,everi:[0,12,13,16,19],everyth:[12,19],exact:[12,19],exactli:[8,18],examin:0,exampl:[0,1,5,7,9,10,11,13,16,17,18,19],exceedingli:12,except:[7,8,9,10,11,12,13,17,18],exclud:12,exclus:[6,8],exec:[12,18],execut:[0,3,5,7,12,13,17,18],executemani:18,executesqlop:5,execution_opt:[3,5,7,12,18],exist:[0,2,7,8,10,11,12,13,17,18,19],existing_autoincr:[3,18],existing_nul:[3,5,18],existing_server_default:[0,3,5,12,18],existing_typ:[0,3,5,10,12,18],exit:12,expand:12,expect:[7,10,11,12,14],explcitli:9,explicit:0,explicitli:[0,9,10,11,12,19],expos:[4,7],express:[7,9,12,16,18],extend:[0,1,2,4,5,6,7,13],extens:[0,3,5,6,12,13,18],extern:[12,18],extra:[10,12,13],fa4456a9201:11,fa445:11,fabric:10,facad:[6,7],face:8,facilit:[12,18],fact:[11,12,19],factori:7,fail:[10,11,12],failur:12,fairli:14,faithfulli:9,fals:[0,1,3,5,7,8,9,10,12,17,18,19],familiar:11,far:[10,12],fashion:12,favor:9,fcntl:12,feasibl:1,featur:[0,1,6,7,9,10,11],februari:12,few:[9,10,11,19],field:[12,13,19],figur:[6,16],file:[0,1,2,5,6,7,8,9,10,11,12,13,15,17,18],file_:[2,17],file_config:2,file_templ:[8,12,19],fileconfig:19,filenam:[2,7,12,19],filesystem:[2,8,19],filter:[0,7,12],find:19,finish:[9,13],fire:18,firebird:12,first:[0,1,2,5,7,9,10,11,12,13,15,16,17,18],fit:0,fix:[7,9,12,18],fk_:[10,16],fk_bar_foo_id_foo:10,fk_user_address:18,fk_user_order_id:16,flag:[0,2,6,7,10,12,13,16,17,18,19],flat:10,flexibl:12,floer:12,focu:12,folder:19,follow:[0,2,6,7,8,10,11,13,16,18,19],foo:[0,2,9,10,11,12,13,18],forc:[7,12,18],forego:16,foreign:[5,7,9],foreign_kei:[7,18],foreign_key_column:18,foreign_key_constraint:7,foreignkeconstraint:12,foreignkei:[10,12,16,18],foreignkeyconstraint:[7,10,12,18],forest:11,form:[0,8,12,18],format:[0,7,11,12,13,19],format_column_nam:3,format_server_default:3,format_table_nam:3,format_typ:3,formatt:19,formatter_:19,formatter_gener:19,forth:11,forward:[7,12],found:[2,7],four:12,fragment:0,free:[9,19],freeli:[7,11],fresh:[11,13],fri:12,from:[0,1,2,3,5,7,8,9,10,11,12],from_config:[7,8],front:[7,12],frozenbal:12,frozenset:8,frustratingli:10,full:[0,3,7,8,10,11,12,13,18,19],fulli:[8,9,10,11,12,13,18,19],func:[12,18],fundament:[0,12],further:[12,17,18],futur:[7,12],gain:0,gatewai:[6,10],gather:[3,12],gave:11,genener:12,generate_revis:[8,12],get_bas:[8,12],get_bind:[7,18],get_by_dialect:3,get_column:7,get_context:[7,13,18],get_current_head:[7,8,12],get_current_revis:[7,12],get_head:[8,12],get_head_revis:7,get_main_opt:2,get_revis:[8,13],get_revision_argu:[7,17],get_schema_nam:[7,12],get_sect:[2,7,9,13],get_section_opt:2,get_starting_revision_argu:[7,12],get_tag_argu:7,get_template_directori:2,get_unique_constraint:12,get_x_argu:[2,7,12,13],getattr:13,giacomo:12,gilcreas:12,git:[12,14],github:12,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],goe:12,gone:10,good:[0,1,7,16,19],googl:14,granular:12,graph:[11,12],great:[11,12],greater:[11,12,18],greatest:18,group:[7,14,18],grow:0,grown:4,guarante:11,guess:9,guid:19,guidanc:[5,9],guidelin:0,hack:17,hackeri:12,had:[11,12,18,19],hand:[9,12,17,19],handl:[0,5,7,12,18],handler:[0,7,19],handler_:19,handler_consol:19,hardcod:12,harland:12,hasn:[9,12],have:[0,7,8,9,10,11,12,13,16,17,18,19],head:[0,1,2,5,7,8],head_onli:[1,12],head_revis:8,header:19,heavi:[12,19],help:[9,12,13],helper:[0,7],henc:[11,12],here:[0,2,3,4,7,8,9,10,11,12,13,14,16,18,19],hex:7,hierarchi:12,high:18,higher:[3,12],highli:12,highlight:13,hint:[11,16],histori:[1,8,11,12,15],hoc:[7,18],hold:[12,19],hole:18,home:19,hong:12,honor:12,hook:[0,3,7,9,12,13],hope:13,host:[7,12,14],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,14,16,18],http:[3,12,14],huge:12,hundr:13,hypothet:13,ibrahim:12,id_:8,idea:[1,9,13,16,19],ident:[3,12,13],identif:12,identifi:[0,7,8,9,10,11,12,13,15,18],idx_op:0,ignor:[7,12],ijl:12,ik_test:18,illustr:[0,5,11,13,17,19],immedi:[12,18],immutabledict:2,impact:[11,12],impl:[3,11,12,13,18],implement:[0,3,5,6,7,9,10,12,13,14,18],implementation_for:[5,13,18],impli:9,implicit:[10,12,13],implicit_bas:8,implicitli:12,implmeta:3,imposs:11,improv:12,in_nam:13,in_order_count:13,inadvert:12,inappropri:12,incept:12,includ:[0,2,3,5,7,8,9],include_object:[0,7,12],include_schema:[7,12],include_symbol:[0,7,12],inclus:8,incompat:[11,12],inconsist:10,incorrect:12,incorrectli:[11,12],increment:13,incur:12,indent:[0,12],independ:[11,12],index:[3,5,7,9,12,14,15,16,18],index_nam:[5,18],indic:[0,2,7,8,9,12],individu:[0,3,7,11,12,18,19],inevit:9,infer:7,info:[0,5,7,9,11,12,13,17,18,19],inform:[1,3,5,7,8,11,12,14,15,18],infrastructur:12,ini:[1,2,7,11,12,13,15],ini_sect:2,init:[1,2,9,12,19],initi:[1,5,11,12],inlin:[12,18],inline_liter:[7,12,18],innodb:10,input:[2,18],insert:[3,5,10,11,12,13,17,18],insid:[0,7,8,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,instal:12,instanc:[0,5,6,7,8,9,12,13,18],instant:7,instanti:[2,6,7],instead:[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],intend:[0,6,7,9,10,12],intent:9,interact:18,intercept:[9,16],interfac:[2,6,18],intermediari:12,intern:[0,1,2],interpret:[12,19],interstingli:11,interv:[7,12],intervent:12,intric:[10,11,13],introduc:[0,11,12,13,18],introduct:[12,19],invalid:12,invari:11,invoc:[1,7,19],invok:[0,2,5,6,7,9,10,11,12,13,18,19],invoke_for_target:13,involv:[7,11,12,18],ioctl:12,ioerror:12,is_bas:8,is_branch_point:8,is_empti:13,is_head:8,is_merge_point:8,is_offline_mod:[7,17],is_transactional_ddl:7,isinst:[7,9],isn:[0,10,11,12],issu:[5,9,10,12,14,18],issue10740:3,item:[0,7,9,12],iter:[0,7,8,12,13],iterate_revis:[8,12],itself:[7,9,10,11,12,13,18,19],ix_:16,ixc:0,jan:12,januari:12,javier:12,job:[0,19],johann:12,john:18,join:[0,11,13,16,17],jone:18,jul:12,juli:12,julien:12,jun:12,just:[1,2,5,10,11,12,13,16,18,19],kahlert:12,kamyshnikova:12,keep:12,kei:[0,2,5,7,8,9],kelli:12,keyerror:12,keyword:[7,12,18],kick:12,kind:[0,5,7,9,10,11,12,13],know:[0,6,10,11,16,19],knowledg:[0,16],known:[0,9,11,12,16,18,19],koizumi:12,kolov:12,kuzminski:12,kwarg:[2,12],kwd:18,land:12,languag:[7,12,13,18],larg:17,larger:12,last:[0,11,17],last_transaction_d:[9,17,19],latenc:19,later:[0,1,9,11,12,17],latest:14,latter:[5,12],layer:12,layout:11,lead:[11,12,14],leak:12,learn:[0,13],least:[5,7,10,12,16,18,19],left:[7,11,18,19],legaci:[0,12],legacy_schema_alias:12,legal:18,len:18,length:[0,7,8,9,10,19],less:[11,12],lesser:0,let:[0,11,13,16,19],level:[0,3,5,7,10,12,13,18,19],levelnam:19,liber:12,librari:[12,18,19],lieu:[13,18],lift:12,lightli:11,lightweight:15,like:[0,2,7,9,10,11,12,13,16,17,18,19],limit:[7,8,9,11,12],line:[2,7,10,11,12,13,17],lineag:12,link:[1,5,11,19],list:[0,1,5,6,7,8,11,12,16,18,19],list_templ:[1,2,12,19],listen:[10,18],listen_for_reflect:10,liter:[5,7,12,18],literal_bind:[7,12,18],littl:12,live:[10,11,17,18,19],load:[7,9,10,11,12,13,19],local:[0,2,7,9,12,17],local_col:[5,18],localhost:[11,19],locat:[0,7,11,12,13,19],log:[12,17,19],logger:[0,19],logger_:19,logger_alemb:19,logger_root:19,logger_sqlalchemi:19,logic:[8,9,10,12,13],longdoc:8,longer:[7,11,12,13,16],look:[0,9,11,12,13,16,19],lookup:12,loos:14,lot:[9,11,16],lower:[8,12,18],luca:12,maarten:12,made:[7,9,10,11,12,18,19],mai:[0,5,7,8,9,10,11,12,13,14,17,18,19],main:[2,6,11,12],maintain:[0,8,11,12,19],major:[3,4,9,12,17,19],make:[0,1,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,10,11,12],manipul:[7,12],manner:12,manual:[7,9,10,11,12,16],map:8,mar:12,marc:12,march:12,marcin:12,marker:8,marquard:12,master:14,match:[5,8,10,12,18,19],max:19,mayb:16,mean:[0,7,10,11,12,17,18],meaning:7,meant:11,mechan:[7,8],member:[9,12],memori:17,mention:[11,16,18],mercuri:[12,14],merg:[1,8],mergepoint:[11,12],messag:[0,1,2,5,8,9,12,13,19],meta:[10,16],metadata:[0,7,9,10,12,13,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,method:[0,2,4,5,6,7,8,9,10,12,13,18,19],methodolog:9,michael:12,michel:12,microsoft:18,might:[10,12,13,16],migrat:[0,1,2,3,4,5,6],migrateoper:[0,5,13,18],migration_context:[0,7,18],migration_script:0,migration_typ:9,migrationcontext:[0,1,2,5,6,7,12,13,18],migrationscontext:16,migrationscript:[0,5,7,12,13],mike:14,million:12,mind:16,minhe:12,minimalist:19,minimum:12,minut:[12,19],misinterpret:12,miss:[12,14],mistaken:12,mistakenli:12,mix:12,mock:7,mode:[2,3,6,7],model_metadata:0,modif:12,modifi:[0,2,3,7,9,12,13,18,19],modify_:0,modify_nam:5,modify_nul:[0,5],modify_op:0,modify_server_default:5,modify_typ:5,modifytableop:[0,5],modul:[0,2,5,6,7,8],modular:12,moment:[11,12,13,18],mon:12,month:[12,19],more:[0,1,4,5,7,8,9,10],moriyoshi:12,most:[0,5,7,8,9,10,11,12,13,14,16,18,19],mostli:[10,12],move:[9,10,12,14,18,19],movement:13,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],mssqlimpl:3,much:[10,11,12,13,16,18],multi:[0,8,19],multidb:[0,5,9,12,19],multiinsert:[3,5,12,18],multiplehead:8,must:[0,8,9,10,11,12,17,19],mutat:[10,12],mutipl:0,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],myapp:[2,7,8,9,16,17],mybranch:0,mycolumn:9,mycustomtyp:9,mydatabas:7,myengin:18,mymodel:[9,16],mypackag:9,mysect:2,myspecialcol:7,myspecialtyp:9,mysql_engin:12,mysqlalterdefault:3,mysqlchangecolumn:3,mysqldb:12,mysqlimpl:3,mysqlmodifycolumn:3,mytabl:7,name:[0,2,3,5,7,8,9],namespac:[5,7,9,12,13,18],naming_convent:[10,12,16,18],narrow:11,nativ:[16,18],natur:[11,12],navig:8,necessari:[6,9,10,12,18],necessarili:12,need:[0,2,3,4,5,7,8,9,10,11,12,13,14,16,17,18,19],neg:19,nest:[7,13],net:12,network:11,never:[12,18],new_column_nam:[5,10,12,18],new_table_nam:[3,5,18],newer:[7,11,12,14],newli:[12,18],newnam:3,next:[5,7,10,11,12,15],nextrev:8,nextval:12,nice:13,no_paramet:12,node:[11,12],non:[0,2,8,9,12,18,19],none:[0,1,2,3,5,7,8,9,10,11,12,13,16,17,18,19],nonetyp:12,nonexist:12,nor:[10,12],normal:[0,3,4,5,7,8,9,10,11,12,13,16,18,19],nose:12,notabl:8,note:[0,7,8,9,10,11,12,13,18,19],noth:[7,8,11,12,19],notic:[17,19],notimplementederror:13,notion:12,notset:19,noufal:12,nov:12,novemb:12,now:[0,5,7,8,9,10,11,12,13,18,19],nspname:0,nullabl:[0,3,5,7,9,10,12,18,19],nullpool:[7,12,13],number:[0,7,8,9,11,12,13,19],numer:[12,18],nut:7,nvarchar:18,obj:[9,13],object_:0,objnam:13,obscur:12,observ:12,obtain:0,obviou:9,occur:[0,5,9,10,11,12,19],oct:12,octob:12,odagiri:12,odd:[10,11],off:[3,7,9,10,11,12,17,18],offer:[11,12],offlin:[2,3,6,7],often:[1,9,11,12,13],oid:[0,13,16],old:[9,10,12,13,18,19],old_data:0,old_obj:13,old_table_nam:[3,5,18],older:[11,12,13,18],omit:[7,10,12,18],onc:[0,7],ondelet:[5,12,18],onli:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,17,18,19],onlin:[7,10,12,17,18],onto:[0,11,19],onupd:[5,12,18],op_cl:18,opcontain:5,open:[2,5,7,12,17],openstack:14,operar:13,opportun:0,opt:[0,7],option:[0,2,3,5,7,8,9,10,11,12,13,17,18,19],oracl:[7,12,16],oracle_batch_separ:7,order:[0,1,3,5,6,7,9,10,11,12,13,16,18,19],order_count:13,ordinarili:7,org:[3,12,14],org_fk:0,organ:[0,5,11,12,13,17,18],organization_id:0,orient:18,origin:[5,7,10,11,12,13],other:[0,1,3,6,7,8,9],otherwis:[7,8,12,16,18],out:[2,5,6,9,11,12,13,16,19],outer:13,output:[0,2,5,6,7,9,11,12,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,12],overcom:10,overhaul:12,overkil:13,overrid:[2,7,9,10,18],overridden:[7,12],overview:[4,5],overwhelm:12,own:[9,11,12,13,16,18],packag:[1,9,12,14,19],page:[14,15],pair:[9,12],paradigm:11,paradoxxxzero:12,parallel:12,paramet:[0,2,4,7,8,9,10,12,13,16,17,18],parameter:18,paramt:12,parent:[11,12,16,18,19],pars:[2,7,12],parse_encod:12,part:[0,5,6,9,11,12,13,18,19],parti:[9,12],partial:[8,11,12,15],particular:[3,4,7,12,16,18,19],particularli:[7,9,12],pass:[0,2,4,5,6,7,8,9,10,11,12,13,16,17,18,19],patch:12,path:[0,1,2,8,9,11,13,17,19],pathnam:19,pattern:[10,12],pedro:12,pep:12,per:[3,6,9,12,18],percent:12,perfect:9,perfectli:18,perform:[0,3,7,10,11,12],perhap:1,perman:11,perspect:[2,7,11],pertin:11,pg_catalog:[12,13,16],pg_class:[0,13,16],pg_constraint:16,pg_namespac:[0,13,16],pg_table_is_vis:13,phase:12,philosoph:10,philosophi:18,phrase:12,pickl:9,pip:14,pipe:12,pk_:16,pk_my_tabl:18,pkg_resourc:12,place:[0,3,5,7,9,10,11,12,13,16,19],placehold:13,plai:[7,19],plain:[7,9,12],plan:0,platform:12,pleas:[0,1,2,5,7,9,10,11,12,19],plpgsql:13,plu:[12,19],plug:0,plugin:[0,4],podoliaka:12,point:[0,1,4,8,11,12,19],pool:[7,13],poolclass:[7,13],popul:[2,8,18,19],posit:[7,12,18,19],possibl:[2,5,10,13,17,18,19],post:[12,14],poster:11,postgreql:12,postgresql:[0,2],postgresqlcontext:[17,19],postgresqlimpl:[3,11,13],potenti:[12,14],pprint:0,practic:[7,18,19],pragma:10,pre:[10,12],preced:[0,9,10,11],predict:10,prefer:[7,8,10,12],prefix:[0,7],prematur:12,prep_table_for_batch:3,presenc:[0,13],present:[0,3,5,6,7,8,9,10,11,12,13,17,18,19],preserv:12,pretti:[10,11,12,13,18],preval:12,prevent:[10,12],previou:[1,11,12,13,18],previous:[0,12],primari:[0,5,6,9,10,12,13,16,17,18],primarili:0,primary_kei:[0,7,10,13,16,18,19],primarykeyconstraint:[0,9,12,16,18],print:[0,2,12],print_stdout:2,prior:[7,10,11,12],probabl:[11,12,19],problem:[10,12,13],proce:[3,5,7,9,10,11,12,13,14,18],procedur:[10,13],proceed:[13,16,19],process:[0,3,9,10,11,12,14,18,19],process_revision_direct:[0,7,12,13],procur:19,produc:[0,6,7,8,9,10,12,13,18,19],produce_migr:0,product:[5,7,12,13,16],prog:2,program:[5,12],programat:2,programmat:[0,1,2,3,4,7,8,12],prohibit:12,project:4,promin:6,prompt:16,proof:7,proper:14,properli:[10,12],propos:[0,13],provid:[0,2,3,4,6,7,8,9,10,11,12,13,16,17,18,19],proxi:[5,7,18],prune:[13,19],pseudo:12,psycopg2:12,publish:14,pull:[11,12,17],purpos:[0,4,6,10,12,13,17],pursu:11,put:[0,11,13],py2k:12,py3:12,py3k:12,pyc:[12,19],pylon:[12,14,19],pyo:[12,19],pypi:[12,14],pyramid:12,pysqlit:[3,12],pytest:12,python3:12,python:[0,2,3,5,6,7,8,9,12,13,14,15,18,19],q_bool:16,qualifi:12,qualnam:19,queri:12,quirk:12,quit:[10,11,13,16],quot:[3,12,18],quote_dot:3,quoted_nam:[12,18],r1975ea:19,radic:12,rais:[7,8,12,13,17],ran:[0,11],rang:[12,15,17],rather:[1,7,9,11,12,13,18,19],rational:10,rcurrent:12,reach:[11,12],read:[2,6,12,17,19],readm:[12,19],readthedoc:14,real:[4,7,11,12,18],realli:11,rearrang:12,reason:[5,9,10,11,12],rec:0,receiv:[0,7,11,12,18],recent:[7,8,12,13,14,18,19],recip:[1,13],recogn:12,recommend:[9,11,12,18],reconcil:11,reconcili:11,recreat:[3,10,12,13,18],redirect:[2,17],reduc:0,redund:12,refactor:[9,12],refer:[0,5,6,7,8,9,10],referent_schema:[5,18],referent_t:[5,18],referenti:[10,12],referred_table_nam:[10,16],refin:12,reflect:[0,3,7,9],reflect_arg:[10,12,18],reflect_kwarg:[10,12,18],reflectt:9,refresh:8,regard:[0,1,2,5,9,12,18],regardless:[7,10,18,19],regexp:12,register_oper:[5,13,18],registr:[0,5],regress:12,regular:[6,7,8,10,11,18],rel:[9,11,12,15],relat:[10,12,16,19],releas:[9,10,12,14,16],releg:13,reli:[10,12,17],reliabl:9,relianc:19,relkind:0,relnam:[0,13,16],relnamespac:[0,13,16],relnum:11,remain:[10,11,12,13,18],rememb:16,remot:[10,12,18],remote_col:[5,18],remov:[9,12,13,18],remove_column:0,remove_constraint:12,remove_index:12,remove_t:0,renam:[5,10,12,18],rename_t:[3,5,18],renamet:3,renametableop:5,render_as_batch:[0,7,10,12],render_create_sequ:0,render_drop_sequ:0,render_item:[0,7,9,12],render_python_cod:0,rendered_inspector_default:3,rendered_metadata_default:[3,7],reorgan:[7,12],repair:[12,14],replac:[0,2,3,9,10,12],replace_sp:13,replace_view:13,replace_with:13,replaceableobject:13,report:[12,14],repositori:[8,11,12,14],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,11,12,13,14,16,18,19],requires_recreate_in_batch:3,resembl:12,reserv:18,resili:12,resolut:[11,12],resolv:[8,11,12],resolve_depend:1,resourc:[12,19],resource_filenam:[12,19],respect:0,respond:19,restor:9,restrict:[12,17,18],result:[0,7,8,9,11,18,19],retriev:[9,12,17,18],reusabl:12,rev:[1,7,8,11,12,13,17,19],rev_id:[1,5,8],rev_rang:1,revers:[0,5,12,13],reversibleop:13,revert:[1,12],revid:8,review:[9,13],revision_environ:[7,12,19],revisionmap:8,rework:12,right:[7,11,16,18],rivera:12,robbi:12,rock:19,roll:[7,13],rollback:17,roman:12,romano:12,root:[8,11,19],rout:[3,7],routin:[0,7,12],row:[0,3,5,11,12,16,17,18],rudimentari:[0,4,9,18,19],rule:[6,9,12,18],run_env:[7,8],run_filt:0,run_migrations_offlin:17,run_migrations_onlin:[0,9,13,16,17],run_test:12,runner:[2,6,12,19],runnier:2,runtim:[4,5],ryan:12,s_downgrad:0,s_upgrad:0,safe:[10,12,18],safeconfigpars:[2,19],sai:[11,13],said:11,same:[0,1,3,5,7,9,11,12,13,16,17,18,19],sampl:[9,12],saniti:12,santacruz:12,sat:12,satisfi:11,scan:[7,12],scenario:[8,10,11,12],scene:[12,16],sch:0,schaik:12,schema:[0,2,3,5,7,9,10,12,13,18],schema_downgrad:13,schema_upgrad:13,schemaitem:[0,7],schemanam:0,scheme:[0,8,9,12,16,17,18,19],scope:[0,7,10,12,13],scott:[11,19],scratch:12,screen:19,script:[0,1,2,4,5,6,7],script_directori:[7,12],script_loc:[2,7,8,12,19],scriptabl:19,scriptdirectori:[1,2,6,7,8,12],search:[9,15],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,9,10,11,12,13,14,16,18,19],seem:16,seen:[10,11,12],segment:12,select:[0,8,9,10,11,12,13,16,17,18],self:[5,9,10,12,13,18],semant:11,semi:11,semicolon:7,send:[10,13],sensit:18,sent:[1,2,5,7,12],separ:[7,8,11,12,13,18],septemb:12,sequenc:[0,3,5,8,9,12,13,18,19],sequence_nam:[0,5],sequent:11,seri:[0,1,2,6,7,10,11,12],serial:[0,12,13,17],serv:[0,5,8,11,12],server:[0,3,7,9,12,17,18],server_default:[3,5,7,12,18],servic:[12,18],session:17,set:[0,2,3,5,6,7,8,9,10],set_main_opt:[2,7,8,12],set_section_opt:[2,12],setdefault:0,setup:[2,12,14,18],setuptool:12,sever:[10,11,12,19],share:[1,2,11,12],shgoh:12,shop:[10,11],shopping_cart:11,shoppingcart:11,shorthand:11,shot:13,should:[0,5,7,8,9,10,11,12,13,14,18,19],shouldn:12,show:[0,1,7,11,12,19],sibl:11,side:[7,11,12,18],sign:12,signal:12,signific:12,similar:[10,11,12,14,16,18],simpl:[0,5,7,9,10,12,13,16,18,19],simpler:2,simplest:[0,5],simpli:[12,13],simplist:13,simultan:[8,11,19],sinc:[0,7,10,11,12,18],singl:[0,1,5,7,8,9,11,12,13,18,19],sit:11,size:12,skip:[7,12],skip_autogener:7,skip_table_on:7,skip_table_two:7,slice:[12,19],slightli:[10,12],slug:[8,12,19],small:[1,6,9,12],smith:18,softwar:12,sok:12,sole:13,solut:16,some:[0,3,7,9,10,11,12,13,16,17,18,19],some_oper:5,some_param:2,some_t:[10,16,18],somecolumn:7,somefunct:12,somenam:7,somet:[9,16],sometag:7,someth:[7,9,11,16,19],somewher:[9,13],soon:13,sort:[11,12],sourc:[9,11,12,13,14,18,19],source_schema:[5,12,18],source_t:[5,18],sourceless:[8,12,19],sourcenam:18,sp_renam:12,space:[7,12],special:[0,3,7,8,9,10,11,12,16,18,19],specif:[0,3,5,6,7,9],specifc:11,specifi:[0,7,9,10,11,12,18,19],specifii:12,spit:12,splice:[1,5,8,11,19],split:[12,13],sql:1,sqla:[9,12],sqlalchemi:[0,2,3,7,9,10,11,12,13,14,15,16,18,19],sqlalchemy_module_prefix:[0,7,9,12],sqlite:0,sqliteimpl:3,sqllchemi:18,sqltext:[5,13,18],src:12,stabl:14,stai:13,stamp:[1,7,12,13],stand:9,standalon:[12,18],standard:[2,5,7,10,17,18,19],standpoint:8,start:[6,7,8,9,11,12,13,15],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,13,16,17,18],static_output:[3,7],statu:[9,11,12],stderr:[17,19],stdout:[2,7,12],stem:10,step:[0,3,5,7,10,11,12,13,15,18],still:[7,10,11,12,13,18],stop:[11,19],storag:2,store:[0,2,5,11,13,18],straight:[12,13,19],straightforward:[12,13],stream:[0,5,6,7,11,12,18,19],streamhandl:19,street:10,stress:11,strictli:8,string:[0,2,3,7,8,9,10,11,12,13,16,18,19],stringif:12,stringio:12,strongli:12,structur:[0,7,10,11,12],stub:[13,18],style:[1,5,10,12,13,18],sub:11,subclass:[0,5,6,8,12,18],subject:[11,12],subsect:4,subsequ:[11,12],subset:[7,12],substitut:[2,11,12,19],succe:12,succeed:8,success:0,suffici:[5,10],suggest:11,suit:[12,17,19],suitabl:[7,12,18],summar:0,sun:12,superced:7,suppli:[6,12,19],support:[0,3,5,7,8,9,10,11,12,13,14,15,16],suppos:[0,9,16,19],suppress:12,sure:[9,11,19],surpris:12,surround:[12,18],sweep:7,sybas:12,symbol:[1,8,11,12,18,19],synonym:7,syntact:18,syntax:10,sys_c0029334:16,system:[0,1,3,5,6,7,10,11,12,13,18],szotten:12,t_tabl:19,tabl:[0,1,3,5,6,7,9],table_arg:[10,18],table_kw:5,table_kwarg:18,table_nam:[0,3,5,10,12,16,18],tablenam:[0,7,12,16],tag:[1,7,12],tailor:[12,13],take:[3,7,9,10,12,13,14,16,18],taken:[0,12],talk:[0,16],tar:14,target:[0,7,9,10,11,12],target_metadata:[0,7,9,10,12,13,16,18],task:[0,9],technic:6,techniqu:[0,5,12,13],tediou:[10,16],tell:[11,12,13,19],templat:[0,1,2,5,7,8,9,12,13,19],template_arg:[7,12],temporari:[12,18],temptabl:12,term:[0,11,18,19],termin:12,termwidth:12,test:[0,8,9,11,12,16,19],test_autogener:12,test_render_fk_constraint_kwarg:12,text:[2,3,6,7,12,13,18],textual:[7,12,13],than:[1,3,7,8,9],thank:12,thei:[0,1,5,7,9,10,11,12,18,19],them:[0,7,10,11,12,13,16,17,18],themselv:[0,5,6,7,8],theodor:12,theoret:19,theori:[13,19],therefor:[10,12,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],those:[3,7,8,9,10,11,12,13,16,18],though:[2,7,10,11,12,13,16,18,19],thoughtfulli:11,thousand:19,three:[0,12,19],through:[0,7,8,10,11,12,13,14,17],thu:[11,12],ticket:12,tiger:19,time:[0,5,7,10,11,12,16,17,19],timestamp:[17,18],tinyint:12,tname:0,todo:18,togeth:[1,11,18,19],token:[0,12,16,18,19],too:[11,12,13,16],tool:[10,14,15,19],toolkit:15,top:[9,11,12],topic:[9,16],toplevel:6,topolog:11,total:[8,19],tougher:13,toward:[7,11,13,18],tox: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],tread:11,treat:[7,11,12,17,18],tree:[11,13,19],trigger:[0,13],tripl:0,trivial:12,truncat:19,truncate_slug_length:[8,12,19],tty:12,tue:12,tupl:[0,7,8,11,13],turn:[2,7,10,11,12,18],tutori:[1,2,7,15,18],twist:11,two:[0,1,5,7,9,11,12,16,17,19],txt:17,type:[0,7],type_:[0,3,5,7,9,10,12,18],typedecor:9,typeengin:[0,7,18],typeerror:[12,13],typic:[3,6,7,8,10,11,12,13,16,18,19],ultim:[6,7,13,18],unaffect:12,unambigu:11,unchang:12,uncondition:[10,12,19],undefin:12,under:[7,12,18],underli:[2,7,18,19],underneath:11,underscor:12,understand:19,understood:[12,18],unicod:[12,19],unimpl:12,uniqu:[5,7,9],unique_constraint:[7,12],uniqueconstraint:[7,9,10,12,16,18],unit:[6,12],unittest:12,unless:[2,8],unlik:10,unmerg:[7,8],unnecessari:12,unnecessarili:12,unpredict:16,unreport:12,until:[11,12],untrust:18,unvers:19,unwant:[9,12],up_or_down_op:0,up_revis:[11,13],updat:[0,7,11,12,13,18],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],upon:[0,1,6,7,8,9,10,11,12,13,17,19],upper:[8,18],upward:11,uq_:16,uq_const_x:16,uq_user_account_nam:16,uq_user_nam:18,uri:[12,19],url:[2,7,17,19],usabl:[12,13],usag:[0,1,2,3,7,10,12,14,15,16,18,19],use_alt:12,user:[0,4,5,6,7,9,10,12,13,14,17,18,19],user_account:16,user_account_id:16,user_id:18,user_module_prefix:[7,9,12],user_ord:16,user_order_id:16,user_order_user_account_id_fkei:16,usernam:10,usual:[0,1,4,7,9,10,11,18],utf:[8,12,19],util:[2,7,8,9,12],utim:0,uuid:[7,9],valid:12,valu:[0,2,7,9,11,12,13,16,17,18,19],van:12,varchar:[0,9,13,17,18],vari:7,variabl:[0,2,7,9,12,18,19],varianc:3,varieti:[9,10,12,19],variou:[6,12,13,18,19],vast:[4,9,19],verbos:[1,11,12,19],veri:[0,5,7,9,11,12,13,19],verifi:18,versa:12,version:[0,1,2,5,6,7,8,9,10],version_fil:17,version_loc:[8,11,19],version_num:[11,13,17],version_path:[1,5,8],version_t:[7,12],version_table_schema:[7,12],versionchang:12,versu:[11,18],via:[0,2,3,5,7,9,10,12,14,17,18,19],vice:12,view:[0,9,11,12,13,15],visit_add_column:3,visit_column_default:3,visit_column_nam:3,visit_column_nul:3,visit_column_typ:3,visit_drop_column:3,visit_rename_column:3,visit_rename_t:3,visual:6,wai:[0,4,10,11,12,13,16,17,19],walk:13,walk_revis:8,want:[0,7,8,11,13,16,17,18,19],warn:[12,19],wasn:12,wed:12,weed:12,week:12,welcom:12,well:[0,4,5,7,9,11,12,13,16,17,18,19],wendi:18,were:[2,7,9,10,11,12],weren:[11,12],what:[0,7],whatev:[0,2,9,19],when:[0,2,3,4,5,6,7,8,9,10,11,12,13,16,17,18,19],whenev:[10,19],where:[0,2,7,8,9,10,11,12,13,16,17,18,19],wherea:[7,9,12],wherebi:[10,12],whether:[0,7,8,18],which:[0,2,4,5,6,7,8,9,10,11,12,13,16,17,18,19],whichev:11,who:[0,1,2,5,6],whole:[0,11,12,13,16,18],whose:[6,12],wide:[0,9,12],width:[0,12],wiki:12,wild:11,wilk:12,william:18,window:12,wish:[0,1,2,5,6,7,11,13,16],with_stat:12,within:[0,2,5,6,7,8,9,10,11,12,13,17,18,19],without:[0,2,7,10,11,12,13,17,18,19],won:[10,12],word:[12,18],work:[0,2,7,9],workaround:[10,12,18],workflow:[10,11,12],world:4,wors:16,worth:16,would:[0,3,5,7,9,10,11,12,13,16,17,18,19],wouldn:12,wow:19,wrap:12,write:[1,12,15,16],writer1:0,writer2:0,writer:0,written:[7,12,13,19],wrong:[12,16],wrote:17,www:12,xdist:12,xxxxx:[11,19],xyz:[12,13],yap:12,year:[12,16,19],yet:[7,9,11,12,18,19],yield:[7,8,12],you:[2,7,8,9,11,12,13,16,19],your:[9,11,12,16,19],yourapp:[1,2,13,19],yourproject:19,yourself:12,zeidler:12,zero:[0,8,12],zone:17,zzzeek:[12,14]},titles:["Autogeneration","Commands","Configuration","DDL Internals","API Details","Operation Directives","Overview","Runtime Objects","Script Directory","Auto Generating Migrations","Running “Batch” Migrations for SQLite and Other Databases","Working with Branches","Changelog","Cookbook","Front Matter","Welcome to Alembic’s documentation!","The Importance of Naming Constraints","Generating SQL Scripts (a.k.a. “Offline Mode”)","Operation Reference","Tutorial"],titleterms:{"function":0,"import":16,affect:9,alemb:15,all:11,api:4,auto:9,autogener:[0,9,10,13,16],base:11,batch:10,branch:[11,13],bug:[12,14],build:13,built:5,call:0,chang:12,changelog:12,check:10,command:[1,13],commun:14,compar:9,comparison:0,condit:13,configur:2,connect:13,constraint:[10,16],context:7,control:[9,10],convent:16,cookbook:13,creat:[0,11,13,19],custom:[0,17],databas:[10,13],date:13,ddl:3,deal:10,depend:[11,14],detail:4,detect:9,diff:0,direct:[0,5],directori:[8,11],document:15,doe:9,don:13,downgrad:19,drop:10,edit:19,element:13,empti:13,engin:0,environ:[7,13,17,19],explicit:11,featur:12,file:19,fine:0,first:19,foreign:10,from:13,front:14,gener:[0,9,13,17],get:[0,17,19],grain:0,head:11,histori:19,homepag:14,identifi:19,includ:10,indic:15,inform:19,ini:19,initi:13,instal:14,integr:16,intern:3,kei:10,label:11,matter:14,mechan:11,merg:11,migrat:[7,9,10,13,17,19],misc:12,mode:[10,17],model:0,modul:9,more:11,multipl:[0,11],mysql:3,name:[10,16],next:19,object:[0,5,7,13],offlin:[10,17],onc:11,oper:[0,5,13,16,18],other:10,our:[0,19],overview:6,partial:19,plugin:5,postgresql:3,prefix:9,project:14,rang:19,refer:[11,18],referenc:10,reflect:10,regist:0,rel:19,render:[0,9],replac:13,revis:[0,8,11,13,19],rewrit:0,run:[0,10,11,19],run_migr:0,runtim:7,scratch:13,script:[8,17,19],second:19,seri:13,set:11,share:13,specif:11,sql:[3,17],sqlite:[3,10],start:17,statu:14,step:19,structur:13,support:17,syntax:11,tabl:[10,15],target:13,than:10,themselv:9,track:0,tutori:19,type:9,uniqu:10,unnam:10,version:[11,17],view:19,welcom:15,what:9,work:[10,11],write:17}})