1
# Copyright 2012 OpenStack LLC.
3
# Licensed under the Apache License, Version 2.0 (the "License"); you may
4
# not use this file except in compliance with the License. You may obtain
5
# a copy of the License at
7
# http://www.apache.org/licenses/LICENSE-2.0
9
# Unless required by applicable law or agreed to in writing, software
10
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
11
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
12
# License for the specific language governing permissions and limitations
15
from sqlalchemy import Boolean, Column
16
from sqlalchemy import Integer, MetaData, String
17
from sqlalchemy import Table
20
def upgrade(migrate_engine):
22
meta.bind = migrate_engine
24
zones = Table('zones', meta, autoload=True)
26
is_parent = Column('is_parent', Boolean(), default=False)
27
rpc_host = Column('rpc_host', String(255))
28
rpc_port = Column('rpc_port', Integer())
29
rpc_virtual_host = Column('rpc_virtual_host', String(255))
31
zones.create_column(is_parent)
32
zones.create_column(rpc_host)
33
zones.create_column(rpc_port)
34
zones.create_column(rpc_virtual_host)
37
def downgrade(migrate_engine):
39
meta.bind = migrate_engine
41
zones = Table('zones', meta, autoload=True)
43
zones.drop_column('rpc_virtual_host')
44
zones.drop_column('rpc_port')
45
zones.drop_column('rpc_host')
46
zones.drop_column('is_parent')