Source code for space_pv_storage.postgres

import enum
import uuid
from datetime import UTC, datetime
from typing import Any

from sqlalchemy import JSON, DateTime, Enum, String, Text, create_engine
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, sessionmaker

from .config import StorageSettings


class Base(DeclarativeBase):
    pass


[docs] class JobStatus(enum.StrEnum): QUEUED = "queued" RUNNING = "running" SUCCEEDED = "succeeded" FAILED = "failed" CANCELLED = "cancelled"
[docs] class JobRun(Base): __tablename__ = "job_runs" id: Mapped[str] = mapped_column(String(36), primary_key=True, default=lambda: str(uuid.uuid4())) task_name: Mapped[str] = mapped_column(String(200), index=True) celery_task_id: Mapped[str | None] = mapped_column(String(100), unique=True, index=True) status: Mapped[JobStatus] = mapped_column( Enum(JobStatus, name="job_status"), default=JobStatus.QUEUED, index=True, ) payload: Mapped[dict[str, Any]] = mapped_column(JSON, default=dict) result: Mapped[dict[str, Any] | None] = mapped_column(JSON) error: Mapped[str | None] = mapped_column(Text) created_at: Mapped[datetime] = mapped_column( DateTime(timezone=True), default=lambda: datetime.now(UTC), index=True, ) started_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True)) finished_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True))
def create_engine_from_settings(settings: StorageSettings | None = None): settings = settings or StorageSettings() return create_engine(settings.postgres_dsn, pool_pre_ping=True) def session_factory(settings: StorageSettings | None = None): return sessionmaker(bind=create_engine_from_settings(settings), expire_on_commit=False)