NexLab_System / app /models /package.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
1.96 kB
# app/models/package.py
# Package, PackageTest, and Partner models.
from typing import Optional, List
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Partner(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
partner_name: str = Field(unique=True, index=True)
partner_note: Optional[str] = None
partner_contact: Optional[str] = None
partner_weight: Optional[float] = Field(default=None)
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
class Package(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
package_name: str = Field(unique=True, index=True)
package_short_name: str
price: float
package_note: Optional[str] = None
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
deleted_by: Optional[int] = Field(default=None, foreign_key="user.id")
deleted_at: Optional[datetime] = None
package_tests: List["PackageTest"] = Relationship(back_populates="package")
class PackageTest(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
package_id: int = Field(foreign_key="package.id")
test_id: int = Field(foreign_key="testdefinition.id")
package: Package = Relationship(back_populates="package_tests")
test: "TestDefinition" = Relationship()