forked from ScoDoc/ScoDoc
44 lines
1.2 KiB
Python
44 lines
1.2 KiB
Python
|
"""fix_refcomp_geii
|
||
|
|
|
||
|
|
Revision ID: f6cb3d4e44ec
|
||
|
|
Revises: 9794534db935
|
||
|
|
Create Date: 2024-07-10 17:03:58.549168
|
||
|
|
|
||
|
|
Élimine éventuels doublons dans associations Apprentissages critiques du ref. comp.
|
||
|
|
Pour le cas de GEII seulement.
|
||
|
|
"""
|
||
|
|
|
||
|
|
from alembic import op
|
||
|
|
|
||
|
|
|
||
|
|
# revision identifiers, used by Alembic.
|
||
|
|
revision = "f6cb3d4e44ec"
|
||
|
|
down_revision = "9794534db935"
|
||
|
|
branch_labels = None
|
||
|
|
depends_on = None
|
||
|
|
|
||
|
|
|
||
|
|
def upgrade():
|
||
|
|
op.execute(
|
||
|
|
"""
|
||
|
|
CREATE TABLE apc_modules_acs_temp AS
|
||
|
|
SELECT DISTINCT module_id, app_crit_id
|
||
|
|
FROM apc_modules_acs;
|
||
|
|
DELETE FROM apc_modules_acs;
|
||
|
|
INSERT INTO apc_modules_acs (module_id, app_crit_id)
|
||
|
|
SELECT module_id, app_crit_id
|
||
|
|
FROM apc_modules_acs_temp;
|
||
|
|
"""
|
||
|
|
)
|
||
|
|
with op.batch_alter_table("apc_modules_acs", schema=None) as batch_op:
|
||
|
|
batch_op.create_unique_constraint(
|
||
|
|
"uix_module_id_app_crit_id", ["module_id", "app_crit_id"]
|
||
|
|
)
|
||
|
|
|
||
|
|
op.drop_table("apc_modules_acs_temp")
|
||
|
|
|
||
|
|
|
||
|
|
def downgrade():
|
||
|
|
with op.batch_alter_table("apc_modules_acs", schema=None) as batch_op:
|
||
|
|
batch_op.drop_constraint("uix_module_id_app_crit_id", type_="unique")
|