Skip to content

LLM-Driven Extraction of Unstructured Data — Built for API Deployments & ETL Pipeline Workflows

2.3 KB
Raw Blame
import uuid

from django.db import models
from utils.models.base_model import BaseModel
from utils.models.org_aware_manager import OrgAwareManager


class ExecutionLog(BaseModel):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    # TODO: Deprecated field, retained for backward compatibility
    # Remove after old logs are rotated from the system
    # Will be NULL for new records, use `wf_execution` instead
    execution_id = models.UUIDField(
        editable=False,
        db_comment="Execution ID (deprecated, refer wf_execution instead)",
        null=True,
    )
    wf_execution = models.ForeignKey(
        "workflow_v2.WorkflowExecution",
        on_delete=models.CASCADE,
        editable=False,
        db_comment="Foreign key from WorkflowExecution model",
        related_name="execution_logs",
        null=True,
        blank=True,
    )
    file_execution = models.ForeignKey(
        "file_execution.WorkflowFileExecution",
        on_delete=models.CASCADE,
        db_index=True,
        editable=False,
        db_comment="Foreign key from WorkflowFileExecution model",
        related_name="execution_logs",
        null=True,
        blank=True,
    )
    data = models.JSONField(db_comment="Execution log data")
    event_time = models.DateTimeField(db_comment="Execution log event time")

    # Auto-discovers FK path: wf_execution → workflow → organization
    # In request context: all queries are org-scoped
    # In Celery/commands: no filtering (full access)
    objects = OrgAwareManager()

    def __str__(self):
        return (
            f"Execution ID: {str(self.wf_execution)}, Message: {self.data}, "
            f"Event time: {self.event_time}"
        )

    class Meta:
        verbose_name = "Execution Log"
        verbose_name_plural = "Execution Logs"
        db_table = "execution_log"
        indexes = [
            models.Index(
                fields=["wf_execution", "event_time"], name="idx_wf_execution_event_time"
            ),
            models.Index(
                fields=["file_execution", "event_time"],
                name="idx_file_execution_event_time",
            ),
            models.Index(
                fields=["execution_id", "event_time"], name="idx_execution_id_event_time"
            ),
        ]