Coverage for manila/db/migrations/alembic/versions/097fad24d2fc_add_share_instances_share_id_index.py: 100%

1# Copyright 2018 SAP SE 

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

16 

17Revision ID: 097fad24d2fc 

18Revises: 0274d20c560f 

19Create Date: 2018-06-12 10:06:50.642418 

20 

21""" 

22 

23# revision identifiers, used by Alembic. 

24revision = '097fad24d2fc' 

25down_revision = '0274d20c560f' 

26 

27from alembic import op 

28 

29 

30INDEX_NAME = 'share_instances_share_id_idx' 

31TABLE_NAME = 'share_instances' 

32 

33 

34def upgrade(): 

35 op.create_index(INDEX_NAME, TABLE_NAME, ['share_id']) 

36 

37 

38def downgrade(): 

39 op.drop_constraint('si_share_fk', TABLE_NAME, type_='foreignkey') 

40 op.drop_index(INDEX_NAME, TABLE_NAME) 

41 op.create_foreign_key( 

42 'si_share_fk', TABLE_NAME, 'shares', ['share_id'], ['id'])