| import uuid |
| from datetime import datetime |
|
|
| from sqlalchemy import ( |
| Boolean, |
| DateTime, |
| Index, |
| String, |
| Text, |
| func, |
| ) |
| from sqlalchemy.dialects.postgresql import UUID |
| from sqlalchemy.orm import Mapped, mapped_column, relationship |
|
|
| from app.db.base import Base |
|
|
|
|
| class Source(Base): |
| __tablename__ = "sources" |
|
|
| id: Mapped[uuid.UUID] = mapped_column( |
| UUID(as_uuid=True), |
| primary_key=True, |
| default=uuid.uuid4, |
| ) |
|
|
| name: Mapped[str] = mapped_column( |
| String(180), |
| nullable=False, |
| unique=True, |
| ) |
|
|
| slug: Mapped[str] = mapped_column( |
| String(180), |
| nullable=False, |
| unique=True, |
| ) |
|
|
| organization_type: Mapped[str] = mapped_column( |
| String(50), |
| nullable=False, |
| default="organization", |
| server_default="organization", |
| ) |
|
|
| base_url: Mapped[str] = mapped_column( |
| Text, |
| nullable=False, |
| ) |
|
|
| opportunities_url: Mapped[str | None] = mapped_column( |
| Text, |
| nullable=True, |
| ) |
|
|
| feed_url: Mapped[str | None] = mapped_column( |
| Text, |
| nullable=True, |
| ) |
|
|
| logo_url: Mapped[str | None] = mapped_column( |
| Text, |
| nullable=True, |
| ) |
|
|
| country_code: Mapped[str | None] = mapped_column( |
| String(2), |
| nullable=True, |
| ) |
|
|
| source_tier: Mapped[str] = mapped_column( |
| String(1), |
| nullable=False, |
| default="B", |
| server_default="B", |
| ) |
|
|
| is_official: Mapped[bool] = mapped_column( |
| Boolean, |
| nullable=False, |
| default=True, |
| server_default="true", |
| ) |
|
|
| is_active: Mapped[bool] = mapped_column( |
| Boolean, |
| nullable=False, |
| default=True, |
| server_default="true", |
| ) |
|
|
| last_checked_at: Mapped[datetime | None] = mapped_column( |
| DateTime(timezone=True), |
| nullable=True, |
| ) |
|
|
| created_at: Mapped[datetime] = mapped_column( |
| DateTime(timezone=True), |
| nullable=False, |
| server_default=func.now(), |
| ) |
|
|
| updated_at: Mapped[datetime] = mapped_column( |
| DateTime(timezone=True), |
| nullable=False, |
| server_default=func.now(), |
| onupdate=func.now(), |
| ) |
|
|
| opportunities = relationship( |
| "Opportunity", |
| back_populates="source", |
| lazy="selectin", |
| ) |
|
|
| __table_args__ = ( |
| Index("ix_sources_slug", "slug"), |
| Index( |
| "ix_sources_active_official", |
| "is_active", |
| "is_official", |
| ), |
| ) |
