File size: 1,378 Bytes
daeb635
 
 
 
 
 
 
 
 
ed0670a
daeb635
 
3d2c240
 
daeb635
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
from sqlmodel import SQLModel, Field, Relationship
from typing import Optional, List
import uuid
from datetime import datetime

class Note(SQLModel, table=True):
    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
    user_id: uuid.UUID = Field(index=True)
    category_id: Optional[uuid.UUID] = Field(default=None, foreign_key="category.id")
    title: Optional[str] = None
    content: Optional[str] = None # Text content (Markdown)
    order_index: float = Field(default=0.0)
    is_archived: bool = Field(default=False)
    archived_at: Optional[datetime] = Field(default=None)
    created_at: datetime = Field(default_factory=datetime.utcnow)
    updated_at: datetime = Field(default_factory=datetime.utcnow)

    # Relationship to MediaAsset
    media_assets: List["MediaAsset"] = Relationship(back_populates="note", sa_relationship_kwargs={"cascade": "all, delete-orphan"})

class MediaAsset(SQLModel, table=True):
    __tablename__ = "media_asset" # Explicit table name to avoid potential conflicts
    
    id: uuid.UUID = Field(default_factory=uuid.uuid4, primary_key=True)
    note_id: uuid.UUID = Field(foreign_key="note.id")
    mime_type: str
    data: bytes # BLOB storage
    created_at: datetime = Field(default_factory=datetime.utcnow)

    # Relationship back to Note
    note: Optional[Note] = Relationship(back_populates="media_assets")