MoleculeFilter

class specatalog.crud_db.read.MoleculeFilter(*, id=None, id__gt=None, id__lt=None, id__ge=None, id__le=None, id__ne=None, name=None, name__like=None, name__ilike=None, name__contains=None, molecular_formula=None, structural_formula=None, structural_formula__like=None, structural_formula__ilike=None, structural_formula__contains=None, additional_info=None, group=None, group__like=None, group__ilike=None, group__contains=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)

Pydantic filter model for Molecule.

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

  • name: str

  • name__like: str

  • name__ilike: str

  • name__contains: str

  • molecular_formula: str

  • structural_formula: str

  • structural_formula__like: str

  • structural_formula__ilike: str

  • structural_formula__contains: str

  • additional_info: str

  • group: str

  • group__like: str

  • group__ilike: str

  • group__contains: str

  • 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

Parameters:

  • id (int | None)

  • id__gt (int | None)

  • id__lt (int | None)

  • id__ge (int | None)

  • id__le (int | None)

  • id__ne (int | None)

  • name (str | None)

  • name__like (str | None)

  • name__ilike (str | None)

  • name__contains (str | None)

  • molecular_formula (str | None)

  • structural_formula (str | None)

  • structural_formula__like (str | None)

  • structural_formula__ilike (str | None)

  • structural_formula__contains (str | None)

  • additional_info (str | None)

  • group (str | None)

  • group__like (str | None)

  • group__ilike (str | None)

  • group__contains (str | 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)