Skip to content

:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.

3.4 KB
Raw Blame
from collections.abc import Iterable
from uuid import UUID

from django.db.models import Q

from posthog.dataclasses import frozen

from products.tasks.backend.facade.profiles import SourceKind, TaskSource, TaskSourceError


@frozen
class SourceColumns:
    signal_report_id: str | None
    hog_flow_id: UUID | None
    source: TaskSource | None


def apply_task_source(
    source: TaskSource | None, *, signal_report_id: str | None, hog_flow_id: UUID | None
) -> SourceColumns:
    if source is None:
        return SourceColumns(
            signal_report_id=signal_report_id,
            hog_flow_id=hog_flow_id,
            source=source_from_columns(signal_report_id=signal_report_id, hog_flow_id=hog_flow_id),
        )
    if signal_report_id is not None or hog_flow_id is not None:
        raise TaskSourceError("Pass the source as source or as signal_report_id and hog_flow_id, not both")
    if source.kind == SourceKind.SIGNAL_REPORT:
        return SourceColumns(signal_report_id=source.id, hog_flow_id=None, source=source)
    if source.kind == SourceKind.HOG_FLOW:
        return SourceColumns(signal_report_id=None, hog_flow_id=UUID(source.id), source=source)
    return SourceColumns(signal_report_id=None, hog_flow_id=None, source=source)


def source_from_columns(*, signal_report_id: str | None, hog_flow_id: UUID | None) -> TaskSource | None:
    if signal_report_id and hog_flow_id:
        raise TaskSourceError("A task has one source. Pass signal_report_id or hog_flow_id, not both")
    if signal_report_id:
        return TaskSource(kind=SourceKind.SIGNAL_REPORT, id=str(signal_report_id))
    if hog_flow_id:
        return TaskSource(kind=SourceKind.HOG_FLOW, id=str(hog_flow_id))
    return None


_RELATION_PREFIXES = frozenset({"", "task__"})
_IDEMPOTENCY_LOOKUPS = frozenset({"", "__startswith"})


def _field_path(via: str, field: str) -> str:
    if via not in _RELATION_PREFIXES:
        raise ValueError(f"Unknown task relation prefix {via!r}")
    return via + field


def source_q(kind: SourceKind, source_ids: Iterable[str | UUID], *, via: str = "") -> Q:
    ids = [str(source_id) for source_id in source_ids]
    on_new_columns = Q(**{_field_path(via, "source_kind"): kind.value, _field_path(via, "source_id__in"): ids})
    if kind == SourceKind.SIGNAL_REPORT:
        on_new_columns &= Q(**{_field_path(via, "signal_report_id__isnull"): False})
        legacy_field = "signal_report_id__in"
    elif kind == SourceKind.HOG_FLOW:
        legacy_field = "hog_flow_id__in"
    else:
        return on_new_columns
    new_columns_incomplete = Q(**{_field_path(via, "source_kind__isnull"): True}) | Q(
        **{_field_path(via, "source_id__isnull"): True}
    )
    return on_new_columns | (new_columns_incomplete & Q(**{_field_path(via, legacy_field): ids}))


def idempotency_key_q(key: str, *, via: str = "") -> Q:
    return _idempotency_q("", key, via)


def idempotency_key_startswith_q(key_prefix: str, *, via: str = "") -> Q:
    return _idempotency_q("__startswith", key_prefix, via)


def _idempotency_q(lookup: str, value: str, via: str) -> Q:
    if lookup not in _IDEMPOTENCY_LOOKUPS:
        raise ValueError(f"Unknown idempotency key lookup {lookup!r}")
    on_new_column = Q(**{_field_path(via, "idempotency_key" + lookup): value})
    legacy = Q(**{_field_path(via, "idempotency_key__isnull"): True, _field_path(via, "origin_key" + lookup): value})
    return on_new_column | legacy