File size: 2,032 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
# app/models/inventory.py
# Supply, Inventory, and CalControl models.

from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship


class Supply(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    name: str = Field(index=True)
    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


class Inventory(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    material_type: str = Field(index=True)
    test_id: Optional[int] = Field(default=None, foreign_key="testdefinition.id")
    supply_id: Optional[int] = Field(default=None, foreign_key="supply.id")
    test: Optional["TestDefinition"] = Relationship()
    supply: Optional["Supply"] = Relationship()
    quantity: float = Field(default=0.0)
    unit: str = Field(default="Test")
    expiration_date: datetime
    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


class CalControl(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    test_id: int = Field(foreign_key="testdefinition.id", index=True)
    device_id: int = Field(foreign_key="device.id", index=True)
    process_type: str = Field(index=True)
    quantity: float
    note: Optional[str] = None
    created_by: Optional[int] = Field(default=None, foreign_key="user.id")
    created_at: datetime = Field(default_factory=datetime.now)
    test: "TestDefinition" = Relationship()
    device: "Device" = Relationship()