Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/migrations/versions/20250228_000001_add_crm_code_columns.py
2026-04-14 19:34:55 +03:30

68 lines
2.4 KiB
Python
Executable file

"""add code column to crm_leads, crm_deals, crm_activities
Revision ID: 20250228_000001
Revises: 20250227_000001_add_crm_tables
Create Date: 2025-02-28
"""
from __future__ import annotations
from alembic import op
import sqlalchemy as sa
revision = "20250228_000001_add_crm_code_columns"
down_revision = "20250227_000001_add_crm_tables"
branch_labels = None
depends_on = None
def upgrade() -> None:
# Add code column to crm_leads (nullable initially for backfill)
op.add_column("crm_leads", sa.Column("code", sa.String(50), nullable=True))
conn = op.get_bind()
# Backfill: L-{id} for existing leads
conn.execute(sa.text(
"UPDATE crm_leads SET code = 'L-' || id WHERE code IS NULL"
))
op.alter_column("crm_leads", "code", nullable=False)
op.create_unique_constraint(
"uq_crm_leads_business_code", "crm_leads", ["business_id", "code"]
)
op.create_index("ix_crm_leads_code", "crm_leads", ["code"])
# Add code column to crm_deals
op.add_column("crm_deals", sa.Column("code", sa.String(50), nullable=True))
conn.execute(sa.text(
"UPDATE crm_deals SET code = 'D-' || id WHERE code IS NULL"
))
op.alter_column("crm_deals", "code", nullable=False)
op.create_unique_constraint(
"uq_crm_deals_business_code", "crm_deals", ["business_id", "code"]
)
op.create_index("ix_crm_deals_code", "crm_deals", ["code"])
# Add code column to crm_activities
op.add_column("crm_activities", sa.Column("code", sa.String(50), nullable=True))
conn.execute(sa.text(
"UPDATE crm_activities SET code = 'A-' || id WHERE code IS NULL"
))
op.alter_column("crm_activities", "code", nullable=False)
op.create_unique_constraint(
"uq_crm_activities_business_code", "crm_activities", ["business_id", "code"]
)
op.create_index("ix_crm_activities_code", "crm_activities", ["code"])
def downgrade() -> None:
op.drop_index("ix_crm_activities_code", "crm_activities")
op.drop_constraint("uq_crm_activities_business_code", "crm_activities", type_="unique")
op.drop_column("crm_activities", "code")
op.drop_index("ix_crm_deals_code", "crm_deals")
op.drop_constraint("uq_crm_deals_business_code", "crm_deals", type_="unique")
op.drop_column("crm_deals", "code")
op.drop_index("ix_crm_leads_code", "crm_leads")
op.drop_constraint("uq_crm_leads_business_code", "crm_leads", type_="unique")
op.drop_column("crm_leads", "code")