Coverage for manila/db/migrations/alembic/versions/aebe2a413e13_add_state_column_for_service.py: 67%

1# Licensed under the Apache License, Version 2.0 (the "License"); you may 

2# not use this file except in compliance with the License. You may obtain 

3# a copy of the License at 

4# 

5# http://www.apache.org/licenses/LICENSE-2.0 

6# 

7# Unless required by applicable law or agreed to in writing, software 

8# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT 

9# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the 

10# License for the specific language governing permissions and limitations 

11# under the License. 

12 

13"""add state column for service 

14 

15Revision ID: aebe2a413e13 

16Revises: ac0620cbe74d 

17Create Date: 2023-01-10 11:43:24.741726 

18 

19""" 

20 

21# revision identifiers, used by Alembic. 

22revision = 'aebe2a413e13' 

23down_revision = 'ac0620cbe74d' 

24 

25from alembic import op 

26from oslo_log import log 

27import sqlalchemy as sa 

28 

29LOG = log.getLogger(__name__) 

30 

31 

32def upgrade(): 

33 try: 

34 op.add_column( 

35 'services', 

36 sa.Column('state', sa.String(36), nullable=True)) 

37 except Exception: 

38 LOG.error("services table column state not added") 

39 raise 

40 

41 

42def downgrade(): 

43 try: 

44 op.drop_column('services', 'state') 

45 except Exception: 

46 LOG.error("services table column state not dropped") 

47 raise