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

« back to all changes in this revision

Viewing changes to cinder/db/sqlalchemy/migrate_repo/versions/085_add_index_to_fixed_ips_by_address.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/085_add_index_to_fixed_ips_by_address.py

 

1

# Copyright 2012 IBM

 

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

from sqlalchemy import Index, MetaData, Table

 

16

 

 

17

 

 

18

def upgrade(migrate_engine):

 

19

    meta = MetaData()

 

20

    meta.bind = migrate_engine

 

21

    instances = Table('fixed_ips', meta, autoload=True)

 

22

    index = Index('address', instances.c.address)

 

23

    index.create(migrate_engine)

 

24

 

 

25

 

 

26

def downgrade(migrate_engine):

 

27

    meta = MetaData()

 

28

    meta.bind = migrate_engine

 

29

    instances = Table('fixed_ips', meta, autoload=True)

 

30

    index = Index('address', instances.c.address)

 

31

    index.drop(migrate_engine)

• Older »

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