Changes between Version 2 and Version 3 of Recipes/SQLAlchemySchemaMigration

Timestamp:

12/05/10 01:13:51 (2 years ago)

Author:

guest (IP: 78.232.186.148)

Comment:

--

Recipes/SQLAlchemySchemaMigration

@@ -58 +58 @@
 options_defaults["tablename"] = lambda cls: "my_prefix_%s" % cls.__name__.lower()
 }}}
+
+== With migrate v0.6 ==
+
+Since v0.6, upgrade and downgrade functions receive the engine as a parameter.
+
+{{{
+from sqlalchemy import *
+from migrate import *
+from elixir import *
+
+__metadata__ = MetaData()
+
+
+class Foo(Entity):
+    using_options(tablename='foo')
+
+setup_all()
+    
+
+def upgrade(migrate_engine):
+    # Upgrade operations go here. Don't create your own engine; use the engine
+    # named 'migrate_engine' imported from migrate.
+    __metadata__.bind = migrate_engine
+    Foo.table.create()
+def downgrade(migrate_engine):
+    # Operations to reverse the above upgrade go here.
+    __metadata__.bind = migrate_engine
+    Foo.table.drop()
+}}}