aboutsummaryrefslogtreecommitdiff
path: root/qc_app/dbinsert.py
AgeCommit message (Expand)Author
2024-03-19Query by `Id` rather than `ProbeFreezeId`...Previously `ProbeFreezeId` was set as 1 more than the largest `Id` value found, which might not end up being the same as the incremented Id. This commit, thus, queries by `Id` which is more robust, and does an actual update for the `ProbeFreezeId` column to make it same value as `Id`. Frederick Muriuki Muriithi
2024-01-24Checks: Update code and tests to ensure all checks pass.Frederick Muriuki Muriithi
2024-01-24redis-prefix: Update "insert data" path.Frederick Muriuki Muriithi
2024-01-08Use extracted functions and fix bugsFrederick Muriuki Muriithi
2024-01-08Extract common database functions into a separate package.Frederick Muriuki Muriithi
2023-12-14Pass connection to `species_by_id` function....To make `species_by_id` function reusable even outside of the application context, pass in the database connection instead of creating the connection inside the function. Frederick Muriuki Muriithi
2023-11-30Handle duplicate dataset creation error...Notify the user when they try to create a new dataset that has the same name as an existing dataset and give them the chance to fix it before continuing. Frederick Muriuki Muriithi
2023-11-15Provide default `AuthorisedUsers` value.Frederick Muriuki Muriithi
2023-10-18Explicitly specify columns...Due to possible schema differences between local small db on development computer and those on CI/CD and Production, explicitly specify the columns being operated on by the queries. Frederick Muriuki Muriithi
2023-10-16Indicate progress for data insert.Frederick Muriuki Muriithi
2023-10-16Link study to ProbeSetFreeze table.Frederick Muriuki Muriithi
2022-08-05Update job status. Display stdout and stderr outputs...* Display the status of the job, as it is running * Display STDERR output if an error occurs * Display STDOUT output as job is running and on successful completion of the job Frederick Muriuki Muriithi
2022-08-04Implement data insertion...- Hook up external data insertion script to webserver code - Provide rudimentary status indication - Generalise some job creation details Frederick Muriuki Muriithi
2022-08-04Fix typo: 'species' -> 'speciesid'Frederick Muriuki Muriithi
2022-07-19Implement confirmation stage...Provide user with a confirmation stage where they can verify all the data before inserting into the database. Frederick Muriuki Muriithi
2022-07-19Enable creation of new dataset...Enable the user to create a new dataset should the need arise. A few extra fixes were done, such as: - Provide list of average methods to choose from - Provide input elements for some expected fields - Add a new confirmation step before doing the actual data update Frederick Muriuki Muriithi
2022-07-19Replace redirect with user confirmation...Rather than using the redirect, that led to exposing the study id as a get parameter, this commit adds an auxilliary step that allows the user to choose whether to continue with the new study or go back and select an existing study. Frederick Muriuki Muriithi
2022-07-19Implement dataset selection...- Implement UI enabling selection from existing datasets - Start implementation of UI that enables creation of new dataset Frederick Muriuki Muriithi
2022-07-19Implement study creation...Enable the creation of the new study, and redirect appropriately with the new study id. Frederick Muriuki Muriithi
2022-07-19Add 'group' and 'tissue' selection....- Build code to populate the "Group" and "Tissue" dropdown lists - Enable redirect with POST data (code 307) in case there is input error to enable the user fix their errors - Move hidden fields to macro to reduce repetition Frederick Muriuki Muriithi
2022-07-19Implement select study...Implement the select study UI Frederick Muriuki Muriithi
2022-07-19Select the platform (GeneChipId) firstFrederick Muriuki Muriithi
2022-07-07Fix linting and typing errorsFrederick Muriuki Muriithi
2022-07-07Add filetype details to database update code...The filetype determines the queries to be run to update the database, therefore, this commit adds filetype information. Frederick Muriuki Muriithi
2022-07-07Provide selection for GeneChips...The GeneChipId value is required for the data being inserted, so this commit provides the UI to enable selection of the chip. Frederick Muriuki Muriithi
2022-07-06Implement UI for dataset selection...As part of updating the database with the new data, there is a need to select the appropriate dataset that the data belongs to, and this commit provides the UI to assist the user do that. Frederick Muriuki Muriithi