Pipeline/backend/app/models/forgejo_commit_activity.py

"""Per-repository per-day commit activity for heatmap and trend queries."""

from __future__ import annotations

from datetime import date as Date, datetime
from uuid import UUID, uuid4

from sqlmodel import Field, Index, SQLModel

from app.core.time import utcnow


class ForgejoCommitDay(SQLModel, table=True):
    """One row per repository per calendar day recording commit count."""

    __tablename__ = "forgejo_commit_activity"  # pyright: ignore[reportAssignmentType]

    id: UUID = Field(default_factory=uuid4, primary_key=True)
    organization_id: UUID = Field(foreign_key="organizations.id", index=True)
    repository_id: UUID = Field(foreign_key="forgejo_repositories.id", index=True)
    date: Date = Field(index=True)
    commit_count: int = Field(default=0)

    created_at: datetime = Field(default_factory=utcnow)
    updated_at: datetime = Field(default_factory=utcnow)

    __table_args__ = (
        Index(
            "ix_forgejo_commit_activity_repo_date",
            "repository_id",
            "date",
            unique=True,
        ),
    )