Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/migrations/versions/20260627_000001_ai_phase7_schedule.py

41 lines
1.7 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

"""فاز ۷: زمان‌بندی ارزیابی خودکار AI
Revision ID: 20260627_000001_ai_phase7_schedule
Revises: 20260626_000002_ai_pgvector_optional
"""
from __future__ import annotations
import sqlalchemy as sa
from alembic import op
revision = "20260627_000001_ai_phase7_schedule"
down_revision = "20260626_000002_ai_pgvector_optional"
branch_labels = None
depends_on = None
def upgrade() -> None:
op.create_table(
"ai_eval_schedule",
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True),
sa.Column("enabled", sa.Boolean(), nullable=False, server_default=sa.text("false")),
sa.Column("cron_expression", sa.String(64), nullable=False, server_default="0 3 * * *"),
sa.Column("timezone", sa.String(64), nullable=False, server_default="Asia/Tehran"),
sa.Column("business_id", sa.Integer(), sa.ForeignKey("businesses.id", ondelete="SET NULL"), nullable=True),
sa.Column("min_pass_rate", sa.Integer(), nullable=False, server_default="70"),
sa.Column("last_run_id", sa.Integer(), sa.ForeignKey("ai_eval_runs.id", ondelete="SET NULL"), nullable=True),
sa.Column("last_run_at", sa.DateTime(), nullable=True),
sa.Column("last_pass_rate", sa.Integer(), nullable=True),
sa.Column("updated_at", sa.DateTime(), nullable=False, server_default=sa.text("NOW()")),
)
op.execute(
"""
INSERT INTO ai_eval_schedule (id, enabled, cron_expression, timezone, min_pass_rate)
SELECT 1, false, '0 3 * * *', 'Asia/Tehran', 70
WHERE NOT EXISTS (SELECT 1 FROM ai_eval_schedule WHERE id = 1)
"""
)
def downgrade() -> None:
op.drop_table("ai_eval_schedule")