Spaces:
Sleeping
Sleeping
Download app/models/test.py from alisaleem97/NexLab_System: direct link, hf CLI and curl.
- Browser
- Download file 5.27 kB
-
https://huggingface.co/spaces/alisaleem97/NexLab_System/resolve/main/app/models/test.py
- Command line
-
hf download hf://spaces/alisaleem97/NexLab_System/app/models/test.py
-
curl -L -o test.py https://huggingface.co/spaces/alisaleem97/NexLab_System/resolve/main/app/models/test.py
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() | |