aboutsummaryrefslogtreecommitdiff
path: root/qc_app/db/populations.py
AgeCommit message (Collapse)Author
2024-05-05Provide default for InbredSetIdFrederick Muriuki Muriithi
The `InbredSetId` field in the `InbredSet` table in MariaDB is in some instances a required field, so we need to provide a value. This value should be the same as that for the `Id` field, that we do not previously know. This commit provides a value of zero (0) as the default. This value is subsequently updated to be same as that of the `Id` field.
2024-04-16Set InbredSet.InbredSetId value in a more robust way.Frederick Muriuki Muriithi
2024-02-02Bug: Specify DictCursor class to return dict-like resultFrederick Muriuki Muriithi
Without specifying the `cursorclass`, the result is a tuple of the form: ((query_col01_val, query_col02_val, ...), ...) where the ellipsis specify the possibility of more than one of the previous form. We specify the DictCursor class instead so that the form changes to: ({query_col01_name: query_col01_val, ...}, ...) which allows us to pick the value we want with a string index.
2024-01-08Extract common database functions into a separate package.Frederick Muriuki Muriithi