Skip to content

OpenRAG is a comprehensive, single package Retrieval-Augmented Generation platform built on Langflow, Docling, and Opensearch.

Python
1.4 KB
Raw Blame
from datetime import UTC, datetime
from typing import Optional

from sqlalchemy import Column
from sqlmodel import Field, SQLModel

from db.types import EncryptedString


class UserPreferences(SQLModel, table=True):
    __tablename__ = "user_preferences"

    user_id: str = Field(
        foreign_key="users.id",
        primary_key=True,
        max_length=64,
    )

    agent_system_prompt_override: Optional[str] = Field(
        default=None,
        sa_column=Column(
            "agent_system_prompt_override",
            EncryptedString(tenant_id="user_pref"),
            nullable=True,
        ),
    )
    default_kf_id: Optional[str] = Field(default=None, max_length=128)
    theme: Optional[str] = Field(default=None, max_length=32)
    language: Optional[str] = Field(default=None, max_length=16)

    # JSON blob: {"openai":{"api_key":"..."}, "anthropic":{...}}
    provider_overrides: Optional[str] = Field(
        default=None,
        sa_column=Column(
            "provider_overrides",
            EncryptedString(tenant_id="user_pref"),
            nullable=True,
        ),
    )

    # Future-proof bag for additional opt-in preferences.
    preferences_json: Optional[str] = Field(
        default=None,
        sa_column=Column(
            "preferences_json",
            EncryptedString(tenant_id="user_pref"),
            nullable=True,
        ),
    )

    updated_at: datetime = Field(default_factory=lambda: datetime.now(UTC))