SQLAlchemy Migrate
Download
Development
Credits
Database schema versioning workflow
Project setup
Making schema changes
Writing change scripts
Command line usage
Python API
Experimental commands
Repository configuration
Customize templates
Database schema migrations
Column
Table
Index
Constraint
Repository migration (0.4.5 -> 0.5.4)
FAQ
Q: Adding a
nullable=False
column
Glossary
Module
migrate.changeset
– Schema changes
Module
migrate.changeset
– Schema migration API
Module
ansisql
– Standard SQL implementation
Module
constraint
– Constraint schema migration API
Module
databases
– Database specific schema migration
Module
schema
– Additional API to SQLAlchemy for migrations
Module
migrate.versioning
– Database versioning and repository management
Module
api
– Python API commands
Module
genmodel
– ORM Model generator
Module
pathed
– Path utilities
Module
repository
– Repository management
Module
schema
– Migration upgrade/downgrade
Module
schemadiff
– ORM Model differencing
Module
script
– Script actions
Module
shell
– CLI interface
Module
util
– Various utility functions
Module
version
– Versioning management
Module
exceptions
– Exception definitions
0.7.3 (201x-xx-xx)
Changes
Documentation
Features
Fixed Bugs
0.7.2 (2011-11-01)
Changes
Documentation
Features
Fixed Bugs
0.7.1 (2011-05-27)
Fixed Bugs
0.7 (2011-05-27)
Features
Fixed bugs
0.6.1 (2011-02-11)
Features
Fixed bugs
0.6 (11.07.2010)
Features
Fixed bugs
Documentation
0.5.4
0.5.3
0.5.2
0.5.1.2
0.5.1.1
0.5.1
0.4.5
0.4.4
0.4.3
0.4.2
0.4.1
0.4.0
0.3
0.2.3
0.2.2
0.2.1
SQLAlchemy Migrate
Docs
»
Edit on GitHub
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
A
add() (migrate.versioning.repository.Changeset method)
add_script() (migrate.versioning.version.Version method)
alter() (migrate.changeset.schema.ChangesetColumn method)
alter_column() (in module migrate.changeset.schema)
AlterTableVisitor (class in migrate.changeset.ansisql)
and_() (in module migrate.versioning.schema)
ANSIColumnDropper (class in migrate.changeset.ansisql)
ANSIColumnGenerator (class in migrate.changeset.ansisql)
ANSIConstraintCommon (class in migrate.changeset.ansisql)
ANSISchemaChanger (class in migrate.changeset.ansisql)
ApiError
append() (migrate.changeset.ansisql.AlterTableVisitor method)
apply_diffs() (migrate.changeset.schema.ColumnDelta method)
are_column_types_eq() (migrate.changeset.schema.ColumnDelta method)
argument_for() (migrate.changeset.constraint.CheckConstraint class method)
(migrate.changeset.constraint.ForeignKeyConstraint class method)
(migrate.changeset.constraint.PrimaryKeyConstraint class method)
(migrate.changeset.constraint.UniqueConstraint class method)
asbool() (in module migrate.versioning.util)
autoname() (migrate.changeset.constraint.ForeignKeyConstraint method)
(migrate.changeset.constraint.PrimaryKeyConstraint method)
(migrate.changeset.constraint.UniqueConstraint method)
B
BaseScript (class in migrate.versioning.script.base)
bindparam() (in module migrate.versioning.schema)
C
cascade_constraint() (migrate.changeset.databases.firebird.FBConstraintDropper method)
catch_known_errors() (in module migrate.versioning.util)
changeset
Changeset (class in migrate.versioning.repository)
changeset() (migrate.versioning.repository.Repository method)
(migrate.versioning.schema.ControlledSchema method)
ChangesetColumn (class in migrate.changeset.schema)
ChangesetDefaultClause (class in migrate.changeset.schema)
ChangesetIndex (class in migrate.changeset.schema)
ChangesetTable (class in migrate.changeset.schema)
CheckConstraint (class in migrate.changeset.constraint)
col_A (migrate.versioning.schemadiff.ColDiff attribute)
col_B (migrate.versioning.schemadiff.ColDiff attribute)
ColDiff (class in migrate.versioning.schemadiff)
Collection (class in migrate.versioning.version)
ColumnDelta (class in migrate.changeset.schema)
columns_different (migrate.versioning.schemadiff.TableDiff attribute)
columns_missing_from_A (migrate.versioning.schemadiff.TableDiff attribute)
columns_missing_from_B (migrate.versioning.schemadiff.TableDiff attribute)
compare_1_column() (migrate.changeset.schema.ColumnDelta method)
compare_2_columns() (migrate.changeset.schema.ColumnDelta method)
compare_model_to_db() (in module migrate.versioning.api)
(migrate.versioning.schema.ControlledSchema class method)
compare_parameters() (migrate.changeset.schema.ColumnDelta method)
ConstraintChangeset (class in migrate.changeset.constraint)
construct_engine() (in module migrate.versioning.util)
ControlledSchema (class in migrate.versioning.schema)
ControlledSchemaError
copy_fixed() (migrate.changeset.schema.ChangesetColumn method)
create() (in module migrate.versioning.api)
(migrate.changeset.constraint.CheckConstraint method)
(migrate.changeset.constraint.ConstraintChangeset method)
(migrate.changeset.constraint.ForeignKeyConstraint method)
(migrate.changeset.constraint.PrimaryKeyConstraint method)
(migrate.changeset.constraint.UniqueConstraint method)
(migrate.changeset.schema.ChangesetColumn method)
(migrate.versioning.repository.Repository class method)
(migrate.versioning.schema.ControlledSchema class method)
(migrate.versioning.script.py.PythonScript class method)
(migrate.versioning.script.sql.SqlScript class method)
create_column() (in module migrate.changeset.schema)
(migrate.changeset.schema.ChangesetTable method)
create_manage_file() (migrate.versioning.repository.Repository class method)
create_model() (in module migrate.versioning.api)
(migrate.versioning.schema.ControlledSchema class method)
create_new_python_version() (migrate.versioning.version.Collection method)
create_new_sql_version() (migrate.versioning.version.Collection method)
create_script() (migrate.versioning.repository.Repository method)
create_script_sql() (migrate.versioning.repository.Repository method)
D
DatabaseAlreadyControlledError
DatabaseNotControlledError
db_version() (in module migrate.versioning.api)
deregister() (migrate.changeset.schema.ChangesetTable method)
dialect_kwargs (migrate.changeset.constraint.CheckConstraint attribute)
(migrate.changeset.constraint.ForeignKeyConstraint attribute)
(migrate.changeset.constraint.PrimaryKeyConstraint attribute)
(migrate.changeset.constraint.UniqueConstraint attribute)
dialect_options (migrate.changeset.constraint.CheckConstraint attribute)
(migrate.changeset.constraint.ForeignKeyConstraint attribute)
(migrate.changeset.constraint.PrimaryKeyConstraint attribute)
(migrate.changeset.constraint.UniqueConstraint attribute)
downgrade() (in module migrate.versioning.api)
drop() (migrate.changeset.constraint.CheckConstraint method)
(migrate.changeset.constraint.ConstraintChangeset method)
(migrate.changeset.constraint.ForeignKeyConstraint method)
(migrate.changeset.constraint.PrimaryKeyConstraint method)
(migrate.changeset.constraint.UniqueConstraint method)
(migrate.changeset.schema.ChangesetColumn method)
(migrate.versioning.schema.ControlledSchema method)
drop_column() (in module migrate.changeset.schema)
(migrate.changeset.schema.ChangesetTable method)
drop_version_control() (in module migrate.versioning.api)
E
Error
execute() (migrate.changeset.ansisql.AlterTableVisitor method)
Extensions (class in migrate.versioning.version)
F
FBColumnDropper (class in migrate.changeset.databases.firebird)
FBColumnGenerator (class in migrate.changeset.databases.firebird)
FBConstraintDropper (class in migrate.changeset.databases.firebird)
FBConstraintGenerator (class in migrate.changeset.databases.firebird)
FBSchemaChanger (class in migrate.changeset.databases.firebird)
ForeignKeyConstraint (class in migrate.changeset.constraint)
G
genB2AMigration() (migrate.versioning.genmodel.ModelGenerator method)
genBDefinition() (migrate.versioning.genmodel.ModelGenerator method)
get_children() (migrate.changeset.constraint.CheckConstraint method)
(migrate.changeset.constraint.ForeignKeyConstraint method)
(migrate.changeset.constraint.PrimaryKeyConstraint method)
(migrate.changeset.constraint.UniqueConstraint method)
get_constraint_name() (migrate.changeset.ansisql.ANSIConstraintCommon method)
get_dialect_visitor() (in module migrate.changeset.databases.visitor)
get_engine_visitor() (in module migrate.changeset.databases.visitor)
getDiffOfModelAgainstDatabase() (in module migrate.versioning.schemadiff)
getDiffOfModelAgainstModel() (in module migrate.versioning.schemadiff)
guess_obj_type() (in module migrate.versioning.util)
H
help() (in module migrate.versioning.api)
I
id (migrate.versioning.repository.Repository attribute)
info (migrate.changeset.constraint.CheckConstraint attribute)
(migrate.changeset.constraint.ForeignKeyConstraint attribute)
(migrate.changeset.constraint.PrimaryKeyConstraint attribute)
(migrate.changeset.constraint.UniqueConstraint attribute)
InvalidConstraintError
InvalidRepositoryError
InvalidScriptError
InvalidVersionError
K
keys() (migrate.versioning.repository.Changeset method)
KnownError
kwargs (migrate.changeset.constraint.CheckConstraint attribute)
(migrate.changeset.constraint.ForeignKeyConstraint attribute)
(migrate.changeset.constraint.PrimaryKeyConstraint attribute)
(migrate.changeset.constraint.UniqueConstraint attribute)
L
latest (migrate.versioning.repository.Repository attribute)
(migrate.versioning.version.Collection attribute)
load() (migrate.versioning.schema.ControlledSchema method)
load_model() (in module migrate.versioning.util)
M
main() (in module migrate.versioning.shell)
make_update_script_for_model() (in module migrate.versioning.api)
(migrate.versioning.script.py.PythonScript class method)
manage() (in module migrate.versioning.api)
Memoize (class in migrate.versioning.util)
migrate (module)
migrate.changeset (module)
migrate.changeset.ansisql (module)
migrate.changeset.constraint (module)
migrate.changeset.databases (module)
migrate.changeset.databases.firebird (module)
migrate.changeset.databases.mysql (module)
migrate.changeset.databases.oracle (module)
migrate.changeset.databases.postgres (module)
migrate.changeset.databases.sqlite (module)
migrate.changeset.databases.visitor (module)
migrate.changeset.schema (module)
migrate.exceptions (module)
migrate.versioning (module)
migrate.versioning.api (module)
migrate.versioning.genmodel (module)
migrate.versioning.migrate_repository (module)
migrate.versioning.pathed (module)
migrate.versioning.repository (module)
migrate.versioning.schema (module)
migrate.versioning.schemadiff (module)
migrate.versioning.script.base (module)
migrate.versioning.script.py (module)
migrate.versioning.script.sql (module)
migrate.versioning.shell (module)
migrate.versioning.util (module)
migrate.versioning.version (module)
MigrateDeprecationWarning
ModelGenerator (class in migrate.versioning.genmodel)
module (migrate.versioning.script.py.PythonScript attribute)
N
NoSuchTableError
NotSupportedError
O
ORM
P
Pathed (class in migrate.versioning.pathed)
PathError
PathFoundError
PathNotFoundError
PGColumnDropper (class in migrate.changeset.databases.postgres)
PGColumnGenerator (class in migrate.changeset.databases.postgres)
PGConstraintDropper (class in migrate.changeset.databases.postgres)
PGConstraintGenerator (class in migrate.changeset.databases.postgres)
PGSchemaChanger (class in migrate.changeset.databases.postgres)
prepare_config() (migrate.versioning.repository.Repository class method)
preview_sql() (migrate.versioning.script.py.PythonScript method)
PrimaryKeyConstraint (class in migrate.changeset.constraint)
process_column() (migrate.changeset.schema.ColumnDelta method)
Python Enhancement Proposals
PEP 8
,
[1]
PythonScript (class in migrate.versioning.script.py)
Q
quote (migrate.changeset.constraint.CheckConstraint attribute)
(migrate.changeset.constraint.ForeignKeyConstraint attribute)
(migrate.changeset.constraint.PrimaryKeyConstraint attribute)
(migrate.changeset.constraint.UniqueConstraint attribute)
R
rename() (migrate.changeset.schema.ChangesetIndex method)
(migrate.changeset.schema.ChangesetTable method)
rename_index() (in module migrate.changeset.schema)
rename_table() (in module migrate.changeset.schema)
repository
Repository (class in migrate.versioning.repository)
repository migration
RepositoryError
require_found() (migrate.versioning.pathed.Pathed class method)
(migrate.versioning.script.py.PythonScript class method)
(migrate.versioning.script.sql.SqlScript class method)
require_notfound() (migrate.versioning.pathed.Pathed class method)
(migrate.versioning.script.py.PythonScript class method)
(migrate.versioning.script.sql.SqlScript class method)
run() (migrate.versioning.repository.Changeset method)
(migrate.versioning.script.base.BaseScript method)
(migrate.versioning.script.py.PythonScript method)
(migrate.versioning.script.sql.SqlScript method)
run_single_visitor() (in module migrate.changeset.databases.visitor)
runB2A() (migrate.versioning.genmodel.ModelGenerator method)
S
SchemaDiff (class in migrate.versioning.schemadiff)
script() (in module migrate.versioning.api)
(migrate.versioning.version.Version method)
script_sql() (in module migrate.versioning.api)
ScriptError
source() (in module migrate.versioning.api)
(migrate.versioning.script.base.BaseScript method)
(migrate.versioning.script.py.PythonScript method)
(migrate.versioning.script.sql.SqlScript method)
SQLiteColumnDropper (class in migrate.changeset.databases.sqlite)
SQLiteColumnGenerator (class in migrate.changeset.databases.sqlite)
SQLiteSchemaChanger (class in migrate.changeset.databases.sqlite)
SqlScript (class in migrate.versioning.script.sql)
start_alter_column() (migrate.changeset.ansisql.ANSISchemaChanger method)
start_alter_table() (migrate.changeset.ansisql.AlterTableVisitor method)
str_to_filename() (in module migrate.versioning.version)
T
TableDiff (class in migrate.versioning.schemadiff)
tables_different (migrate.versioning.schemadiff.SchemaDiff attribute)
tables_missing_from_A (migrate.versioning.schemadiff.SchemaDiff attribute)
tables_missing_from_B (migrate.versioning.schemadiff.SchemaDiff attribute)
test() (in module migrate.versioning.api)
type_A (migrate.versioning.schemadiff.ColDiff attribute)
type_B (migrate.versioning.schemadiff.ColDiff attribute)
U
UniqueConstraint (class in migrate.changeset.constraint)
update_db_from_model() (in module migrate.versioning.api)
(migrate.versioning.schema.ControlledSchema method)
update_repository_table() (migrate.versioning.schema.ControlledSchema method)
upgrade() (in module migrate.versioning.api)
(migrate.versioning.schema.ControlledSchema method)
UsageError
use_timestamp_numbering (migrate.versioning.repository.Repository attribute)
V
verify() (migrate.versioning.repository.Repository class method)
(migrate.versioning.script.base.BaseScript class method)
(migrate.versioning.script.py.PythonScript class method)
(migrate.versioning.script.sql.SqlScript class method)
verify_module() (migrate.versioning.script.py.PythonScript class method)
VerNum (class in migrate.versioning.version)
version
Version (class in migrate.versioning.version)
version() (in module migrate.versioning.api)
(migrate.versioning.repository.Repository method)
(migrate.versioning.version.Collection method)
version_control() (in module migrate.versioning.api)
version_table (migrate.versioning.repository.Repository attribute)
visit_column() (migrate.changeset.ansisql.ANSIColumnDropper method)
(migrate.changeset.ansisql.ANSIColumnGenerator method)
(migrate.changeset.ansisql.ANSISchemaChanger method)
(migrate.changeset.databases.firebird.FBColumnDropper method)
visit_index() (migrate.changeset.ansisql.ANSISchemaChanger method)
(migrate.changeset.databases.sqlite.SQLiteSchemaChanger method)
visit_table() (migrate.changeset.ansisql.ANSISchemaChanger method)
(migrate.changeset.databases.firebird.FBSchemaChanger method)
W
with_engine() (in module migrate.versioning.util)
WrongRepositoryError
Read the Docs
v: latest
Versions
latest
v0.7.2
v0.7.1
Downloads
PDF
HTML
Epub
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.