Coverage for mindsdb / migrations / versions / 2023-08-31_4c26ad04eeaa_add_skills_table.py: 80%

1"""add_skills_table 

2 

3Revision ID: 4c26ad04eeaa 

4Revises: b5bf593ba659 

5Create Date: 2023-08-31 17:04:26.898015 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10 

11 

12# revision identifiers, used by Alembic. 

13revision = '4c26ad04eeaa' 

14down_revision = 'd44ab65a6a35' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

20 op.create_table( 

21 'skills', 

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

23 sa.Column('name', sa.String(), nullable=False), 

24 sa.Column('project_id', sa.Integer(), nullable=False), 

25 sa.Column('type', sa.String(), nullable=False), 

26 sa.Column('params', sa.JSON(), nullable=True), 

27 sa.PrimaryKeyConstraint('id') 

28 ) 

29 

30 

31def downgrade(): 

32 op.drop_table('skills')