Script 2561c13a3556_add_dist_git_instance_table_py
|
|
1 """
2 add dist_git_instance table
3
4 Revision ID: 2561c13a3556
5 Revises: d230af5e05d8
6 Create Date: 2020-01-30 14:49:07.698008
7 """
8
9 import sqlalchemy as sa
10 from alembic import op
11
12
13 revision = '2561c13a3556'
14 down_revision = 'd230af5e05d8'
15
17 new_table = op.create_table('dist_git_instance',
18 sa.Column('id', sa.Integer(), nullable=False),
19 sa.Column('name', sa.String(length=50), nullable=False),
20 sa.Column('clone_url', sa.String(length=100), nullable=False),
21 sa.Column('clone_package_uri', sa.String(length=100), nullable=False),
22 sa.Column('priority', sa.Integer(), nullable=False),
23 sa.PrimaryKeyConstraint('id'),
24 sa.UniqueConstraint('name')
25 )
26 op.bulk_insert(new_table, [{
27 'name': 'fedora',
28 'clone_url': 'https://src.fedoraproject.org',
29 'clone_package_uri': 'rpms/{pkgname}.git',
30 'priority': 100,
31 }])
32
34 op.drop_table('dist_git_instance')
35