0d30c58bf0
Snapshot of the working tree on srv1071960 (branch main), taken during server cleanup. .env files, node_modules, builds, logs and media were excluded.
44 lines
1.4 KiB
Python
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'")
|