← Back to branch summary

~ubuntu-cloud-archive/ubuntu/precise/nova/trunk

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/094_update_postgresql_sequence_names.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/094_update_postgresql_sequence_names.py
 
1
# vim: tabstop=4 shiftwidth=4 softtabstop=4
 
2
 
 
3
# Copyright (c) 2012 Red Hat, Inc.
 
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 MetaData
 
19
 
 
20
 
 
21
def upgrade(migrate_engine):
 
22
    meta = MetaData()
 
23
    meta.bind = migrate_engine
 
24
 
 
25
    # NOTE(dprince): Need to rename the leftover zones stuff and quota_new
 
26
    # stuff from Essex for PostgreSQL.
 
27
    if migrate_engine.name == "postgresql":
 
28
        sql = """ALTER TABLE zones_id_seq RENAME TO cells_id_seq;
 
29
              ALTER TABLE ONLY cells DROP CONSTRAINT zones_pkey;
 
30
              ALTER TABLE ONLY cells ADD CONSTRAINT cells_pkey
 
31
              PRIMARY KEY (id);
 
32
 
 
33
              ALTER TABLE quotas_new_id_seq RENAME TO quotas_id_seq;
 
34
              ALTER TABLE ONLY quotas DROP CONSTRAINT quotas_new_pkey;
 
35
              ALTER TABLE ONLY quotas ADD CONSTRAINT quotas_pkey
 
36
              PRIMARY KEY (id);"""
 
37
        migrate_engine.execute(sql)
 
38
 
 
39
 
 
40
def downgrade(migrate_engine):
 
41
    meta = MetaData()
 
42
    meta.bind = migrate_engine
 
43
 
 
44
    if migrate_engine.name == "postgresql":
 
45
        sql = """ALTER TABLE cells_id_seq RENAME TO zones_id_seq;
 
46
              ALTER TABLE ONLY cells DROP CONSTRAINT cells_pkey;
 
47
              ALTER TABLE ONLY cells ADD CONSTRAINT zones_pkey
 
48
              PRIMARY KEY (id);
 
49
 
 
50
              ALTER TABLE quotas_id_seq RENAME TO quotas_new_id_seq;
 
51
              ALTER TABLE ONLY quotas DROP CONSTRAINT quotas_pkey;
 
52
              ALTER TABLE ONLY quotas ADD CONSTRAINT quotas_new_pkey
 
53
              PRIMARY KEY (id);"""
 
54
        migrate_engine.execute(sql)