~ubuntu-branches/ubuntu/trusty/heat/trusty-security

« back to all changes in this revision

Viewing changes to heat/db/sqlalchemy/migrate_repo/versions/017_event_state_status.py

  • Committer: Package Import Robot
  • Author(s): Chuck Short, Yolanda Robla, Chuck Short
  • Date: 2013-07-22 16:22:29 UTC
  • mfrom: (1.1.2)
  • Revision ID: package-import@ubuntu.com-20130722162229-zzvfu40id94ii0hc
Tags: 2013.2~b2-0ubuntu1
[ Yolanda Robla ]
* debian/tests: added autopkg tests

[ Chuck Short ]
* New upstream release
* debian/control:
  - Add python-pbr to build-depends.
  - Add python-d2to to build-depends.
  - Dropped python-argparse.
  - Add python-six to build-depends.
  - Dropped python-sendfile.
  - Dropped python-nose.
  - Added testrepository.
  - Added python-testtools.
* debian/rules: Run testrepository instead of nosetets.
* debian/patches/removes-lxml-version-limitation-from-pip-requires.patch: Dropped
  no longer needed.
* debian/patches/fix-package-version-detection-when-building-doc.patch: Dropped
  no longer needed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
# vim: tabstop=4 shiftwidth=4 softtabstop=4
 
2
 
 
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
 
6
#
 
7
#         http://www.apache.org/licenses/LICENSE-2.0
 
8
#
 
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
 
13
#    under the License.
 
14
 
 
15
import sqlalchemy
 
16
 
 
17
 
 
18
def upgrade(migrate_engine):
 
19
    meta = sqlalchemy.MetaData()
 
20
    meta.bind = migrate_engine
 
21
 
 
22
    event = sqlalchemy.Table('event', meta, autoload=True)
 
23
    # Currently there is a 'name' column which really holds the
 
24
    # resource status, so rename it and add a separate action column
 
25
    # action is e.g "CREATE" and status is e.g "IN_PROGRESS"
 
26
    event.c.name.alter(name='resource_status')
 
27
    sqlalchemy.Column('resource_action', sqlalchemy.String(255)).create(event)
 
28
 
 
29
 
 
30
def downgrade(migrate_engine):
 
31
    meta = sqlalchemy.MetaData()
 
32
    meta.bind = migrate_engine
 
33
 
 
34
    event = sqlalchemy.Table('event', meta, autoload=True)
 
35
    event.c.resource_status.alter(name='name')
 
36
    event.c.resource_action.drop()