models.py

"""
Models per docs/Schema.md section 9: CPPA Pinecone Sync.

PineconeFailList  - records failed sync operations by failed_id and app_type for retry or audit.
PineconeSyncStatus - tracks the last successful sync per source app_type.
"""

from django.db import models


class PineconeFailList(models.Model):
    """Records failed sync operations by failed_id and app_type for retry or audit."""

    failed_id = models.CharField(max_length=255, db_index=True)
    app_type = models.CharField(max_length=64, db_index=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = "cppa_pinecone_sync_pineconefaillist"
        ordering = ["id"]
        verbose_name = "Pinecone fail list entry"
        verbose_name_plural = "Pinecone fail list entries"

    def __str__(self) -> str:
        return f"PineconeFailList(app_type={self.app_type}, failed_id={self.failed_id})"


class PineconeSyncStatus(models.Model):
    """Tracks the last successful sync per source app_type.

    One row per app_type (e.g. "slack", "mailing", "github").
    final_sync_at is when the last sync for that app_type completed.
    """

    app_type = models.CharField(max_length=64, unique=True, db_index=True)
    final_sync_at = models.DateTimeField(null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "cppa_pinecone_sync_pineconesyncstatus"
        ordering = ["app_type"]
        verbose_name = "Pinecone sync status"
        verbose_name_plural = "Pinecone sync statuses"

    def __str__(self) -> str:
        return f"PineconeSyncStatus(app_type={self.app_type}, final_sync_at={self.final_sync_at})"