aboutsummaryrefslogtreecommitdiff
path: root/scripts/insert_data.py
AgeCommit message (Expand)Author
2023-11-30Bug: Fix insertion error...Fix a bug that was causing the data insertion to fail. Frederick Muriuki Muriithi
2023-11-30Fix errors caught by pylint and mypy.Frederick Muriuki Muriithi
2023-11-15Log out DB errors even when handled...Log out any DB errors that occur to help with tracking and debugging failures. Frederick Muriuki Muriithi
2023-11-15Remove debugging statement.Frederick Muriuki Muriithi
2023-11-15Bug: Insert ProbeSets before average data and cross-refs...Insert the ProbeSets first before inserting the average data and cross-referencing it. Frederick Muriuki Muriithi
2023-11-15mypy: Fix typing errors.Frederick Muriuki Muriithi
2023-11-15Linting: Fix linting errors.Frederick Muriuki Muriithi
2023-10-30Prevent overwrite. Avoid inserting same probeset multiple times....* Avoid overwriting existing data by adding a random string to the name of the ProbeSet * Read ProbeSet names separately from the means for the strains, to avoid entering the same ProbeSet record over and over with varying names. Frederick Muriuki Muriithi
2023-10-18Link to `ProbeSet.Id` in XRef Table...The "ProbeSetId" value in the file is actually stored in the database in the `ProbeSet.Name` field, whereas the `ProbeSetXRef` table actually uses the `ProbeSet.Id` value to define the relationships. This commit fixes that issue. Frederick Muriuki Muriithi
2023-10-16Fix bug: Insert ProbeSets if they do not exist.Frederick Muriuki Muriithi
2023-10-16Fix bug: Provide the platform_id to `insert_means`Frederick Muriuki Muriithi
2023-10-16Fix bug: parsing fields from query.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-04Format queries for output. Get rid of extraneous output.Frederick Muriuki Muriithi
2022-07-19Save standard error data. Fix linting and typing errors.Frederick Muriuki Muriithi
2022-07-19Implement data insertion (averages/means)...* quality_control/file_utils.py (new file): extract common file utilities. * quality_control/parsing.py (refactor): extract common file utilities. * scripts/insert_data.py: Implement data insertion for averages/means Frederick Muriuki Muriithi