authorities can also have a 'name' for standalone deployments

[sfa.git] / sfa / storage / migrations / versions / 004_authority_name.py

diff --git a/sfa/storage/migrations/versions/004_authority_name.py b/sfa/storage/migrations/versions/004_authority_name.py
new file mode 100644 (file)
index 0000000..55ed1ef
--- /dev/null
+++ b/sfa/storage/migrations/versions/004_authority_name.py
@@ -0,0 +1,17 @@
+# this move is about adding a 'name' column in the 'authority' table
+
+#from sfa.util.sfalogging import logger
+
+from sqlalchemy import MetaData, Table, Column, String
+from migrate.changeset.schema import create_column, drop_column
+
+def upgrade(migrate_engine):
+    metadata = MetaData(bind = migrate_engine)
+    authorities = Table('authorities', metadata, autoload=True)
+    name_column = Column('name', String)
+    name_column.create(authorities)
+
+def downgrade(migrate_engine):
+    metadata = MetaData(bind = migrate_engine)
+    authorities = Table('authorities', metadata, autoload=True)
+    authorities.c.name.drop()