crud_db

The crud_db-package provides modules for the manipulation of the database. This includes creation, reading, update and deletion.

create

create_new_measurement(data)	Create a new database entry for the measurement table.
create_new_molecule(data)	Create a new database entry for the molecule table.

read

run_query(filters[, ordering])

Query the database.

FilterModels

MeasurementFilter	Pydantic filter model for Measurement.
CWEPRFilter	Pydantic filter model for CWEPR.
TREPRFilter	Pydantic filter model for TREPR.
PulseEPRFilter	Pydantic filter model for PulseEPR.
UVVisFilter	Pydantic filter model for UVVis.
FluorescenceFilter	Pydantic filter model for Fluorescence.
TAFilter	Pydantic filter model for TA.
MoleculeFilter	Pydantic filter model for Molecule.
SingleMoleculeFilter	Pydantic filter model for SingleMolecule.
RPFilter	Pydantic filter model for RP.
TDPFilter	Pydantic filter model for TDP.
TTPFilter	Pydantic filter model for TTP.

OrderingModels

MeasurementOrdering	Pydantic ordering model for Measurement.
CWEPROrdering	Pydantic ordering model for CWEPR.
TREPROrdering	Pydantic ordering model for TREPR.
PulseEPROrdering	Pydantic ordering model for PulseEPR.
UVVisOrdering	Pydantic ordering model for UVVis.
FluorescenceOrdering	Pydantic ordering model for Fluorescence.
TAOrdering	Pydantic ordering model for TA.
MoleculeOrdering	Pydantic ordering model for Molecule.
SingleMoleculeOrdering	Pydantic ordering model for SingleMolecule.
RPOrdering	Pydantic ordering model for RP.
TDPOrdering	Pydantic ordering model for TDP.
TTPOrdering	Pydantic ordering model for TTP.

update

update_model(entry, update_data)

Update a database entry using an update model.

UpdateModels

MeasurementUpdate	Pydantic update model for Measurement.
CWEPRUpdate	Pydantic update model for CWEPR.
TREPRUpdate	Pydantic update model for TREPR.
PulseEPRUpdate	Pydantic update model for PulseEPR.
UVVisUpdate	Pydantic update model for UVVis.
FluorescenceUpdate	Pydantic update model for Fluorescence.
TAUpdate	Pydantic update model for TA.
MoleculeUpdate	Pydantic update model for Molecule.
SingleMoleculeUpdate	Pydantic update model for SingleMolecule.
RPUpdate	Pydantic update model for RP.
TDPUpdate	Pydantic update model for TDP.
TTPUpdate	Pydantic update model for TTP.

delete

delete_object(obj)	Delete an entry from the database.
delete_molecule(mol_id)	Delete an entry from the molecule table with a given molecular-id.
delete_measurement(ms_id)	Delete an entry from the measurement table with a given measurement-id.