corvix.db

SQLAlchemy ORM models and engine helpers for PostgreSQL persistence.

Classes

Base	Shared declarative base for all ORM models.
User	Registered user with an encrypted GitHub token.
NotificationRecordRow	Persisted notification record scoped to a user.
UserPreferences	Per-user preferences (theme, browser notifications).
PushSubscription	Browser push subscription for a user.

Functions

get_database_url(→ str | None)

Return DB URL from env, supporting ${URL_ENV}_FILE Docker secret files.

Module Contents

class corvix.db.Base

Bases: sqlalchemy.orm.DeclarativeBase

Shared declarative base for all ORM models.

class corvix.db.User

Bases: Base

Registered user with an encrypted GitHub token.

__tablename__ = 'users'

id: sqlalchemy.orm.Mapped[uuid.UUID]

github_login: sqlalchemy.orm.Mapped[str]

github_token: sqlalchemy.orm.Mapped[str]

created_at: sqlalchemy.orm.Mapped[datetime.datetime]

updated_at: sqlalchemy.orm.Mapped[datetime.datetime]

preferences: sqlalchemy.orm.Mapped[UserPreferences | None]

push_subscriptions: sqlalchemy.orm.Mapped[list[PushSubscription]]

notification_records: sqlalchemy.orm.Mapped[list[NotificationRecordRow]]

class corvix.db.NotificationRecordRow

Bases: Base

Persisted notification record scoped to a user.

__tablename__ = 'notification_records'

__table_args__

id: sqlalchemy.orm.Mapped[int]

user_id: sqlalchemy.orm.Mapped[uuid.UUID]

account_id: sqlalchemy.orm.Mapped[str]

account_label: sqlalchemy.orm.Mapped[str]

thread_id: sqlalchemy.orm.Mapped[str]

repository: sqlalchemy.orm.Mapped[str]

reason: sqlalchemy.orm.Mapped[str]

subject_title: sqlalchemy.orm.Mapped[str]

subject_type: sqlalchemy.orm.Mapped[str]

unread: sqlalchemy.orm.Mapped[bool]

updated_at: sqlalchemy.orm.Mapped[datetime.datetime]

thread_url: sqlalchemy.orm.Mapped[str | None]

web_url: sqlalchemy.orm.Mapped[str | None]

score: sqlalchemy.orm.Mapped[float]

excluded: sqlalchemy.orm.Mapped[bool]

matched_rules: sqlalchemy.orm.Mapped[list[str]]

actions_taken: sqlalchemy.orm.Mapped[list[str]]

context: sqlalchemy.orm.Mapped[dict[str, object]]

dismissed: sqlalchemy.orm.Mapped[bool]

snapshot_at: sqlalchemy.orm.Mapped[datetime.datetime]

user: sqlalchemy.orm.Mapped[User]

class corvix.db.UserPreferences

Bases: Base

Per-user preferences (theme, browser notifications).

__tablename__ = 'user_preferences'

user_id: sqlalchemy.orm.Mapped[uuid.UUID]

theme: sqlalchemy.orm.Mapped[str]

browser_notify: sqlalchemy.orm.Mapped[bool]

user: sqlalchemy.orm.Mapped[User]

class corvix.db.PushSubscription

Bases: Base

Browser push subscription for a user.

__tablename__ = 'push_subscriptions'

__table_args__

id: sqlalchemy.orm.Mapped[int]

user_id: sqlalchemy.orm.Mapped[uuid.UUID]

endpoint: sqlalchemy.orm.Mapped[str]

p256dh_key: sqlalchemy.orm.Mapped[str]

auth_key: sqlalchemy.orm.Mapped[str]

created_at: sqlalchemy.orm.Mapped[datetime.datetime]

user: sqlalchemy.orm.Mapped[User]

corvix.db.get_database_url(url_env: str = 'DATABASE_URL') → str | None

Return DB URL from env, supporting ${URL_ENV}_FILE Docker secret files.