Hello community, here is the log from the commit of package python-alembic for openSUSE:Factory checked in at 2015-02-06 10:23:18 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/python-alembic (Old) and /work/SRC/openSUSE:Factory/.python-alembic.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "python-alembic" Changes: -------- --- /work/SRC/openSUSE:Factory/python-alembic/python-alembic.changes 2015-01-06 09:07:18.000000000 +0100 +++ /work/SRC/openSUSE:Factory/.python-alembic.new/python-alembic.changes 2015-02-06 10:23:19.000000000 +0100 @@ -1,0 +2,32 @@ +Thu Feb 5 15:04:20 UTC 2015 - tbechtold@suse.com + +- update to 0.7.4: + * Repaired issue where a server default specified without text() + that represented a numeric or floating point (e.g. with decimal + places) value would fail in the Postgresql-specific check for + “compare server default”; as PG accepts the value with quotes + in the table specification, it’s still valid. Pull request + courtesy Dimitris Theodorou. + * The rendering of a ForeignKeyConstraint will now ensure that + the names of the source and target columns are the database-side + name of each column, and not the value of the .key attribute as + may be set only on the Python side. This is because Alembic + generates the DDL for constraints as standalone objects without + the need to actually refer to an in-Python Table object, so + there’s no step that would resolve these Python-only key names + to database column names. + * Fixed bug in foreign key autogenerate where if the in-Python + table used custom column keys (e.g. using the key='foo' kwarg + to Column), the comparison of existing foreign keys to those + specified in the metadata would fail, as the reflected table + would not have these keys available which to match up. Foreign + key comparison for autogenerate now ensures it’s looking at + the database-side names of the columns in all cases; this + matches the same functionality within unique constraints and + indexes. + * Fixed issue in autogenerate type rendering where types that + belong to modules that have the name “sqlalchemy” in them would + be mistaken as being part of the sqlalchemy. namespace. Pull + req courtesy Bartosz Burclaf. + +------------------------------------------------------------------- Old: ---- alembic-0.7.3.tar.gz New: ---- alembic-0.7.4.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ python-alembic.spec ++++++ --- /var/tmp/diff_new_pack.xhi7Vu/_old 2015-02-06 10:23:20.000000000 +0100 +++ /var/tmp/diff_new_pack.xhi7Vu/_new 2015-02-06 10:23:20.000000000 +0100 @@ -1,7 +1,7 @@ # # spec file for package python-alembic # -# Copyright (c) 2015 SUSE LINUX Products GmbH, Nuernberg, Germany. +# Copyright (c) 2015 SUSE LINUX GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -17,7 +17,7 @@ Name: python-alembic -Version: 0.7.3 +Version: 0.7.4 Release: 0 Url: http://bitbucket.org/zzzeek/alembic Summary: A database migration tool for SQLAlchemy ++++++ alembic-0.7.3.tar.gz -> alembic-0.7.4.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/LICENSE new/alembic-0.7.4/LICENSE --- old/alembic-0.7.3/LICENSE 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/LICENSE 2015-01-12 20:14:57.000000000 +0100 @@ -1,6 +1,6 @@ This is the MIT license: http://www.opensource.org/licenses/mit-license.php -Copyright (C) 2009-2014 by Michael Bayer. +Copyright (C) 2009-2015 by Michael Bayer. Alembic is a trademark of Michael Bayer. Permission is hereby granted, free of charge, to any person obtaining a copy of this diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/PKG-INFO new/alembic-0.7.4/PKG-INFO --- old/alembic-0.7.3/PKG-INFO 2014-12-30 18:17:40.000000000 +0100 +++ new/alembic-0.7.4/PKG-INFO 2015-01-12 20:18:56.000000000 +0100 @@ -1,6 +1,6 @@ Metadata-Version: 1.1 Name: alembic -Version: 0.7.3 +Version: 0.7.4 Summary: A database migration tool for SQLAlchemy. Home-page: http://bitbucket.org/zzzeek/alembic Author: Mike Bayer diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/__init__.py new/alembic-0.7.4/alembic/__init__.py --- old/alembic-0.7.3/alembic/__init__.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/__init__.py 2015-01-12 20:14:18.000000000 +0100 @@ -1,6 +1,6 @@ from os import path -__version__ = '0.7.3' +__version__ = '0.7.4' package_dir = path.abspath(path.dirname(__file__)) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/autogenerate/render.py new/alembic-0.7.4/alembic/autogenerate/render.py --- old/alembic-0.7.3/alembic/autogenerate/render.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/autogenerate/render.py 2015-01-12 20:14:18.000000000 +0100 @@ -500,7 +500,7 @@ if imports is not None: imports.add("from sqlalchemy.dialects import %s" % dname) return "%s.%r" % (dname, type_) - elif mod.startswith("sqlalchemy"): + elif mod.startswith("sqlalchemy."): prefix = _sqlalchemy_autogenerate_prefix(autogen_context) return "%s%r" % (prefix, type_) else: @@ -543,12 +543,22 @@ """ colspec = fk._get_colspec() - if metadata_schema is not None and colspec.count(".") == 1: - # need to render schema breaking up tokens by hand, since the - # ForeignKeyConstraint here may not actually have a remote - # Table present - # no schema in the colspec, render it - colspec = "%s.%s" % (metadata_schema, colspec) + tokens = colspec.split(".") + tname, colname = tokens[-2:] + + if metadata_schema is not None and len(tokens) == 2: + table_fullname = "%s.%s" % (metadata_schema, tname) + else: + table_fullname = ".".join(tokens[0:-1]) + + if fk.parent is not None and fk.parent.table is not None: + # try to resolve the remote table and adjust for column.key + parent_metadata = fk.parent.table.metadata + if table_fullname in parent_metadata.tables: + colname = _ident(parent_metadata.tables[table_fullname].c[colname].name) + + colspec = "%s.%s" % (table_fullname, colname) + return colspec @@ -577,7 +587,7 @@ "[%(refcols)s], %(args)s)" % { "prefix": _sqlalchemy_autogenerate_prefix(autogen_context), "cols": ", ".join( - "%r" % f.parent.key for f in constraint.elements), + "%r" % _ident(f.parent.name) for f in constraint.elements), "refcols": ", ".join(repr(_fk_colspec(f, apply_metadata_schema)) for f in constraint.elements), "args": ", ".join( diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/ddl/base.py new/alembic-0.7.4/alembic/ddl/base.py --- old/alembic-0.7.3/alembic/ddl/base.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/ddl/base.py 2015-01-12 20:14:18.000000000 +0100 @@ -172,10 +172,11 @@ def _fk_spec(constraint): if util.sqla_100: - source_columns = constraint.column_keys + source_columns = [ + constraint.columns[key].name for key in constraint.column_keys] else: source_columns = [ - element.parent.key for element in constraint.elements] + element.parent.name for element in constraint.elements] source_table = constraint.parent.name source_schema = constraint.parent.schema diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/ddl/postgresql.py new/alembic-0.7.4/alembic/ddl/postgresql.py --- old/alembic-0.7.3/alembic/ddl/postgresql.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/ddl/postgresql.py 2015-01-12 20:14:18.000000000 +0100 @@ -4,7 +4,7 @@ from .base import compiles, alter_table, format_table_name, RenameTable from .impl import DefaultImpl from sqlalchemy.dialects.postgresql import INTEGER, BIGINT -from sqlalchemy import text +from sqlalchemy import text, Numeric import logging log = logging.getLogger(__name__) @@ -35,7 +35,10 @@ if metadata_column.server_default is not None and \ isinstance(metadata_column.server_default.arg, compat.string_types) and \ - not re.match(r"^'.+'$", rendered_metadata_default): + not re.match(r"^'.+'$", rendered_metadata_default) and \ + not isinstance(inspector_column.type, Numeric): + # don't single quote if the column type is float/numeric, + # otherwise a comparison such as SELECT 5 = '5.0' will fail rendered_metadata_default = "'%s'" % rendered_metadata_default return not self.connection.scalar( diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/testing/requirements.py new/alembic-0.7.4/alembic/testing/requirements.py --- old/alembic-0.7.3/alembic/testing/requirements.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/testing/requirements.py 2015-01-12 20:14:18.000000000 +0100 @@ -60,6 +60,13 @@ ) @property + def fail_before_sqla_099(self): + return exclusions.fails_if( + lambda config: not util.sqla_099, + "SQLAlchemy 0.9.9 or greater required" + ) + + @property def sqlalchemy_08(self): return exclusions.skip_if( diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic/util.py new/alembic-0.7.4/alembic/util.py --- old/alembic-0.7.3/alembic/util.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/alembic/util.py 2015-01-12 20:14:18.000000000 +0100 @@ -34,6 +34,7 @@ sqla_092 = _vers >= (0, 9, 2) sqla_094 = _vers >= (0, 9, 4) sqla_094 = _vers >= (0, 9, 4) +sqla_099 = _vers >= (0, 9, 9) sqla_100 = _vers >= (1, 0, 0) if not sqla_07: raise CommandError( diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic.egg-info/PKG-INFO new/alembic-0.7.4/alembic.egg-info/PKG-INFO --- old/alembic-0.7.3/alembic.egg-info/PKG-INFO 2014-12-30 18:17:40.000000000 +0100 +++ new/alembic-0.7.4/alembic.egg-info/PKG-INFO 2015-01-12 20:18:55.000000000 +0100 @@ -1,6 +1,6 @@ Metadata-Version: 1.1 Name: alembic -Version: 0.7.3 +Version: 0.7.4 Summary: A database migration tool for SQLAlchemy. Home-page: http://bitbucket.org/zzzeek/alembic Author: Mike Bayer diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic.egg-info/SOURCES.txt new/alembic-0.7.4/alembic.egg-info/SOURCES.txt --- old/alembic-0.7.3/alembic.egg-info/SOURCES.txt 2014-12-30 18:17:40.000000000 +0100 +++ new/alembic-0.7.4/alembic.egg-info/SOURCES.txt 2015-01-12 20:18:55.000000000 +0100 @@ -25,6 +25,7 @@ alembic.egg-info/dependency_links.txt alembic.egg-info/entry_points.txt alembic.egg-info/not-zip-safe +alembic.egg-info/pbr.json alembic.egg-info/requires.txt alembic.egg-info/top_level.txt alembic/autogenerate/__init__.py diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/alembic.egg-info/pbr.json new/alembic-0.7.4/alembic.egg-info/pbr.json --- old/alembic-0.7.3/alembic.egg-info/pbr.json 1970-01-01 01:00:00.000000000 +0100 +++ new/alembic-0.7.4/alembic.egg-info/pbr.json 2015-01-12 20:18:55.000000000 +0100 @@ -0,0 +1 @@ +{"is_release": false, "git_version": "f342bd2"} \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/_sources/changelog.txt new/alembic-0.7.4/docs/_sources/changelog.txt --- old/alembic-0.7.3/docs/_sources/changelog.txt 2014-12-30 18:14:28.000000000 +0100 +++ new/alembic-0.7.4/docs/_sources/changelog.txt 2015-01-12 20:16:09.000000000 +0100 @@ -1,8 +1,59 @@ - ========== Changelog ========== + +.. changelog:: + :version: 0.7.4 + :released: January 12, 2015 + + .. change:: + :tags: bug, autogenerate, postgresql + :tickets: 241 + :pullreq: bitbucket:37 + + Repaired issue where a server default specified without ``text()`` + that represented a numeric or floating point (e.g. with decimal places) + value would fail in the Postgresql-specific check for "compare server + default"; as PG accepts the value with quotes in the table specification, + it's still valid. Pull request courtesy Dimitris Theodorou. + + .. change:: + :tags: bug, autogenerate + :tickets: 259 + + The rendering of a :class:`~sqlalchemy.schema.ForeignKeyConstraint` + will now ensure that the names of the source and target columns are + the database-side name of each column, and not the value of the + ``.key`` attribute as may be set only on the Python side. + This is because Alembic generates the DDL for constraints + as standalone objects without the need to actually refer to an in-Python + :class:`~sqlalchemy.schema.Table` object, so there's no step that + would resolve these Python-only key names to database column names. + + .. change:: + :tags: bug, autogenerate + :tickets: 260 + + Fixed bug in foreign key autogenerate where if the in-Python table + used custom column keys (e.g. using the ``key='foo'`` kwarg to + ``Column``), the comparison of existing foreign keys to those specified + in the metadata would fail, as the reflected table would not have + these keys available which to match up. Foreign key comparison for + autogenerate now ensures it's looking at the database-side names + of the columns in all cases; this matches the same functionality + within unique constraints and indexes. + + .. change:: + :tags: bug, autogenerate + :tickets: 261 + :pullreq: github:17 + + Fixed issue in autogenerate type rendering where types that belong + to modules that have the name "sqlalchemy" in them would be mistaken + as being part of the ``sqlalchemy.`` namespace. Pull req courtesy + Bartosz Burclaf. + .. changelog:: :version: 0.7.3 :released: December 30, 2014 diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/api.html new/alembic-0.7.4/docs/api.html --- old/alembic-0.7.3/docs/api.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/api.html 2015-01-12 20:17:10.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>API Details — Alembic 0.7.3 documentation</title> + <title>API Details — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Changelog" href="changelog.html" /> <link rel="prev" title="Cookbook" href="cookbook.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="cookbook.html" title="Cookbook" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -2395,11 +2395,11 @@ <li class="right" > <a href="cookbook.html" title="Cookbook" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/autogenerate.html new/alembic-0.7.4/docs/autogenerate.html --- old/alembic-0.7.3/docs/autogenerate.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/autogenerate.html 2015-01-12 20:17:10.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Auto Generating Migrations — Alembic 0.7.3 documentation</title> + <title>Auto Generating Migrations — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Generating SQL Scripts (a.k.a. “Offline Mode”)" href="offline.html" /> <link rel="prev" title="Tutorial" href="tutorial.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="tutorial.html" title="Tutorial" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -456,11 +456,11 @@ <li class="right" > <a href="tutorial.html" title="Tutorial" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/batch.html new/alembic-0.7.4/docs/batch.html --- old/alembic-0.7.3/docs/batch.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/batch.html 2015-01-12 20:17:10.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Running “Batch” Migrations for SQLite and Other Databases — Alembic 0.7.3 documentation</title> + <title>Running “Batch” Migrations for SQLite and Other Databases — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Working with Branches" href="branches.html" /> <link rel="prev" title="The Importance of Naming Constraints" href="naming.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="naming.html" title="The Importance of Naming Constraints" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -417,11 +417,11 @@ <li class="right" > <a href="naming.html" title="The Importance of Naming Constraints" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/branches.html new/alembic-0.7.4/docs/branches.html --- old/alembic-0.7.3/docs/branches.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/branches.html 2015-01-12 20:17:10.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Working with Branches — Alembic 0.7.3 documentation</title> + <title>Working with Branches — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Operation Reference" href="ops.html" /> <link rel="prev" title="Running “Batch” Migrations for SQLite and Other Databases" href="batch.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="batch.html" title="Running “Batch” Migrations for SQLite and Other Databases" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -899,11 +899,11 @@ <li class="right" > <a href="batch.html" title="Running “Batch” Migrations for SQLite and Other Databases" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/build/changelog.rst new/alembic-0.7.4/docs/build/changelog.rst --- old/alembic-0.7.3/docs/build/changelog.rst 2014-12-30 18:14:28.000000000 +0100 +++ new/alembic-0.7.4/docs/build/changelog.rst 2015-01-12 20:16:09.000000000 +0100 @@ -1,8 +1,59 @@ - ========== Changelog ========== + +.. changelog:: + :version: 0.7.4 + :released: January 12, 2015 + + .. change:: + :tags: bug, autogenerate, postgresql + :tickets: 241 + :pullreq: bitbucket:37 + + Repaired issue where a server default specified without ``text()`` + that represented a numeric or floating point (e.g. with decimal places) + value would fail in the Postgresql-specific check for "compare server + default"; as PG accepts the value with quotes in the table specification, + it's still valid. Pull request courtesy Dimitris Theodorou. + + .. change:: + :tags: bug, autogenerate + :tickets: 259 + + The rendering of a :class:`~sqlalchemy.schema.ForeignKeyConstraint` + will now ensure that the names of the source and target columns are + the database-side name of each column, and not the value of the + ``.key`` attribute as may be set only on the Python side. + This is because Alembic generates the DDL for constraints + as standalone objects without the need to actually refer to an in-Python + :class:`~sqlalchemy.schema.Table` object, so there's no step that + would resolve these Python-only key names to database column names. + + .. change:: + :tags: bug, autogenerate + :tickets: 260 + + Fixed bug in foreign key autogenerate where if the in-Python table + used custom column keys (e.g. using the ``key='foo'`` kwarg to + ``Column``), the comparison of existing foreign keys to those specified + in the metadata would fail, as the reflected table would not have + these keys available which to match up. Foreign key comparison for + autogenerate now ensures it's looking at the database-side names + of the columns in all cases; this matches the same functionality + within unique constraints and indexes. + + .. change:: + :tags: bug, autogenerate + :tickets: 261 + :pullreq: github:17 + + Fixed issue in autogenerate type rendering where types that belong + to modules that have the name "sqlalchemy" in them would be mistaken + as being part of the ``sqlalchemy.`` namespace. Pull req courtesy + Bartosz Burclaf. + .. changelog:: :version: 0.7.3 :released: December 30, 2014 diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/build/conf.py new/alembic-0.7.4/docs/build/conf.py --- old/alembic-0.7.3/docs/build/conf.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/docs/build/conf.py 2015-01-12 20:15:15.000000000 +0100 @@ -62,7 +62,7 @@ # General information about the project. project = u'Alembic' -copyright = u'2010-2014, Mike Bayer' +copyright = u'2010-2015, Mike Bayer' # The version info for the project you're documenting, acts as replacement for # |version| and |release|, also used in various other places throughout the diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/changelog.html new/alembic-0.7.4/docs/changelog.html --- old/alembic-0.7.3/docs/changelog.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/changelog.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Changelog — Alembic 0.7.3 documentation</title> + <title>Changelog — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="prev" title="API Details" href="api.html" /> </head> <body> @@ -41,7 +41,7 @@ <li class="right" > <a href="api.html" title="API Details" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -52,6 +52,47 @@ <div class="section" id="changelog"> <h1>Changelog<a class="headerlink" href="#changelog" title="Permalink to this headline">¶</a></h1> +<div class="section" id="change-0.7.4"> +<h2>0.7.4<a class="headerlink" href="#change-0.7.4" title="Permalink to this headline">¶</a></h2> +Released: January 12, 2015<div class="section" id="change-0.7.4-bug"> +<h3>bug<a class="headerlink" href="#change-0.7.4-bug" title="Permalink to this headline">¶</a></h3> +<ul class="simple"> +<li><p id="change-0.7.4-0"><span class="target" id="change-67b3d80132e3657ea4c9993c2d4f587d"><strong>[bug] [postgresql] [autogenerate] </strong></span>Repaired issue where a server default specified without <tt class="docutils literal"><span class="pre">text()</span></tt> +that represented a numeric or floating point (e.g. with decimal places) +value would fail in the Postgresql-specific check for “compare server +default”; as PG accepts the value with quotes in the table specification, +it’s still valid. Pull request courtesy Dimitris Theodorou.<a class="changeset-link headerlink reference internal" href="#change-67b3d80132e3657ea4c9993c2d4f587d">¶</a><p>References: <a class="reference external" href="https://bitbucket.org/zzzeek/alembic/issue/241/">#241</a>, <a class="reference external" href="https://bitbucket.org/zzzeek/alembic/pull-request/37">pull request bitbucket:37</a></p> +</p> +</li> +<li><p id="change-0.7.4-1"><span class="target" id="change-aa7772b6ea7a40a10180856865c276cc"><strong>[bug] [autogenerate] </strong></span>The rendering of a <a class="reference external" href="http://www.sqlalchemy.org/docs/core/constraints.html#sqlalchemy.schema.ForeignKeyConstraint" title="(in SQLAlchemy v0.9)"><tt class="xref py py-class docutils literal"><span class="pre">ForeignKeyConstraint</span></tt></a> +will now ensure that the names of the source and target columns are +the database-side name of each column, and not the value of the +<tt class="docutils literal"><span class="pre">.key</span></tt> attribute as may be set only on the Python side. +This is because Alembic generates the DDL for constraints +as standalone objects without the need to actually refer to an in-Python +<a class="reference external" href="http://www.sqlalchemy.org/docs/core/metadata.html#sqlalchemy.schema.Table" title="(in SQLAlchemy v0.9)"><tt class="xref py py-class docutils literal"><span class="pre">Table</span></tt></a> object, so there’s no step that +would resolve these Python-only key names to database column names.<a class="changeset-link headerlink reference internal" href="#change-aa7772b6ea7a40a10180856865c276cc">¶</a><p>References: <a class="reference external" href="https://bitbucket.org/zzzeek/alembic/issue/259/">#259</a></p> +</p> +</li> +<li><p id="change-0.7.4-2"><span class="target" id="change-1c70cc234b1cac2257cb8eb77879955e"><strong>[bug] [autogenerate] </strong></span>Fixed bug in foreign key autogenerate where if the in-Python table +used custom column keys (e.g. using the <tt class="docutils literal"><span class="pre">key='foo'</span></tt> kwarg to +<tt class="docutils literal"><span class="pre">Column</span></tt>), the comparison of existing foreign keys to those specified +in the metadata would fail, as the reflected table would not have +these keys available which to match up. Foreign key comparison for +autogenerate now ensures it’s looking at the database-side names +of the columns in all cases; this matches the same functionality +within unique constraints and indexes.<a class="changeset-link headerlink reference internal" href="#change-1c70cc234b1cac2257cb8eb77879955e">¶</a><p>References: <a class="reference external" href="https://bitbucket.org/zzzeek/alembic/issue/260/">#260</a></p> +</p> +</li> +<li><p id="change-0.7.4-3"><span class="target" id="change-4deef0362ad86b8e59c1929b45ec8882"><strong>[bug] [autogenerate] </strong></span>Fixed issue in autogenerate type rendering where types that belong +to modules that have the name “sqlalchemy” in them would be mistaken +as being part of the <tt class="docutils literal"><span class="pre">sqlalchemy.</span></tt> namespace. Pull req courtesy +Bartosz Burclaf.<a class="changeset-link headerlink reference internal" href="#change-4deef0362ad86b8e59c1929b45ec8882">¶</a><p>References: <a class="reference external" href="https://bitbucket.org/zzzeek/alembic/issue/261/">#261</a>, <a class="reference external" href="https://github.com/zzzeek/alembic/pull/17">pull request github:17</a></p> +</p> +</li> +</ul> +</div> +</div> <div class="section" id="change-0.7.3"> <h2>0.7.3<a class="headerlink" href="#change-0.7.3" title="Permalink to this headline">¶</a></h2> Released: December 30, 2014<div class="section" id="change-0.7.3-bug"> @@ -1822,6 +1863,10 @@ <h3><a href="index.html">Table Of Contents</a></h3> <ul> <li><a class="reference internal" href="#">Changelog</a><ul> +<li><a class="reference internal" href="#change-0.7.4">0.7.4</a><ul> +<li><a class="reference internal" href="#change-0.7.4-bug">bug</a></li> +</ul> +</li> <li><a class="reference internal" href="#change-0.7.3">0.7.3</a><ul> <li><a class="reference internal" href="#change-0.7.3-bug">bug</a></li> </ul> @@ -1998,11 +2043,11 @@ <li class="right" > <a href="api.html" title="API Details" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/cookbook.html new/alembic-0.7.4/docs/cookbook.html --- old/alembic-0.7.3/docs/cookbook.html 2014-12-30 18:15:09.000000000 +0100 +++ new/alembic-0.7.4/docs/cookbook.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Cookbook — Alembic 0.7.3 documentation</title> + <title>Cookbook — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="API Details" href="api.html" /> <link rel="prev" title="Operation Reference" href="ops.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="ops.html" title="Operation Reference" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -290,11 +290,11 @@ <li class="right" > <a href="ops.html" title="Operation Reference" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/front.html new/alembic-0.7.4/docs/front.html --- old/alembic-0.7.3/docs/front.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/front.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Front Matter — Alembic 0.7.3 documentation</title> + <title>Front Matter — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Tutorial" href="tutorial.html" /> <link rel="prev" title="Welcome to Alembic’s documentation!" href="index.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="index.html" title="Welcome to Alembic’s documentation!" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -185,11 +185,11 @@ <li class="right" > <a href="index.html" title="Welcome to Alembic’s documentation!" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/genindex.html new/alembic-0.7.4/docs/genindex.html --- old/alembic-0.7.3/docs/genindex.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/genindex.html 2015-01-12 20:17:11.000000000 +0100 @@ -7,7 +7,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Index — Alembic 0.7.3 documentation</title> + <title>Index — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -17,7 +17,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -26,7 +26,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> </head> <body> <div class="related"> @@ -38,7 +38,7 @@ <li class="right" > <a href="py-modindex.html" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -1236,11 +1236,11 @@ <li class="right" > <a href="py-modindex.html" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/index.html new/alembic-0.7.4/docs/index.html --- old/alembic-0.7.3/docs/index.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/index.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Welcome to Alembic’s documentation! — Alembic 0.7.3 documentation</title> + <title>Welcome to Alembic’s documentation! — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="#" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="#" /> <link rel="next" title="Front Matter" href="front.html" /> </head> <body> @@ -41,7 +41,7 @@ <li class="right" > <a href="front.html" title="Front Matter" accesskey="N">next</a> |</li> - <li><a href="#">Alembic 0.7.3 documentation</a> »</li> + <li><a href="#">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -128,6 +128,7 @@ </ul> </li> <li class="toctree-l1"><a class="reference internal" href="changelog.html">Changelog</a><ul> +<li class="toctree-l2"><a class="reference internal" href="changelog.html#change-0.7.4">0.7.4</a></li> <li class="toctree-l2"><a class="reference internal" href="changelog.html#change-0.7.3">0.7.3</a></li> <li class="toctree-l2"><a class="reference internal" href="changelog.html#change-0.7.2">0.7.2</a></li> <li class="toctree-l2"><a class="reference internal" href="changelog.html#change-0.7.1">0.7.1</a></li> @@ -221,11 +222,11 @@ <li class="right" > <a href="front.html" title="Front Matter" >next</a> |</li> - <li><a href="#">Alembic 0.7.3 documentation</a> »</li> + <li><a href="#">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/naming.html new/alembic-0.7.4/docs/naming.html --- old/alembic-0.7.3/docs/naming.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/naming.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>The Importance of Naming Constraints — Alembic 0.7.3 documentation</title> + <title>The Importance of Naming Constraints — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Running “Batch” Migrations for SQLite and Other Databases" href="batch.html" /> <link rel="prev" title="Generating SQL Scripts (a.k.a. “Offline Mode”)" href="offline.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="offline.html" title="Generating SQL Scripts (a.k.a. “Offline Mode”)" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -314,11 +314,11 @@ <li class="right" > <a href="offline.html" title="Generating SQL Scripts (a.k.a. “Offline Mode”)" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/offline.html new/alembic-0.7.4/docs/offline.html --- old/alembic-0.7.3/docs/offline.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/offline.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Generating SQL Scripts (a.k.a. “Offline Mode”) — Alembic 0.7.3 documentation</title> + <title>Generating SQL Scripts (a.k.a. “Offline Mode”) — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="The Importance of Naming Constraints" href="naming.html" /> <link rel="prev" title="Auto Generating Migrations" href="autogenerate.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="autogenerate.html" title="Auto Generating Migrations" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -246,11 +246,11 @@ <li class="right" > <a href="autogenerate.html" title="Auto Generating Migrations" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/ops.html new/alembic-0.7.4/docs/ops.html --- old/alembic-0.7.3/docs/ops.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/ops.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Operation Reference — Alembic 0.7.3 documentation</title> + <title>Operation Reference — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Cookbook" href="cookbook.html" /> <link rel="prev" title="Working with Branches" href="branches.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="branches.html" title="Working with Branches" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -1425,11 +1425,11 @@ <li class="right" > <a href="branches.html" title="Working with Branches" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/py-modindex.html new/alembic-0.7.4/docs/py-modindex.html --- old/alembic-0.7.3/docs/py-modindex.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/py-modindex.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Python Module Index — Alembic 0.7.3 documentation</title> + <title>Python Module Index — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> @@ -40,7 +40,7 @@ <li class="right" > <a href="#" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -170,11 +170,11 @@ <li class="right" > <a href="#" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/search.html new/alembic-0.7.4/docs/search.html --- old/alembic-0.7.3/docs/search.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/search.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Search — Alembic 0.7.3 documentation</title> + <title>Search — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -26,7 +26,7 @@ <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> <script type="text/javascript" src="_static/searchtools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <script type="text/javascript"> jQuery(function() { Search.loadIndex("searchindex.js"); }); </script> @@ -45,7 +45,7 @@ <li class="right" > <a href="py-modindex.html" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -96,11 +96,11 @@ <li class="right" > <a href="py-modindex.html" title="Python Module Index" >modules</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/searchindex.js new/alembic-0.7.4/docs/searchindex.js --- old/alembic-0.7.3/docs/searchindex.js 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/searchindex.js 2015-01-12 20:17:11.000000000 +0100 @@ -1 +1 @@ -Search.setIndex({envversion:42,terms:{walk_revis:6,untrust:2,prefix:6,dirnam:10,alembic_vers:[10,6,1,11,3],logger_root:11,relnum:1,whose:[6,3],accur:4,"const":6,aug:3,pprint:6,under:[6,2,3],get_current_head:[6,3],worth:8,everi:[8,11,3],starting_rev:6,quote_dot:6,batchoper:[2,5,3],kick:3,appar:3,rename_t:[6,2],vast:[4,11],include_schema:[6,3],run_env:6,factori:6,readthedoc:7,sqliteimpl:6,script_directori:[6,3],"27c6a":1,direct:[1,2,3,4,5,6,8,10,11],batch:6,second:[0,2,1,5,3],street:5,after_parent_attach:[8,4],even:[1,2,3,5,8,11],neg:11,calcul:[6,11],binet:3,nonetyp:3,"new":[1,2,3,4,5,6,8,9,11],net:3,topolog:1,metadata:[2,3,4,5,6,8,11],"27c":1,behavior:[6,2,4,5,3],never:[2,3],here:[1,2,3,4,5,6,7,8,9,11],all_constraint:8,pedro:3,argv:6,path:[1,4,6,10,9,11],interpret:[11,3],autogenrendertest:3,odagiri:3,datetim:[4,11,2],naming_convent:[8,2,5,3],pyramid:3,total:[6,11],highli:3,describ:[1,2,3,5,6,10,11],would:[1,2,3,4,5,6,8,10,11],compare_to:6,old_table_nam:[6,2],call:[1,2,3,4,5,6,8,11],harland:3,recommend:[7,4,2,1,3],uq_user_nam:2,type:6,tell:[9,1,11,3],autogen:[6,3],relat:[8,5,11,3],notic:[10,11],warn:[11,3],pkg_resourc:3,hole:2,hold:[11,3],must:[1,3,4,5,6,10,11],join:[8,1,10],err:3,some_t:[8,5,2],setup:[6,7,2,3],work:[6,4],wors:8,rework:3,root:[6,1,11],"29f8":1,overrid:[6,4,5,2],defer:3,give:[4,8,9,1,3],autodetect:3,indic:[6,3],want:[1,2,6,8,10,11],keep:3,end:[1,2,3,4,6,10,11],hoc:[6,2],quot:[6,2,3],output_encod:[6,11,3],how:[3,4,5,6,8,9,11],conn:[6,2],env:[2,3,4,5,6,8,10,11],verifi:2,ancestor:1,perspect:[6,1],updat:[6,1,2],visit_drop_column:6,recogn:3,tablenam:[8,6,3],after:[9,1,3],befor:[1,2,3,5,6,11],wrong:[8,3],parallel:3,attempt:[2,1,5,3],third:1,classmethod:6,logger_:11,zzzeek:[7,3],imposs:1,receiv:[6,2,1,3],type_:[6,2,4,5,3],maintain:[6,1,11,3],enter:5,exclus:6,engine_from_config:[6,4],order:[1,2,3,4,5,6,8,11],composit:3,get_unique_constraint:3,assert_relative_length:6,becaus:[4,1,5,3],"2b1ae634e5cd_add_order_id":11,autogen_context:[6,4],demarc:6,affect:6,constraint_typ:8,addcolumn:6,flexibl:3,vari:6,revision_environ:[6,11,3],pk_my_tabl:2,uuid:6,fix:[6,2,4,3],inadvert:3,better:[8,3],comprehens:4,easier:11,split:3,them:[1,2,3,5,6,8,10],poolclass:6,thei:[1,2,3,4,5,6,11],proce:[1,2,3,4,5,6,7],safe:[2,5,3],"break":[1,2],drop_tabl:[6,4,11,9,2],mytabl:6,r1975ea:11,accommod:[5,3],luca:3,each:[1,2,3,6,8,10,11],higher:[6,3],side:[6,2,1,3],mean:[10,6,1,5,2],prohibit:3,iterate_revis:[6,3],unreport:3,enorm:[2,3],bflag:5,version_path:6,foreignkeyconstraint:[6,2,5,3],network:1,paradoxxxzero:3,newli:[2,3],content:6,rewrit:3,branch:6,adapt:3,mypackag:4,forth:1,streamhandl:11,written:[6,11,3],abramowitz:3,free:[4,11],standard:[10,6,5,11,2],lineag:3,q_bool:8,convent:[0,5,3],filter:[6,3],include_object:[6,3],isn:[1,5,3],regress:3,onto:[1,11],source_schema:[2,3],suppos:[8,4,11],rang:[10,3],perfectli:2,render:6,thoughtfulli:1,independ:[1,3],restrict:[10,2],hook:[6,4,3],instruct:[6,2,1,11,3],alreadi:[1,2,3,4,5,6,8],wasn:3,primari:[2,3,4,5,6,8,10],format_typ:6,top:[4,1,3],downsid:3,mercuri:[7,3],master:7,too:[8,1,3],john:2,listen:[5,2],consol:[6,11],namespac:[6,4,2],tool:[7,0,5,11],setuptool:3,travers:[6,1,3],"10g":8,incur:3,termin:3,contyp:8,target:[1,2,3,4,5,6,11],keyword:[6,2,3],provid:[1,2,3,4,5,6,8,9,10,11],tree:[1,11],batch_alter_t:[6,2,5,3],ddlelement:6,entri:[4,1],minut:[11,3],fashion:3,runner:[6,11,3],mind:8,manner:3,increment:9,include_symbol:[6,3],seem:8,incompat:[1,3],recreat:[6,2,5,3],latter:3,get_revis:6,derek:3,methodolog:4,greatest:2,though:[1,2,3,5,6,8,9,11],usernam:5,version_fil:10,multiplehead:6,skip_table_on:6,regular:[6,1,5,2],phase:3,prematur:3,sub:1,tradit:[2,3],don:[6,2,1,11,3],doc:[6,3],doe:6,dummi:3,declar:4,left:[6,1,11,2],notion:3,dot:[6,2,3],mysqlalterdefault:6,changeset:6,columnnam:6,mostli:[5,3],mssql_drop_foreign_kei:[2,3],syntax:5,radic:3,uq_const_x:8,is_offline_mod:[10,6],involv:[2,1,3],absolut:[11,3],layout:1,pk_:8,latenc:11,folder:11,oct:3,wide:[4,3],stop:[1,11],report:[7,3],incept:3,bat:[6,11],bar:[6,5,11,2],"109e":1,"public":[6,3],bad:4,septemb:3,alembic_cfg:[6,9],respond:11,commandlin:[9,3],robbi:3,datatyp:[6,4,2],result:[4,6,1,11,2],multidb:[11,3],auto_incr:[2,3],fail:[1,5,3],themselv:6,basemost:1,subject:[1,3],said:[6,1],databas:[6,4],figur:8,user_ord:8,approach:[9,5,11,3],attribut:[4,6,1,3],accord:[2,3],mysqlimpl:6,extend:[6,9],newnam:6,extens:3,batch_separ:6,howev:[1,2,3,4,5,6,8],against:[1,2,3,4,5,6,10,11],logic:[6,5,9,3],seri:[1,2,3,5,6,7,9],col:[6,2],remote_col:2,kwd:2,diff:6,guid:11,assum:[8,1,10,11,3],duplic:3,get_template_directori:6,script_loc:[6,11,3],fri:3,three:[6,11,3],been:[1,2,3,6,7,8],much:[8,2,1,5,3],end_vers:10,basic:[1,2,3,4,6,10,9,11],"__doc__":3,koizumi:3,version_table_schema:[6,3],py3:3,spit:3,suppress:3,ani:[1,2,3,4,5,6,8,9,10,11],lift:3,"catch":3,ae1027:[1,11],giacomo:3,execution_opt:[6,2,3],"__repr__":4,ident:6,blume:3,servic:[2,3],weren:[1,3],safeconfigpars:[6,11],resource_filenam:[11,3],have:[1,2,3,4,5,6,8,10,11],tabl:[6,4],toolkit:0,kwarg:6,varchar:[10,6,4,2],tediou:[8,5],sever:[1,5,11,3],mako:[1,3,4,6,9,11],hong:3,incorrectli:1,perform:[6,1,5,3],suggest:1,make:[1,2,3,4,6,8,9,10,11],mayb:8,complex:3,descend:1,sat:3,complet:[8,6,5,3],inspected_default:6,create_engin:[6,3],hand:[10,4,11,3],fairli:7,rais:[10,6,4,3],set_section_opt:[6,3],is_head:6,thu:[1,3],client:10,wherebi:[5,3],thi:[1,2,3,4,5,6,7,8,9,10,11],everyth:[11,3],paradigm:1,unchang:3,identifi:[0,1,2,3,4,5,6,9],coomber:3,just:[1,2,3,5,6,8,9,11],context_opt:6,yet:[1,2,3,4,6,11],languag:[6,2,3],previous:3,metadata_column:6,easi:[8,9,10],mysqlchangecolumn:6,had:[2,1,11,3],reflect_kwarg:[2,5,3],board:5,els:[2,3,4,5,6,10,9,11],gave:1,opt:6,applic:[1,2,3,4,5,6,8,9,11],quirk:3,preserv:3,background:4,renamet:6,specif:[6,4],temptabl:3,arbitrari:3,manual:[4,8,1,5,3],local_col:2,specifii:3,unnecessari:3,underli:[6,11,2],www:3,right:[8,6,1,2],old:[2,3,4,5,9,11],dimitri:3,typeerror:3,interv:3,"34e094ad6ef1":1,txt:10,cooper:3,bottom:10,subclass:[6,2,3],buffer:6,tracker:[7,3],py2k:3,overcom:5,condit:3,fileconfig:11,foo:[4,6,1,5,2],my_tabl:[9,2],localhost:[1,11],plu:[11,3],conn_uniqu:6,repositori:[7,6,1,3],post:[7,3],alexand:3,chronolog:6,slightli:[5,3],surround:[2,3],generate_revis:[6,3],commit:[10,6,4,3],produc:[2,3,4,5,6,11],encourgag:8,xyz:3,encod:[6,11,3],bound:[2,3],down:[4,6,1,11,3],resili:3,lieu:2,wrap:3,qualnam:11,git:[7,3],fabric:5,wai:[1,3,5,6,8,9,10,11],support:[0,1,3,4,5,6,7,8,9],avail:[2,4,6,7,9,11],width:[6,3],reli:[10,5,3],add_column:[2,3,4,5,6,8,11],shgoh:3,head:6,creation:[11,3],form:[6,2,3],offer:[1,3],forc:[6,2],sqlalchemi:[0,1,2,3,4,5,6,7,8,9,11],metadata_typ:6,"true":[2,3,4,5,6,8,9,11],sourceless:[6,11,3],create_constraint:5,absens:5,unmerg:6,until:1,absenc:10,emit:[1,2,3,5,6,8,9],defaultimpl:6,featur:[4,6,1,5],alongsid:3,create_check_constraint:2,hardcod:3,transactional_ddl:[10,6,3],exist:[1,2,3,5,6,10,9,11],check:[6,4],somenam:6,index:[0,2,3,4,6,7,8],when:[1,2,3,4,5,6,8,9,10,11],refactor:4,zeidler:3,entrypoint:6,jone:2,test:[1,3,4,6,8,11],roll:[6,9],node:1,intend:[6,4,5,3],stringio:3,dialect_nam:[10,6],stringif:3,"_alembic_batch_temp":5,intent:4,consid:[1,2,3,5,6,9],doubl:3,run_migrations_onlin:[8,4,10],bitbucket:[7,3],nov:3,longer:[8,6,1,9,3],anywher:11,pseudo:3,relnam:8,remove_column:6,tinyint:3,pathnam:11,time:[1,3,5,6,10,8,11],add_index:3,backward:3,concept:1,skip:[6,3],consum:[11,3],signific:3,customari:6,add_revis:6,row:[1,2,3,6,8,10],pg_class:8,depend:[6,4],zone:10,graph:1,decim:11,visit_column_default:6,certainli:8,isinst:[6,4],sourc:[1,2,3,6,7,11],string:[1,2,3,4,5,6,8,9,11],ibrahim:3,quoted_nam:[2,3],drop_constraint:[6,8,2,5,3],word:[2,3],exact:[11,3],"2a95":1,"1975ea83b712_create_account_t":11,level:[6,2,5,11,3],did:[4,1],reconcil:1,iter:[6,9],item:[6,4,3],head_revis:6,dir:6,upper:[6,2],sign:3,ini_sect:6,transaction_per_migr:[6,3],cmd_line_url:6,render_as_batch:[6,5,3],current:[1,2,3,4,5,6,7,10,11],sinc:[6,2,1,5,3],axel:3,is_bas:6,ascii:3,redirect:[10,6],deriv:[6,11,2],gener:6,satisfi:1,referred_table_nam:[8,5],modif:3,splice:[6,1,11],address:[5,2],dialect_kw:2,along:[1,2,3,5,6,11],behav:5,pysqlit:[6,3],semant:1,regardless:[6,5,11,2],extra:[5,3],modul:6,prefer:[6,5,3],fk_bar_foo_id_foo:5,"1975ea83b712_create_accoun":11,marker:6,instal:3,append_constraint:3,memori:10,live:[10,1,5,11,2],handler:[6,11],scope:5,challeng:[4,10,1,5],claus:2,explcitli:4,enhanc:[7,3],accept:[2,3,4,5,6,10,11],obj:4,effort:[8,3],easiest:6,nextval:3,uniqu:[6,4],mycolumn:4,modify_nul:6,whatev:[6,4,11],purpos:[10,9,5,3],encapsul:6,stream:[6,2,1,11,3],predict:5,relnamespac:8,glitch:3,levelnam:11,topic:[8,4],critic:[10,4],immutabledict:6,occur:[4,1,5,11,3],alwai:[1,2,4,5,7,10],differenti:3,multipl:6,write:[0,8,6,3],parameter:2,map:6,product:[8,9,3],mar:3,autoincr:[6,2,3],max:11,resolve_depend:6,usabl:6,ioctl:3,rev_rang:6,mai:[1,2,3,4,5,6,7,10,11],underscor:3,data:[2,3,4,5,6,9],current_vers:10,stress:1,practic:[6,11,2],rather:[6,2,4,11,3],"switch":9,preced:[1,5],combin:[4,2,1,3],pg_namespac:8,callabl:[6,4,3],talk:[8,6],tty:3,anticip:3,my_funct:6,format_server_default:6,still:[2,1,5,9,3],conjunct:[2,4,3],"55af2cb":1,group:[7,6,2],thank:3,emit_commit:6,platform:3,window:3,d747a8a8879_add_a_shopping_cart_column:1,is_merge_point:6,main:[6,1,3],sok:3,non:[6,2,4,11,3],enviromn:11,environmentcontext:[2,3,4,5,6,10,9],col2:4,initi:[6,2,1,11,3],col1:4,underneath:1,"53fffde5ad5_merge_ae1_and_27c":1,ae1027a6acf_add_a_column:[1,11],now:[1,2,3,4,5,6,7,9,11],discuss:[7,1],nor:[5,3],introduct:[11,3],term:[1,11,2],name:[6,4],version_num:[10,1],config:[3,4,6,10,9,11],didn:[1,3],revert:[6,3],typeengin:[6,2],datamemb:[6,2],rock:11,attributeerror:3,compil:[6,3],dialect:[6,2,5,3],replac:[6,4,5,9,3],individu:[6,2,1,11,3],continu:[4,1,11,3],visit_rename_column:6,year:[8,11,3],foreign_kei:[6,2],accomplish:10,"3rd":3,space:[6,3],mssql_drop_check:[2,3],rational:5,correct:[4,5,11,3],static_output:6,earlier:1,get_head:[6,3],romano:3,cart:1,metadata_default:6,bayer:7,theori:[9,11],alter_t:6,org:[7,6,3],unpredict:8,care:[7,6],reusabl:3,suffici:5,badli:3,rule:[2,4,3],visit_column_nul:6,thing:[1,2,3,6,8,9,11],place:[1,3,4,5,6,8,11],think:[9,1],first:[0,1,2,3,4,5,6,8,9,10],origin:[6,1,5,3],wiki:3,get_starting_revision_argu:6,directli:[1,2,3,4,5,6,11],onc:6,arrai:3,yourself:3,environment_context:6,"long":[4,1,5,11,3],open:[10,6,3],size:3,given:[1,2,3,4,5,6,8,9,11],workaround:[5,3],"29f859a13ea":1,paramt:3,conveni:[4,8,1],uniqueconstraint:[2,3,4,5,6,8],migrationscontext:8,especi:1,programat:6,copi:[6,2,5,9,3],specifi:[1,2,3,5,6,11],"short":3,enclos:6,pragma:5,than:[6,4],erdfelt:3,serv:[6,1,3],get_section_opt:6,kuzminski:3,were:[4,6,1,5,3],posit:[6,2,11,3],sqlalchemy_module_prefix:[6,4,3],pre:5,sai:[9,1],ann:3,argument:[1,2,3,4,5,6,9,11],"_replac":6,deliv:3,exclud:3,dbapi:[2,3],engin:[2,3,4,6,10,9,11],techniqu:[9,3],get_revision_argu:[10,6],note:[1,2,3,4,5,6,11],dispar:3,take:[2,3,4,5,6,7,8,9],concern:5,noth:[6,1,11,3],begin:[2,3,4,5,6,10,11],sure:[4,1,11],"enum":[2,4,5,3],normal:[1,2,4,5,6,8,9,11],track:7,beta:[7,1,5,3],pair:[4,3],synonym:6,db_2:10,db_1:10,later:[4,10,6,1],brokenpipeerror:3,create_al:[6,9],shop:[1,5],shot:9,show:[6,1,11,3],hack:10,get_x_argu:[6,9,3],onli:[1,2,3,4,5,6,10,9,11],explicitli:[4,1,5,11,3],transact:[1,3,5,6,10,11],behind:[8,3],dict:5,over:[4,6,1,5,3],variou:[2,11,9,3],get:[0,1,3,4,6,7,8,9],repr:[6,1,9,3],soon:9,cannot:[1,2,3,4,5,6],get_schema_nam:[6,3],utf:[6,11,3],constraint_nam:[8,2,3],requir:[1,2,3,5,6,7,8,11],my_render_column:6,yield:[6,3],as_revision_numb:6,where:[1,2,3,4,5,6,8,9,10,11],existing_autoincr:[6,2],"__module__":[6,4,3],reserv:2,nextrev:6,review:4,my_metadata:9,enough:[8,4],between:[1,3,4,5,6,7,9,11],"import":[0,1,3,4,6,9],across:[6,2,1,5,3],fcntl:3,august:3,parent:[8,2,1,11,3],screen:11,is_branch_point:6,uncondition:[5,11,3],come:[6,4,9,3],tue:3,javier:3,tutori:[0,6,2],version_t:[6,3],impl:[6,1,2],improv:3,among:[1,3],issue10740:6,podoliaka:3,unittest:3,colon:[11,3],emit_ev:3,ultim:[6,2],semicolon:6,marc:3,ck_bool_:2,render_item:[6,4,3],thousand:11,fk_user_address:2,tiger:11,andrei:3,dialectnam:2,andrea:3,those:[1,2,3,4,5,6,8,9],"case":[1,2,3,4,5,6,8,9,11],kolov:3,cast:3,invok:[1,2,3,4,5,6,9,11],invoc:[6,11],new_column_nam:[2,5,3],argpars:[6,3],advantag:1,stdout:[6,3],henc:[1,3],destin:[6,2],ddlevent:4,myapp:[8,6,4,10],ck_bool_t_x:2,pursu:1,"__init__":3,develop:[7,1,11],author:3,intermediari:3,same:[1,2,3,4,6,8,9,10,11],inconsist:5,column_0_label:8,document:[7,6,4,3],week:3,finish:[9,4],nest:6,oid:8,driver:[11,3],weed:3,driven:3,capabl:[10,6,11],mani:[6,1,5,3],extern:[2,3],somecolumn:6,"0x100254150":6,metadata_unique_constraint:6,appropri:[6,4,2,1,3],choos:1,copy_from:[5,2],without:[1,2,3,5,6,10,9,11],deferr:[2,3],model:[1,4,6,8,9,11],execut:[6,10,2,9,3],termwidth:3,aspect:[2,3],versu:[1,2],"55af2cb1c267_add_another_account_column":1,except:[1,2,3,4,5,6,10],littl:3,identif:3,batch_op:[6,5,2],kahlert:3,table_nam:[6,8,2,5,3],around:3,read:[10,6,11,3],migrationcontext:[6,2,3],correct_for_autogen_constraint:6,mon:3,table_kwarg:2,saniti:3,ae1027a6acf:[10,1,11],integ:[2,3,4,5,6,8,11],server:[6,10,2,4,3],either:[1,2,3,4,6,11],cascad:2,output:[1,2,3,4,6,10,11],manag:[6,2,1,11,3],"function":[1,2,3,4,6,8,10,11],somefunct:3,my_enum:5,interstingli:1,ascend:11,intact:3,d747:1,ondelet:[2,3],slice:[11,3],"109ec7d132bf":1,definit:[4,5,2],"27c6":1,legal:2,target_metadata:[2,3,4,5,6,8],exit:3,notabl:6,refer:[6,5],column_info:[6,5],formatter_:11,inspect:[9,3],broken:[10,3],foreign_key_column:2,found:6,standpoint:6,regexp:3,drop_column:[6,2,5,11,3],unicod:[11,3],comparison:[6,4,3],firebird:3,up_revis:[9,1],addconstraint:2,addition:[5,3],degre:[2,3],stand:4,act:2,alemb:[1,3,4,5,6,7,9],"\u0142ukasz":3,routin:[6,3],visit_add_column:6,visit_column_nam:6,your:[4,8,1,11,3],get_bas:[6,3],log:[10,11,3],area:[4,11],aren:[4,1,5,2],hex:6,start:[0,1,3,4,6,9],interfac:2,lot:[4,8,1],scriptdirectori:[6,3],strictli:6,tupl:[6,1],regard:[2,3],jun:3,default_constraint:2,jul:3,starting_vers:10,yourproject:11,pull:[10,1,3],possibl:[10,5,11,2],"default":[1,2,3,4,5,6,8,10,11],current_rev:6,foreignkei:[8,2,5,3],embed:3,connect:[2,3,4,5,6,8,10,11],gone:5,remove_index:3,creat:[6,4,5],certain:6,bugtrack:3,deep:3,strongli:[7,3],file:[0,1,2,3,4,5,6,10,9],rendered_inspector_default:6,rearrang:3,logger_sqlalchemi:11,incorrect:3,again:[1,3,4,5,8,9,11],googl:7,event:[2,3,4,5,6,8],field:[11,3],"3512b954651e_add_account":11,ignor:3,you:[1,3,4,6,8,9,11],"1975ea83b712_add_account_t":[1,11],architectur:5,"27c6a30d7c24":[4,1],sequenc:[6,2,4,11,3],symbol:[6,2,1,11,3],docstr:[6,3],existing_nul:[6,2],versionad:6,sequent:1,philosoph:5,descript:[10,4,11,2],columntyp:6,inevit:4,token:[8,2,11,3],potenti:[7,3],escap:3,batchoperationsimpl:6,represent:4,all:[6,4,5],illustr:[10,1,11],month:[11,3],abil:11,compare_metadata:[6,3],follow:[1,2,5,6,8,11],yourapp:[6,11,9],altercolumn:6,init:[6,11,3],program:3,queri:3,table_arg:[5,2],introduc:[6,2,1,3],liter:[2,3],straightforward:3,fals:[2,3,4,5,6,10,11],offlin:6,util:[6,4,3],candid:[6,4,3],mechan:6,failur:3,veri:[4,6,1,11,3],ticket:3,pg_catalog:[8,3],schema_upgrad:9,list:[1,2,3,6,8,11],atsushi:3,adjust:[4,5,3],stderr:[10,11],small:[6,4,3],superced:6,user_account_id:8,user_account:8,zero:[6,3],design:[10,11,2],contextu:[6,3],pass:[1,2,3,4,5,6,8,9,10,11],further:[10,2,3],what:6,navig:6,sun:3,section:[1,3,4,5,6,10,9,11],abl:[8,6,9],brief:2,conn_unique_constraint:6,delet:[9,1,2],version:[6,4,5],primary_kei:[8,6,5,11,2],method:[2,3,4,5,6,11],schemaitem:6,movement:9,hasn:[4,3],full:[1,2,3,5,6,9,11],christian:3,postgreql:3,dict_:6,handler_:11,shouldn:3,rudimentari:[4,11,2],modifi:[2,3,4,6,9,11],valu:[1,2,3,4,6,8,10,11],search:[0,4],misinterpret:3,prior:[1,5,3],action:[9,2],narrow:1,get_bind:[6,2],via:[2,3,4,5,6,7,10,11],shorthand:1,onupd:[2,3],filenam:[6,11,3],inappropri:3,establish:[6,1],select:[1,2,3,4,5,6,8,10],"3cac04ae8714":1,proceed:[8,11],distinct:[2,1,3],liber:3,two:[1,3,4,6,8,10,11],taken:3,anscestor:1,more:[6,4,5],flat:5,diamond:1,desir:[4,1,5,11,3],cmd_opt:[6,3],hundr:9,sometag:6,flag:[2,3,5,6,8,9,10,11],particular:[6,8,2,11,3],known:[1,2,3,4,8,11],none:[1,2,3,4,5,6,8,9,10,11],endpoint:[6,1],hour:[11,3],malt:3,file_templ:[6,11,3],dev:3,histori:[6,1,3],remain:[2,1,5,9,3],caveat:[6,5,2],learn:9,dec:3,def:[1,3,4,5,6,8,9,10,11],frustratingli:5,prompt:8,scan:[6,3],t_tabl:11,fk_:[8,5],share:1,templat:[6,11,9,3],minimum:3,phrase:3,huge:3,cours:[4,6,1,2],awkward:3,secur:2,programmat:[6,3],anoth:[1,5,11,3],bulk_insert:[6,2,9,3],simpl:[2,4,5,8,9,11],resourc:[11,3],referenc:6,reflect:[6,4],catalog:8,autogenerer:4,mutat:[5,3],varianc:6,associ:[1,2,3,6,7,8],prep_table_for_batch:6,list_templ:[6,11,3],circumst:2,github:3,confus:[1,3],caus:3,egg:11,help:[4,3],autoload:5,through:[1,3,5,6,7,10,9],hierarchi:3,get_main_opt:6,paramet:[2,3,4,5,6,8,9,10],style:[6,2,5,3],psycopg2:3,brycelohr:3,bypass:[5,2],might:[8,5,3],alter:[2,3,4,5,6,8,10],wouldn:3,good:[8,6,11],"return":[2,3,4,5,6,11],bagnoli:3,timestamp:[10,2],eventu:4,unlik:5,refresh:6,easili:9,achiev:[4,1],innodb:5,fulli:[4,6,1,11,3],intervent:3,down_revis:[4,6,1,11,9],truncat:11,drop_index:[6,2,3],conn_index:6,idea:[8,9,4,11],procedur:5,realli:1,heavi:[11,3],expect:[7,6,1,5,3],stabl:7,beyond:8,todo:2,orient:2,marcin:3,publish:7,ae10:[1,11,3],rendered_metadata_default:6,print:[6,3],schaik:3,qualifi:3,assist:[6,2,3],proxi:[6,2],advanc:2,differ:[1,3,4,5,6,10,11],reason:[4,1,5],base:[6,4],intric:[1,5],ask:[1,3],earliest:9,basi:[7,6,3],create_foreign_kei:[2,3],omit:[6,2,5,3],perman:1,metadata_index:6,assign:[8,1,5],major:[10,6,4,11,3],obviou:4,prevent:[5,3],number:[4,6,1,11,3],placehold:9,done:[1,3,4,5,6,11],construct:[6,2,4,3],blank:9,mistakenli:3,miss:[7,3],guess:4,interact:2,least:[2,3,5,6,8,11],as_dictionari:[6,9],statement:[2,3,5,6,8,9,10],migration_context:[6,2],scheme:[2,3,4,6,8,10,11],store:[6,1],schema:[2,3,4,5,6,9],option:[1,2,3,4,5,6,10,9,11],destination_rev:6,head_onli:[6,3],part:[4,2,1,11,3],pars:[6,3],consult:6,get_head_revis:6,albeit:11,kind:[1,3,4,5,6,9],whenev:[5,11],remot:[2,5,3],remov:[2,4,9,3],"27c6a30d7c24_add_shopping_cart_t":1,"2a95102259be_add_ip_account_t":1,consumpt:6,toward:[6,1,9,2],accomod:4,packag:[7,6,11,3],emit_begin:6,"null":[6,10,2,5,3],entireti:3,built:[6,4,3],equival:[6,4,3],odd:[1,5],self:[2,5,3],also:[1,2,3,4,5,6,8,10,11],build:[4,6,1,3],mysect:6,notset:11,distribut:7,exec:[2,3],set_main_opt:[6,3],previou:[6,2,1,3],reach:1,most:[1,3,4,5,6,7,8,9,11],plai:11,server_default:[6,2,3],alpha:3,mymodel:[8,4],cover:[1,3],ext:6,clean:[1,11,3],mssql_add_column:6,usual:[4,6,1,5,2],microsoft:2,carefulli:[1,11],use_alt:3,alphanumer:8,session:10,particularli:[6,4,3],sqla:4,fine:[1,2],find:11,impact:[1,3],pretti:[2,1,5,3],solut:8,"2a95102259b":1,express:[6,8,2,4,3],referent_schema:2,nativ:[8,2],alter_column:[6,2,5,3],existing_typ:[6,2,5,3],common:[9,1],wrote:10,forego:8,set:[6,4,5],dump:[10,11,3],as_sql:6,startup:11,see:[1,2,3,4,5,6,7,8,11],sybas:3,arg:[6,11,2],close:[1,3],wow:11,won:[5,3],inline_liter:[2,3],altern:[6,2,1,5,3],catalogu:9,syntact:2,numer:2,complement:3,user_order_user_account_id_fkei:8,succeed:6,frozenset:6,distinguish:3,altert:6,classnam:6,popul:[6,11,2],both:[8,2,1,10,3],last:[10,1],hint:[8,1],alon:[1,5,3],foreign:[6,4],roman:3,whole:[8,2,1,3],load:[1,3,4,5,9,11],simpli:[9,3],point:[6,1,11,3],instanti:6,sweep:6,header:11,suppli:11,"_exec":3,hackeri:3,backend:[2,3,4,5,6,8],faithfulli:4,user_id:2,stamp:[6,9],due:[6,3],empti:[6,4,11,3],implicit:[5,3],ran:1,yap:3,unambigu:1,upgrade_:3,create_d:[9,2],nonexist:3,fire:2,convert:[6,8,2,3],unnecessarili:3,understand:11,func:[2,3],look:[4,8,1,11,3],straight:[11,3],erron:3,user_module_prefix:[6,4,3],formatt:11,"while":[1,2,3,5,6,8,10,11],executemani:2,match:[6,2,5,11,3],abov:[1,2,4,5,6,7,8,11],error:[1,3,4,6,10,11],anonym:[4,2],loos:7,pylon:[7,11,3],real:[6,1,2],get_tag_argu:6,readm:[11,3],itself:[1,2,3,5,6,9,11],seen:[1,5,3],decor:3,pytest:3,decod:3,conflict:5,rev_id:6,wherea:6,moment:[2,1,9,3],temporari:[2,3],user:[2,3,4,5,6,7,10,9,11],postgresqlcontext:[10,11],user_order_id:8,chang:[4,6,1,5],recent:[7,6,11,9],lower:[6,2,3],task:4,older:[2,1,3],kelli:3,somet:[8,4],pickl:4,branchnam:1,obscur:3,relianc:11,foreignkeconstraint:3,elect:6,scenario:[6,1,5,3],theoret:11,mydatabas:6,format_column_nam:6,input:[6,2],subsequ:[1,3],start_migr:6,march:3,format:[6,1,11,3],big:3,get_current_revis:[6,3],bit:[6,3],outright:3,semi:1,signal:3,resolv:[6,1,3],collect:[6,2,9,3],visit_rename_t:6,encount:4,often:[4,9,1,3],get_sect:[6,4],get_column:6,some:[1,2,3,4,5,6,8,10,11],back:[6,1,11,9,3],global:[8,11,3],understood:[2,3],sampl:[4,3],surpris:3,ijl:3,pep:3,per:[6,2,3],santacruz:3,substitut:[6,1,11,3],larg:10,prog:6,reproduc:4,nose:3,id_:6,run:[6,4],goe:3,requires_recreate_in_batch:6,stem:5,step:[0,1,2,3,5,6],mssql:[6,3],constraint:[6,4],commanderror:[6,3],pertin:1,block:[5,2],charl:3,repair:[7,3],"__future__":3,emphasi:[1,5,3],within:[1,2,3,4,5,6,7,10,9,11],ix_:8,ensur:[1,2,3,4,7,8],ae102:1,skip_table_two:6,inclus:6,"55af2cb1c267":1,moriyoshi:3,textual:6,custom:[0,6,4,9,3],command_termin:6,includ:[6,4],suit:[10,11,3],forward:[6,3],properli:[5,3],reorgan:6,poster:1,bigseri:3,link:[1,11],translat:3,newer:[6,1,3],delta:[1,11],line:[1,3,5,6,10,9],info:[1,3,4,6,10,11],logger_alemb:11,consist:[2,3],file_:[10,6],highlight:9,similar:[1,2,3,5,7,8],clear:1,ck_user_name_len:2,reconcili:1,doesn:[1,3,4,5,6,8],repres:[2,3,5,6,9,11],"char":4,home:11,shopping_cart:1,sp_renam:3,implmeta:6,mock:6,draw:11,inspected_typ:6,remove_constraint:3,william:2,meaning:6,ago:11,land:3,lead:[7,1,3],algorithm:1,downgrade_token:6,d747a8a8879:1,far:[5,3],fresh:1,create_primary_kei:[2,3],code:[1,3,4,7,8,11],partial:[0,6,1],scratch:3,data_downgrad:9,schema_downgrad:9,procur:11,sensit:2,send:5,shoppingcart:1,aris:[5,3],sent:[6,3],connam:8,rollback:[10,4],whichev:1,truncate_slug_length:[6,11,3],releg:9,implicitli:3,dbname:[6,11],recip:9,complic:8,maarten:3,michael:3,sqllchemi:2,ryan:3,"try":[4,10,1,3],mergepoint:1,pleas:[1,3,4,5,6,11],impli:4,natur:[1,3],format_table_nam:6,focu:3,mysqldb:3,print_stdout:6,carlo:3,rivera:3,append:3,compat:[6,2,4,5,3],listen_for_reflect:5,compar:[6,4,3],resembl:3,dedup:3,access:[10,6,4,5,3],ck_sometable_q_bool:8,can:[1,2,3,4,5,6,8,9,10,11],antukh:3,implicit_bas:6,my_nam:4,len:2,intercept:[8,4],let:[8,1,11],ioerror:3,becom:[9,1],accessor:3,great:[1,3],mssqlimpl:6,ctx:2,migration_typ:4,earli:3,typic:[1,2,5,6,8,11],honor:3,chanc:6,add_constraint:6,apr:3,appli:[1,2,3,4,5,6,8,9,11],szotten:3,gatewai:5,"boolean":[8,2,5,3],fa4456a9201:1,tailor:[9,3],from:[4,6,1,5,3],"1975ea83b712":[10,1,11],upgrad:[1,2,3,4,5,6,8,9,10,11],next:[0,6,1,5,3],few:[4,1,5,11],reflectt:6,stage:6,sort:[1,3],src:3,create_index:[6,2,3],account:[1,2,3,4,10,11],retriev:[10,2,4,3],alia:1,crazi:1,cumbersom:4,proof:6,control:6,tar:7,process:[1,2,3,4,5,6,7,11],output_buff:[10,6],high:2,tag:[6,3],onlin:[6,10,2,5,3],serial:[10,3],parse_encod:3,sit:1,nvarchar:2,acycl:1,forest:1,instead:[1,3,4,5,6,10,9,11],chri:3,columndefault:6,overridden:[6,3],longdoc:6,philosophi:2,drop:[6,4],essenti:5,bind:[6,2],my_compare_typ:6,inspected_column:6,correspond:[2,5,3],element:[6,3],issu:[7,2,4,5,3],allow:[1,2,3,4,5,6,10,11],datefmt:11,depends_on:[6,1],move:[2,3,4,5,7,11],add_tabl:6,primarykeyconstraint:[8,2,4,3],perfect:4,disambigu:2,infrastructur:3,therefor:[2,5,3],greater:[2,1,3],python:[0,2,3,4,6,7,11],overal:3,dai:[11,3],mention:[8,1,2],overkil:9,front:[6,3],minimalist:11,somewher:4,anyth:[11,2],edit:[0,8,1,4],tran:4,frozenbal:3,februari:3,mode:6,mycustomtyp:4,compatib:3,upward:1,subset:6,meta:[8,5],"static":3,our:[0,1,2,4,5,8,9,10],patch:3,some_param:6,special:[1,2,3,4,5,6,8,11],out:[1,3,4,6,8,9,11],variabl:[6,2,4,11,3],"bo\u0142di":3,compare_typ:[6,4],rev:[1,3,6,10,9,11],stub:2,suitabl:[6,2,3],rel:[0,4,1,3],get_context:[6,2],defens:3,insid:[6,1,11,9,3],workflow:[1,5,3],manipul:6,standalon:2,dictionari:[6,8,2,3],releas:[7,8,4,5,3],afterward:[5,3],indent:[6,3],guarante:1,unwant:[4,3],could:[4,1,11,3],pictur:6,put:1,david:3,length:[6,4,5,11],enforc:5,outsid:[6,2,3],softwar:3,blown:[6,3],scene:[8,3],date:[4,1,3],priamri:2,existing_server_default:[6,2,3],defaultclaus:2,handler_consol:11,system:[6,2,1,5,3],messag:[6,4,11,9,3],attach:[6,4],my_column:4,upgrade_engine1:11,upgrade_engine2:11,"final":[6,5,3],"55af":1,juli:3,upgrade_token:6,minhe:3,accompani:[2,3],exactli:[6,2],mssql_drop_default:[2,3],compare_server_default:[6,4],prune:[9,11],structur:[1,2,3,5,6,11],charact:[6,2,11,3],myspecialcol:6,config_arg:[6,3],respons:6,deprec:[6,3],rcurrent:3,lightli:1,disadvantag:8,need:[1,2,3,4,5,6,7,8,9,10,11],turn:[6,2,1,5,3],automat:[1,2,3,4,5,11],"3ba2b522d10d":9,inform:[7,0,6,1,3],diverg:1,rout:6,accuraci:6,mix:3,best:[8,1],which:[1,2,3,4,5,6,8,9,10,11],discrep:1,my_compare_server_default:6,singl:[1,2,3,4,6,11],courtesi:3,unless:6,oracl:[8,6,3],pyo:[11,3],ck_:8,pyc:[11,3],"class":[6,10,2,11,3],url:[10,6,11],gather:[6,3],request:[6,11,9,3],uri:[11,3],face:6,pipe:3,determin:[10,6,4,11,3],ik_test:2,someth:[4,8,6,1,11],fact:[1,11],dba:[10,3],text:[6,2,3],verbos:[6,1,11,3],bring:1,trivial:3,anywai:11,ae1:[1,11],branch_label:[6,1,11],locat:[6,1,11,3],should:[1,2,3,4,5,6,7,9,11],jan:3,visit_column_typ:6,local:[10,6,3],hope:9,meant:1,genener:3,familiar:1,pypi:[7,3],autom:[8,2,5,3],made:[1,2,3,4,5,6,11],db1:10,db2:10,gilcreas:3,enabl:[6,10,2,5,3],organ:[10,2,1,3],dein:3,integr:[0,9,5,3],contain:[1,2,3,4,6,11],view:[4,1,3],legaci:3,knowledg:8,xxxxx:[1,11],accounts_t:2,statu:[4,1,3],aros:3,correctli:3,pattern:[5,3],formatter_gener:11,state:[6,1,5,11,2],bruno:3,kei:[6,4],file_config:6,appopri:8,job:[6,11],entir:[2,3,5,6,8,9,11],overhaul:3,addit:[1,2,3,4,6,7,9,11],instant:6,"3adcc9a56557_rename_username_field":11,version_loc:[6,1,11],equal:[1,2],configpars:11,etc:[6,2,3],instanc:[6,4,2],freeli:1,column_0_nam:[8,5],comment:[6,11,3],unimpl:3,no_paramet:3,johann:3,config_ini_sect:[6,4],quit:[8,9,1,5],tread:1,"290696571ad2":9,get_by_dialect:6,is_transactional_ddl:6,compos:11,compon:[11,3],new_table_nam:[6,2],besid:1,treat:[6,10,2,1,3],scriptabl:11,immedi:[2,3],create_unique_constraint:[8,2,3],mike:7,"109ec7d132bf_add_ip_number_t":1,presenc:9,bulk:[6,2,3],togeth:[6,1,11,2],specifc:1,present:[1,2,3,4,5,6,10,11],multi:[6,11],plain:4,"__pycache__":3,cursor:2,defin:[2,3,4,6,8,9],wilk:3,wild:1,observ:3,customiz:11,almost:[1,5,3],remove_t:6,revid:6,myengin:2,reflect_arg:[2,5,3],bigint:3,uq_:8,lightweight:0,branchpoint:[6,1],inspector:[6,5,3],account_t:2,nullpool:[6,3],unique_constraint:[6,3],welcom:3,parti:3,began:1,referenti:[5,3],cross:[1,3],member:3,handl:[6,2,3],difficult:3,http:[7,6,3],denot:[8,6],py3k:3,upon:[1,3,5,6,10,11],effect:[6,8,2,1,3],myspecialtyp:4,column_nam:[6,2],multiinsert:[6,2,3],expand:3,inspector_column:6,exceedingli:3,off:[1,2,3,4,5,6,10],center:4,well:[1,2,3,4,6,8,10,11],mysql_engin:3,argnam:2,theodor:3,runnier:6,exampl:[1,2,4,5,6,8,9,10,11],filesystem:[6,11],undefin:3,sibl:1,latest:7,less:[1,3],"2to3":3,begin_transact:6,marquard:3,floer:3,simultan:[6,1,11],renam:[2,5,3],check_constraint:2,wed:3,nullabl:[2,3,4,5,6,11],test_autogener:3,smith:2,kamyshnikova:3,add:[1,2,3,4,5,6,7,8,9,10,11],lookup:3,logger:11,autogen_column_reflect:6,account_id:2,agnost:3,crud:2,from_config:6,revisionmap:6,know:[8,1,5,11],"3cac04ae8714_create_networking_branch":1,conrelid:8,python3:3,desc:3,insert:[1,2,3,5,6,10],template_arg:[6,3],like:[1,2,3,4,5,6,8,10,11],mssql_batch_separ:6,dropcolumn:6,necessari:[2,4,5,3],page:[7,0],revers:3,with_stat:3,proper:7,enviro:11,librari:[2,11,3],separ:[6,2,1,3],wendi:2,last_transaction_d:[10,4,11],encourag:[10,3],pg_constraint:8,"34e094ad6ef1_more_account_chang":1,usag:[0,2,3,5,6,7,8,11],host:[7,6,3],slug:[6,11,3],run_migr:[10,6,4,2],about:[1,3,6,7,8,11],actual:[1,2,3,4,6,10],column:[1,2,3,4,5,6,8,9,10,11],scott:[1,11],foreign_key_constraint:6,constructor:[6,4],disabl:[6,5,3],own:[4,8,2,1,3],uq_user_account_nam:8,create_t:[2,3,4,6,9,11],run_migrations_offlin:10,column_reflect:[6,4,5],merg:6,van:3,skip_autogener:6,unvers:11,transfer:5,downgrad:[0,1,2,3,4,6,10,9],pool:6,checkconstraint:[8,2,5,3],fk_user_order_id:8,keyerror:3,postgresqlimpl:[6,1],inlin:[2,3],bug:6,count:3,old_data:6,mysqlmodifycolumn:6,whether:[6,2],wish:[8,6,1],displai:[6,1,11],below:[10,6,5,3],limit:[4,6,1,3],otherwis:[6,8,2,3],problem:[5,3],evalu:3,dure:[6,2,11,3],twist:1,novemb:3,implement:[7,6,4,3],ini:[0,6,1,9,3],pip:7,probabl:[1,11,3],noufal:3,"53fffde5ad5":1,percent:3,other:[6,4],bool:2,futur:[6,3],rememb:8,varieti:[4,5,11,3],alembic_module_prefix:[6,3],test_render_fk_constraint_kwarg:3,oracle_batch_separ:6,data_upgrad:9,reliabl:4,sys_c0029334:8,columnnul:6,config_file_nam:[10,6],portion:6,decemb:3,invari:1},objtypes:{"0":"py:module","1":"py:attribute","2":"py:function","3":"py:method","4":"py:class","5":"py:classmethod"},objnames:{"0":["py","module","Python module"],"1":["py","attribute","Python attribute"],"2":["py","function","Python function"],"3":["py","method","Python method"],"4":["py","class","Python class"],"5":["py","classmethod","Python class method"]},filenames:["index","branches","ops","changelog","autogenerate","batch","api","front","naming","cookbook","offline","tutorial"],titles:["Welcome to Alembic’s documentation!","Working with Branches","Operation Reference","Changelog","Auto Generating Migrations","Running “Batch” Migrations for SQLite and Other Databases","API Details","Front Matter","The Importance of Naming Constraints","Cookbook","Generating SQL Scripts (a.k.a. “Offline Mode”)","Tutorial"],objects:{"alembic.script":{ScriptDirectory:[6,4,1,""],Script:[6,4,1,""]},"alembic.config.Config":{get_template_directory:[6,3,1,""],set_section_option:[6,3,1,""],get_section:[6,3,1,""],set_main_option:[6,3,1,""],get_main_option:[6,3,1,""],get_section_option:[6,3,1,""],cmd_opts:[6,1,1,""],print_stdout:[6,3,1,""],config_file_name:[6,1,1,""],config_ini_section:[6,1,1,""]},"alembic.autogenerate":{compare_metadata:[6,2,1,""]},"alembic.ddl.mssql":{visit_column_nullable:[6,2,1,""],visit_rename_table:[6,2,1,""],visit_column_default:[6,2,1,""],mssql_add_column:[6,2,1,""],MSSQLImpl:[6,4,1,""],visit_rename_column:[6,2,1,""],visit_add_column:[6,2,1,""],visit_column_type:[6,2,1,""]},"alembic.operations.BatchOperations":{create_index:[2,3,1,""],drop_index:[2,3,1,""],create_primary_key:[2,3,1,""],create_check_constraint:[2,3,1,""],alter_column:[2,3,1,""],drop_column:[2,3,1,""],drop_constraint:[2,3,1,""],create_foreign_key:[2,3,1,""],add_column:[2,3,1,""],create_unique_constraint:[2,3,1,""]},"alembic.operations.Operations":{create_index:[2,3,1,""],execute:[2,3,1,""],f:[2,3,1,""],drop_index:[2,3,1,""],create_primary_key:[2,3,1,""],create_check_constraint:[2,3,1,""],alter_column:[2,3,1,""],create_foreign_key:[2,3,1,""],batch_alter_table:[2,3,1,""],drop_column:[2,3,1,""],drop_constraint:[2,3,1,""],inline_literal:[2,3,1,""],drop_table:[2,3,1,""],create_table:[2,3,1,""],bulk_insert:[2,3,1,""],add_column:[2,3,1,""],get_context:[2,3,1,""],create_unique_constraint:[2,3,1,""],get_bind:[2,3,1,""],rename_table:[2,3,1,""]},"alembic.ddl.sqlite":{SQLiteImpl:[6,4,1,""]},"alembic.revision.RevisionMap":{get_revision:[6,3,1,""],get_revisions:[6,3,1,""],get_current_head:[6,3,1,""],iterate_revisions:[6,3,1,""],add_revision:[6,3,1,""]},"alembic.environment":{EnvironmentContext:[6,4,1,""]},"alembic.ddl.impl":{ImplMeta:[6,4,1,""],DefaultImpl:[6,4,1,""]},"alembic.ddl.postgresql.PostgresqlImpl":{correct_for_autogen_constraints:[6,3,1,""],transactional_ddl:[6,1,1,""],compare_server_default:[6,3,1,""],autogen_column_reflect:[6,3,1,""],prep_table_for_batch:[6,3,1,""]},"alembic.ddl":{sqlite:[6,0,0,"-"],postgresql:[6,0,0,"-"],base:[6,0,0,"-"],mysql:[6,0,0,"-"],mssql:[6,0,0,"-"],impl:[6,0,0,"-"]},"alembic.revision":{RevisionMap:[6,4,1,""],Revision:[6,4,1,""]},"alembic.command":{upgrade:[6,2,1,""],branches:[6,2,1,""],show:[6,2,1,""],stamp:[6,2,1,""],current:[6,2,1,""],merge:[6,2,1,""],init:[6,2,1,""],list_templates:[6,2,1,""],downgrade:[6,2,1,""],heads:[6,2,1,""],revision:[6,2,1,""],history:[6,2,1,""]},"alembic.migration.MigrationContext":{execute:[6,3,1,""],get_current_heads:[6,3,1,""],configure:[6,5,1,""],stamp:[6,3,1,""],bind:[6,1,1,""],run_migrations:[6,3,1,""],get_current_revision:[6,3,1,""],config:[6,1,1,""]},"alembic.ddl.mysql":{MySQLAlterDefault:[6,4,1,""],MySQLChangeColumn:[6,4,1,""],MySQLModifyColumn:[6,4,1,""],MySQLImpl:[6,4,1,""]},"alembic.config":{main:[6,2,1,""],Config:[6,4,1,""]},"alembic.script.ScriptDirectory":{get_revisions:[6,3,1,""],get_base:[6,3,1,""],generate_revision:[6,3,1,""],iterate_revisions:[6,3,1,""],run_env:[6,3,1,""],from_config:[6,5,1,""],get_bases:[6,3,1,""],get_revision:[6,3,1,""],as_revision_number:[6,3,1,""],get_current_head:[6,3,1,""],get_heads:[6,3,1,""],walk_revisions:[6,3,1,""]},"alembic.ddl.postgresql":{visit_rename_table:[6,2,1,""],PostgresqlImpl:[6,4,1,""]},"alembic.environment.EnvironmentContext":{execute:[6,3,1,""],get_revision_argument:[6,3,1,""],configure:[6,3,1,""],script:[6,1,1,""],begin_transaction:[6,3,1,""],is_transactional_ddl:[6,3,1,""],get_head_revisions:[6,3,1,""],get_x_argument:[6,3,1,""],get_head_revision:[6,3,1,""],run_migrations:[6,3,1,""],get_tag_argument:[6,3,1,""],is_offline_mode:[6,3,1,""],get_context:[6,3,1,""],config:[6,1,1,""],get_starting_revision_argument:[6,3,1,""],get_bind:[6,3,1,""],static_output:[6,3,1,""]},"alembic.operations":{Operations:[2,4,1,""],BatchOperations:[2,4,1,""]},"alembic.ddl.impl.DefaultImpl":{drop_index:[6,3,1,""],correct_for_autogen_constraints:[6,3,1,""],drop_table:[6,3,1,""],rename_table:[6,3,1,""],compare_type:[6,3,1,""],emit_commit:[6,3,1,""],get_by_dialect:[6,5,1,""],command_terminator:[6,1,1,""],prep_table_for_batch:[6,3,1,""],create_table:[6,3,1,""],bulk_insert:[6,3,1,""],add_column:[6,3,1,""],autogen_column_reflect:[6,3,1,""],static_output:[6,3,1,""],transactional_ddl:[6,1,1,""],alter_column:[6,3,1,""],requires_recreate_in_batch:[6,3,1,""],drop_column:[6,3,1,""],drop_constraint:[6,3,1,""],compare_server_default:[6,3,1,""],create_index:[6,3,1,""],execute:[6,3,1,""],bind:[6,1,1,""],start_migrations:[6,3,1,""],emit_begin:[6,3,1,""],add_constraint:[6,3,1,""]},"alembic.ddl.sqlite.SQLiteImpl":{transactional_ddl:[6,1,1,""],correct_for_autogen_constraints:[6,3,1,""],requires_recreate_in_batch:[6,3,1,""],drop_constraint:[6,3,1,""],compare_server_default:[6,3,1,""],add_constraint:[6,3,1,""]},"alembic.ddl.base":{ColumnNullable:[6,4,1,""],visit_column_default:[6,2,1,""],visit_column_nullable:[6,2,1,""],format_server_default:[6,2,1,""],visit_column_type:[6,2,1,""],RenameTable:[6,4,1,""],AddColumn:[6,4,1,""],alter_table:[6,2,1,""],format_type:[6,2,1,""],add_column:[6,2,1,""],ColumnDefault:[6,4,1,""],visit_drop_column:[6,2,1,""],format_column_name:[6,2,1,""],ColumnType:[6,4,1,""],visit_rename_table:[6,2,1,""],quote_dotted:[6,2,1,""],visit_add_column:[6,2,1,""],drop_column:[6,2,1,""],alter_column:[6,2,1,""],format_table_name:[6,2,1,""],visit_column_name:[6,2,1,""],AlterColumn:[6,4,1,""],DropColumn:[6,4,1,""],ColumnName:[6,4,1,""],AlterTable:[6,4,1,""]},"alembic.migration":{MigrationContext:[6,4,1,""]},"alembic.ddl.mysql.MySQLImpl":{correct_for_autogen_constraints:[6,3,1,""],alter_column:[6,3,1,""],transactional_ddl:[6,1,1,""],compare_server_default:[6,3,1,""]},"alembic.revision.Revision":{nextrev:[6,1,1,""],revision:[6,1,1,""],is_head:[6,1,1,""],down_revision:[6,1,1,""],is_branch_point:[6,1,1,""],dependencies:[6,1,1,""],is_merge_point:[6,1,1,""],branch_labels:[6,1,1,""],is_base:[6,1,1,""]},"alembic.ddl.mssql.MSSQLImpl":{alter_column:[6,3,1,""],transactional_ddl:[6,1,1,""],emit_commit:[6,3,1,""],batch_separator:[6,1,1,""],drop_column:[6,3,1,""],emit_begin:[6,3,1,""],bulk_insert:[6,3,1,""]},"alembic.script.Script":{doc:[6,1,1,""],longdoc:[6,1,1,""],module:[6,1,1,""],path:[6,1,1,""]},alembic:{operations:[2,0,0,"-"],script:[6,0,0,"-"],environment:[6,0,0,"-"],command:[6,0,0,"-"],migration:[6,0,0,"-"],ddl:[6,0,0,"-"],config:[6,0,0,"-"],revision:[6,0,0,"-"]}},titleterms:{all:1,partial:11,scratch:9,syntax:1,prefix:4,mysql:6,identifi:11,depend:[7,1],configur:6,bug:[7,3],overview:6,get:[10,11],auto:4,offlin:[10,5],mechan:1,condit:9,front:7,affect:4,name:[8,5],specif:1,changelog:3,edit:11,drop:5,integr:8,second:11,refer:[1,2],view:11,set:1,deal:5,batch:5,intern:6,themselv:4,what:4,detect:4,databas:[9,5],label:1,version:[10,1],rel:11,ddl:6,"import":8,mode:[10,5],run:[1,5,11],kei:5,migrat:[4,5,6,10,9,11],autogener:[8,6,4,5],gener:[10,4],step:11,base:1,postgresql:6,constraint:[8,5],unnam:5,script:[10,6,11],foreign:5,tutori:11,context:6,alemb:0,chang:3,first:11,oper:[8,6,2],rang:11,render:4,onc:1,modul:4,misc:3,api:6,instal:7,custom:10,merg:1,from:9,convent:8,commun:7,support:10,next:11,start:10,downgrad:11,includ:5,type:4,more:1,head:1,than:5,work:[1,5],uniqu:5,histori:11,project:7,matter:7,control:[4,5],sqlite:[6,5],featur:3,creat:[1,11],indic:0,ini:11,file:11,tabl:[0,5],revis:[6,1,11],element:9,check:5,multipl:1,welcom:0,detail:6,write:10,other:5,build:9,branch:1,command:6,document:0,referenc:5,our:11,object:6,statu:7,reflect:5,sql:[10,6],date:9,homepag:7,directori:[6,1],explicit:1,doe:4,inform:11,environ:[10,6,11],cookbook:9}}) \ No newline at end of file +Search.setIndex({envversion:42,terms:{walk_revis:6,untrust:2,prefix:6,dirnam:10,alembic_vers:[10,6,1,11,3],logger_root:11,relnum:1,whose:[6,3],accur:4,"const":6,aug:3,pprint:6,under:[6,2,3],get_current_head:[6,3],worth:8,everi:[8,11,3],starting_rev:6,quote_dot:6,batchoper:[2,5,3],kick:3,appar:3,rename_t:[6,2],vast:[4,11],include_schema:[6,3],run_env:6,factori:6,readthedoc:7,sqliteimpl:6,script_directori:[6,3],"27c6a":1,direct:[1,2,3,4,5,6,8,10,11],batch:6,second:[0,2,1,5,3],street:5,after_parent_attach:[8,4],even:[1,2,3,5,8,11],neg:11,calcul:[6,11],binet:3,nonetyp:3,"new":[1,2,3,4,5,6,8,9,11],net:3,topolog:1,metadata:[2,3,4,5,6,8,11],"27c":1,behavior:[6,2,4,5,3],never:[2,3],here:[1,2,3,4,5,6,7,8,9,11],all_constraint:8,pedro:3,argv:6,path:[1,4,6,10,9,11],interpret:[11,3],autogenrendertest:3,odagiri:3,datetim:[4,11,2],naming_convent:[8,2,5,3],pyramid:3,total:[6,11],highli:3,describ:[1,2,3,5,6,10,11],would:[1,2,3,4,5,6,8,10,11],compare_to:6,old_table_nam:[6,2],call:[1,2,3,4,5,6,8,11],harland:3,recommend:[7,4,2,1,3],uq_user_nam:2,type:6,tell:[9,1,11,3],autogen:[6,3],relat:[8,5,11,3],notic:[10,11],warn:[11,3],pkg_resourc:3,hole:2,hold:[11,3],must:[1,3,4,5,6,10,11],join:[8,1,10],err:3,some_t:[8,5,2],setup:[6,7,2,3],work:[6,4],wors:8,rework:3,root:[6,1,11],"29f8":1,overrid:[6,4,5,2],defer:3,give:[4,8,9,1,3],autodetect:3,indic:[6,3],want:[1,2,6,8,10,11],david:3,end:[1,2,3,4,6,10,11],hoc:[6,2],quot:[6,2,3],output_encod:[6,11,3],how:[3,4,5,6,8,9,11],conn:[6,2],env:[2,3,4,5,6,8,10,11],verifi:2,ancestor:1,perspect:[6,1],updat:[6,1,2],visit_drop_column:6,recogn:3,tablenam:[8,6,3],after:[9,1,3],befor:[1,2,3,5,6,11],wrong:[8,3],parallel:3,attempt:[2,1,5,3],third:1,classmethod:6,logger_:11,zzzeek:[7,3],imposs:1,receiv:[6,2,1,3],type_:[6,2,4,5,3],maintain:[6,1,11,3],enter:5,exclus:6,engine_from_config:[6,4],order:[1,2,3,4,5,6,8,11],composit:3,get_unique_constraint:3,assert_relative_length:6,becaus:[4,1,5,3],"2b1ae634e5cd_add_order_id":11,autogen_context:[6,4],demarc:6,affect:6,constraint_typ:8,addcolumn:6,flexibl:3,vari:6,revision_environ:[6,11,3],pk_my_tabl:2,uuid:6,fix:[6,2,4,3],inadvert:3,better:[8,3],comprehens:4,easier:11,split:3,them:[1,2,3,5,6,8,10],poolclass:6,thei:[1,2,3,4,5,6,11],proce:[1,2,3,4,5,6,7],safe:[2,5,3],"break":[1,2],drop_tabl:[6,4,11,9,2],mytabl:6,r1975ea:11,accommod:[5,3],luca:3,each:[1,2,3,6,8,10,11],higher:[6,3],side:[6,2,1,3],mean:[10,6,1,5,2],prohibit:3,iterate_revis:[6,3],unreport:3,enorm:[2,3],bflag:5,version_path:6,foreignkeyconstraint:[6,2,5,3],network:1,paradoxxxzero:3,newli:[2,3],content:6,rewrit:3,branch:6,adapt:3,mypackag:4,forth:1,streamhandl:11,written:[6,11,3],abramowitz:3,free:[4,11],standard:[10,6,5,11,2],lineag:3,q_bool:8,convent:[0,5,3],filter:[6,3],include_object:[6,3],isn:[1,5,3],regress:3,onto:[1,11],source_schema:[2,3],suppos:[8,4,11],rang:[10,3],perfectli:2,render:6,thoughtfulli:1,independ:[1,3],restrict:[10,2],hook:[6,4,3],instruct:[6,2,1,11,3],alreadi:[1,2,3,4,5,6,8],wasn:3,primari:[2,3,4,5,6,8,10],format_typ:6,top:[4,1,3],downsid:3,mercuri:[7,3],master:7,too:[8,1,3],john:2,listen:[5,2],consol:[6,11],namespac:[6,2,4,3],tool:[7,0,5,11],setuptool:3,travers:[6,1,3],"10g":8,incur:3,termin:3,contyp:8,target:[1,2,3,4,5,6,11],keyword:[6,2,3],provid:[1,2,3,4,5,6,8,9,10,11],tree:[1,11],batch_alter_t:[6,2,5,3],ddlelement:6,entri:[4,1],minut:[11,3],fashion:3,runner:[6,11,3],mind:8,manner:3,increment:9,include_symbol:[6,3],seem:8,incompat:[1,3],recreat:[6,2,5,3],latter:3,get_revis:6,derek:3,methodolog:4,greatest:2,though:[1,2,3,5,6,8,9,11],usernam:5,version_fil:10,multiplehead:6,skip_table_on:6,regular:[6,1,5,2],phase:3,prematur:3,sub:1,tradit:[2,3],don:[6,2,1,11,3],doc:[6,3],doe:6,dummi:3,declar:4,left:[6,1,11,2],notion:3,dot:[6,2,3],mysqlalterdefault:6,changeset:6,columnnam:6,mostli:[5,3],mssql_drop_foreign_kei:[2,3],syntax:5,radic:3,uq_const_x:8,is_offline_mod:[10,6],involv:[2,1,3],absolut:[11,3],layout:1,pk_:8,latenc:11,folder:11,oct:3,wide:[4,3],stop:[1,11],report:[7,3],incept:3,bat:[6,11],bar:[6,5,11,2],"109e":1,"public":[6,3],bad:4,septemb:3,alembic_cfg:[6,9],respond:11,commandlin:[9,3],robbi:3,datatyp:[6,4,2],result:[4,6,1,11,2],multidb:[11,3],auto_incr:[2,3],fail:[1,5,3],themselv:6,basemost:1,subject:[1,3],said:[6,1],databas:[6,4],figur:8,user_ord:8,approach:[9,5,11,3],attribut:[4,6,1,3],accord:[2,3],mysqlimpl:6,extend:[6,9],newnam:6,extens:3,batch_separ:6,howev:[1,2,3,4,5,6,8],against:[1,2,3,4,5,6,10,11],logic:[6,5,9,3],seri:[1,2,3,5,6,7,9],col:[6,2],remote_col:2,kwd:2,diff:6,guid:11,assum:[8,1,10,11,3],duplic:3,get_template_directori:6,script_loc:[6,11,3],fri:3,three:[6,11,3],been:[1,2,3,6,7,8],much:[8,2,1,5,3],end_vers:10,basic:[1,2,3,4,6,10,9,11],"__doc__":3,koizumi:3,version_table_schema:[6,3],py3:3,spit:3,suppress:3,ani:[1,2,3,4,5,6,8,9,10,11],lift:3,"catch":3,ae1027:[1,11],giacomo:3,execution_opt:[6,2,3],"__repr__":4,ident:6,blume:3,servic:[2,3],weren:[1,3],safeconfigpars:[6,11],resource_filenam:[11,3],have:[1,2,3,4,5,6,8,10,11],tabl:[6,4],toolkit:0,kwarg:[6,3],varchar:[10,6,4,2],tediou:[8,5],sever:[1,5,11,3],mako:[1,3,4,6,9,11],hong:3,incorrectli:1,perform:[6,1,5,3],suggest:1,make:[1,2,3,4,6,8,9,10,11],mayb:8,complex:3,descend:1,sat:3,complet:[8,6,5,3],inspected_default:6,create_engin:[6,3],hand:[10,4,11,3],fairli:7,rais:[10,6,4,3],set_section_opt:[6,3],is_head:6,thu:[1,3],client:10,wherebi:[5,3],thi:[1,2,3,4,5,6,7,8,9,10,11],everyth:[11,3],paradigm:1,unchang:3,identifi:[0,1,2,3,4,5,6,9],coomber:3,just:[1,2,3,5,6,8,9,11],context_opt:6,yet:[1,2,3,4,6,11],languag:[6,2,3],previous:3,metadata_column:6,easi:[8,9,10],mysqlchangecolumn:6,had:[2,1,11,3],reflect_kwarg:[2,5,3],board:5,els:[2,3,4,5,6,10,9,11],gave:1,opt:6,applic:[1,2,3,4,5,6,8,9,11],quirk:3,preserv:3,background:4,renamet:6,specif:[6,4],temptabl:3,arbitrari:3,manual:[4,8,1,5,3],local_col:2,specifii:3,unnecessari:3,underli:[6,11,2],www:3,right:[8,6,1,2],old:[2,3,4,5,9,11],dimitri:3,typeerror:3,interv:3,"34e094ad6ef1":1,txt:10,cooper:3,bottom:10,subclass:[6,2,3],buffer:6,tracker:[7,3],py2k:3,overcom:5,condit:3,fileconfig:11,foo:[1,2,3,4,5,6],my_tabl:[9,2],localhost:[1,11],plu:[11,3],conn_uniqu:6,repositori:[7,6,1,3],post:[7,3],alexand:3,chronolog:6,slightli:[5,3],surround:[2,3],generate_revis:[6,3],commit:[10,6,4,3],produc:[2,3,4,5,6,11],encourgag:8,xyz:3,"float":3,encod:[6,11,3],bound:[2,3],down:[4,6,1,11,3],resili:3,lieu:2,wrap:3,qualnam:11,git:[7,3],fabric:5,wai:[1,3,5,6,8,9,10,11],support:[0,1,3,4,5,6,7,8,9],avail:[2,3,4,6,7,9,11],width:[6,3],reli:[10,5,3],add_column:[2,3,4,5,6,8,11],shgoh:3,head:6,creation:[11,3],form:[6,2,3],offer:[1,3],forc:[6,2],sqlalchemi:[0,1,2,3,4,5,6,7,8,9,11],metadata_typ:6,"true":[2,3,4,5,6,8,9,11],sourceless:[6,11,3],create_constraint:5,absens:5,unmerg:6,until:1,absenc:10,emit:[1,2,3,5,6,8,9],defaultimpl:6,featur:[4,6,1,5],alongsid:3,create_check_constraint:2,hardcod:3,transactional_ddl:[10,6,3],exist:[1,2,3,5,6,10,9,11],check:[6,4],somenam:6,index:[0,2,3,4,6,7,8],when:[1,2,3,4,5,6,8,9,10,11],refactor:4,zeidler:3,entrypoint:6,jone:2,test:[1,3,4,6,8,11],roll:[6,9],node:1,intend:[6,4,5,3],stringio:3,dialect_nam:[10,6],stringif:3,"_alembic_batch_temp":5,intent:4,consid:[1,2,3,5,6,9],doubl:3,run_migrations_onlin:[8,4,10],bitbucket:[7,3],nov:3,longer:[8,6,1,9,3],anywher:11,pseudo:3,relnam:8,remove_column:6,tinyint:3,pathnam:11,time:[1,3,5,6,10,8,11],add_index:3,backward:3,concept:1,skip:[6,3],consum:[11,3],signific:3,customari:6,add_revis:6,row:[1,2,3,6,8,10],pg_class:8,depend:[6,4],zone:10,graph:1,decim:[11,3],visit_column_default:6,certainli:8,isinst:[6,4],sourc:[1,2,3,6,7,11],string:[1,2,3,4,5,6,8,9,11],ibrahim:3,quoted_nam:[2,3],drop_constraint:[6,8,2,5,3],word:[2,3],exact:[11,3],"2a95":1,"1975ea83b712_create_account_t":11,level:[6,2,5,11,3],did:[4,1],reconcil:1,iter:[6,9],item:[6,4,3],head_revis:6,dir:6,upper:[6,2],sign:3,ini_sect:6,transaction_per_migr:[6,3],cmd_line_url:6,render_as_batch:[6,5,3],current:[1,2,3,4,5,6,7,10,11],sinc:[6,2,1,5,3],axel:3,is_bas:6,ascii:3,redirect:[10,6],deriv:[6,11,2],gener:6,satisfi:1,referred_table_nam:[8,5],modif:3,splice:[6,1,11],address:[5,2],dialect_kw:2,along:[1,2,3,5,6,11],behav:5,pysqlit:[6,3],semant:1,regardless:[6,5,11,2],extra:[5,3],modul:6,prefer:[6,5,3],fk_bar_foo_id_foo:5,"1975ea83b712_create_accoun":11,marker:6,instal:3,append_constraint:3,memori:10,live:[10,1,5,11,2],handler:[6,11],scope:5,challeng:[4,10,1,5],claus:2,explcitli:4,enhanc:[7,3],accept:[2,3,4,5,6,10,11],obj:4,effort:[8,3],easiest:6,nextval:3,uniqu:[6,4],mycolumn:4,modify_nul:6,whatev:[6,4,11],purpos:[10,9,5,3],encapsul:6,stream:[6,2,1,11,3],predict:5,relnamespac:8,glitch:3,levelnam:11,topic:[8,4],critic:[10,4],immutabledict:6,occur:[4,1,5,11,3],alwai:[1,2,4,5,7,10],differenti:3,multipl:6,write:[0,8,6,3],parameter:2,map:6,product:[8,9,3],mar:3,autoincr:[6,2,3],max:11,resolve_depend:6,usabl:6,ioctl:3,rev_rang:6,mai:[1,2,3,4,5,6,7,10,11],underscor:3,data:[2,3,4,5,6,9],current_vers:10,stress:1,practic:[6,11,2],rather:[6,2,4,11,3],"switch":9,preced:[1,5],combin:[4,2,1,3],pg_namespac:8,callabl:[6,4,3],talk:[8,6],tty:3,anticip:3,my_funct:6,format_server_default:6,still:[2,1,5,9,3],conjunct:[2,4,3],"55af2cb":1,group:[7,6,2],thank:3,emit_commit:6,platform:3,window:3,d747a8a8879_add_a_shopping_cart_column:1,is_merge_point:6,main:[6,1,3],sok:3,non:[6,2,4,11,3],enviromn:11,environmentcontext:[2,3,4,5,6,10,9],col2:4,initi:[6,2,1,11,3],col1:4,underneath:1,"53fffde5ad5_merge_ae1_and_27c":1,ae1027a6acf_add_a_column:[1,11],now:[1,2,3,4,5,6,7,9,11],discuss:[7,1],nor:[5,3],introduct:[11,3],term:[1,11,2],name:[6,4],version_num:[10,1],config:[3,4,6,10,9,11],didn:[1,3],revert:[6,3],typeengin:[6,2],datamemb:[6,2],rock:11,januari:3,attributeerror:3,compil:[6,3],dialect:[6,2,5,3],replac:[6,4,5,9,3],individu:[6,2,1,11,3],continu:[4,1,11,3],visit_rename_column:6,year:[8,11,3],foreign_kei:[6,2],accomplish:10,"3rd":3,space:[6,3],mssql_drop_check:[2,3],rational:5,correct:[4,5,11,3],static_output:6,earlier:1,get_head:[6,3],romano:3,cart:1,metadata_default:6,bayer:7,theori:[9,11],alter_t:6,org:[7,6,3],unpredict:8,care:[7,6],reusabl:3,suffici:5,badli:3,rule:[2,4,3],visit_column_nul:6,thing:[1,2,3,6,8,9,11],place:[1,3,4,5,6,8,11],think:[9,1],first:[0,1,2,3,4,5,6,8,9,10],origin:[6,1,5,3],wiki:3,get_starting_revision_argu:6,directli:[1,2,3,4,5,6,11],onc:6,arrai:3,yourself:3,environment_context:6,"long":[4,1,5,11,3],open:[10,6,3],size:3,given:[1,2,3,4,5,6,8,9,11],workaround:[5,3],"29f859a13ea":1,paramt:3,conveni:[4,8,1],uniqueconstraint:[2,3,4,5,6,8],migrationscontext:8,especi:1,programat:6,copi:[6,2,5,9,3],specifi:[1,2,3,5,6,11],github:3,enclos:6,pragma:5,than:[6,4],erdfelt:3,serv:[6,1,3],get_section_opt:6,kuzminski:3,were:[4,6,1,5,3],posit:[6,2,11,3],sqlalchemy_module_prefix:[6,4,3],pre:5,sai:[9,1],ann:3,argument:[1,2,3,4,5,6,9,11],"_replac":6,deliv:3,exclud:3,dbapi:[2,3],engin:[2,3,4,6,10,9,11],techniqu:[9,3],get_revision_argu:[10,6],note:[1,2,3,4,5,6,11],dispar:3,take:[2,3,4,5,6,7,8,9],concern:5,noth:[6,1,11,3],begin:[2,3,4,5,6,10,11],sure:[4,1,11],"enum":[2,4,5,3],normal:[1,2,4,5,6,8,9,11],track:7,beta:[7,1,5,3],pair:[4,3],synonym:6,db_2:10,db_1:10,later:[4,10,6,1],brokenpipeerror:3,create_al:[6,9],shop:[1,5],shot:9,show:[6,1,11,3],hack:10,get_x_argu:[6,9,3],onli:[1,2,3,4,5,6,10,9,11],explicitli:[4,1,5,11,3],transact:[1,3,5,6,10,11],behind:[8,3],dict:5,over:[4,6,1,5,3],variou:[2,11,9,3],get:[0,1,3,4,6,7,8,9],repr:[6,1,9,3],soon:9,cannot:[1,2,3,4,5,6],get_schema_nam:[6,3],utf:[6,11,3],constraint_nam:[8,2,3],requir:[1,2,3,5,6,7,8,11],my_render_column:6,yield:[6,3],as_revision_numb:6,where:[1,2,3,4,5,6,8,9,10,11],existing_autoincr:[6,2],"__module__":[6,4,3],reserv:2,nextrev:6,review:4,my_metadata:9,enough:[8,4],between:[1,3,4,5,6,7,9,11],"import":[0,1,3,4,6,9],across:[6,2,1,5,3],fcntl:3,august:3,parent:[8,2,1,11,3],screen:11,is_branch_point:6,uncondition:[5,11,3],come:[6,4,9,3],tue:3,javier:3,tutori:[0,6,2],version_t:[6,3],impl:[6,1,2],improv:3,among:[1,3],issue10740:6,podoliaka:3,unittest:3,colon:[11,3],emit_ev:3,ultim:[6,2],semicolon:6,marc:3,ck_bool_:2,render_item:[6,4,3],thousand:11,fk_user_address:2,tiger:11,andrei:3,dialectnam:2,andrea:3,those:[1,2,3,4,5,6,8,9],"case":[1,2,3,4,5,6,8,9,11],kolov:3,cast:3,invok:[1,2,3,4,5,6,9,11],invoc:[6,11],new_column_nam:[2,5,3],argpars:[6,3],advantag:1,stdout:[6,3],henc:[1,3],destin:[6,2],ddlevent:4,myapp:[8,6,4,10],ck_bool_t_x:2,pursu:1,"__init__":3,develop:[7,1,11],author:3,intermediari:3,same:[1,2,3,4,6,8,9,10,11],inconsist:5,column_0_label:8,eventu:4,week:3,finish:[9,4],nest:6,oid:8,driver:[11,3],weed:3,driven:3,capabl:[10,6,11],mani:[6,1,5,3],extern:[2,3],somecolumn:6,"0x100254150":6,metadata_unique_constraint:6,appropri:[6,4,2,1,3],choos:1,copy_from:[5,2],without:[1,2,3,5,6,10,9,11],deferr:[2,3],model:[1,4,6,8,9,11],execut:[6,10,2,9,3],termwidth:3,aspect:[2,3],versu:[1,2],"55af2cb1c267_add_another_account_column":1,except:[1,2,3,4,5,6,10],littl:3,identif:3,batch_op:[6,5,2],kahlert:3,table_nam:[6,8,2,5,3],around:3,read:[10,6,11,3],migrationcontext:[6,2,3],correct_for_autogen_constraint:6,mon:3,table_kwarg:2,saniti:3,ae1027a6acf:[10,1,11],integ:[2,3,4,5,6,8,11],server:[6,10,2,4,3],either:[1,2,3,4,6,11],cascad:2,output:[1,2,3,4,6,10,11],burclaf:3,manag:[6,2,1,11,3],"function":[1,2,3,4,6,8,10,11],somefunct:3,my_enum:5,interstingli:1,ascend:11,intact:3,d747:1,ondelet:[2,3],slice:[11,3],"109ec7d132bf":1,definit:[4,5,2],"27c6":1,legal:2,target_metadata:[2,3,4,5,6,8],exit:3,notabl:6,refer:[6,5],column_info:[6,5],formatter_:11,inspect:[9,3],broken:[10,3],foreign_key_column:2,found:6,standpoint:6,regexp:3,drop_column:[6,2,5,11,3],unicod:[11,3],comparison:[6,4,3],firebird:3,up_revis:[9,1],addconstraint:2,addition:[5,3],degre:[2,3],stand:4,act:2,alemb:[1,3,4,5,6,7,9],"\u0142ukasz":3,routin:[6,3],visit_add_column:6,visit_column_nam:6,your:[4,8,1,11,3],get_bas:[6,3],log:[10,11,3],area:[4,11],aren:[4,1,5,2],hex:6,start:[0,1,3,4,6,9],interfac:2,lot:[4,8,1],scriptdirectori:[6,3],strictli:6,tupl:[6,1],regard:[2,3],jun:3,default_constraint:2,jul:3,starting_vers:10,yourproject:11,pull:[10,1,3],possibl:[10,5,11,2],"default":[1,2,3,4,5,6,8,10,11],current_rev:6,foreignkei:[8,2,5,3],embed:3,connect:[2,3,4,5,6,8,10,11],gone:5,remove_index:3,creat:[6,4,5],certain:6,bugtrack:3,deep:3,strongli:[7,3],file:[0,1,2,3,4,5,6,10,9],rendered_inspector_default:6,rearrang:3,logger_sqlalchemi:11,incorrect:3,again:[1,3,4,5,8,9,11],googl:7,event:[2,3,4,5,6,8],field:[11,3],valid:3,"3512b954651e_add_account":11,ignor:3,you:[1,3,4,6,8,9,11],"1975ea83b712_add_account_t":[1,11],architectur:5,"27c6a30d7c24":[4,1],sequenc:[6,2,4,11,3],symbol:[6,2,1,11,3],docstr:[6,3],existing_nul:[6,2],versionad:6,sequent:1,philosoph:5,descript:[10,4,11,2],columntyp:6,inevit:4,token:[8,2,11,3],potenti:[7,3],escap:3,batchoperationsimpl:6,represent:4,all:[6,4,5],illustr:[10,1,11],month:[11,3],abil:11,compare_metadata:[6,3],follow:[1,2,5,6,8,11],yourapp:[6,11,9],altercolumn:6,init:[6,11,3],program:3,queri:3,table_arg:[5,2],introduc:[6,2,1,3],liter:[2,3],straightforward:3,fals:[2,3,4,5,6,10,11],offlin:6,util:[6,4,3],candid:[6,4,3],mechan:6,failur:3,veri:[4,6,1,11,3],ticket:3,pg_catalog:[8,3],schema_upgrad:9,list:[1,2,3,6,8,11],atsushi:3,adjust:[4,5,3],stderr:[10,11],small:[6,4,3],superced:6,user_account_id:8,user_account:8,zero:[6,3],design:[10,11,2],contextu:[6,3],pass:[1,2,3,4,5,6,8,9,10,11],further:[10,2,3],what:6,navig:6,sun:3,section:[1,3,4,5,6,10,9,11],abl:[8,6,9],brief:2,conn_unique_constraint:6,delet:[9,1,2],version:[6,4,5],primary_kei:[8,6,5,11,2],method:[2,3,4,5,6,11],schemaitem:6,movement:9,hasn:[4,3],full:[1,2,3,5,6,9,11],christian:3,postgreql:3,dict_:6,handler_:11,shouldn:3,rudimentari:[4,11,2],modifi:[2,3,4,6,9,11],valu:[1,2,3,4,6,8,10,11],search:[0,4],misinterpret:3,prior:[1,5,3],action:[9,2],narrow:1,get_bind:[6,2],via:[2,3,4,5,6,7,10,11],shorthand:1,onupd:[2,3],filenam:[6,11,3],inappropri:3,establish:[6,1],select:[1,2,3,4,5,6,8,10],"3cac04ae8714":1,proceed:[8,11],distinct:[2,1,3],liber:3,two:[1,3,4,6,8,10,11],taken:3,anscestor:1,more:[6,4,5],flat:5,diamond:1,desir:[4,1,5,11,3],cmd_opt:[6,3],hundr:9,sometag:6,flag:[2,3,5,6,8,9,10,11],particular:[6,8,2,11,3],known:[1,2,3,4,8,11],none:[1,2,3,4,5,6,8,9,10,11],endpoint:[6,1],hour:[11,3],malt:3,file_templ:[6,11,3],dev:3,histori:[6,1,3],remain:[2,1,5,9,3],caveat:[6,5,2],learn:9,dec:3,def:[1,3,4,5,6,8,9,10,11],frustratingli:5,prompt:8,scan:[6,3],t_tabl:11,fk_:[8,5],share:1,templat:[6,11,9,3],minimum:3,phrase:3,huge:3,cours:[4,6,1,2],awkward:3,secur:2,programmat:[6,3],anoth:[1,5,11,3],bulk_insert:[6,2,9,3],simpl:[2,4,5,8,9,11],resourc:[11,3],referenc:6,reflect:[6,4],catalog:8,autogenerer:4,mutat:[5,3],varianc:6,associ:[1,2,3,6,7,8],prep_table_for_batch:6,list_templ:[6,11,3],circumst:2,"short":3,confus:[1,3],caus:3,egg:11,help:[4,3],autoload:5,through:[1,3,5,6,7,10,9],hierarchi:3,get_main_opt:6,paramet:[2,3,4,5,6,8,9,10],style:[6,2,5,3],psycopg2:3,brycelohr:3,bypass:[5,2],might:[8,5,3],alter:[2,3,4,5,6,8,10],wouldn:3,good:[8,6,11],"return":[2,3,4,5,6,11],bagnoli:3,timestamp:[10,2],document:[7,6,4,3],unlik:5,refresh:6,easili:9,achiev:[4,1],innodb:5,fulli:[4,6,1,11,3],intervent:3,down_revis:[4,6,1,11,9],truncat:11,drop_index:[6,2,3],conn_index:6,idea:[8,9,4,11],procedur:5,realli:1,heavi:[11,3],expect:[7,6,1,5,3],stabl:7,beyond:8,todo:2,orient:2,marcin:3,publish:7,ae10:[1,11,3],rendered_metadata_default:6,print:[6,3],schaik:3,qualifi:3,assist:[6,2,3],proxi:[6,2],advanc:2,differ:[1,3,4,5,6,10,11],reason:[4,1,5],base:[6,4],intric:[1,5],ask:[1,3],earliest:9,basi:[7,6,3],create_foreign_kei:[2,3],omit:[6,2,5,3],perman:1,metadata_index:6,assign:[8,1,5],major:[10,6,4,11,3],obviou:4,prevent:[5,3],number:[4,6,1,11,3],placehold:9,done:[1,3,4,5,6,11],construct:[6,2,4,3],blank:9,mistakenli:3,miss:[7,3],guess:4,interact:2,least:[2,3,5,6,8,11],as_dictionari:[6,9],statement:[2,3,5,6,8,9,10],migration_context:[6,2],scheme:[2,3,4,6,8,10,11],store:[6,1],schema:[2,3,4,5,6,9],option:[1,2,3,4,5,6,10,9,11],destination_rev:6,head_onli:[6,3],part:[4,2,1,11,3],pars:[6,3],consult:6,bartosz:3,get_head_revis:6,albeit:11,kind:[1,3,4,5,6,9],whenev:[5,11],remot:[2,5,3],remov:[2,4,9,3],"27c6a30d7c24_add_shopping_cart_t":1,"2a95102259be_add_ip_account_t":1,consumpt:6,toward:[6,1,9,2],accomod:4,packag:[7,6,11,3],emit_begin:6,"null":[6,10,2,5,3],entireti:3,built:[6,4,3],equival:[6,4,3],odd:[1,5],self:[2,5,3],also:[1,2,3,4,5,6,8,10,11],build:[4,6,1,3],mysect:6,notset:11,distribut:7,exec:[2,3],set_main_opt:[6,3],previou:[6,2,1,3],reach:1,most:[1,3,4,5,6,7,8,9,11],plai:11,server_default:[6,2,3],alpha:3,mymodel:[8,4],cover:[1,3],ext:6,clean:[1,11,3],mssql_add_column:6,usual:[4,6,1,5,2],microsoft:2,carefulli:[1,11],use_alt:3,alphanumer:8,session:10,particularli:[6,4,3],sqla:4,fine:[1,2],find:11,impact:[1,3],pretti:[2,1,5,3],solut:8,"2a95102259b":1,express:[6,8,2,4,3],referent_schema:2,nativ:[8,2],alter_column:[6,2,5,3],existing_typ:[6,2,5,3],common:[9,1],wrote:10,forego:8,set:[6,4,5],dump:[10,11,3],as_sql:6,startup:11,see:[1,2,3,4,5,6,7,8,11],sybas:3,arg:[6,11,2],close:[1,3],wow:11,won:[5,3],inline_liter:[2,3],altern:[6,2,1,5,3],catalogu:9,syntact:2,numer:[2,3],complement:3,user_order_user_account_id_fkei:8,succeed:6,frozenset:6,distinguish:3,altert:6,classnam:6,popul:[6,11,2],both:[8,2,1,10,3],last:[10,1],hint:[8,1],alon:[1,5,3],foreign:[6,4],roman:3,whole:[8,2,1,3],load:[1,3,4,5,9,11],simpli:[9,3],point:[6,1,11,3],instanti:6,sweep:6,header:11,suppli:11,"_exec":3,hackeri:3,backend:[2,3,4,5,6,8],faithfulli:4,user_id:2,stamp:[6,9],due:[6,3],empti:[6,4,11,3],implicit:[5,3],ran:1,yap:3,unambigu:1,upgrade_:3,create_d:[9,2],nonexist:3,fire:2,convert:[6,8,2,3],unnecessarili:3,understand:11,func:[2,3],look:[4,8,1,11,3],straight:[11,3],erron:3,user_module_prefix:[6,4,3],formatt:11,"while":[1,2,3,5,6,8,10,11],executemani:2,match:[6,2,5,11,3],abov:[1,2,4,5,6,7,8,11],error:[1,3,4,6,10,11],anonym:[4,2],loos:7,pylon:[7,11,3],real:[6,1,2],get_tag_argu:6,readm:[11,3],itself:[1,2,3,5,6,9,11],seen:[1,5,3],decor:3,belong:3,pytest:3,decod:3,conflict:5,rev_id:6,wherea:6,moment:[2,1,9,3],temporari:[2,3],user:[2,3,4,5,6,7,10,9,11],postgresqlcontext:[10,11],user_order_id:8,chang:[4,6,1,5],recent:[7,6,11,9],lower:[6,2,3],task:4,older:[2,1,3],kelli:3,somet:[8,4],pickl:4,branchnam:1,obscur:3,relianc:11,foreignkeconstraint:3,elect:6,scenario:[6,1,5,3],theoret:11,mydatabas:6,format_column_nam:6,input:[6,2],subsequ:[1,3],start_migr:6,march:3,format:[6,1,11,3],big:3,get_current_revis:[6,3],bit:[6,3],outright:3,semi:1,signal:3,resolv:[6,1,3],collect:[6,2,9,3],visit_rename_t:6,encount:4,often:[4,9,1,3],get_sect:[6,4],get_column:6,some:[1,2,3,4,5,6,8,10,11],back:[6,1,11,9,3],global:[8,11,3],understood:[2,3],sampl:[4,3],surpris:3,ijl:3,pep:3,per:[6,2,3],santacruz:3,substitut:[6,1,11,3],larg:10,prog:6,reproduc:4,nose:3,id_:6,run:[6,4],goe:3,requires_recreate_in_batch:6,stem:5,step:[0,1,2,3,5,6],mssql:[6,3],constraint:[6,4],commanderror:[6,3],pertin:1,block:[5,2],charl:3,repair:[7,3],"__future__":3,emphasi:[1,5,3],within:[1,2,3,4,5,6,7,10,9,11],ix_:8,ensur:[1,2,3,4,7,8],ae102:1,skip_table_two:6,inclus:6,"55af2cb1c267":1,moriyoshi:3,textual:6,custom:[0,6,4,9,3],command_termin:6,includ:[6,4],suit:[10,11,3],forward:[6,3],properli:[5,3],reorgan:6,poster:1,bigseri:3,link:[1,11],translat:3,newer:[6,1,3],delta:[1,11],line:[1,3,5,6,10,9],info:[1,3,4,6,10,11],logger_alemb:11,consist:[2,3],file_:[10,6],highlight:9,similar:[1,2,3,5,7,8],clear:1,ck_user_name_len:2,reconcili:1,doesn:[1,3,4,5,6,8],repres:[2,3,5,6,9,11],"char":4,home:11,shopping_cart:1,sp_renam:3,implmeta:6,mock:6,draw:11,inspected_typ:6,remove_constraint:3,william:2,meaning:6,ago:11,land:3,lead:[7,1,3],algorithm:1,downgrade_token:6,d747a8a8879:1,far:[5,3],fresh:1,create_primary_kei:[2,3],code:[1,3,4,7,8,11],partial:[0,6,1],scratch:3,data_downgrad:9,schema_downgrad:9,procur:11,sensit:2,send:5,shoppingcart:1,aris:[5,3],sent:[6,3],connam:8,rollback:[10,4],whichev:1,truncate_slug_length:[6,11,3],releg:9,implicitli:3,dbname:[6,11],recip:9,complic:8,maarten:3,michael:3,sqllchemi:2,ryan:3,"try":[4,10,1,3],mergepoint:1,pleas:[1,3,4,5,6,11],impli:4,natur:[1,3],format_table_nam:6,focu:3,mysqldb:3,print_stdout:6,carlo:3,rivera:3,append:3,compat:[6,2,4,5,3],listen_for_reflect:5,compar:[6,4,3],resembl:3,dedup:3,access:[10,6,4,5,3],ck_sometable_q_bool:8,can:[1,2,3,4,5,6,8,9,10,11],antukh:3,implicit_bas:6,my_nam:4,len:2,intercept:[8,4],let:[8,1,11],ioerror:3,becom:[9,1],accessor:3,great:[1,3],mssqlimpl:6,ctx:2,migration_typ:4,earli:3,typic:[1,2,5,6,8,11],honor:3,chanc:6,add_constraint:6,apr:3,appli:[1,2,3,4,5,6,8,9,11],szotten:3,gatewai:5,"boolean":[8,2,5,3],fa4456a9201:1,tailor:[9,3],from:[4,6,1,5,3],"1975ea83b712":[10,1,11],upgrad:[1,2,3,4,5,6,8,9,10,11],next:[0,6,1,5,3],few:[4,1,5,11],reflectt:6,stage:6,sort:[1,3],src:3,create_index:[6,2,3],account:[1,2,3,4,10,11],retriev:[10,2,4,3],alia:1,crazi:1,cumbersom:4,proof:6,control:6,tar:7,process:[1,2,3,4,5,6,7,11],output_buff:[10,6],high:2,tag:[6,3],onlin:[6,10,2,5,3],serial:[10,3],parse_encod:3,sit:1,nvarchar:2,acycl:1,forest:1,instead:[1,3,4,5,6,10,9,11],chri:3,columndefault:6,overridden:[6,3],longdoc:6,philosophi:2,drop:[6,4],essenti:5,bind:[6,2],my_compare_typ:6,inspected_column:6,correspond:[2,5,3],element:[6,3],issu:[7,2,4,5,3],allow:[1,2,3,4,5,6,10,11],datefmt:11,depends_on:[6,1],move:[2,3,4,5,7,11],add_tabl:6,primarykeyconstraint:[8,2,4,3],perfect:4,disambigu:2,infrastructur:3,therefor:[2,5,3],greater:[2,1,3],python:[0,2,3,4,6,7,11],overal:3,dai:[11,3],mention:[8,1,2],overkil:9,front:[6,3],minimalist:11,somewher:4,anyth:[11,2],edit:[0,8,1,4],tran:4,frozenbal:3,februari:3,mode:6,mycustomtyp:4,compatib:3,upward:1,subset:6,meta:[8,5],"static":3,our:[0,1,2,4,5,8,9,10],patch:3,some_param:6,special:[1,2,3,4,5,6,8,11],out:[1,3,4,6,8,9,11],variabl:[6,2,4,11,3],"bo\u0142di":3,compare_typ:[6,4],req:3,rev:[1,3,6,10,9,11],stub:2,suitabl:[6,2,3],rel:[0,4,1,3],get_context:[6,2],defens:3,insid:[6,1,11,9,3],workflow:[1,5,3],manipul:6,standalon:[2,3],dictionari:[6,8,2,3],releas:[7,8,4,5,3],afterward:[5,3],indent:[6,3],guarante:1,unwant:[4,3],could:[4,1,11,3],pictur:6,put:1,keep:3,length:[6,4,5,11],enforc:5,outsid:[6,2,3],softwar:3,blown:[6,3],scene:[8,3],date:[4,1,3],priamri:2,existing_server_default:[6,2,3],defaultclaus:2,handler_consol:11,system:[6,2,1,5,3],messag:[6,4,11,9,3],attach:[6,4],my_column:4,upgrade_engine1:11,upgrade_engine2:11,"final":[6,5,3],"55af":1,juli:3,upgrade_token:6,minhe:3,accompani:[2,3],exactli:[6,2],mssql_drop_default:[2,3],compare_server_default:[6,4],prune:[9,11],structur:[1,2,3,5,6,11],charact:[6,2,11,3],myspecialcol:6,config_arg:[6,3],respons:6,deprec:[6,3],rcurrent:3,lightli:1,disadvantag:8,need:[1,2,3,4,5,6,7,8,9,10,11],turn:[6,2,1,5,3],automat:[1,2,3,4,5,11],"3ba2b522d10d":9,inform:[7,0,6,1,3],diverg:1,rout:6,accuraci:6,mix:3,best:[8,1],which:[1,2,3,4,5,6,8,9,10,11],discrep:1,my_compare_server_default:6,singl:[1,2,3,4,6,11],courtesi:3,unless:6,oracl:[8,6,3],pyo:[11,3],ck_:8,pyc:[11,3],"class":[6,10,2,11,3],url:[10,6,11],gather:[6,3],request:[6,11,9,3],uri:[11,3],face:6,pipe:3,determin:[10,6,4,11,3],ik_test:2,someth:[4,8,6,1,11],fact:[1,11],dba:[10,3],text:[6,2,3],verbos:[6,1,11,3],bring:1,trivial:3,anywai:11,ae1:[1,11],branch_label:[6,1,11],locat:[6,1,11,3],should:[1,2,3,4,5,6,7,9,11],jan:3,visit_column_typ:6,local:[10,6,3],hope:9,meant:1,genener:3,familiar:1,pypi:[7,3],autom:[8,2,5,3],made:[1,2,3,4,5,6,11],db1:10,db2:10,gilcreas:3,enabl:[6,10,2,5,3],organ:[10,2,1,3],dein:3,integr:[0,9,5,3],contain:[1,2,3,4,6,11],view:[4,1,3],legaci:3,knowledg:8,xxxxx:[1,11],accounts_t:2,statu:[4,1,3],aros:3,correctli:3,pattern:[5,3],formatter_gener:11,state:[6,1,5,11,2],bruno:3,kei:[6,4],file_config:6,appopri:8,job:[6,11],entir:[2,3,5,6,8,9,11],overhaul:3,addit:[1,2,3,4,6,7,9,11],instant:6,"3adcc9a56557_rename_username_field":11,version_loc:[6,1,11],equal:[1,2],configpars:11,etc:[6,2,3],instanc:[6,4,2],freeli:1,column_0_nam:[8,5],comment:[6,11,3],unimpl:3,no_paramet:3,johann:3,config_ini_sect:[6,4],quit:[8,9,1,5],tread:1,"290696571ad2":9,get_by_dialect:6,is_transactional_ddl:6,compos:11,compon:[11,3],new_table_nam:[6,2],besid:1,treat:[6,10,2,1,3],scriptabl:11,immedi:[2,3],create_unique_constraint:[8,2,3],mike:7,"109ec7d132bf_add_ip_number_t":1,presenc:9,bulk:[6,2,3],togeth:[6,1,11,2],specifc:1,present:[1,2,3,4,5,6,10,11],multi:[6,11],plain:4,"__pycache__":3,cursor:2,defin:[2,3,4,6,8,9],wilk:3,wild:1,observ:3,customiz:11,almost:[1,5,3],remove_t:6,revid:6,myengin:2,reflect_arg:[2,5,3],bigint:3,uq_:8,lightweight:0,branchpoint:[6,1],inspector:[6,5,3],account_t:2,nullpool:[6,3],unique_constraint:[6,3],welcom:3,parti:3,began:1,referenti:[5,3],cross:[1,3],member:3,handl:[6,2,3],difficult:3,http:[7,6,3],denot:[8,6],py3k:3,upon:[1,3,5,6,10,11],effect:[6,8,2,1,3],myspecialtyp:4,column_nam:[6,2],multiinsert:[6,2,3],expand:3,inspector_column:6,exceedingli:3,off:[1,2,3,4,5,6,10],center:4,well:[1,2,3,4,6,8,10,11],mysql_engin:3,argnam:2,theodor:3,runnier:6,exampl:[1,2,4,5,6,8,9,10,11],filesystem:[6,11],undefin:3,sibl:1,latest:7,less:[1,3],"2to3":3,begin_transact:6,marquard:3,mistaken:3,floer:3,simultan:[6,1,11],renam:[2,5,3],check_constraint:2,wed:3,nullabl:[2,3,4,5,6,11],test_autogener:3,smith:2,kamyshnikova:3,add:[1,2,3,4,5,6,7,8,9,10,11],lookup:3,logger:11,autogen_column_reflect:6,account_id:2,agnost:3,crud:2,from_config:6,revisionmap:6,know:[8,1,5,11],"3cac04ae8714_create_networking_branch":1,conrelid:8,python3:3,desc:3,insert:[1,2,3,5,6,10],template_arg:[6,3],like:[1,2,3,4,5,6,8,10,11],mssql_batch_separ:6,dropcolumn:6,necessari:[2,4,5,3],page:[7,0],revers:3,with_stat:3,proper:7,enviro:11,librari:[2,11,3],separ:[6,2,1,3],wendi:2,last_transaction_d:[10,4,11],encourag:[10,3],pg_constraint:8,"34e094ad6ef1_more_account_chang":1,usag:[0,2,3,5,6,7,8,11],host:[7,6,3],slug:[6,11,3],run_migr:[10,6,4,2],about:[1,3,6,7,8,11],actual:[1,2,3,4,6,10],column:[1,2,3,4,5,6,8,9,10,11],scott:[1,11],foreign_key_constraint:6,constructor:[6,4],disabl:[6,5,3],own:[4,8,2,1,3],uq_user_account_nam:8,create_t:[2,3,4,6,9,11],run_migrations_offlin:10,column_reflect:[6,4,5],merg:6,van:3,skip_autogener:6,unvers:11,transfer:5,downgrad:[0,1,2,3,4,6,10,9],pool:6,checkconstraint:[8,2,5,3],fk_user_order_id:8,keyerror:3,postgresqlimpl:[6,1],inlin:[2,3],bug:6,count:3,old_data:6,mysqlmodifycolumn:6,whether:[6,2],wish:[8,6,1],displai:[6,1,11],below:[10,6,5,3],limit:[4,6,1,3],otherwis:[6,8,2,3],problem:[5,3],evalu:3,dure:[6,2,11,3],twist:1,novemb:3,implement:[7,6,4,3],ini:[0,6,1,9,3],pip:7,probabl:[1,11,3],noufal:3,"53fffde5ad5":1,percent:3,other:[6,4],bool:2,futur:[6,3],rememb:8,varieti:[4,5,11,3],alembic_module_prefix:[6,3],test_render_fk_constraint_kwarg:3,oracle_batch_separ:6,data_upgrad:9,reliabl:4,sys_c0029334:8,columnnul:6,config_file_nam:[10,6],portion:6,decemb:3,invari:1},objtypes:{"0":"py:module","1":"py:attribute","2":"py:function","3":"py:method","4":"py:class","5":"py:classmethod"},objnames:{"0":["py","module","Python module"],"1":["py","attribute","Python attribute"],"2":["py","function","Python function"],"3":["py","method","Python method"],"4":["py","class","Python class"],"5":["py","classmethod","Python class method"]},filenames:["index","branches","ops","changelog","autogenerate","batch","api","front","naming","cookbook","offline","tutorial"],titles:["Welcome to Alembic’s documentation!","Working with Branches","Operation Reference","Changelog","Auto Generating Migrations","Running “Batch” Migrations for SQLite and Other Databases","API Details","Front Matter","The Importance of Naming Constraints","Cookbook","Generating SQL Scripts (a.k.a. “Offline Mode”)","Tutorial"],objects:{"alembic.script":{ScriptDirectory:[6,4,1,""],Script:[6,4,1,""]},"alembic.config.Config":{get_template_directory:[6,3,1,""],set_section_option:[6,3,1,""],get_section:[6,3,1,""],set_main_option:[6,3,1,""],get_main_option:[6,3,1,""],get_section_option:[6,3,1,""],cmd_opts:[6,1,1,""],print_stdout:[6,3,1,""],config_file_name:[6,1,1,""],config_ini_section:[6,1,1,""]},"alembic.autogenerate":{compare_metadata:[6,2,1,""]},"alembic.ddl.mssql":{visit_column_nullable:[6,2,1,""],visit_rename_table:[6,2,1,""],visit_column_default:[6,2,1,""],mssql_add_column:[6,2,1,""],MSSQLImpl:[6,4,1,""],visit_rename_column:[6,2,1,""],visit_add_column:[6,2,1,""],visit_column_type:[6,2,1,""]},"alembic.operations.BatchOperations":{create_index:[2,3,1,""],drop_index:[2,3,1,""],create_primary_key:[2,3,1,""],create_check_constraint:[2,3,1,""],alter_column:[2,3,1,""],drop_column:[2,3,1,""],drop_constraint:[2,3,1,""],create_foreign_key:[2,3,1,""],add_column:[2,3,1,""],create_unique_constraint:[2,3,1,""]},"alembic.operations.Operations":{create_index:[2,3,1,""],execute:[2,3,1,""],f:[2,3,1,""],drop_index:[2,3,1,""],create_primary_key:[2,3,1,""],create_check_constraint:[2,3,1,""],alter_column:[2,3,1,""],create_foreign_key:[2,3,1,""],batch_alter_table:[2,3,1,""],drop_column:[2,3,1,""],drop_constraint:[2,3,1,""],inline_literal:[2,3,1,""],drop_table:[2,3,1,""],create_table:[2,3,1,""],bulk_insert:[2,3,1,""],add_column:[2,3,1,""],get_context:[2,3,1,""],create_unique_constraint:[2,3,1,""],get_bind:[2,3,1,""],rename_table:[2,3,1,""]},"alembic.ddl.sqlite":{SQLiteImpl:[6,4,1,""]},"alembic.revision.RevisionMap":{get_revision:[6,3,1,""],get_revisions:[6,3,1,""],get_current_head:[6,3,1,""],iterate_revisions:[6,3,1,""],add_revision:[6,3,1,""]},"alembic.environment":{EnvironmentContext:[6,4,1,""]},"alembic.ddl.impl":{ImplMeta:[6,4,1,""],DefaultImpl:[6,4,1,""]},"alembic.ddl.postgresql.PostgresqlImpl":{correct_for_autogen_constraints:[6,3,1,""],transactional_ddl:[6,1,1,""],compare_server_default:[6,3,1,""],autogen_column_reflect:[6,3,1,""],prep_table_for_batch:[6,3,1,""]},"alembic.ddl":{sqlite:[6,0,0,"-"],postgresql:[6,0,0,"-"],base:[6,0,0,"-"],mysql:[6,0,0,"-"],mssql:[6,0,0,"-"],impl:[6,0,0,"-"]},"alembic.revision":{RevisionMap:[6,4,1,""],Revision:[6,4,1,""]},"alembic.command":{upgrade:[6,2,1,""],branches:[6,2,1,""],show:[6,2,1,""],stamp:[6,2,1,""],current:[6,2,1,""],merge:[6,2,1,""],init:[6,2,1,""],list_templates:[6,2,1,""],downgrade:[6,2,1,""],heads:[6,2,1,""],revision:[6,2,1,""],history:[6,2,1,""]},"alembic.migration.MigrationContext":{execute:[6,3,1,""],get_current_heads:[6,3,1,""],configure:[6,5,1,""],stamp:[6,3,1,""],bind:[6,1,1,""],run_migrations:[6,3,1,""],get_current_revision:[6,3,1,""],config:[6,1,1,""]},"alembic.ddl.mysql":{MySQLAlterDefault:[6,4,1,""],MySQLChangeColumn:[6,4,1,""],MySQLModifyColumn:[6,4,1,""],MySQLImpl:[6,4,1,""]},"alembic.config":{main:[6,2,1,""],Config:[6,4,1,""]},"alembic.script.ScriptDirectory":{get_revisions:[6,3,1,""],get_base:[6,3,1,""],generate_revision:[6,3,1,""],iterate_revisions:[6,3,1,""],run_env:[6,3,1,""],from_config:[6,5,1,""],get_bases:[6,3,1,""],get_revision:[6,3,1,""],as_revision_number:[6,3,1,""],get_current_head:[6,3,1,""],get_heads:[6,3,1,""],walk_revisions:[6,3,1,""]},"alembic.ddl.postgresql":{visit_rename_table:[6,2,1,""],PostgresqlImpl:[6,4,1,""]},"alembic.environment.EnvironmentContext":{execute:[6,3,1,""],get_revision_argument:[6,3,1,""],configure:[6,3,1,""],script:[6,1,1,""],begin_transaction:[6,3,1,""],is_transactional_ddl:[6,3,1,""],get_head_revisions:[6,3,1,""],get_x_argument:[6,3,1,""],get_head_revision:[6,3,1,""],run_migrations:[6,3,1,""],get_tag_argument:[6,3,1,""],is_offline_mode:[6,3,1,""],get_context:[6,3,1,""],config:[6,1,1,""],get_starting_revision_argument:[6,3,1,""],get_bind:[6,3,1,""],static_output:[6,3,1,""]},"alembic.operations":{Operations:[2,4,1,""],BatchOperations:[2,4,1,""]},"alembic.ddl.impl.DefaultImpl":{drop_index:[6,3,1,""],correct_for_autogen_constraints:[6,3,1,""],drop_table:[6,3,1,""],rename_table:[6,3,1,""],compare_type:[6,3,1,""],emit_commit:[6,3,1,""],get_by_dialect:[6,5,1,""],command_terminator:[6,1,1,""],prep_table_for_batch:[6,3,1,""],create_table:[6,3,1,""],bulk_insert:[6,3,1,""],add_column:[6,3,1,""],autogen_column_reflect:[6,3,1,""],static_output:[6,3,1,""],transactional_ddl:[6,1,1,""],alter_column:[6,3,1,""],requires_recreate_in_batch:[6,3,1,""],drop_column:[6,3,1,""],drop_constraint:[6,3,1,""],compare_server_default:[6,3,1,""],create_index:[6,3,1,""],execute:[6,3,1,""],bind:[6,1,1,""],start_migrations:[6,3,1,""],emit_begin:[6,3,1,""],add_constraint:[6,3,1,""]},"alembic.ddl.sqlite.SQLiteImpl":{transactional_ddl:[6,1,1,""],correct_for_autogen_constraints:[6,3,1,""],requires_recreate_in_batch:[6,3,1,""],drop_constraint:[6,3,1,""],compare_server_default:[6,3,1,""],add_constraint:[6,3,1,""]},"alembic.ddl.base":{ColumnNullable:[6,4,1,""],visit_column_default:[6,2,1,""],visit_column_nullable:[6,2,1,""],format_server_default:[6,2,1,""],visit_column_type:[6,2,1,""],RenameTable:[6,4,1,""],AddColumn:[6,4,1,""],alter_table:[6,2,1,""],format_type:[6,2,1,""],add_column:[6,2,1,""],ColumnDefault:[6,4,1,""],visit_drop_column:[6,2,1,""],format_column_name:[6,2,1,""],ColumnType:[6,4,1,""],visit_rename_table:[6,2,1,""],quote_dotted:[6,2,1,""],visit_add_column:[6,2,1,""],drop_column:[6,2,1,""],alter_column:[6,2,1,""],format_table_name:[6,2,1,""],visit_column_name:[6,2,1,""],AlterColumn:[6,4,1,""],DropColumn:[6,4,1,""],ColumnName:[6,4,1,""],AlterTable:[6,4,1,""]},"alembic.migration":{MigrationContext:[6,4,1,""]},"alembic.ddl.mysql.MySQLImpl":{correct_for_autogen_constraints:[6,3,1,""],alter_column:[6,3,1,""],transactional_ddl:[6,1,1,""],compare_server_default:[6,3,1,""]},"alembic.revision.Revision":{nextrev:[6,1,1,""],revision:[6,1,1,""],is_head:[6,1,1,""],down_revision:[6,1,1,""],is_branch_point:[6,1,1,""],dependencies:[6,1,1,""],is_merge_point:[6,1,1,""],branch_labels:[6,1,1,""],is_base:[6,1,1,""]},"alembic.ddl.mssql.MSSQLImpl":{alter_column:[6,3,1,""],transactional_ddl:[6,1,1,""],emit_commit:[6,3,1,""],batch_separator:[6,1,1,""],drop_column:[6,3,1,""],emit_begin:[6,3,1,""],bulk_insert:[6,3,1,""]},"alembic.script.Script":{doc:[6,1,1,""],longdoc:[6,1,1,""],module:[6,1,1,""],path:[6,1,1,""]},alembic:{operations:[2,0,0,"-"],script:[6,0,0,"-"],environment:[6,0,0,"-"],command:[6,0,0,"-"],migration:[6,0,0,"-"],ddl:[6,0,0,"-"],config:[6,0,0,"-"],revision:[6,0,0,"-"]}},titleterms:{all:1,partial:11,scratch:9,syntax:1,prefix:4,mysql:6,identifi:11,depend:[7,1],configur:6,bug:[7,3],overview:6,get:[10,11],auto:4,offlin:[10,5],mechan:1,condit:9,front:7,affect:4,name:[8,5],specif:1,changelog:3,edit:11,drop:5,integr:8,second:11,refer:[1,2],view:11,set:1,deal:5,batch:5,intern:6,themselv:4,what:4,detect:4,databas:[9,5],label:1,version:[10,1],rel:11,ddl:6,"import":8,mode:[10,5],run:[1,5,11],kei:5,migrat:[4,5,6,10,9,11],autogener:[8,6,4,5],gener:[10,4],step:11,base:1,postgresql:6,constraint:[8,5],unnam:5,script:[10,6,11],foreign:5,tutori:11,context:6,alemb:0,chang:3,first:11,oper:[8,6,2],rang:11,render:4,onc:1,modul:4,misc:3,api:6,instal:7,custom:10,merg:1,from:9,convent:8,commun:7,support:10,next:11,start:10,downgrad:11,includ:5,type:4,more:1,head:1,than:5,work:[1,5],uniqu:5,histori:11,project:7,matter:7,control:[4,5],sqlite:[6,5],featur:3,creat:[1,11],indic:0,ini:11,file:11,tabl:[0,5],revis:[6,1,11],element:9,check:5,multipl:1,welcom:0,detail:6,write:10,other:5,build:9,branch:1,command:6,document:0,referenc:5,our:11,object:6,statu:7,reflect:5,sql:[10,6],date:9,homepag:7,directori:[6,1],explicit:1,doe:4,inform:11,environ:[10,6,11],cookbook:9}}) \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/docs/tutorial.html new/alembic-0.7.4/docs/tutorial.html --- old/alembic-0.7.3/docs/tutorial.html 2014-12-30 18:15:10.000000000 +0100 +++ new/alembic-0.7.4/docs/tutorial.html 2015-01-12 20:17:11.000000000 +0100 @@ -6,7 +6,7 @@ <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>Tutorial — Alembic 0.7.3 documentation</title> + <title>Tutorial — Alembic 0.7.4 documentation</title> <link rel="stylesheet" href="_static/nature_override.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> @@ -16,7 +16,7 @@ <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', - VERSION: '0.7.3', + VERSION: '0.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true @@ -25,7 +25,7 @@ <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> - <link rel="top" title="Alembic 0.7.3 documentation" href="index.html" /> + <link rel="top" title="Alembic 0.7.4 documentation" href="index.html" /> <link rel="next" title="Auto Generating Migrations" href="autogenerate.html" /> <link rel="prev" title="Front Matter" href="front.html" /> </head> @@ -45,7 +45,7 @@ <li class="right" > <a href="front.html" title="Front Matter" accesskey="P">previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> @@ -649,11 +649,11 @@ <li class="right" > <a href="front.html" title="Front Matter" >previous</a> |</li> - <li><a href="index.html">Alembic 0.7.3 documentation</a> »</li> + <li><a href="index.html">Alembic 0.7.4 documentation</a> »</li> </ul> </div> <div class="footer"> - © Copyright 2010-2014, Mike Bayer. + © Copyright 2010-2015, Mike Bayer. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.2.3. </div> </body> diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/tests/test_autogen_fks.py new/alembic-0.7.4/tests/test_autogen_fks.py --- old/alembic-0.7.3/tests/test_autogen_fks.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/tests/test_autogen_fks.py 2015-01-12 20:14:18.000000000 +0100 @@ -13,7 +13,7 @@ class AutogenerateForeignKeysTest(AutogenFixtureTest, TestBase): __backend__ = True - def test_added_fk(self): + def test_remove_fk(self): m1 = MetaData() m2 = MetaData() @@ -50,7 +50,7 @@ conditional_name="servergenerated" ) - def test_removed_fk(self): + def test_add_fk(self): m1 = MetaData() m2 = MetaData() @@ -160,14 +160,13 @@ eq_(diffs, []) - def test_removed_composite_fk_with_name(self): + def test_add_composite_fk_with_name(self): m1 = MetaData() m2 = MetaData() Table('table', m1, - Column('id', Integer, primary_key=True), - Column('id_1', String(10)), - Column('id_2', String(10)), + Column('id_1', String(10), primary_key=True), + Column('id_2', String(10), primary_key=True), mysql_engine='InnoDB') Table('user', m1, @@ -179,9 +178,8 @@ mysql_engine='InnoDB') Table('table', m2, - Column('id', Integer, primary_key=True), - Column('id_1', String(10)), - Column('id_2', String(10)), + Column('id_1', String(10), primary_key=True), + Column('id_2', String(10), primary_key=True), mysql_engine='InnoDB') Table('user', m2, @@ -204,7 +202,7 @@ name="fk_test_name" ) - def test_added_composite_fk(self): + def test_remove_composite_fk(self): m1 = MetaData() m2 = MetaData() @@ -246,6 +244,78 @@ conditional_name="fk_test_name" ) + def test_add_fk_colkeys(self): + m1 = MetaData() + m2 = MetaData() + + Table('table', m1, + Column('id_1', String(10), primary_key=True), + Column('id_2', String(10), primary_key=True), + mysql_engine='InnoDB') + + Table('user', m1, + Column('id', Integer, primary_key=True), + Column('other_id_1', String(10)), + Column('other_id_2', String(10)), + mysql_engine='InnoDB') + + Table('table', m2, + Column('id_1', String(10), key='tid1', primary_key=True), + Column('id_2', String(10), key='tid2', primary_key=True), + mysql_engine='InnoDB') + + Table('user', m2, + Column('id', Integer, primary_key=True), + Column('other_id_1', String(10), key='oid1'), + Column('other_id_2', String(10), key='oid2'), + ForeignKeyConstraint(['oid1', 'oid2'], + ['table.tid1', 'table.tid2'], + name='fk_test_name'), + mysql_engine='InnoDB') + + diffs = self._fixture(m1, m2) + + self._assert_fk_diff( + diffs[0], "add_fk", + "user", ['other_id_1', 'other_id_2'], + 'table', ['id_1', 'id_2'], + name="fk_test_name" + ) + + def test_no_change_colkeys(self): + m1 = MetaData() + m2 = MetaData() + + Table('table', m1, + Column('id_1', String(10), primary_key=True), + Column('id_2', String(10), primary_key=True), + mysql_engine='InnoDB') + + Table('user', m1, + Column('id', Integer, primary_key=True), + Column('other_id_1', String(10)), + Column('other_id_2', String(10)), + ForeignKeyConstraint(['other_id_1', 'other_id_2'], + ['table.id_1', 'table.id_2']), + mysql_engine='InnoDB') + + Table('table', m2, + Column('id_1', String(10), key='tid1', primary_key=True), + Column('id_2', String(10), key='tid2', primary_key=True), + mysql_engine='InnoDB') + + Table('user', m2, + Column('id', Integer, primary_key=True), + Column('other_id_1', String(10), key='oid1'), + Column('other_id_2', String(10), key='oid2'), + ForeignKeyConstraint(['oid1', 'oid2'], + ['table.tid1', 'table.tid2']), + mysql_engine='InnoDB') + + diffs = self._fixture(m1, m2) + + eq_(diffs, []) + class IncludeHooksTest(AutogenFixtureTest, TestBase): __backend__ = True diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/tests/test_autogen_indexes.py new/alembic-0.7.4/tests/test_autogen_indexes.py --- old/alembic-0.7.3/tests/test_autogen_indexes.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/tests/test_autogen_indexes.py 2015-01-12 20:14:18.000000000 +0100 @@ -258,6 +258,40 @@ diffs = self._fixture(m1, m2) eq_(diffs, []) + def test_nothing_changed_unique_w_colkeys(self): + m1 = MetaData() + m2 = MetaData() + + Table('nothing_changed', m1, + Column('x', String(20), key='nx'), + UniqueConstraint('nx') + ) + + Table('nothing_changed', m2, + Column('x', String(20), key='nx'), + UniqueConstraint('nx') + ) + + diffs = self._fixture(m1, m2) + eq_(diffs, []) + + def test_nothing_changed_index_w_colkeys(self): + m1 = MetaData() + m2 = MetaData() + + Table('nothing_changed', m1, + Column('x', String(20), key='nx'), + Index('foobar', 'nx') + ) + + Table('nothing_changed', m2, + Column('x', String(20), key='nx'), + Index('foobar', 'nx') + ) + + diffs = self._fixture(m1, m2) + eq_(diffs, []) + def test_nothing_changed_index_named_as_column(self): m1 = MetaData() m2 = MetaData() diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/tests/test_autogen_render.py new/alembic-0.7.4/tests/test_autogen_render.py --- old/alembic-0.7.3/tests/test_autogen_render.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/tests/test_autogen_render.py 2015-01-12 20:14:18.000000000 +0100 @@ -9,6 +9,7 @@ PrimaryKeyConstraint, Index, func, text, DefaultClause from sqlalchemy.types import TIMESTAMP +from sqlalchemy.types import UserDefinedType from sqlalchemy.dialects import mysql, postgresql from sqlalchemy.engine.default import DefaultDialect from sqlalchemy.sql import and_, column, literal_column, false @@ -18,6 +19,9 @@ from alembic import autogenerate, util, compat from alembic.testing import eq_, eq_ignore_whitespace, config +from alembic.testing.fixtures import op_fixture +from alembic import op # noqa +import sqlalchemy as sa # noqa py3k = sys.version_info >= (3, ) @@ -265,6 +269,64 @@ "op.create_foreign_key('fk_a_id', 'b', 'a', ['a_id'], ['id'])" ) + def test_add_fk_constraint_inline_colkeys(self): + m = MetaData() + Table('a', m, Column('id', Integer, key='aid', primary_key=True)) + b = Table( + 'b', m, + Column('a_id', Integer, ForeignKey('a.aid'), key='baid')) + + py_code = autogenerate.render._add_table(b, self.autogen_context) + + eq_ignore_whitespace( + py_code, + "op.create_table('b'," + "sa.Column('a_id', sa.Integer(), nullable=True)," + "sa.ForeignKeyConstraint(['a_id'], ['a.id'], ))" + ) + + context = op_fixture() + eval(py_code) + context.assert_( + "CREATE TABLE b (a_id INTEGER, " + "FOREIGN KEY(a_id) REFERENCES a (id))") + + def test_add_fk_constraint_separate_colkeys(self): + m = MetaData() + Table('a', m, Column('id', Integer, key='aid', primary_key=True)) + b = Table('b', m, Column('a_id', Integer, key='baid')) + fk = ForeignKeyConstraint(['baid'], ['a.aid'], name='fk_a_id') + b.append_constraint(fk) + + py_code = autogenerate.render._add_table(b, self.autogen_context) + + eq_ignore_whitespace( + py_code, + "op.create_table('b'," + "sa.Column('a_id', sa.Integer(), nullable=True)," + "sa.ForeignKeyConstraint(['a_id'], ['a.id'], name='fk_a_id'))" + ) + + context = op_fixture() + eval(py_code) + context.assert_( + "CREATE TABLE b (a_id INTEGER, CONSTRAINT " + "fk_a_id FOREIGN KEY(a_id) REFERENCES a (id))") + + context = op_fixture() + py_code = autogenerate.render._add_fk_constraint( + fk, self.autogen_context) + + eq_ignore_whitespace( + autogenerate.render._add_fk_constraint(fk, self.autogen_context), + "op.create_foreign_key('fk_a_id', 'b', 'a', ['a_id'], ['id'])" + ) + + eval(py_code) + context.assert_( + "ALTER TABLE b ADD CONSTRAINT fk_a_id " + "FOREIGN KEY(a_id) REFERENCES a (id)") + def test_add_fk_constraint_schema(self): m = MetaData() Table( @@ -877,6 +939,15 @@ "sa.Enum('one', 'two', 'three')" ) + @config.requirements.fail_before_sqla_099 + def test_render_non_native_enum(self): + eq_ignore_whitespace( + autogenerate.render._repr_type( + Enum("one", "two", "three", native_enum=False), + self.autogen_context), + "sa.Enum('one', 'two', 'three', native_enum=False)" + ) + def test_repr_plain_sqla_type(self): type_ = Integer() autogen_context = { @@ -892,9 +963,29 @@ "sa.Integer()" ) - def test_repr_user_type_user_prefix_None(self): - from sqlalchemy.types import UserDefinedType + def test_repr_custom_type_w_sqla_prefix(self): + autogen_context = { + 'opts': { + 'sqlalchemy_module_prefix': 'sa.', + 'alembic_module_prefix': 'op.', + 'user_module_prefix': None + }, + 'dialect': mysql.dialect() + } + + class MyType(UserDefinedType): + pass + + MyType.__module__ = "sqlalchemy_util.types" + + type_ = MyType() + eq_ignore_whitespace( + autogenerate.render._repr_type(type_, autogen_context), + "sqlalchemy_util.types.MyType()" + ) + + def test_repr_user_type_user_prefix_None(self): class MyType(UserDefinedType): def get_col_spec(self): diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/alembic-0.7.3/tests/test_postgresql.py new/alembic-0.7.4/tests/test_postgresql.py --- old/alembic-0.7.3/tests/test_postgresql.py 2014-12-30 18:13:36.000000000 +0100 +++ new/alembic-0.7.4/tests/test_postgresql.py 2015-01-12 20:14:18.000000000 +0100 @@ -1,6 +1,6 @@ from sqlalchemy import DateTime, MetaData, Table, Column, text, Integer, \ - String, Interval, Sequence, Numeric, BigInteger + String, Interval, Sequence, Numeric, BigInteger, Float, Numeric from sqlalchemy.dialects.postgresql import ARRAY from sqlalchemy.engine.reflection import Inspector from alembic.operations import Operations @@ -193,8 +193,11 @@ def tearDown(self): self.metadata.drop_all() - def _compare_default_roundtrip(self, type_, orig_default, alternate=None): - diff_expected = alternate is not None + def _compare_default_roundtrip( + self, type_, orig_default, alternate=None, diff_expected=None): + diff_expected = diff_expected \ + if diff_expected is not None \ + else alternate is not None if alternate is None: alternate = orig_default @@ -274,6 +277,67 @@ text("5"), "7" ) + def test_compare_float_str(self): + self._compare_default_roundtrip( + Float(), + "5.2", + ) + + def test_compare_float_text(self): + self._compare_default_roundtrip( + Float(), + text("5.2"), + ) + + def test_compare_float_no_diff1(self): + self._compare_default_roundtrip( + Float(), + text("5.2"), "5.2", + diff_expected=False + ) + + def test_compare_float_no_diff2(self): + self._compare_default_roundtrip( + Float(), + "5.2", text("5.2"), + diff_expected=False + ) + + def test_compare_float_no_diff3(self): + self._compare_default_roundtrip( + Float(), + text("5"), text("5.0"), + diff_expected=False + ) + + def test_compare_float_no_diff4(self): + self._compare_default_roundtrip( + Float(), + "5", "5.0", + diff_expected=False + ) + + def test_compare_float_no_diff5(self): + self._compare_default_roundtrip( + Float(), + text("5"), "5.0", + diff_expected=False + ) + + def test_compare_float_no_diff6(self): + self._compare_default_roundtrip( + Float(), + "5", text("5.0"), + diff_expected=False + ) + + def test_compare_numeric_no_diff(self): + self._compare_default_roundtrip( + Numeric(), + text("5"), "5.0", + diff_expected=False + ) + def test_compare_character_str(self): self._compare_default_roundtrip( String(), -- To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-commit+help@opensuse.org