NexLab_System / app /models /test.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
5.27 kB
# app/models/test.py
# Test definition, test-device/parameter links, ranges, and result types.
from typing import Optional, List
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
from app.models.department import Department, SampleType, ReportNote, Device, Parameter
class TestDefinition(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_name: str = Field(unique=True, index=True)
test_short_name: str
department_id: int = Field(foreign_key="department.id")
sample_type_id: int = Field(foreign_key="sampletype.id")
report_note_id: Optional[int] = Field(default=None, foreign_key="reportnote.id")
price: float
test_note: Optional[str] = None
test_condition: Optional[str] = None
is_available: bool = Field(default=True)
print_separately: bool = Field(default=False)
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
# Relationships
department: Department = Relationship()
sample_type: SampleType = Relationship()
report_note: Optional[ReportNote] = Relationship()
test_devices: List["TestDevice"] = Relationship(back_populates="test")
test_parameters: List["TestParameter"] = Relationship(back_populates="test")
class TestDevice(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_id: int = Field(foreign_key="testdefinition.id")
device_id: int = Field(foreign_key="device.id")
test: TestDefinition = Relationship(back_populates="test_devices")
device: Device = Relationship()
class TestParameter(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_id: int = Field(foreign_key="testdefinition.id")
parameter_id: int = Field(foreign_key="parameter.id")
test: TestDefinition = Relationship(back_populates="test_parameters")
parameter: Parameter = Relationship()
class TestRange(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_id: int = Field(foreign_key="testdefinition.id")
parameter_id: Optional[int] = Field(default=None, foreign_key="parameter.id")
device_id: Optional[int] = Field(default=None, foreign_key="device.id")
unit: str = Field(default="")
gender_type: str = Field(default="both")
age_from: int = Field(default=0)
age_from_unit: str = Field(default="year")
age_to: int = Field(default=999)
age_to_unit: str = Field(default="year")
age_unit: str = Field(default="year")
fasting_required: bool = Field(default=False)
range_type: str = Field(default="number")
normal_from: Optional[float] = Field(default=None)
normal_to: Optional[float] = Field(default=None)
vlow_from: Optional[float] = Field(default=None)
vlow_to: Optional[float] = Field(default=None)
low_from: Optional[float] = Field(default=None)
low_to: Optional[float] = Field(default=None)
midlow_from: Optional[float] = Field(default=None)
midlow_to: Optional[float] = Field(default=None)
midhigh_from: Optional[float] = Field(default=None)
midhigh_to: Optional[float] = Field(default=None)
high_from: Optional[float] = Field(default=None)
high_to: Optional[float] = Field(default=None)
vhigh_from: Optional[float] = Field(default=None)
vhigh_to: Optional[float] = Field(default=None)
panic_less_than: Optional[float] = Field(default=None)
panic_more_than: Optional[float] = Field(default=None)
text_range: Optional[str] = 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
test: TestDefinition = Relationship()
parameter: Optional[Parameter] = Relationship()
device: Optional[Device] = Relationship()
class TestResultType(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_id: int = Field(foreign_key="testdefinition.id")
parameter_id: Optional[int] = Field(default=None, foreign_key="parameter.id")
result_type: str = Field(default="number")
selection_options: Optional[str] = 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
test: TestDefinition = Relationship()
parameter: Optional[Parameter] = Relationship()