~ubuntu-branches/ubuntu/trusty/cinder/trusty

« back to all changes in this revision

Viewing changes to cinder/db/sqlalchemy/migrate_repo/versions/086_set_engine_mysql_innodb.py

• browse files at revision 1
• compare with another revision
• download diff
• download tarball
• view history from revision 1

Show diffs side-by-side

added

removed

cinder/db/sqlalchemy/migrate_repo/versions/086_set_engine_mysql_innodb.py

 

1

# vim: tabstop=4 shiftwidth=4 softtabstop=4

 

2

 

 

3

# Copyright 2011 OpenStack LLC.

 

4

#

 

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

 

8

#

 

9

#         http://www.apache.org/licenses/LICENSE-2.0

 

10

#

 

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

 

15

#    under the License.

 

16

 

 

17

from sqlalchemy import MetaData

 

18

 

 

19

 

 

20

def upgrade(migrate_engine):

 

21

    # Upgrade operations go here. Don't create your own engine;

 

22

    # bind migrate_engine to your metadata

 

23

 

 

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"]

 

31

 

 

32

    meta = MetaData()

 

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():

 

37

            table_name = row[0]

 

38

            if table_name in tables:

 

39

                migrate_engine.execute("ALTER TABLE %s Engine=InnoDB" %

 

40

                                       table_name)

 

41

 

 

42

 

 

43

def downgrade(migrate_engine):

 

44

    pass

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1