From 533866679755bd6e7a97cfa0f050eaa832b0b373 Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Sat, 11 Apr 2026 21:32:49 -0500 Subject: fix: reduce sr.ht poll API load with cached repo discovery --- src/srht_contrib/models.py | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'src/srht_contrib/models.py') diff --git a/src/srht_contrib/models.py b/src/srht_contrib/models.py index 475bd22..e0725ff 100644 --- a/src/srht_contrib/models.py +++ b/src/srht_contrib/models.py @@ -81,6 +81,16 @@ class TrackedActor(Base): last_backfill_error: Mapped[str | None] = mapped_column(Text, nullable=True) +class DiscoveredRepository(Base): + __tablename__ = "discovered_repositories" + __table_args__ = (UniqueConstraint("actor", "name", name="uq_discovered_repository_actor_name"),) + + id: Mapped[int] = mapped_column(Integer, primary_key=True) + actor: Mapped[str] = mapped_column(String(255), nullable=False) + name: Mapped[str] = mapped_column(String(255), nullable=False) + discovered_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), nullable=False) + + class ServiceBackfillState(Base): __tablename__ = "service_backfill_states" __table_args__ = (UniqueConstraint("actor", "service", "scope", name="uq_service_backfill_state_actor_service_scope"),) -- cgit v1.2.3