/home/mrjunejune/zenbu: love/poppy/db/models.py annotate

annotate love/poppy/db/models.py @ 71:75de5903355c

Giagantic changes that update Dowa library to be more align with stb style array and hashmap. Updated Seobeo to be caching on server side instead of file level caching. Deleted bunch of things I don't really use.

author	June Park <parkjune1995@gmail.com>
date	Sun, 28 Dec 2025 20:34:22 -0800
parents	cf9caa4abc3e
children

rev	line source
38 cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	1 from sqlmodel import SQLModel, Field, Relationship
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	2 from typing import Optional, List
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	3 from datetime import datetime
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	4 import uuid
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	5 from sqlalchemy import text
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	6
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	7
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	8 class MessageAsset(SQLModel, table=True):
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	9 id: uuid.UUID = Field(
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	10 default_factory=uuid.uuid4,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	11 primary_key=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	12 index=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	13 nullable=False,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	14 sa_column_kwargs={"server_default": text("gen_random_uuid()")},
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	15 )
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	16 message_id: uuid.UUID = Field(foreign_key="message.id", index=True)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	17 asset_type: str = Field(index=True) # "image" \| "file" \| "audio" \| "video" \| etc.
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	18 url: str = Field() # public or signed URL
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	19 # Pretty good suggestions but not needed for now.
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	20 # filename: Optional[str] = Field(default=None)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	21 # mime_type: Optional[str] = Field(default=None)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	22 # width: Optional[int] = Field(default=None) # for images/videos
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	23 # height: Optional[int] = Field(default=None)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	24 # size_bytes: Optional[int] = Field(default=None)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	25 # alt_text: Optional[str] = Field(default=None) # user-provided description
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	26 created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	27
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	28 # Relationship back to message
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	29 message: "Message" = Relationship(back_populates="assets")
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	30
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	31 class Message(SQLModel, table=True):
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	32 id: uuid.UUID = Field(
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	33 default_factory=uuid.uuid4,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	34 primary_key=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	35 index=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	36 nullable=False,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	37 sa_column_kwargs={"server_default": text("gen_random_uuid()")},
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	38 )
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	39 chat_id: uuid.UUID = Field(foreign_key="chat.id")
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	40
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	41 role: str = Field(
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	42 index=True
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	43 ) # "user" \| "assistant" TODO: use enum? I don't mind just defining like this tho.
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	44 content: str
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	45 created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	46
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	47 # Relationship
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	48 chat: Optional["Chat"] = Relationship(back_populates="messages")
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	49 assets: List[MessageAsset] = Relationship(back_populates="message")
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	50
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	51 class Chat(SQLModel, table=True):
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	52 id: uuid.UUID = Field(
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	53 default_factory=uuid.uuid4,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	54 primary_key=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	55 index=True,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	56 nullable=False,
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	57 sa_column_kwargs={"server_default": text("gen_random_uuid()")},
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	58 )
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	59
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	60 title: str = Field(default="New Chat")
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	61 created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	62
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	63 # Relationship
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	64 messages: List[Message] = Relationship(
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	65 back_populates="chat", sa_relationship_kwargs={"cascade": "all, delete-orphan"}
cf9caa4abc3e [Love] FE and BE. Can chat and render images. Also created MCP for powerpoint generations. MrJuneJune <me@mrjunejune.com> parents: diff changeset	66 )

Mercurial

annotate love/poppy/db/models.py @ 71:75de5903355c