hackathon-2-phase-3 / src /models /custom_data.py
codeverseinnovation
updarte code
9f99698
Raw History Blame Contribute Delete
1.49 kB
from datetime import datetime
from uuid import UUID, uuid4
from sqlmodel import SQLModel, Field
from sqlalchemy import Column, String, Text, DateTime
from typing import Optional
class CustomDataBase(SQLModel):
name: str = Field(sa_column=Column(String(255), nullable=False))
description: Optional[str] = Field(default=None, sa_column=Column(Text, nullable=True))
category: Optional[str] = Field(default=None, sa_column=Column(String(100), nullable=True))
class CustomData(CustomDataBase, table=True):
"""
Custom data table for storing additional application data.
"""
__tablename__ = "custom_data"
id: UUID = Field(default_factory=uuid4, primary_key=True)
name: str = Field(sa_column=Column(String(255), nullable=False))
description: Optional[str] = Field(default=None, sa_column=Column(Text, nullable=True))
category: Optional[str] = Field(default=None, sa_column=Column(String(100), nullable=True))
created_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
updated_at: datetime = Field(default_factory=datetime.utcnow, nullable=False)
class CustomDataCreate(CustomDataBase):
name: str
description: Optional[str] = None
category: Optional[str] = None
class CustomDataUpdate(SQLModel):
name: Optional[str] = None
description: Optional[str] = None
category: Optional[str] = None
class CustomDataRead(CustomDataBase):
id: UUID
created_at: datetime
updated_at: datetime