1
# vim: tabstop=4 shiftwidth=4 softtabstop=4
3
# Copyright 2011 OpenStack LLC.
5
# Licensed under the Apache License, Version 2.0 (the "License"); you may
6
# not use this file except in compliance with the License. You may obtain
7
# a copy of the License at
9
# http://www.apache.org/licenses/LICENSE-2.0
11
# Unless required by applicable law or agreed to in writing, software
12
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
13
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
14
# License for the specific language governing permissions and limitations
17
from sqlalchemy import MetaData
20
def upgrade(migrate_engine):
21
# Upgrade operations go here. Don't create your own engine;
22
# bind migrate_engine to your metadata
24
tables = ["agent_builds", "aggregate_hosts", "aggregate_metadata",
25
"aggregates", "block_device_mapping", "bw_usage_cache",
26
"dns_domains", "instance_faults", "instance_type_extra_specs",
27
"provider_fw_rules", "quota_classes", "s3_images",
28
"sm_backend_config", "sm_flavors", "sm_volume",
29
"virtual_storage_arrays", "volume_metadata",
30
"volume_type_extra_specs", "volume_types"]
33
meta.bind = migrate_engine
34
if migrate_engine.name == "mysql":
35
d = migrate_engine.execute("SHOW TABLE STATUS WHERE Engine!='InnoDB';")
36
for row in d.fetchall():
38
if table_name in tables:
39
migrate_engine.execute("ALTER TABLE %s Engine=InnoDB" %
43
def downgrade(migrate_engine):