summaryrefslogtreecommitdiff
path: root/heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py
diff options
context:
space:
mode:
Diffstat (limited to 'heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py')
-rw-r--r--heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py49
1 files changed, 0 insertions, 49 deletions
diff --git a/heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py b/heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py
deleted file mode 100644
index 8b485460b..000000000
--- a/heat/db/sqlalchemy/migrate_repo/versions/009_remove_parsed_template.py
+++ /dev/null
@@ -1,49 +0,0 @@
-from sqlalchemy import *
-from migrate import *
-
-
-def upgrade(migrate_engine):
- meta = MetaData(bind=migrate_engine)
-
- def fk_name(table, ref_column):
- for fk in table.foreign_keys:
- if fk.column == ref_column:
- return fk.name
-
- resource = Table('resource', meta, autoload=True)
- parsed_template = Table('parsed_template', meta, autoload=True)
-
- res_kc = ForeignKeyConstraint([resource.c.parsed_template_id],
- [parsed_template.c.id],
- name=fk_name(resource,
- parsed_template.c.id))
- try:
- res_kc.drop()
- except NotSupportedError:
- # SQLite (used in unit tests) cannot drop a Foreign Key constraint
- pass
-
- resource.c.parsed_template_id.drop()
-
- parsed_template.drop()
-
-
-def downgrade(migrate_engine):
- meta = MetaData(bind=migrate_engine)
-
- raw_template = Table('raw_template', meta, autoload=True)
-
- parsed_template = Table(
- 'parsed_template', meta,
- Column('id', Integer, primary_key=True),
- Column('created_at', DateTime(timezone=False)),
- Column('updated_at', DateTime(timezone=False)),
- Column('raw_template_id', Integer, ForeignKey("raw_template.id"),
- nullable=False),
- Column('template', Text())
- )
- parsed_template.create()
-
- resource = Table('resource', meta, autoload=True)
- Column('parsed_template_id', Integer, ForeignKey('parsed_template.id'),
- nullable=True).create(resource)