aboutsummaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
10 daysExtract building of data items into helper function.Frederick Muriuki Muriithi
10 daysIncrease number of rows per query.Frederick Muriuki Muriithi
10 daysDebug the query: useful to figure out what's happening.Frederick Muriuki Muriithi
10 daysMemory saving: Don't reload saved dataFrederick Muriuki Muriithi
We already have all the data in memory, so we do not need to reload it and keep yet another copy.
11 daysCompute data in files lazily.Frederick Muriuki Muriithi
11 daysProcess NA-strings in the worker script.Frederick Muriuki Muriithi
11 daysAdd note in documentation.Frederick Muriuki Muriithi
11 daysRevert "Convert N/A values to NoneType objects."Frederick Muriuki Muriithi
This reverts commit 6870c08d484f482cc2f2501d28b474636dd0810d. The "read_csv_file" should return the data in the CSV file, as is, before processing the N/A values.
11 daysUpdate placeholder functionFrederick Muriuki Muriithi
We'll probably provide a token to use to update the authorisation for the new data. The commit also explicitly raises a `NotImplement` exception for now.
11 daysAdd missing import.Frederick Muriuki Muriithi
11 daysFix bug: Compute data correctly. Replace N/A strings with NoneType.Frederick Muriuki Muriithi
11 daysAdd some debugging statements.Frederick Muriuki Muriithi
11 daysParametrize the "DataId" column for different tables.Frederick Muriuki Muriithi
11 daysExplicitly query for newly entered data.Frederick Muriuki Muriithi
The `cursor.executemany()` call only returned the last row that was inserted, rather than ALL the rows. This is not the correct thing to do, therefore, this commit fixes that by explicitly querying for all the newly entered data.
11 daysConvert N/A values to NoneType objects.Frederick Muriuki Muriithi
11 daysPass the phenotypes name-to-id map to functions.Frederick Muriuki Muriithi
11 daysCompute the map from a phenotype's name to its ID.Frederick Muriuki Muriithi
2025-05-30Refactor: Extract common pattern into separate functionFrederick Muriuki Muriithi
Extract the common pattern into a separate, more generalized function and pass the new function the data it requires to perform its tasks for the different file types.
2025-05-30Add typing to load_data function and invoke it.Frederick Muriuki Muriithi
2025-05-30Save standard errors and counts.Frederick Muriuki Muriithi
2025-05-30Get the species, population and dataset.Frederick Muriuki Muriithi
2025-05-30Add more tables to lock list.Frederick Muriuki Muriithi
2025-05-30Fix query: Add missing field and parameter.Frederick Muriuki Muriithi
2025-05-30Fix function names.Frederick Muriuki Muriithi
2025-05-30Fix processing of numerical data to save to the database.Frederick Muriuki Muriithi
2025-05-30Fix file paths: append the path to the extraction directory.Frederick Muriuki Muriithi
2025-05-30Add new file type.Frederick Muriuki Muriithi
2025-05-30Add dataset_id and bundle path to job metadata.Frederick Muriuki Muriithi
2025-05-30Fix typo: Fix table name.Frederick Muriuki Muriithi
2025-05-30Bug: Loop until the data is exhausted.Frederick Muriuki Muriithi
2025-05-30Fix typo, and bug.Frederick Muriuki Muriithi
2025-05-30Fix indentation.Frederick Muriuki Muriithi
2025-05-30Refactor out common `__row_to_dataitems__` function.Frederick Muriuki Muriithi
2025-05-30Use full table names rather than aliasesFrederick Muriuki Muriithi
Using aliases leads to errors when you have to use table locking to prevent data corruption. This commit updates queries to use the full table names rather than aliases, in order to prevent such troubles.
2025-05-28Bug: Fix actual data value, not result set.Frederick Muriuki Muriithi
2025-05-28Bug: Add missing commas.Frederick Muriuki Muriithi
2025-05-28Maintain single list of tables — build logs and query from listFrederick Muriuki Muriithi
Maintain a list of tables to lock when running the script and build the logging messages, and lock query from the list for easier maintenance.
2025-05-28Add missing import.Frederick Muriuki Muriithi
2025-05-28Pass path to bundle extraction dir, and make paths relative to it.Frederick Muriuki Muriithi
Pass the path where the bundle was extracted to the function doing the work. Make the paths for the files being used be relative to the extraction directory thus passed.
2025-05-28Add javascript debugging function.Frederick Muriuki Muriithi
2025-05-19Extract the bundle first.Frederick Muriuki Muriithi
2025-05-19Add "Publication" table to locked tables.Frederick Muriuki Muriithi
2025-05-19Bug: Connection objects do not have execute() function.Frederick Muriuki Muriithi
2025-05-19Handle case where the given publication_id does not exist.Frederick Muriuki Muriithi
2025-05-19Fix generic bugsFrederick Muriuki Muriithi
2025-05-19Import missing symbols.Frederick Muriuki Muriithi
2025-05-19Provide extra metadata to the job.Frederick Muriuki Muriithi
2025-05-19Provide missing URI to the MariaDB database to the script.Frederick Muriuki Muriithi
2025-05-19Cross-reference phenotypes, publications, and data.Frederick Muriuki Muriithi
2025-05-19Retrieve publication first.Frederick Muriuki Muriithi