Coverage for mindsdb / migrations / versions / 2023-09-06_e187961e844a_add_agent_skills_table.py: 80%

1"""add agent_skills_table 

2 

3Revision ID: e187961e844a 

4Revises: 4c26ad04eeaa 

5Create Date: 2023-09-06 13:56:17.803484 

6 

7""" 

8from alembic import op 

9import sqlalchemy as sa 

10 

11 

12# revision identifiers, used by Alembic. 

13revision = 'e187961e844a' 

14down_revision = '4c26ad04eeaa' 

15branch_labels = None 

16depends_on = None 

17 

18 

19def upgrade(): 

20 op.create_table( 

21 'agent_skills', 

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

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

24 sa.PrimaryKeyConstraint('agent_id', 'skill_id') 

25 ) 

26 

27 

28def downgrade(): 

29 op.drop_table('agent_skills')