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)