Spaces:
Sleeping
Sleeping
File size: 5,266 Bytes
6ea020b | 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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 | # 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()
|