fc7ea2a7e386_analytics_tables.py 文件源码

def downgrade():
    """Downgrade the database to an older revision."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('similar_stacks', sa.Column('appstack_id', sa.INTEGER(), autoincrement=False,
                  nullable=True))
    op.add_column('similar_stacks', sa.Column('dependency_list', postgresql.JSONB(),
                  autoincrement=False, nullable=False))
    op.drop_constraint(None, 'similar_stacks', type_='foreignkey')
    op.drop_constraint(None, 'similar_stacks', type_='foreignkey')
    op.create_foreign_key('similar_stacks_appstack_id_fkey', 'similar_stacks', 'app_stacks',
                          ['appstack_id'], ['id'])
    op.drop_constraint('sim_unique', 'similar_stacks', type_='unique')
    op.drop_column('similar_stacks', 'stack_id')
    op.drop_column('similar_stacks', 'similarity_value')
    op.drop_column('similar_stacks', 'similar_stack_id')
    op.drop_column('similar_stacks', 'analysis')
    op.create_table('app_stacks',
                    sa.Column('id', sa.INTEGER(), nullable=False),
                    sa.Column('stack_json', postgresql.JSONB(), autoincrement=False,
                              nullable=False),
                    sa.PrimaryKeyConstraint('id', name='app_stacks_pkey'))
    op.create_table('reference_stacks',
                    sa.Column('id', sa.INTEGER(), nullable=False),
                    sa.Column('name', sa.VARCHAR(length=255), autoincrement=False,
                              nullable=False),
                    sa.Column('version', sa.VARCHAR(length=255), autoincrement=False,
                              nullable=False),
                    sa.Column('description', sa.TEXT(), autoincrement=False, nullable=False),
                    sa.Column('dependencies', postgresql.JSONB(), autoincrement=False,
                              nullable=False),
                    sa.PrimaryKeyConstraint('id', name='reference_stacks_pkey'),
                    sa.UniqueConstraint('name', 'version', name='stack_unique'))
    op.drop_table('stacks')
    # ### end Alembic commands ###