adf671eddeb4_level_cascade_deletion.py 文件源码

def upgrade():
    table_prefix = context.config.get_main_option('table_prefix')
    table_name = table_prefix + 'environment_hierarchy_level'

    with op.batch_alter_table(table_name) as batch:
        batch.drop_constraint(
            table_prefix + 'environment_hierarchy_level_environment_id_fkey',
            type_='foreignkey'
        )
        batch.create_foreign_key(
            table_prefix + 'environment_hierarchy_level_environment_id_fkey',
            table_prefix + 'environment',
            ['environment_id'], ['id'], ondelete='CASCADE'
        )