Files
celtic-life-science/alembic/versions/b8f4a1c6d2e9_abm_agm_role_codes.py
Shubhankar45 0d30c58bf0 Server backup 2026-11-07 of uncommitted work in projects/pharma-web-celtic
Snapshot of the working tree on srv1071960 (branch main), taken during
server cleanup. .env files, node_modules, builds, logs and media were excluded.
2026-11-07 05:43:12 +00:00

44 lines
1.4 KiB
Python

"""Rename the AM/GM role and pending-status codes to ABM/AGM
Revision ID: b8f4a1c6d2e9
Revises: a7e3f9b5c2d4
Create Date: 2026-11-04
"""
from collections.abc import Sequence
from alembic import op
revision: str = "b8f4a1c6d2e9"
down_revision: str | None = "a7e3f9b5c2d4"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None
def upgrade() -> None:
op.execute("UPDATE \"user\" SET role = 'ABM' WHERE role = 'AM'")
op.execute("UPDATE \"user\" SET role = 'AGM' WHERE role = 'GM'")
op.execute(
"UPDATE daily_call_report SET returned_by_role = 'ABM' WHERE returned_by_role = 'AM'"
)
op.execute(
"UPDATE daily_call_report SET returned_by_role = 'AGM' WHERE returned_by_role = 'GM'"
)
op.execute(
"UPDATE daily_call_report SET status = 'PENDING_ABM' WHERE status = 'PENDING_AM'"
)
def downgrade() -> None:
op.execute(
"UPDATE daily_call_report SET status = 'PENDING_AM' WHERE status = 'PENDING_ABM'"
)
op.execute(
"UPDATE daily_call_report SET returned_by_role = 'AM' WHERE returned_by_role = 'ABM'"
)
op.execute(
"UPDATE daily_call_report SET returned_by_role = 'GM' WHERE returned_by_role = 'AGM'"
)
op.execute("UPDATE \"user\" SET role = 'AM' WHERE role = 'ABM'")
op.execute("UPDATE \"user\" SET role = 'GM' WHERE role = 'AGM'")