summaryrefslogtreecommitdiff
path: root/designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py
diff options
context:
space:
mode:
Diffstat (limited to 'designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py')
-rw-r--r--designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py76
1 files changed, 0 insertions, 76 deletions
diff --git a/designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py b/designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py
deleted file mode 100644
index 772a9283..00000000
--- a/designate/pool_manager/cache/impl_sqlalchemy/migrate_repo/versions/001_add_pool_manager_status.py
+++ /dev/null
@@ -1,76 +0,0 @@
-# Copyright 2014 eBay Inc.
-#
-# Author: Ron Rickard <rrickard@ebaysf.com>
-#
-# Licensed under the Apache License, Version 2.0 (the "License"); you may
-# not use this file except in compliance with the License. You may obtain
-# a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
-# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
-# License for the specific language governing permissions and limitations
-# under the License.
-from sqlalchemy import Integer, DateTime, Enum, UniqueConstraint
-from sqlalchemy.schema import Table, Column, MetaData
-
-from designate.sqlalchemy.types import UUID
-
-UPDATE_STATUSES = ['SUCCESS', 'ERROR']
-UPDATE_ACTIONS = ['CREATE', 'DELETE', 'UPDATE']
-
-meta = MetaData()
-
-pool_manager_statuses = Table(
- 'pool_manager_statuses', meta,
- Column('id', UUID(), primary_key=True),
- Column('version', Integer(), nullable=False),
- Column('created_at', DateTime()),
- Column('updated_at', DateTime()),
- Column('server_id', UUID(), nullable=False),
- Column('domain_id', UUID(), nullable=False),
- Column('action', Enum(name='update_actions', *UPDATE_ACTIONS),
- nullable=False),
- Column('status', Enum(name='update_statuses', *UPDATE_STATUSES),
- nullable=True),
- Column('serial_number', Integer, nullable=False),
-
- UniqueConstraint('server_id', 'domain_id', 'action',
- name='unique_pool_manager_status'),
-
- mysql_engine='InnoDB',
- mysql_charset='utf8')
-
-
-def upgrade(migrate_engine):
- meta.bind = migrate_engine
-
- with migrate_engine.begin() as conn:
- if migrate_engine.name == "mysql":
- conn.execute("SET foreign_key_checks = 0;")
-
- elif migrate_engine.name == "postgresql":
- conn.execute("SET CONSTRAINTS ALL DEFERRED;")
-
- pool_manager_statuses.create(conn)
-
- if migrate_engine.name == "mysql":
- conn.execute("SET foreign_key_checks = 1;")
-
-
-def downgrade(migrate_engine):
- meta.bind = migrate_engine
-
- with migrate_engine.begin() as conn:
- if migrate_engine.name == "mysql":
- conn.execute("SET foreign_key_checks = 0;")
-
- elif migrate_engine.name == "postgresql":
- conn.execute("SET CONSTRAINTS ALL DEFERRED;")
-
- pool_manager_statuses.drop()
-
- if migrate_engine.name == "mysql":
- conn.execute("SET foreign_key_checks = 1;")