Coverage for mindsdb / migrations / versions / 2023-06-19_b5bf593ba659_create_chat_bots_history_table.py: 80%

1"""create_chat_bots_history_table 

2 

3Revision ID: b5bf593ba659 

4Revises: 9d6271bb2c38 

5Create Date: 2023-06-19 09:56:37.108680 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10 

11 

12# revision identifiers, used by Alembic. 

13revision = 'b5bf593ba659' 

14down_revision = '9d6271bb2c38' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

20 op.create_table( 

21 'chat_bots_history', 

22 sa.Column('id', sa.Integer(), nullable=False), 

23 sa.Column('chat_bot_id', sa.Integer(), nullable=False), 

24 sa.Column('type', sa.String()), 

25 sa.Column('text', sa.String()), 

26 sa.Column('user', sa.String()), 

27 sa.Column('destination', sa.String()), 

28 sa.Column('sent_at', sa.DateTime()), 

29 sa.Column('error', sa.String()), 

30 sa.PrimaryKeyConstraint('id'), 

31 ) 

32 

33 

34def downgrade(): 

35 op.drop_table('chat_bots_history')