# SPDX-FileCopyrightText: 2026 Dennis Fink # # SPDX-License-Identifier: BSD-3-Clause """Define database models for users and incoming and outgoing Webmentions.""" from __future__ import annotations import json from datetime import UTC, datetime from enum import StrEnum from hashlib import sha256 from typing import Never from uuid import UUID, uuid7 import sqlalchemy as sa from flask_login import UserMixin from sqlalchemy import ( Boolean, DateTime, Enum, ForeignKey, Index, Integer, String, Text, UniqueConstraint, Uuid, ) from sqlalchemy.ext.hybrid import hybrid_property from sqlalchemy.orm import Mapped, mapped_column, relationship, validates from werkzeug.security import check_password_hash, generate_password_hash from .extensions import Base class ReceivedStatus(StrEnum): """Persisted lifecycle state of an incoming Webmention.""" RECEIVED = "received" VERIFYING = "verifying" VERIFIED = "verified" FAILED = "failed" DELETED = "deleted" class SentWebmentionStatus(StrEnum): """Represent the outcome of a Webmention send attempt.""" SENT = "sent" UNSUPPORTED = "unsupported" FAILED = "failed" class User(UserMixin, Base): """Represent an authenticated application user.""" __tablename__ = "users" id: Mapped[int] = mapped_column(primary_key=True) username: Mapped[str] = mapped_column(Text(), index=True, unique=True) password_hash: Mapped[str] = mapped_column(Text(), nullable=False) def __repr__(self) -> str: """Represent the user by username.""" return f"" @property def password(self) -> Never: """Prevent access to the user's plain-text password. :raises AttributeError: Always, because the password is write-only. """ raise AttributeError("Password is write-only") @password.setter def password(self, password: str) -> None: """Hash and store a new password. :param password: Plain-text password to hash. """ self.password_hash = generate_password_hash(password) def get_id(self) -> str: """Bind the login session to the current stored password hash. Only a one-way fingerprint is placed in Flask's signed cookie, never the password hash itself. Rehashing the password invalidates all previously issued session identifiers without a schema change. """ fingerprint = sha256(self.password_hash.encode("utf-8")).hexdigest() return f"{self.id}:{fingerprint}" def check_password(self, password: str) -> bool: """Check a plain-text password against the stored password hash. :param password: Plain-text password to check. :return: Whether the password matches the stored hash. """ return check_password_hash(self.password_hash, password) class ReceivedWebmention(Base): """Represent a Webmention received for verification.""" __tablename__ = "received_webmentions" uuid: Mapped[UUID] = mapped_column(Uuid(as_uuid=True), primary_key=True) source: Mapped[str] = mapped_column(Text(), nullable=False) target: Mapped[str] = mapped_column(Text(), nullable=False) url_digest: Mapped[str] = mapped_column(String(64), nullable=False) @validates("source", "target") def _update_url_digest(self, key: str, value: str) -> str: source = value if key == "source" else self.__dict__.get("source") target = value if key == "target" else self.__dict__.get("target") if source is not None and target is not None: self.url_digest = received_url_digest(source, target) return value status: Mapped[str] = mapped_column( Text(), nullable=False, default=ReceivedStatus.RECEIVED ) # Counts stale-row requeues, not Huey's bounded in-task retries. A fresh # explicit submission resets this counter. recovery_attempts: Mapped[int] = mapped_column( Integer, nullable=False, default=0, server_default="0" ) failure_reason: Mapped[str | None] = mapped_column( Text(), nullable=True, default=None ) updated_at: Mapped[datetime] = mapped_column( DateTime(timezone=True), default=lambda: datetime.now(UTC), onupdate=lambda: datetime.now(UTC), nullable=False, ) notification_sent_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) __table_args__ = ( UniqueConstraint("url_digest", name="uq_webmention_url_digest"), Index("ix_received_webmentions_status_updated_at", "status", "updated_at"), ) def __repr__(self) -> str: """Represent the received Webmention by source and target.""" return f" {self.target!r}>" @staticmethod def verification_reset_values( *, at: datetime, recoveries: int = 0 ) -> dict[str, object]: """Return the columns to reset when verification is explicitly reopened.""" return { "status": ReceivedStatus.RECEIVED, "failure_reason": None, "recovery_attempts": recoveries, "updated_at": at, } def reset_for_verification(self) -> ReceivedWebmention: """Reopen an existing row for manual verification and return it.""" for key, value in self.verification_reset_values(at=datetime.now(UTC)).items(): setattr(self, key, value) return self @property def verified(self) -> bool: """Return whether the Webmention has been successfully verified.""" return self.status == ReceivedStatus.VERIFIED @property def created_at(self) -> datetime: """Return the creation time encoded in the Webmention UUID.""" return uuid7_to_datetime(self.uuid) class Source(Base): """Represent a generated source document containing outgoing Webmentions.""" __tablename__ = "sources" uuid: Mapped[UUID] = mapped_column( Uuid(as_uuid=True), primary_key=True, default=uuid7 ) path: Mapped[str] = mapped_column(Text(), nullable=False, unique=True) url: Mapped[str] = mapped_column(Text(), nullable=False, unique=True) content_hash: Mapped[str] = mapped_column(String(32), nullable=False) revision: Mapped[int] = mapped_column(Integer(), nullable=False, default=1) last_seen_at: Mapped[datetime] = mapped_column( DateTime(timezone=True), nullable=False ) revised_at: Mapped[datetime] = mapped_column( DateTime(timezone=True), nullable=False ) deleted_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) sent_webmentions: Mapped[list[SentWebmention]] = relationship( back_populates="source", cascade="all, delete-orphan" ) def __repr__(self) -> str: """Represent the source by its public URL.""" return f"" @property def created_at(self) -> datetime: """Return the creation time encoded in the source UUID.""" return uuid7_to_datetime(self.uuid) class SentWebmention(Base): """Represent an outgoing Webmention associated with a source.""" __tablename__ = "sent_webmentions" uuid: Mapped[UUID] = mapped_column( Uuid(as_uuid=True), primary_key=True, default=uuid7 ) source_id: Mapped[UUID] = mapped_column( Uuid(as_uuid=True), ForeignKey("sources.uuid", ondelete="CASCADE"), nullable=False, index=True, ) target: Mapped[str] = mapped_column(Text(), nullable=False) target_digest: Mapped[str] = mapped_column(String(64), nullable=False) @validates("target") def _update_target_digest(self, key: str, value: str) -> str: self.target_digest = sent_target_digest(value) return value active: Mapped[bool] = mapped_column(Boolean(), nullable=False, default=True) desired_revision: Mapped[int] = mapped_column(Integer(), nullable=False) processed_revision: Mapped[int | None] = mapped_column( Integer(), nullable=True, default=None ) sent_revision: Mapped[int | None] = mapped_column( Integer(), nullable=True, default=None ) status: Mapped[SentWebmentionStatus | None] = mapped_column( Enum( SentWebmentionStatus, name="sent_webmention_status", values_callable=lambda enum_type: [member.value for member in enum_type], native_enum=False, ), nullable=True, default=None, ) failure_reason: Mapped[str | None] = mapped_column( Text(), nullable=True, default=None ) endpoint: Mapped[str | None] = mapped_column(Text(), nullable=True, default=None) response_status: Mapped[int | None] = mapped_column( Integer(), nullable=True, default=None ) status_url: Mapped[str | None] = mapped_column(Text(), nullable=True, default=None) # Retry state belongs to the desired revision, not to the target forever. attempt_count: Mapped[int] = mapped_column(Integer(), nullable=False, default=0) next_retry_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) last_attempted_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) last_sent_at: Mapped[datetime | None] = mapped_column( DateTime(timezone=True), nullable=True, default=None ) source: Mapped[Source] = relationship(back_populates="sent_webmentions") __table_args__ = ( UniqueConstraint( "source_id", "target_digest", name="uq_sent_webmention_source_target_digest" ), ) def __repr__(self) -> str: """Represent the sent Webmention by its target URL.""" return f"" def reopen( self, revision: int, active: bool, *, resend: bool = False ) -> SentWebmention: """Reopen delivery for a revision while preserving send history.""" self.desired_revision = revision self.active = active self.attempt_count = 0 self.next_retry_at = None if resend: self.processed_revision = None self.status = None self.failure_reason = None self.endpoint = None self.response_status = None self.status_url = None return self @hybrid_property def pending(self) -> bool: """Return whether the Webmention has an unprocessed source revision.""" return ( self.processed_revision is None or self.processed_revision < self.desired_revision ) @pending.inplace.expression @classmethod def _pending_expression(cls) -> sa.ColumnElement[bool]: """Express pending-revision status in database queries.""" return sa.or_( cls.processed_revision.is_(None), cls.processed_revision < cls.desired_revision, ) @property def created_at(self) -> datetime: """Return the creation time encoded in the Webmention UUID.""" return uuid7_to_datetime(self.uuid) def uuid7_to_datetime(identifier: UUID) -> datetime: """Convert a UUID version 7 timestamp to a datetime. :param identifier: UUID whose embedded timestamp should be converted. :return: Timestamp as a timezone-aware UTC datetime. """ return datetime.fromtimestamp(identifier.time / 1000, tz=UTC) def received_url_digest(source: str, target: str) -> str: """Fingerprint an unambiguous, ordered source/target pair.""" encoded = json.dumps( [source, target], ensure_ascii=False, separators=(",", ":") ).encode("utf-8") return sha256(encoded).hexdigest() def sent_target_digest(target: str) -> str: """Fingerprint an outgoing target (unique within each source ID).""" return sha256(target.encode("utf-8")).hexdigest()