Coverage for mindsdb / migrations / versions / 2023-04-11_b8be148dbc85_jobs_history_query.py: 60%

1"""jobs_history_query 

2 

3Revision ID: b8be148dbc85 

4Revises: ef04cdbe51ed 

5Create Date: 2023-04-11 17:35:16.273293 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10import mindsdb.interfaces.storage.db # noqa 

11 

12# revision identifiers, used by Alembic. 

13revision = 'b8be148dbc85' 

14down_revision = 'ef04cdbe51ed' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

20 

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

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

23 batch_op.add_column(sa.Column('updated_at', sa.DateTime(), nullable=True, 

24 server_default=sa.func.current_timestamp())) 

25 

26 # ### end Alembic commands ### 

27 

28 

29def downgrade(): 

30 

31 with op.batch_alter_table('jobs_history', schema=None) as batch_op: 

32 batch_op.drop_column('updated_at') 

33 batch_op.drop_column('query_str') 

34 

35 # ### end Alembic commands ###