Coverage for mindsdb / migrations / versions / 2023-11-01_c67822e96833_jobs_active.py: 69%

1"""jobs_active 

2 

3Revision ID: c67822e96833 

4Revises: 309db3d07cf4 

5Create Date: 2023-11-01 15:42:53.249859 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10import mindsdb.interfaces.storage.db # noqa 

11 

12# revision identifiers, used by Alembic. 

13revision = 'c67822e96833' 

14down_revision = '309db3d07cf4' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

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

21 

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

23 batch_op.add_column(sa.Column('active', sa.Boolean(), nullable=True)) 

24 

25 # ### end Alembic commands ### 

26 

27 

28def downgrade(): 

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

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

31 batch_op.drop_column('active') 

32 

33 # ### end Alembic commands ###