Coverage for mindsdb / migrations / versions / 2024-02-02_5a5c49313e52_job_condition.py: 69%

1"""job_condition 

2 

3Revision ID: 5a5c49313e52 

4Revises: 4b3c9d63e89c 

5Create Date: 2024-02-02 11:17:07.246330 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10import mindsdb.interfaces.storage.db # noqa 

11 

12# revision identifiers, used by Alembic. 

13revision = '5a5c49313e52' 

14down_revision = '4b3c9d63e89c' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

20 # ### commands auto generated by Alembic - please adjust! ### 

21 with op.batch_alter_table('jobs', schema=None) as batch_op: 

22 batch_op.add_column(sa.Column('if_query_str', sa.String(), nullable=True)) 

23 

24 # ### end Alembic commands ### 

25 

26 

27def downgrade(): 

28 # ### commands auto generated by Alembic - please adjust! ### 

29 with op.batch_alter_table('jobs', schema=None) as batch_op: 

30 batch_op.drop_column('if_query_str') 

31 

32 # ### end Alembic commands ###