aboutsummaryrefslogtreecommitdiff
path: root/qc_app/db
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-04-16bug: Set ProbeFreezeId for only new row!Frederick Muriuki Muriithi
Previously the extra ProbeFreezeId column was being updated for *ALL* rows, rather than just the newly inserted row, which is a bug. This commit fixes that.
2024-04-12Provide defaults for required field.Frederick Muriuki Muriithi
2024-04-12Consistently check for possibly non-existent dataFrederick Muriuki Muriithi
The "geno-dataset", "tissue", "pheno-study" and "pheno-dataset" data "objects" might not exist for a particular uploaded bundle, so we check in a consistent manner to ensure they are provided when needed.
2024-04-12Provide tissue-id details to probeset dataset templatesFrederick Muriuki Muriithi
2024-03-29Add UI to select/create tissue.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-18UI: Display summary information.Frederick Muriuki Muriithi
2024-01-18UI: Create new ProbeSet dataset.Frederick Muriuki Muriithi
2024-01-18Create new ProbeSet study.Frederick Muriuki Muriithi
2024-01-17UI: Select ProbeSet study.Frederick Muriuki Muriithi
2024-01-17UI: Initialise summary page.Frederick Muriuki Muriithi
2024-01-16UI: Create UI to select from existing genotype datasets.Frederick Muriuki Muriithi
2024-01-08Extract common database functions into a separate package.Frederick Muriuki Muriithi