aboutsummaryrefslogtreecommitdiff
path: root/gn3/db
AgeCommit message (Expand)Author
2021-08-05db: traits: Return unique values when fetching sample dataBonfaceKilz
2021-08-05Reorganise the database codeMuriithi Frederick Muriuki
2021-08-05Build up trait_name items from full nameMuriithi Frederick Muriuki
2021-08-04Fix issues caught by pylintMuriithi Frederick Muriuki
2021-08-04Retrieve the RISet and RISet ID valuesMuriithi Frederick Muriuki
2021-08-04Add tests for post-processing functionsMuriithi Frederick Muriuki
2021-08-04Avoid string interpolation: use prepared statementMuriithi Frederick Muriuki
2021-07-30Rework db functions to enable postprocessingMuriithi Frederick Muriuki
2021-07-30Return dict from query functionsMuriithi Frederick Muriuki
2021-07-29Merge branch 'main' into Feature/Update-db-from-csv-dataBonfaceKilz
2021-07-29Delete "update_raw" and it's test-casesBonfaceKilz
2021-07-29Add method for updating values from a sample datasetBonfaceKilz
2021-07-29Add type annotations to the functionMuriithi Frederick Muriuki
2021-07-29Retrieve trait informationMuriithi Frederick Muriuki
2021-07-29Make name retrieval more generalMuriithi Frederick Muriuki
2021-07-29Retrieve 'ProbeSet' trait nameMuriithi Frederick Muriuki
2021-07-29db: traits: Remove publishdata columnBonfaceKilz
2021-07-26gn3: db: Create a raw update queryBonfaceKilz
2021-07-26db: traits: Fetch sample_data from a trait in csv formBonfaceKilz
2021-07-26db: traits: Remove unused functionsBonfaceKilz
2021-07-10gn3: db: Use correct type for columns arg in fetch functionsBonfaceKilz
2021-07-10Fix pylint issuesBonfaceKilz
2021-07-10gn3: db: Add extra argument to specify column in fetch statementsBonfaceKilz
2021-07-10db: phenotypes: Add Probeset data structuresBonfaceKilz
2021-06-07Rename json_data column to json_diff_dataBonfaceKilz
2021-06-07gn3: db: Fix how columns from tables is resolvedBonfaceKilz
2021-06-07gn3: db: Add "id_" property to metadata_audit class and mappingBonfaceKilz
2021-06-07gn3: db: Add "fetchall" method.BonfaceKilz
2021-06-07gn3: metadata_audit: Make props for MetadataAudit class optionalBonfaceKilz
2021-06-07gn3: db: Make "WHERE" clause optionalBonfaceKilz
2021-06-07gn3: db: Use correct DATACLASSMAP entry from metadata_auditBonfaceKilz
2021-06-07gn3: db: sort importsBonfaceKilz
2021-06-03gn3: db: Remove "escape_string" from importsBonfaceKilz
2021-06-03Use prepared statements for FETCH sql functionBonfaceKilz
2021-06-03gn3: db: Replace items() with keys()BonfaceKilz
2021-06-03Use prepared statements for UPDATE sql functionBonfaceKilz
2021-06-03gn3: db: Add new function for doing sql INSERTBonfaceKilz
2021-06-03Add data structures for the table metadata_auditBonfaceKilz
2021-06-03gn3: db: Add spacing before around "AND" in sql clauseBonfaceKilz
2021-06-03Get the diff between 2 dicts and return that as a dictBonfaceKilz
2021-06-03gn3: db: Return None if data and where are emptyBonfaceKilz
2021-05-26Move the methods, "update" and "fetch", to gn3.dbBonfaceKilz
2021-05-26db: phenotypes: Fix publication_mappingBonfaceKilz
2021-05-26db: phenotypes: Fix typoBonfaceKilz
2021-05-20db: phenotypes: Add function for fetching a single resultBonfaceKilz
2021-05-20db: phenotypes: Add a dataclass mapBonfaceKilz
2021-05-20db: phenotypes: Add Publication table mappingBonfaceKilz
2021-05-20db: phenotypes: Rename phenotype_column_mappingBonfaceKilz
2021-05-20db: phenotypes: Add Publication dataclass and mappingBonfaceKilz
2021-05-20db: phenotypes: Generalise the update functionBonfaceKilz