TREPRFilter

class specatalog.crud_db.read.TREPRFilter(*, id=None, id__gt=None, id__lt=None, id__ge=None, id__le=None, id__ne=None, molecular_id=None, molecular_id__gt=None, molecular_id__lt=None, molecular_id__ge=None, molecular_id__le=None, molecular_id__ne=None, method=None, method__like=None, method__ilike=None, method__contains=None, temperature=None, temperature__gt=None, temperature__lt=None, temperature__ge=None, temperature__le=None, temperature__ne=None, solvent=None, concentration=None, date=None, date__gt=None, date__lt=None, date__ge=None, date__le=None, date__ne=None, measured_by=None, location=None, device=None, series=None, path=None, path__like=None, path__ilike=None, path__contains=None, corrected=None, evaluated=None, created_at=None, created_at__gt=None, created_at__lt=None, created_at__ge=None, created_at__le=None, created_at__ne=None, updated_at=None, updated_at__gt=None, updated_at__lt=None, updated_at__ge=None, updated_at__le=None, updated_at__ne=None, frequency_band=None, excitation_wl=None, excitation_wl__gt=None, excitation_wl__lt=None, excitation_wl__ge=None, excitation_wl__le=None, excitation_wl__ne=None, excitation_energy=None, attenuation=None, attenuation__like=None, attenuation__ilike=None, attenuation__contains=None, number_of_scans=None, repetitionrate=None, mode=None)

Pydantic filter model for TREPR.

The following operators can (but do not have to) be applied to the attributes by appending the operator to the field name, e.g. temperature__gt=20 (-> temperature > 20):

• gt: greater than

• lt: less than

• ge: greater than or equal to

• le: less than or equal to

• ne: not equal

• like: SQL LIKE pattern match

• ilike: case-insensitive LIKE

• contains: substring match (for strings)

The following fields can be selected:

• id: int

• id__gt: int

• id__lt: int

• id__ge: int

• id__le: int

• id__ne: int

• molecular_id: int

• molecular_id__gt: int

• molecular_id__lt: int

• molecular_id__ge: int

• molecular_id__le: int

• molecular_id__ne: int

• method: str

• method__like: str

• method__ilike: str

• method__contains: str

• temperature: float

• temperature__gt: float

• temperature__lt: float

• temperature__ge: float

• temperature__le: float

• temperature__ne: float

• solvent: Solvents

• concentration: str

• date: date

• date__gt: date

• date__lt: date

• date__ge: date

• date__le: date

• date__ne: date

• measured_by: Names

• location: str

• device: Devices

• series: str

• path: str

• path__like: str

• path__ilike: str

• path__contains: str

• corrected: bool

• evaluated: bool

• created_at: datetime

• created_at__gt: datetime

• created_at__lt: datetime

• created_at__ge: datetime

• created_at__le: datetime

• created_at__ne: datetime

• updated_at: datetime

• updated_at__gt: datetime

• updated_at__lt: datetime

• updated_at__ge: datetime

• updated_at__le: datetime

• updated_at__ne: datetime

• frequency_band: FrequencyBands

• excitation_wl: float

• excitation_wl__gt: float

• excitation_wl__lt: float

• excitation_wl__ge: float

• excitation_wl__le: float

• excitation_wl__ne: float

• excitation_energy: float

• attenuation: str

• attenuation__like: str

• attenuation__ilike: str

• attenuation__contains: str

• number_of_scans: int

• repetitionrate: float

• mode: str

Parameters:

• id (int | None)

• id__gt (int | None)

• id__lt (int | None)

• id__ge (int | None)

• id__le (int | None)

• id__ne (int | None)

• molecular_id (int | None)

• molecular_id__gt (int | None)

• molecular_id__lt (int | None)

• molecular_id__ge (int | None)

• molecular_id__le (int | None)

• molecular_id__ne (int | None)

• method (str | None)

• method__like (str | None)

• method__ilike (str | None)

• method__contains (str | None)

• temperature (float | None)

• temperature__gt (float | None)

• temperature__lt (float | None)

• temperature__ge (float | None)

• temperature__le (float | None)

• temperature__ne (float | None)

• solvent (Solvents | None)

• concentration (str | None)

• date (date | None)

• date__gt (date | None)

• date__lt (date | None)

• date__ge (date | None)

• date__le (date | None)

• date__ne (date | None)

• measured_by (Names | None)

• location (str | None)

• device (Devices | None)

• series (str | None)

• path (str | None)

• path__like (str | None)

• path__ilike (str | None)

• path__contains (str | None)

• corrected (bool | None)

• evaluated (bool | None)

• created_at (datetime | None)

• created_at__gt (datetime | None)

• created_at__lt (datetime | None)

• created_at__ge (datetime | None)

• created_at__le (datetime | None)

• created_at__ne (datetime | None)

• updated_at (datetime | None)

• updated_at__gt (datetime | None)

• updated_at__lt (datetime | None)

• updated_at__ge (datetime | None)

• updated_at__le (datetime | None)

• updated_at__ne (datetime | None)

• frequency_band (FrequencyBands | None)

• excitation_wl (float | None)

• excitation_wl__gt (float | None)

• excitation_wl__lt (float | None)

• excitation_wl__ge (float | None)

• excitation_wl__le (float | None)

• excitation_wl__ne (float | None)

• excitation_energy (float | None)

• attenuation (str | None)

• attenuation__like (str | None)

• attenuation__ilike (str | None)

• attenuation__contains (str | None)

• number_of_scans (int | None)

• repetitionrate (float | None)

• mode (str | None)