summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2014-11-20 18:33:07 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2014-11-20 18:33:07 -0500
commit1b7ffaa175775bb7d24b95fb39f7c3c052c23127 (patch)
tree8288d281a7e1bf21694d6842e0a17df74d64009a
parent5c747a068b539cec9dd88836427f57352f3f0735 (diff)
downloadalembic-1b7ffaa175775bb7d24b95fb39f7c3c052c23127.tar.gz
put the sqlite thing near the top as it's the other big feature
-rw-r--r--docs/build/changelog.rst60
1 files changed, 30 insertions, 30 deletions
diff --git a/docs/build/changelog.rst b/docs/build/changelog.rst
index 9001333..3cc3026 100644
--- a/docs/build/changelog.rst
+++ b/docs/build/changelog.rst
@@ -27,6 +27,36 @@ Changelog
:ref:`branches`
.. change::
+ :tags: feature, operations, sqlite
+ :tickets: 21
+
+ Added "move and copy" workflow, where a table to be altered is copied to
+ a new one with the new structure and the old one dropped, is now
+ implemented for SQLite as well as all database backends in general
+ using the new :meth:`.Operations.batch_alter_table` system. This
+ directive provides a table-specific operations context which gathers
+ column- and constraint-level mutations specific to that table, and
+ at the end of the context creates a new table combining the structure
+ of the old one with the given changes, copies data from old table to new,
+ and finally drops the old table,
+ renaming the new one to the existing name. This is required for
+ fully featured SQLite migrations, as SQLite has very little support for the
+ traditional ALTER directive. The batch directive
+ is intended to produce code that is still compatible with other databases,
+ in that the "move and copy" process only occurs for SQLite by default,
+ while still providing some level of sanity to SQLite's
+ requirement by allowing multiple table mutation operations to
+ proceed within one "move and copy" as well as providing explicit
+ control over when this operation actually occurs. The "move and copy"
+ feature may be optionally applied to other backends as well, however
+ dealing with referential integrity constraints from other tables must
+ still be handled explicitly.
+
+ .. seealso::
+
+ :ref:`batch_migrations`
+
+ .. change::
:tags: feature, commands
New commands added: ``alembic show``, ``alembic heads`` and
@@ -87,36 +117,6 @@ Changelog
Pull request courtesy David Szotten.
.. change::
- :tags: feature, operations, sqlite
- :tickets: 21
-
- Added "move and copy" workflow, where a table to be altered is copied to
- a new one with the new structure and the old one dropped, is now
- implemented for SQLite as well as all database backends in general
- using the new :meth:`.Operations.batch_alter_table` system. This
- directive provides a table-specific operations context which gathers
- column- and constraint-level mutations specific to that table, and
- at the end of the context creates a new table combining the structure
- of the old one with the given changes, copies data from old table to new,
- and finally drops the old table,
- renaming the new one to the existing name. This is required for
- fully featured SQLite migrations, as SQLite has very little support for the
- traditional ALTER directive. The batch directive
- is intended to produce code that is still compatible with other databases,
- in that the "move and copy" process only occurs for SQLite by default,
- while still providing some level of sanity to SQLite's
- requirement by allowing multiple table mutation operations to
- proceed within one "move and copy" as well as providing explicit
- control over when this operation actually occurs. The "move and copy"
- feature may be optionally applied to other backends as well, however
- dealing with referential integrity constraints from other tables must
- still be handled explicitly.
-
- .. seealso::
-
- :ref:`batch_migrations`
-
- .. change::
:tags: feature, operations
:tickets: 205