migrations/versions/900758871713_.py

   1 """empty message
   2
   3 Revision ID: 900758871713
   4 Revises: ea5a023711e0
   5 Create Date: 2018-05-27 16:36:44.258935
   6
   7 """
   8 from alembic import op
   9 import sqlalchemy as sa
  10
  11
  12 # revision identifiers, used by Alembic.
  13 revision = '900758871713'
  14 down_revision = 'ea5a023711e0'
  15 branch_labels = None
  16 depends_on = None
  17
  18
  19 def upgrade():
  20     # ### commands auto generated by Alembic - please adjust! ###
  21     op.create_table('meta_package',
  22         sa.Column('id', sa.Integer(), nullable=False),
  23         sa.Column('name', sa.String(length=100), nullable=False),
  24         sa.PrimaryKeyConstraint('id'),
  25         sa.UniqueConstraint('name')
  26     )
  27     op.create_table('provides',
  28         sa.Column('package_id', sa.Integer(), nullable=False),
  29         sa.Column('metapackage_id', sa.Integer(), nullable=False),
  30         sa.ForeignKeyConstraint(['metapackage_id'], ['meta_package.id'], ),
  31         sa.ForeignKeyConstraint(['package_id'], ['package.id'], ),
  32         sa.PrimaryKeyConstraint('package_id', 'metapackage_id')
  33     )
  34     op.drop_table('harddeps')
  35     op.drop_table('softdeps')
  36     # ### end Alembic commands ###
  37
  38
  39 def downgrade():
  40     # ### commands auto generated by Alembic - please adjust! ###
  41     op.create_table('softdeps',
  42         sa.Column('package_id', sa.INTEGER(), nullable=False),
  43         sa.Column('dependency_id', sa.INTEGER(), nullable=False),
  44         sa.ForeignKeyConstraint(['dependency_id'], ['package.id'], ),
  45         sa.ForeignKeyConstraint(['package_id'], ['package.id'], ),
  46         sa.PrimaryKeyConstraint('package_id', 'dependency_id')
  47     )
  48     op.create_table('harddeps',
  49         sa.Column('package_id', sa.INTEGER(), nullable=False),
  50         sa.Column('dependency_id', sa.INTEGER(), nullable=False),
  51         sa.ForeignKeyConstraint(['dependency_id'], ['package.id'], ),
  52         sa.ForeignKeyConstraint(['package_id'], ['package.id'], ),
  53         sa.PrimaryKeyConstraint('package_id', 'dependency_id')
  54     )
  55     op.drop_table('provides')
  56     op.drop_table('meta_package')
  57     # ### end Alembic commands ###