aboutsummaryrefslogtreecommitdiff
path: root/qc_app/dbinsert.py
AgeCommit message (Collapse)Author
2024-04-17Use `cursor.lastrowid` to get row identifierFrederick Muriuki Muriithi
Use the more robust `cursor.lastrowid` to get the row identifier value, rather than using the `SELECT MAX(Id) …` form. With the `cursor.lastrowid` form, we do not have to remember to add 1 to the value to avoid conflict.
2024-03-19Query by `Id` rather than `ProbeFreezeId`Frederick Muriuki Muriithi
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`.
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.Frederick Muriuki Muriithi
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.
2023-11-30Handle duplicate dataset creation errorFrederick Muriuki Muriithi
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.
2023-11-15Provide default `AuthorisedUsers` value.Frederick Muriuki Muriithi
2023-10-18Explicitly specify columnsFrederick Muriuki Muriithi
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.
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 outputsFrederick Muriuki Muriithi
* 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
2022-08-04Implement data insertionFrederick Muriuki Muriithi
- Hook up external data insertion script to webserver code - Provide rudimentary status indication - Generalise some job creation details
2022-08-04Fix typo: 'species' -> 'speciesid'Frederick Muriuki Muriithi
2022-07-19Implement confirmation stageFrederick Muriuki Muriithi
Provide user with a confirmation stage where they can verify all the data before inserting into the database.
2022-07-19Enable creation of new datasetFrederick Muriuki Muriithi
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
2022-07-19Replace redirect with user confirmationFrederick Muriuki Muriithi
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.
2022-07-19Implement dataset selectionFrederick Muriuki Muriithi
- Implement UI enabling selection from existing datasets - Start implementation of UI that enables creation of new dataset
2022-07-19Implement study creationFrederick Muriuki Muriithi
Enable the creation of the new study, and redirect appropriately with the new study id.
2022-07-19Add 'group' and 'tissue' selection.Frederick Muriuki Muriithi
- 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
2022-07-19Implement select studyFrederick Muriuki Muriithi
Implement the select study UI
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 codeFrederick Muriuki Muriithi
The filetype determines the queries to be run to update the database, therefore, this commit adds filetype information.
2022-07-07Provide selection for GeneChipsFrederick Muriuki Muriithi
The GeneChipId value is required for the data being inserted, so this commit provides the UI to enable selection of the chip.
2022-07-06Implement UI for dataset selectionFrederick Muriuki Muriithi
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.