Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/app/services/support/support_background_jobs.py

89 lines
3.3 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.

"""Background jobs for support ticketing (SLA breach checks)."""
from __future__ import annotations
import asyncio
import logging
from datetime import datetime
from sqlalchemy.exc import TimeoutError as SQLTimeoutError
from adapters.db.models.support.status import Status
from adapters.db.models.support.ticket import Ticket
from adapters.db.session import get_db_session
logger = logging.getLogger(__name__)
def _refresh_sla_breach_flags() -> int:
"""Mark open tickets whose SLA is breached. Returns count of updated rows."""
try:
with get_db_session(retries=1, delay=0.5) as db:
now = datetime.utcnow()
tickets = (
db.query(Ticket)
.join(Ticket.status)
.filter(Status.is_final.is_(False), Ticket.closed_at.is_(None))
.all()
)
changed = 0
for ticket in tickets:
breached = False
if ticket.resolution_due_at and now > ticket.resolution_due_at:
breached = True
elif (
ticket.first_response_due_at
and ticket.first_responded_at is None
and now > ticket.first_response_due_at
):
breached = True
if ticket.sla_breached != breached:
ticket.sla_breached = breached
changed += 1
if changed:
db.commit()
return changed
except SQLTimeoutError as exc:
logger.warning("SLA breach check skipped (pool exhausted): %s", exc)
return 0
except Exception:
logger.exception("SLA breach check failed")
return 0
async def support_sla_breach_check_loop(interval_seconds: int = 300) -> None:
"""Every 5 minutes by default, refresh sla_breached on open tickets."""
while True:
try:
changed = await asyncio.to_thread(_refresh_sla_breach_flags)
if changed:
logger.info("Support SLA: updated breach flag on %s ticket(s)", changed)
except Exception:
logger.exception("Error in support SLA breach loop")
await asyncio.sleep(interval_seconds)
def _refresh_subscription_statuses() -> int:
try:
with get_db_session(retries=1, delay=0.5) as db:
from app.services.support.support_billing_service import refresh_subscription_statuses
return refresh_subscription_statuses(db)
except SQLTimeoutError as exc:
logger.warning("Support subscription status refresh skipped (pool exhausted): %s", exc)
return 0
except Exception:
logger.exception("Support subscription status refresh failed")
return 0
async def support_subscription_status_loop(interval_seconds: int = 600) -> None:
"""هر ۱۰ دقیقه وضعیت اشتراک‌ها و نشست‌های پرداخت را به‌روز می‌کند."""
while True:
try:
changed = await asyncio.to_thread(_refresh_subscription_statuses)
if changed:
logger.info("Support billing: updated %s subscription/session row(s)", changed)
except Exception:
logger.exception("Error in support subscription status loop")
await asyncio.sleep(interval_seconds)