Search.setIndex({docnames:["api","changelog","changeset","credits","download","faq","glossary","index","tools","versioning"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":4,"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.ext.intersphinx":1,sphinx:56},filenames:["api.rst","changelog.rst","changeset.rst","credits.rst","download.rst","faq.rst","glossary.rst","index.rst","tools.rst","versioning.rst"],objects:{"":{migrate:[7,0,0,"-"]},"migrate.changeset":{ansisql:[0,0,0,"-"],constraint:[0,0,0,"-"],databases:[0,0,0,"-"],schema:[0,0,0,"-"]},"migrate.changeset.ansisql":{ANSIColumnDropper:[0,1,1,""],ANSIColumnGenerator:[0,1,1,""],ANSIConstraintCommon:[0,1,1,""],ANSIConstraintDropper:[0,1,1,""],ANSIConstraintGenerator:[0,1,1,""],ANSIDialect:[0,1,1,""],ANSISchemaChanger:[0,1,1,""],AlterTableVisitor:[0,1,1,""]},"migrate.changeset.ansisql.ANSIColumnDropper":{visit_column:[0,2,1,""]},"migrate.changeset.ansisql.ANSIColumnGenerator":{visit_column:[0,2,1,""]},"migrate.changeset.ansisql.ANSIConstraintCommon":{get_constraint_name:[0,2,1,""]},"migrate.changeset.ansisql.ANSIDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.ansisql.ANSISchemaChanger":{start_alter_column:[0,2,1,""],visit_column:[0,2,1,""],visit_index:[0,2,1,""],visit_table:[0,2,1,""]},"migrate.changeset.ansisql.AlterTableVisitor":{append:[0,2,1,""],execute:[0,2,1,""],start_alter_table:[0,2,1,""]},"migrate.changeset.constraint":{CheckConstraint:[0,1,1,""],ConstraintChangeset:[0,1,1,""],ForeignKeyConstraint:[0,1,1,""],PrimaryKeyConstraint:[0,1,1,""],UniqueConstraint:[0,1,1,""]},"migrate.changeset.constraint.CheckConstraint":{argument_for:[0,2,1,""],contains_column:[0,2,1,""],copy:[0,2,1,""],create:[0,2,1,""],dialect_kwargs:[0,3,1,""],dialect_options:[0,3,1,""],drop:[0,2,1,""],get_children:[0,2,1,""],info:[0,3,1,""],kwargs:[0,4,1,""]},"migrate.changeset.constraint.ConstraintChangeset":{create:[0,2,1,""],drop:[0,2,1,""]},"migrate.changeset.constraint.ForeignKeyConstraint":{argument_for:[0,2,1,""],autoname:[0,2,1,""],column_keys:[0,4,1,""],contains_column:[0,2,1,""],copy:[0,2,1,""],create:[0,2,1,""],dialect_kwargs:[0,3,1,""],dialect_options:[0,3,1,""],drop:[0,2,1,""],get_children:[0,2,1,""],info:[0,3,1,""],kwargs:[0,4,1,""],referred_table:[0,4,1,""]},"migrate.changeset.constraint.PrimaryKeyConstraint":{argument_for:[0,2,1,""],autoname:[0,2,1,""],contains_column:[0,2,1,""],copy:[0,2,1,""],create:[0,2,1,""],dialect_kwargs:[0,3,1,""],dialect_options:[0,3,1,""],drop:[0,2,1,""],get_children:[0,2,1,""],info:[0,3,1,""],kwargs:[0,4,1,""]},"migrate.changeset.constraint.UniqueConstraint":{argument_for:[0,2,1,""],autoname:[0,2,1,""],contains_column:[0,2,1,""],copy:[0,2,1,""],create:[0,2,1,""],dialect_kwargs:[0,3,1,""],dialect_options:[0,3,1,""],drop:[0,2,1,""],get_children:[0,2,1,""],info:[0,3,1,""],kwargs:[0,4,1,""]},"migrate.changeset.databases":{firebird:[0,0,0,"-"],mysql:[0,0,0,"-"],oracle:[0,0,0,"-"],postgres:[0,0,0,"-"],sqlite:[0,0,0,"-"],visitor:[0,0,0,"-"]},"migrate.changeset.databases.firebird":{FBColumnDropper:[0,1,1,""],FBColumnGenerator:[0,1,1,""],FBConstraintDropper:[0,1,1,""],FBConstraintGenerator:[0,1,1,""],FBDialect:[0,1,1,""],FBSchemaChanger:[0,1,1,""]},"migrate.changeset.databases.firebird.FBColumnDropper":{visit_column:[0,2,1,""]},"migrate.changeset.databases.firebird.FBConstraintDropper":{cascade_constraint:[0,2,1,""]},"migrate.changeset.databases.firebird.FBDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.databases.firebird.FBSchemaChanger":{visit_table:[0,2,1,""]},"migrate.changeset.databases.mysql":{MySQLColumnDropper:[0,1,1,""],MySQLColumnGenerator:[0,1,1,""],MySQLConstraintDropper:[0,1,1,""],MySQLConstraintGenerator:[0,1,1,""],MySQLDialect:[0,1,1,""],MySQLSchemaChanger:[0,1,1,""]},"migrate.changeset.databases.mysql.MySQLDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.databases.mysql.MySQLSchemaChanger":{visit_column:[0,2,1,""],visit_index:[0,2,1,""]},"migrate.changeset.databases.oracle":{OracleColumnDropper:[0,1,1,""],OracleColumnGenerator:[0,1,1,""],OracleConstraintDropper:[0,1,1,""],OracleConstraintGenerator:[0,1,1,""],OracleDialect:[0,1,1,""],OracleSchemaChanger:[0,1,1,""]},"migrate.changeset.databases.oracle.OracleDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.databases.oracle.OracleSchemaChanger":{visit_column:[0,2,1,""]},"migrate.changeset.databases.postgres":{PGColumnDropper:[0,1,1,""],PGColumnGenerator:[0,1,1,""],PGConstraintDropper:[0,1,1,""],PGConstraintGenerator:[0,1,1,""],PGDialect:[0,1,1,""],PGSchemaChanger:[0,1,1,""]},"migrate.changeset.databases.postgres.PGDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.databases.sqlite":{SQLiteColumnDropper:[0,1,1,""],SQLiteColumnGenerator:[0,1,1,""],SQLiteConstraintDropper:[0,1,1,""],SQLiteConstraintGenerator:[0,1,1,""],SQLiteDialect:[0,1,1,""],SQLiteSchemaChanger:[0,1,1,""]},"migrate.changeset.databases.sqlite.SQLiteColumnDropper":{visit_column:[0,2,1,""]},"migrate.changeset.databases.sqlite.SQLiteColumnGenerator":{visit_column:[0,2,1,""]},"migrate.changeset.databases.sqlite.SQLiteDialect":{columndropper:[0,3,1,""],columngenerator:[0,3,1,""],constraintdropper:[0,3,1,""],constraintgenerator:[0,3,1,""],schemachanger:[0,3,1,""]},"migrate.changeset.databases.sqlite.SQLiteSchemaChanger":{visit_index:[0,2,1,""]},"migrate.changeset.databases.visitor":{get_dialect_visitor:[0,5,1,""],get_engine_visitor:[0,5,1,""],run_single_visitor:[0,5,1,""]},"migrate.changeset.schema":{ChangesetColumn:[0,1,1,""],ChangesetDefaultClause:[0,1,1,""],ChangesetIndex:[0,1,1,""],ChangesetTable:[0,1,1,""],ColumnDelta:[0,1,1,""],alter_column:[0,5,1,""],create_column:[0,5,1,""],drop_column:[0,5,1,""],rename_index:[0,5,1,""],rename_table:[0,5,1,""]},"migrate.changeset.schema.ChangesetColumn":{alter:[0,2,1,""],copy_fixed:[0,2,1,""],create:[0,2,1,""],drop:[0,2,1,""]},"migrate.changeset.schema.ChangesetIndex":{rename:[0,2,1,""]},"migrate.changeset.schema.ChangesetTable":{create_column:[0,2,1,""],deregister:[0,2,1,""],drop_column:[0,2,1,""],rename:[0,2,1,""]},"migrate.changeset.schema.ColumnDelta":{apply_diffs:[0,2,1,""],are_column_types_eq:[0,2,1,""],compare_1_column:[0,2,1,""],compare_2_columns:[0,2,1,""],compare_parameters:[0,2,1,""],keys:[0,2,1,""],process_column:[0,2,1,""]},"migrate.exceptions":{ApiError:[0,6,1,""],ControlledSchemaError:[0,6,1,""],DatabaseAlreadyControlledError:[0,6,1,""],DatabaseNotControlledError:[0,6,1,""],Error:[0,6,1,""],InvalidConstraintError:[0,6,1,""],InvalidRepositoryError:[0,6,1,""],InvalidScriptError:[0,6,1,""],InvalidVersionError:[0,6,1,""],KnownError:[0,6,1,""],MigrateDeprecationWarning:[0,6,1,""],NoSuchTableError:[0,6,1,""],NotSupportedError:[0,6,1,""],PathError:[0,6,1,""],PathFoundError:[0,6,1,""],PathNotFoundError:[0,6,1,""],RepositoryError:[0,6,1,""],ScriptError:[0,6,1,""],UsageError:[0,6,1,""],VersionNotFoundError:[0,6,1,""],WrongRepositoryError:[0,6,1,""]},"migrate.versioning":{api:[0,0,0,"-"],genmodel:[0,0,0,"-"],migrate_repository:[8,0,0,"-"],pathed:[0,0,0,"-"],repository:[0,0,0,"-"],schema:[0,0,0,"-"],schemadiff:[0,0,0,"-"],shell:[0,0,0,"-"],util:[0,0,0,"-"],version:[0,0,0,"-"]},"migrate.versioning.api":{compare_model_to_db:[0,5,1,""],create:[0,5,1,""],create_model:[0,5,1,""],db_version:[0,5,1,""],downgrade:[0,5,1,""],drop_version_control:[0,5,1,""],help:[0,5,1,""],make_update_script_for_model:[0,5,1,""],manage:[0,5,1,""],script:[0,5,1,""],script_sql:[0,5,1,""],source:[0,5,1,""],test:[0,5,1,""],update_db_from_model:[0,5,1,""],upgrade:[0,5,1,""],version:[0,5,1,""],version_control:[0,5,1,""]},"migrate.versioning.genmodel":{ModelGenerator:[0,1,1,""]},"migrate.versioning.genmodel.ModelGenerator":{genB2AMigration:[0,2,1,""],genBDefinition:[0,2,1,""],runB2A:[0,2,1,""]},"migrate.versioning.pathed":{Pathed:[0,1,1,""]},"migrate.versioning.pathed.Pathed":{require_found:[0,2,1,""],require_notfound:[0,2,1,""]},"migrate.versioning.repository":{Changeset:[0,1,1,""],Repository:[0,1,1,""]},"migrate.versioning.repository.Changeset":{add:[0,2,1,""],items:[0,2,1,""],keys:[0,2,1,""],run:[0,2,1,""],values:[0,2,1,""]},"migrate.versioning.repository.Repository":{changeset:[0,2,1,""],create:[0,2,1,""],create_manage_file:[0,2,1,""],create_script:[0,2,1,""],create_script_sql:[0,2,1,""],id:[0,4,1,""],latest:[0,4,1,""],prepare_config:[0,2,1,""],use_timestamp_numbering:[0,4,1,""],verify:[0,2,1,""],version:[0,2,1,""],version_table:[0,4,1,""]},"migrate.versioning.schema":{ControlledSchema:[0,1,1,""]},"migrate.versioning.schema.ControlledSchema":{changeset:[0,2,1,""],compare_model_to_db:[0,2,1,""],create:[0,2,1,""],create_model:[0,2,1,""],drop:[0,2,1,""],load:[0,2,1,""],update_db_from_model:[0,2,1,""],update_repository_table:[0,2,1,""],upgrade:[0,2,1,""]},"migrate.versioning.schemadiff":{ColDiff:[0,1,1,""],SchemaDiff:[0,1,1,""],TableDiff:[0,1,1,""],getDiffOfModelAgainstDatabase:[0,5,1,""],getDiffOfModelAgainstModel:[0,5,1,""]},"migrate.versioning.schemadiff.ColDiff":{col_A:[0,3,1,""],col_B:[0,3,1,""],type_A:[0,3,1,""],type_B:[0,3,1,""]},"migrate.versioning.schemadiff.SchemaDiff":{tables_different:[0,3,1,""],tables_missing_from_A:[0,3,1,""],tables_missing_from_B:[0,3,1,""]},"migrate.versioning.schemadiff.TableDiff":{columns_different:[0,3,1,""],columns_missing_from_A:[0,3,1,""],columns_missing_from_B:[0,3,1,""]},"migrate.versioning.script":{base:[0,0,0,"-"],py:[0,0,0,"-"],sql:[0,0,0,"-"]},"migrate.versioning.script.base":{BaseScript:[0,1,1,""]},"migrate.versioning.script.base.BaseScript":{run:[0,2,1,""],source:[0,2,1,""],verify:[0,2,1,""]},"migrate.versioning.script.py":{PythonScript:[0,1,1,""]},"migrate.versioning.script.py.PythonScript":{create:[0,2,1,""],make_update_script_for_model:[0,2,1,""],module:[0,4,1,""],preview_sql:[0,2,1,""],require_found:[0,2,1,""],require_notfound:[0,2,1,""],run:[0,2,1,""],source:[0,2,1,""],verify:[0,2,1,""],verify_module:[0,2,1,""]},"migrate.versioning.script.sql":{SqlScript:[0,1,1,""]},"migrate.versioning.script.sql.SqlScript":{create:[0,2,1,""],require_found:[0,2,1,""],require_notfound:[0,2,1,""],run:[0,2,1,""],source:[0,2,1,""],verify:[0,2,1,""]},"migrate.versioning.shell":{PassiveOptionParser:[0,1,1,""],main:[0,5,1,""]},"migrate.versioning.util":{Memoize:[0,1,1,""],asbool:[0,5,1,""],catch_known_errors:[0,5,1,""],construct_engine:[0,5,1,""],guess_obj_type:[0,5,1,""],load_model:[0,5,1,""],with_engine:[0,5,1,""]},"migrate.versioning.version":{Collection:[0,1,1,""],Extensions:[0,1,1,""],VerNum:[0,1,1,""],Version:[0,1,1,""],str_to_filename:[0,5,1,""]},"migrate.versioning.version.Collection":{create_new_python_version:[0,2,1,""],create_new_sql_version:[0,2,1,""],latest:[0,4,1,""],version:[0,2,1,""]},"migrate.versioning.version.Version":{add_script:[0,2,1,""],script:[0,2,1,""]},migrate:{changeset:[0,0,0,"-"],exceptions:[0,0,0,"-"],versioning:[0,0,0,"-"]}},objnames:{"0":["py","module","Python module"],"1":["py","class","Python class"],"2":["py","method","Python method"],"3":["py","attribute","Python attribute"],"4":["py","property","Python property"],"5":["py","function","Python function"],"6":["py","exception","Python exception"]},objtypes:{"0":"py:module","1":"py:class","2":"py:method","3":"py:attribute","4":"py:property","5":"py:function","6":"py:exception"},terms:{"0":[0,2,6,7,9],"001_add_account_t":9,"001_add_initial_t":0,"001_description_postgresql_downgrad":0,"001_description_postgresql_upgrad":0,"002_add_email_column":9,"002_postgresql_downgrad":9,"002_postgresql_upgrad":9,"01":7,"02":7,"05":7,"07":7,"08":7,"1":[0,7,9],"10":1,"100":1,"104":1,"105":1,"107":1,"108":1,"11":7,"113":1,"118":1,"121":1,"122":1,"123":1,"1231":7,"124":1,"125":1,"128":[1,9],"129":1,"140":1,"15":1,"154":1,"2":[0,6,7,9],"2005":7,"2010":7,"2011":7,"201x":7,"2021":7,"23":1,"26":7,"27":7,"29":1,"3":[2,7],"30":7,"32":1,"36":1,"38":1,"4":[0,7,9],"40":9,"41":9,"42":[2,9],"5":[0,7,9],"52":1,"52201":0,"54":1,"6":[0,2,7,9],"62":1,"64":1,"66":1,"68":1,"69":1,"7":[6,7,9],"72":1,"74":1,"75":1,"77":2,"8":[0,1,7],"80":1,"83":1,"87":1,"88":1,"9":[0,1],"94":1,"96":1,"beno\u00eet":1,"boolean":0,"break":[1,9],"case":[0,1,2,7],"catch":0,"class":[0,1,2],"default":[0,1,2,5,9],"do":[0,1,2,5,9],"elsd\u00f6rfer":3,"final":0,"function":[1,2,7,9],"garc\u00eda":3,"import":[0,1,2,9],"int":0,"ko\u017ear":[3,7],"lepist\u00f6":3,"new":[0,1,2,4,7,9],"null":[5,7,9],"r\u0101t":3,"rafa\u0142":3,"return":0,"str\u00f6mberg":3,"true":[0,1,2,9],"try":2,"while":1,A:[0,5,6,9],As:9,At:0,But:9,By:[0,9],For:[0,2,9],If:[0,1,3,4,9],In:[0,2,7],It:[0,7,9],NOT:[5,7,9],No:0,Not:0,One:9,That:5,The:[0,2,3,7,9],These:9,To:[4,9],Will:0,_:0,__init__:1,__main__:1,__name__:1,__new__:[0,1],__version__:1,_build:1,_express:0,_run_single_visitor:0,_schema:0,_set_par:1,abbrevi:6,abdelkad:3,abl:[4,9],about:[0,3,9],abov:[2,9],accept:[0,1,9],access:[0,2],accord:1,accordingli:1,account:9,acquir:0,across:1,act:0,action:7,activest:0,actual:[0,9],ad:[0,1,2,7],adam:3,add:[0,1,2,3,5,7,9],add_help_opt:0,add_script:0,add_to_t:1,addit:7,additon:1,adoma:3,advanc:2,advic:[1,3],affect:[2,9],after:[0,1,2,5,7,9],ag:2,again:1,against:[0,1,9],al:7,alex:[1,3],alexand:3,algarvio:3,alia:0,alik:0,all:[0,1,2,4,5,9],allard:1,allow:[0,1,2,5,9],almost:9,alon:9,alreadi:[0,5,9],also:[0,1,2,9],alter:[0,1,2,7,9],alter_column:[0,1],alter_metadata:[1,2],altertablevisitor:0,although:0,alwai:2,an:[0,1,2,6,9],andrei:3,andrew:3,androniko:3,ani:[0,2,9],announc:1,anoth:[0,2,9],ansi:0,ansicolumndropp:0,ansicolumngener:0,ansiconstraintcommon:0,ansiconstraintdropp:0,ansiconstraintgener:0,ansidialect:0,ansischemachang:0,ansisql:7,antoin:3,anymor:1,anyth:9,api:[1,2],apierror:0,apollon:3,app:9,appear:9,append:0,append_column:1,appli:[0,1,9],applic:9,apply_diff:0,applymodel:0,appropri:0,ar:[0,1,2,4,9],archiv:7,are_column_types_eq:0,aren:0,arg:0,argument:[0,1,2,9],argument_for:0,argument_nam:0,argumenterror:0,argv:0,arrang:0,artemenko:3,asbool:0,ascend:6,aspx:7,assembl:0,assert:2,assign:9,associ:[0,9],assum:[0,9],assumpt:9,astanin:3,asuffield:[1,3],atler:1,attempt:[0,9],attribut:[0,1],attributeerror:1,author:7,autocod:0,autoload:9,autom:1,automat:0,autonam:[0,1],avail:[0,2,4,7,9],avoid:[1,9],b:0,backward:[1,7],bad:[0,9],barbato:3,barendt:3,base:[0,1,2,9],basescript:0,basic:5,baumann:3,bayer:[1,3],becaus:[2,9],been:[0,1,3,4,7,9],befor:[8,9],begin:[0,9],behalf:0,behav:0,behavior:[0,7],behaviour:9,behind:9,being:1,belong:9,ben:3,benjamin:3,best:2,better:[0,1,9],between:[0,9],bialecki:3,bin:9,bind:[0,9],bit:1,blob:5,blog:7,bonser:3,bool:[0,1],borrow:0,both:[0,9],bound:0,branch:7,branko:3,broke:7,bruno:3,buffer:0,bug:[3,4,7],build:[0,1],bylina:3,c:[2,9],calcul:0,call:[0,1,9],can:[0,1,2,4,6,7,9],cannot:9,cantrel:[1,3],captur:0,care:9,cascad:[0,1,2],cascade_constraint:0,case_sensit:0,catch_known_error:0,cfg:[6,9],chang:[2,4],changelog:1,changer:0,changeset:[1,2,6,7,9],changesetcolumn:[0,1,2],changesetdefaultclaus:0,changesetindex:0,changesett:0,che:3,check:[0,1,2],checkconstraint:[0,1,2],chees:4,chen:3,chesnei:3,child:0,chri:3,christian:[1,3,9],christoph:3,classmethod:0,claus:0,clean:1,clear:[0,1],cli:7,close:0,cmd:[0,1],code:[0,1,3,7,9],col1:2,col2:2,col3:2,col:[0,2],col_a:0,col_b:0,col_nam:0,coldiff:[0,1],collect:[0,9],column:[0,1,7,9],column_kei:0,columncollect:0,columncollectionconstraint:0,columndelta:[0,1],columndropp:0,columngener:0,columns_differ:0,columns_missing_from_a:0,columns_missing_from_b:0,com:[0,1,3,7],command:[1,4,7],commandlin:9,comment:1,commit:[1,9],common:0,commonli:1,compar:[0,1,9],compare_1_column:0,compare_2_column:0,compare_model_to_db:[0,1,9],compare_paramet:0,comparison:[0,1],compat:[1,7],compil:[0,9],compiler_lint:0,complet:[1,4],complianc:1,comput:0,con:[0,2],condit:[0,1],config:0,config_fil:0,configur:[0,2,6,7],conflict:1,conflict_handl:0,confus:1,connect:[0,1,9],consid:9,consist:7,constaint:0,constraint:[1,7,9],constraintchangeset:0,constraintdropp:0,constraintgener:0,construct:[0,1],construct_argu:0,construct_engin:0,constructor:[0,1],consum:0,contain:[0,5,6,9],contains_column:0,content:[0,5],context:0,continu:9,contraint:[1,2],contribut:[3,4],contributor:1,control:[0,7],controlledschema:0,controlledschemaerror:0,conveni:9,convert:0,convert_unicod:0,coomb:3,copi:[0,9],copy_fix:0,core:0,correct:[0,1,9],correctli:[1,9],correspond:1,could:9,coverag:1,creat:[0,1,2,3,5,7],create_column:0,create_engin:[0,9],create_manage_fil:0,create_model:[0,9],create_new_python_vers:0,create_new_sql_vers:0,create_script:0,create_script_sql:0,creation:[0,1],credit:[1,7],current:[0,7,8,9],current_col_nam:0,current_column:0,current_nam:[0,1],custom:[0,1,7],cut:0,d:[0,4],dalouch:3,dan:3,dangoor:[1,3],data:[0,5,7,9],databas:[1,5,6,7],databasealreadycontrollederror:0,databasenotcontrollederror:0,datatyp:7,date:0,david:3,db2:7,db:[0,1,9],db_version:[0,9],dbapi:0,ddl:0,de:[1,3],deal:[1,7],declar:[0,9],decler:0,decor:0,def:[1,9],defaultclaus:0,defaultdialect:0,defin:[0,1,6,9],definit:[7,9],delta:0,demand:9,depend:1,deprec:[0,1,2],der:3,deregist:0,describ:0,descript:[0,1,9],despit:9,dest:0,destin:0,detail:9,determin:[0,9],dev:[4,7],develop:[1,9],dialect:[0,1,2],dialect_kwarg:0,dialect_nam:0,dialect_opt:0,dialectkwarg:0,dict:0,dictionari:0,diff:[0,1],differ:[0,1,9],differenc:7,direct:[0,2],directionless:0,directori:[0,9],disable_log:[0,1],discourag:1,displai:[0,9],dispos:0,dittbern:[3,7],dittbernerno:7,doc:[1,4],document:[2,4,9],doe:[0,1,5,9],domen:[1,3,7],domenno:7,don:[1,9],done:[0,2,9],dot:[0,1,3],dotted_nam:0,doubl:0,down:[0,1],downgrad:[1,6,7,9],download:1,driver:1,drop:[0,1,2,7,9],drop_column:0,drop_version_control:0,drope:[0,1],dropper:0,due:9,dump:[0,1,9],dure:[7,9],dustin:[1,3],dynam:0,e:0,each:[0,9],earlier:0,eas:9,easi:8,easy_instal:4,echo:[0,1],edit:7,eg:1,either:[0,2],element:[0,9],elixir:7,elli:[1,3],els:0,email:[1,9],emailc:9,emil:3,empti:[0,1,9],emsli:3,enabl:0,encod:0,end:[0,9],endver:0,engin:[0,1,9],engine_arg_:[0,1],engine_dict:[0,1],engledew:3,enough:9,ensur:[0,9],enter:9,entir:9,entrypoint:1,epilog:0,equal:0,equival:9,error:[0,1,9],especi:1,etc:[0,9],evalu:0,evan:[1,3,7],everi:9,everyth:[0,1,2],evolv:9,ex:[0,9],exactli:[0,9],exampl:[0,1,7,9],except:[1,7,9],exclud:[0,1],excludet:[0,1],excludetablesgetdiffofmodelagainstmodel:1,exectu:0,execut:[0,9],exist:[0,2,7],expect:[0,9],experiment:[0,1,7],explain:9,explicit:[1,2,9],explicitli:2,express:0,extend:[0,9],extens:0,extern:0,extra:[0,2],extract:[0,1],extras_requir:1,eyal:3,f:0,fail:[1,9],failur:1,fals:[0,2,7],faq:7,far:9,favaro:[1,3],favor:1,favour:0,fbcolumndropp:0,fbcolumngener:0,fbconstraintdropp:0,fbconstraintgener:0,fbdialect:0,fbschemachang:0,featur:[0,7,9],file:[0,1,4,6,9],file_:0,filelist:0,filenam:[0,1],filesystem:1,fill:9,find:0,fine:[1,9],firebird:[1,7],first:[0,1,9],fit:9,fix:7,fk:0,fkei:2,flag:0,flat:0,florian:3,fn:0,follow:[0,2,3,4,7,9],foobar:2,foreign:[1,2],foreignkeyconstraint:[0,1,2],forgiv:1,forkel:3,form:0,format:[0,1],formatt:0,found:0,fred:3,free:7,freshli:9,friedenbach:3,from:[0,1,2,4,6,7,8,9],frontend:9,fuller:3,futur:0,g:0,gabriel:[1,3],gedmina:3,genb2amigr:0,genbdefinit:0,gener:[1,7,9],genmodel:[1,7],gerrit:4,get:[0,1,4,5,9],get_children:0,get_constraint_nam:0,get_dialect_visitor:0,get_engine_visitor:0,getdiffofmodelagainstdatabas:0,getdiffofmodelagainstmodel:0,getelman:3,ginsberg:3,github:[4,7],give:[0,2],given:[0,2,9],gladilin:3,glossari:[1,7],gmail:[1,3],goe:[0,9],gonera:3,good:9,googl:[0,1,3,7],graham:3,greb:3,grossman:3,group:7,guess:[0,2,9],guess_obj_typ:0,ha:[0,1,3,7,9],had:7,hamel:3,hand:9,handl:1,hanff:3,happen:[0,9],have:[0,1,2,4,5,9],headlin:9,heavili:0,heck:3,help:[0,1,3,4,9],helper:0,here:[0,2,9],hesketh:3,hierarchi:6,higgin:3,highest:9,ho:[1,3],hoc:0,hochstein:3,home:9,host:7,how:[2,6],howev:[0,9],html:[4,7],http:[0,4,7],id:[0,2,9],idea:9,ident:0,identifi:9,ie:[0,9],ignor:[1,4,9],ilya:3,immedi:0,implement:[1,7],implicit:9,implicit_return:0,improv:[1,3],includ:[0,2],incompat:1,incorrect:1,increment:9,indent:0,independ:[0,2,9],index:[0,1,7],index_nam:[0,1,2],indic:[0,9],info:[0,7],inform:[0,1,2,4,7,9],infra:4,initi:[0,3,9],insert:7,insid:9,inspir:7,instal:[4,9],instanc:[0,1],instead:[0,1,2,9],instruct:6,intact:0,integ:[2,9],integr:[1,9],integrityerror:5,interest:9,interfac:[7,9],intern:1,interpret:1,intuit:2,invalid:0,invalidconstrainterror:0,invalidrepositoryerror:0,invalidscripterror:0,invalidversionerror:0,involv:1,isn:0,issu:[0,1,2,7],issuetrack:1,istead:0,item:0,its:[0,2,9],itself:9,j:[1,3],jai:3,jame:3,jan:[3,7],jarrod:3,jason:[1,3],jayson:3,jeremi:[1,3],jeroen:3,joe:3,johnson:3,johnston:3,jona:3,jonathan:[1,3,7],jorg:3,joshua:3,jude:3,juliusz:3,just:[0,1,9],k:0,kang:3,keen:1,kei:[0,1,2,9],keroack:3,kevin:[1,3],keyword:[0,1,2,9],kind:[0,2],know:9,known:0,knownerror:0,ko:3,kozar:1,kristap:3,kristian:3,kroymann:3,kumar:[1,3],kuratomi:3,kvilekv:3,kw:0,kwarg:[0,9],label:0,label_length:0,labela:0,labelb:0,lacour:7,landon:3,lang_altert:7,languag:0,larger:0,later:0,latest:[0,4,9],latest_vers:9,launchpad:[4,7],learn:9,leav:0,leduc:3,lee:3,left:2,lenard:3,length:[0,1],let:[0,9],lev:3,level:[0,5,9],licens:7,life:2,like:[0,4,9],limit:7,lin:3,line:[0,1,4,7],link:[1,2],list:[0,1,2,3,4,7,9],ll:[2,9],load:[0,2],load_model:0,local:0,locat:0,log:[0,1],logengin:1,login:9,logsql:1,look:9,lope:3,lorin:3,lot:1,lowri:3,ls:9,luca:3,lukasz:3,made:[0,9],magic:1,mahmoud:3,mai:[0,6,9],mail:1,main:[0,1,9],maintain:[3,7],major:1,make:[0,1,2,7],make_update_script_for_model:[0,1,9],manag:[1,6],mani:[0,2,9],manifest:1,manual:4,map:[0,6],mapper:6,marica:3,mariu:3,mark:[0,1,3],markup:1,martin:3,match:[0,2,9],mathieu:3,max_identifier_length:0,maxwel:3,mcloughlin:[1,3],mcmillan:[1,3],mean:[0,5],mechan:9,member:0,memoiz:0,memori:9,mentor:7,messag:0,meta:[2,9],metadata:[0,1,9],metadataa:0,metadatab:0,method:[0,1,2],michael:[1,3],michalski:[1,3],might:9,migrat:[1,3,4,6,9],migrate_engin:[1,9],migrate_repositori:[1,8],migrate_vers:[0,9],migratedeprecationwarn:0,mikael:3,mill:3,mimic:0,minimum:1,miss:[1,3],mit:7,mitchel:[1,3],mock:[0,1],model:[1,7,9],modelgener:0,modif:[1,2,9],modifi:[0,1,2,7],modul:[1,2,7,9],moment:0,monkeypatch:1,more:[1,2,4,7,9],most:[0,2],move:1,mssql:7,much:0,multi:2,multipl:[0,9],must:[0,4,9],mutabl:0,my_object:0,my_repositori:9,mydialect:0,mydialect_length:0,mysql:[5,7,9],mysqlcolumndropp:0,mysqlcolumngener:0,mysqlconstraintdropp:0,mysqlconstraintgener:0,mysqldialect:0,mysqlschemachang:0,mytabl:[2,9],nagurnei:3,name:[0,1,2,3,9],namespac:0,nathan:3,necessari:[1,9],nedo:3,need:[2,9],needless:1,nest:0,net:[4,7],nevar:3,new_col:0,new_column:0,new_typ:0,newindexnam:2,newtablenam:2,next:[0,9],nichola:3,nick:3,non:[0,1],none:0,normal:9,nose:1,nosuchmoduleerror:0,nosuchtableerror:0,note:[0,2],notifi:4,notimplementederror:9,notsupportederror:0,now:[0,1,4,7,9],nullabl:[2,7],num:2,number:[0,1,6,9],obj:0,object:[0,1,2,6,9],observ:9,octob:7,odagaki:3,off:0,old:[0,1,9],old_col:0,old_typ:0,older:9,oldmodel:0,omit:[0,9],omit_attr:0,onc:[0,4,9],one:[0,2,9],onli:[0,1,2,9],onlin:1,op:0,openstack:4,oper:[0,2,7,9],opt:0,option:[0,1,2,5,9],option_class:0,option_list:0,optionpars:9,optpars:0,oracl:[1,2,7,9],oraclecolumndropp:0,oraclecolumngener:0,oracleconstraintdropp:0,oracleconstraintgener:0,oracledialect:0,oracleschemachang:0,order:0,org:[4,7],origin:0,orm:[1,6,7],os:1,other:[0,1,2,9],othert:2,otherwis:[0,1],our:9,out:[0,2],output:[1,9],outsid:9,over:7,overrid:0,overriden:0,own:[1,2,9],p:0,packag:[0,1,9],page:[4,7],paltanaviciu:3,param:0,paramet:[0,1,2,9],paramstyl:0,parent:0,pars:[1,9],part:[0,7,9],parti:0,partial:[1,7],particip:0,particular:0,partli:1,pass:[0,1,2,9],passiveoptionpars:0,passwd:9,past:[3,9],patch:[1,3],path:[7,9],patherror:0,pathfounderror:0,pathnotfounderror:0,patrick:3,paul:3,pawel:3,pedro:3,peopl:3,pep:1,per:0,perciou:3,perform:[0,6,9],perhap:9,persist:1,perthui:[1,3],pete:1,peter:3,pgcolumndropp:0,pgcolumngener:0,pgconstraintdropp:0,pgconstraintgener:0,pgdialect:0,pgschemachang:0,pip:4,pipe:3,pitrou:3,place:1,plain:0,pleas:[3,7],poli:3,popul:[0,2],populate_default:[0,1,2],posit:[0,9],possibl:0,postgr:[7,9],postgresql:[0,1,9],postgresql_wher:0,practic:2,pradeep:3,prat:3,preconfigur:9,predefin:9,prefer:9,prepar:0,prepare_config:0,present:[0,1],pretti:1,prevent:1,preview:[0,9],preview_pi:[0,9],preview_sql:[0,1,9],previou:1,primari:[0,2,9],primary_kei:[2,9],primary_key_nam:[0,1,2],primarykeyconstraint:[0,2],print:1,prioriti:9,probabl:[1,5,9],problem:9,process:[0,9],process_column:0,product:[1,9],prog:[0,9],program:9,project:[0,3,7],properli:[1,9],properti:[0,2,5],provid:[0,7,9],pull:[1,4],purpos:9,put:9,pwannygood:1,py:[0,1,6,8,9],py_tmpl:9,pylon:9,pypi:1,python:[1,2,6,7],pythonscript:0,q:7,queri:0,quot:[0,1],r:3,rail:7,rais:[0,9],rather:[0,9],raw:0,re:[1,9],read:[1,7,9],readthedoc:7,real:0,realli:9,receiv:0,reciev:1,refactor:[1,9],refcolumn:0,refer:[0,1,9],referenc:0,referred_t:0,reffer:0,refin:1,reflect:[0,1,9],regard:4,regardless:1,registri:0,regress:1,rel:9,relat:[1,6],releas:[0,4,6],relev:2,rememb:9,remov:[0,1,5],renam:[0,1,2,7],rename_index:0,rename_t:0,replac:0,report:3,repositori:[1,6,7],repository_directori:8,repository_id:9,repository_path:0,repositoryerror:0,repres:0,represent:0,request:4,requir:[0,1,2,9],require_found:0,require_notfound:0,required_db:9,resourc:0,respect:0,rest:9,restrict:5,result:[0,9],result_column:0,retallack:3,retriev:9,reus:0,revers:[0,1,9],revert:9,review:4,rewrit:1,rewriten:9,robert:3,romi:3,rosson:[3,7],roughli:9,row:5,rubi:7,ruigrok:3,run:[0,1,8,9],run_single_visitor:0,runb2a:0,rundown:2,ryan:3,s:[0,1,2,3,5,7,9],sa:[0,1],sa_dialect:0,saclass:0,safe:0,sai:9,same:[0,2,9],sami:3,save:0,schema:[1,6],schemachang:0,schemadiff:[1,7],schemagener:[0,1],schemaitem:0,schemaiter:0,scheme:0,schiel:3,scratch:[0,9],script:[1,6,7],script_sql:[0,9],scripterror:0,search:7,second:[0,1,9],section:[1,2,9],see:[2,7,9],select:9,self:[0,2],send:[0,9],sensit:1,sent:0,separ:0,sequenc:[0,1],sergiu:3,seri:0,server_default:1,server_side_cursor:0,set:[0,1,5,6,9],setup:[1,7],setuptool:1,sever:[0,9],shabalin:3,shamardin:3,shell:[1,7,9],shield:3,shop:4,should:[0,1,4,6,8,9],shouldn:[0,9],show:0,shown:[1,9],shut:1,shutil:1,si:7,silent:[1,9],similar:9,similarli:9,simm:[1,3,9],simon:3,simpl:9,simpli:0,simplifi:1,sinc:[0,2],singl:[0,9],slade:3,slot:9,small:7,so:[0,5,9],some:[0,1,2,9],some_index:0,some_opt:[0,9],someth:[2,9],sometim:[1,9],sorek:3,sort:0,sourc:[0,1,7,9],space:0,spamdev:7,spamgooglemail:7,specif:[6,7],specifi:[0,1,9],sphinx:1,sphinxcontrib:1,split:7,sponsor:3,sql:[1,6,7],sqlalchemi:[1,2,3,4,6,8,9],sqlautocod:0,sqlite3:9,sqlite:[1,7,9],sqlite_sequ:1,sqlitecolumndropp:0,sqlitecolumngener:0,sqliteconstraintdropp:0,sqliteconstraintgener:0,sqlitedialect:0,sqliteschemachang:0,sqlscript:0,sqltext:0,stackforg:7,stamp:9,standalon:0,standard:[2,7],stark:3,start:[0,7,9],start_alter_column:0,start_alter_t:0,startver:0,state:[0,2],statement:[0,1,2,7],stdout:[0,9],step:[0,1,4],stephen:3,still:1,store:[0,9],stout:3,str_to_filenam:0,string:[0,1,2,9],structur:0,stuff:9,sub:9,subclass:0,submit:4,subscrib:4,subsequ:9,subset:0,succed:0,success:9,successfulli:9,sudwart:3,summaris:0,summer:[3,7],suppli:0,support:[0,1,2,9],supports_native_boolean:0,sure:[2,9],svetlov:3,sylvain:3,synonym:0,syntax:[0,1],system:[0,1],t:[0,1,9],tabl:[0,1,5],tablediff:0,tables_differ:0,tables_missing_from_a:0,tables_missing_from_b:0,tailor:9,take:[2,9],taken:[0,7],tarbal:1,target:0,target_t:0,tediou:9,tell:[3,9],templat:[0,1,7],templates_path:[1,9],templates_them:[1,9],temporari:7,tend:0,terminolog:1,test:[0,1,7],tests_requir:1,text:[0,1,5],than:[0,1,2,9],thank:[1,3],thei:9,them:9,theme:9,therefor:0,thi:[0,1,2,4,5,9],thing:[0,1],third:0,those:[4,9],though:1,thread:9,through:[0,1,4],thu:5,time:[0,2,7,9],timestamp:[1,6,9],tmpl_dir:0,toarca:3,too:9,tool:[0,1,4,6,9],topython:0,toshio:3,toupgradedowngradepython:0,trac:1,track:[1,9],tracker:1,transact:1,transform:0,travers:0,tree:0,trei:3,tri:0,trick:1,trigger:5,tupl:0,tutori:[1,2],two:[0,5,7,9],type:[0,2,5,9],type_a:0,type_b:0,typic:0,unchang:[0,9],under:[0,9],underscor:0,undesir:9,unicod:1,uniqu:[0,1,2,9],unique_nam:[0,1,2],uniqueconstraint:[0,1,2],unit:1,univers:2,unknown:7,unlik:0,unsupport:1,untouch:1,unus:0,up:[0,1],updat:[0,1,5,9],update_db_from_model:0,update_repository_t:0,upgrad:[1,6,7],url:[0,1,9],us:[0,1,2,3,4,6,7,8,9],usag:[0,1,7],usageerror:0,use_timestamp_numb:[0,9],user:[0,1,9],usr:9,utc:9,utf:0,util:7,valid:0,valu:[0,1,5],van:3,vantuyl:3,varchar:9,varga:3,vari:0,variabl:[0,9],variou:[2,7],vasilii:3,ve:9,ver:0,veri:9,verifi:0,verify_modul:0,vernum:0,versa:9,version:[1,2,4,6,7,8],version_control:[0,1,9],version_t:[0,9],versionnotfounderror:0,via:[0,4,9],vice:9,vienn:3,view:[0,9],visit:0,visit_column:0,visit_index:0,visit_t:0,visitor:7,visitorcal:0,volunt:7,vukel:3,wa:[0,1,7,9],wai:[0,1,7,9],want:9,warn:[0,1],we:[3,9],well:[2,7,9],were:[0,9],weren:0,werven:3,what:[0,9],when:[0,1,2,4,7,9],where:[0,1],which:[0,1,6,9],whole:9,wilcox:3,wish:[0,9],with_engin:0,wither:3,within:0,without:[2,5,9],won:9,wong:[1,3],work:[0,1,5,9],workaround:7,workflow:[4,7],would:[0,4,9],wrap:0,wright:3,writabl:0,write:7,written:0,wrong:9,wrongrepositoryerror:0,www:7,x2line:7,x:[0,1,7],xx:7,y:0,yamada:3,ye:7,yeeland:3,yet:0,you:[0,2,3,4,5,7,9],your:[0,2,3,5,8,9],yuen:[1,3],zukowski:3},titles:["Module <code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">migrate.changeset</span></code> \u2013 Schema changes","0.7.3 (201x-xx-xx)","Database schema migrations","Credits","Download","FAQ","Glossary","<code class=\"xref py py-mod docutils literal notranslate\"><span class=\"pre\">migrate</span></code> - SQLAlchemy Migrate (schema change management)","Repository migration (0.4.5 -&gt; 0.5.4)","Database schema versioning workflow"],titleterms:{"0":[1,8],"01":1,"02":1,"05":1,"07":1,"1":1,"11":1,"2":1,"2010":1,"2011":1,"201x":1,"27":1,"3":1,"4":[1,8],"5":[1,8],"6":1,"7":1,"function":0,action:0,ad:5,addit:0,ansisql:0,api:[0,7,9],behavior:9,bug:1,chang:[0,1,7,9],changelog:7,changeset:0,cli:0,column:[2,5],command:[0,9],configur:9,consist:9,constraint:[0,2],control:9,creat:9,credit:3,custom:9,databas:[0,2,9],definit:0,develop:[4,7],dialect:7,differenc:0,document:[1,7],downgrad:0,download:[4,7],edit:9,exampl:2,except:0,exist:9,experiment:9,fals:5,faq:5,featur:1,firebird:0,fix:1,gener:0,genmodel:0,glossari:6,guid:7,implement:0,index:2,indic:7,interfac:0,line:9,make:9,manag:[0,7,9],migrat:[0,2,7,8],model:0,modifi:9,modul:0,mysql:0,nullabl:5,oracl:0,orm:0,overview:7,path:0,postgr:0,project:9,python:[0,9],q:5,repositori:[0,8,9],schema:[0,2,7,9],schemadiff:0,script:[0,9],setup:9,shell:0,specif:[0,9],sql:[0,9],sqlalchemi:[0,7],sqlite:0,standard:0,support:7,tabl:[2,7,9],templat:9,test:9,tutori:7,upgrad:[0,9],usag:9,user:7,util:0,variou:0,version:[0,9],visitor:0,workflow:9,write:9,xx:1}})