← Back to branch summary

~ubuntu-branches/ubuntu/saucy/nova/saucy-proposed

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/017_make_instance_type_id_an_integer.py

  • Committer: Package Import Robot
  • Author(s): Chuck Short
  • Date: 2012-05-24 13:12:53 UTC
  • mfrom: (1.1.55)
  • Revision ID: package-import@ubuntu.com-20120524131253-ommql08fg1en06ut
Tags: 2012.2~f1-0ubuntu1
https://launchpad.net/bugs/907197
* New upstream release.
* Prepare for quantal:
  - Dropped debian/patches/upstream/0006-Use-project_id-in-ec2.cloud._format_image.patch
  - Dropped debian/patches/upstream/0005-Populate-image-properties-with-project_id-again.patch
  - Dropped debian/patches/upstream/0004-Fixed-bug-962840-added-a-test-case.patch
  - Dropped debian/patches/upstream/0003-Allow-unprivileged-RADOS-users-to-access-rbd-volumes.patch
  - Dropped debian/patches/upstream/0002-Stop-libvirt-test-from-deleting-instances-dir.patch
  - Dropped debian/patches/upstream/0001-fix-bug-where-nova-ignores-glance-host-in-imageref.patch 
  - Dropped debian/patches/0001-fix-useexisting-deprecation-warnings.patch
* debian/control: Add python-keystone as a dependency. (LP: #907197)
* debian/patches/kombu_tests_timeout.patch: Refreshed.
* debian/nova.conf, debian/nova-common.postinst: Convert to new ini
  file configuration
* debian/patches/nova-manage_flagfile_location.patch: Refreshed

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/017_make_instance_type_id_an_integer.py
1
 
# vim: tabstop=4 shiftwidth=4 softtabstop=4
2
 
 
3
 
# Copyright 2012 OpenStack LLC.
4
 
# All Rights Reserved.
5
 
#
6
 
#    Licensed under the Apache License, Version 2.0 (the "License"); you may
7
 
#    not use this file except in compliance with the License. You may obtain
8
 
#    a copy of the License at
9
 
#
10
 
#         http://www.apache.org/licenses/LICENSE-2.0
11
 
#
12
 
#    Unless required by applicable law or agreed to in writing, software
13
 
#    distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
14
 
#    WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
15
 
#    License for the specific language governing permissions and limitations
16
 
#    under the License.
17
 
 
18
 
from sqlalchemy import Column, Integer, MetaData, String, Table
19
 
from nova import log as logging
20
 
 
21
 
LOG = logging.getLogger(__name__)
22
 
 
23
 
 
24
 
def upgrade(migrate_engine):
25
 
    meta = MetaData()
26
 
    meta.bind = migrate_engine
27
 
 
28
 
    instances = Table('instances', meta, autoload=True)
29
 
 
30
 
    types = {}
31
 
    for instance in migrate_engine.execute(instances.select()):
32
 
        if instance.instance_type_id is None:
33
 
            types[instance.id] = None
34
 
            continue
35
 
        try:
36
 
            types[instance.id] = int(instance.instance_type_id)
37
 
        except ValueError:
38
 
            LOG.warn("Instance %s did not have instance_type_id "
39
 
                         "converted to an integer because its value is %s" %
40
 
                          (instance.id, instance.instance_type_id))
41
 
            types[instance.id] = None
42
 
 
43
 
    integer_column = Column('instance_type_id_int', Integer(), nullable=True)
44
 
    string_column = instances.c.instance_type_id
45
 
 
46
 
    integer_column.create(instances)
47
 
    for instance_id, instance_type_id in types.iteritems():
48
 
        update = instances.update().\
49
 
                where(instances.c.id == instance_id).\
50
 
                values(instance_type_id_int=instance_type_id)
51
 
        migrate_engine.execute(update)
52
 
 
53
 
    string_column.alter(name='instance_type_id_str')
54
 
    integer_column.alter(name='instance_type_id')
55
 
    string_column.drop()
56
 
 
57
 
 
58
 
def downgrade(migrate_engine):
59
 
    meta = MetaData()
60
 
    meta.bind = migrate_engine
61
 
 
62
 
    instances = Table('instances', meta, autoload=True)
63
 
 
64
 
    integer_column = instances.c.instance_type_id
65
 
    string_column = Column('instance_type_id_str',
66
 
                           String(length=255, convert_unicode=False,
67
 
                                  assert_unicode=None, unicode_error=None,
68
 
                                  _warn_on_bytestring=False),
69
 
                           nullable=True)
70
 
 
71
 
    types = {}
72
 
    for instance in migrate_engine.execute(instances.select()):
73
 
        if instance.instance_type_id is None:
74
 
            types[instance.id] = None
75
 
        else:
76
 
            types[instance.id] = str(instance.instance_type_id)
77
 
 
78
 
    string_column.create(instances)
79
 
    for instance_id, instance_type_id in types.iteritems():
80
 
        update = instances.update().\
81
 
                where(instances.c.id == instance_id).\
82
 
                values(instance_type_id_str=instance_type_id)
83
 
        migrate_engine.execute(update)
84
 
 
85
 
    integer_column.alter(name='instance_type_id_int')
86
 
    string_column.alter(name='instance_type_id')
87
 
    integer_column.drop()