aboutsummaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2025-06-02Parametrize the "DataId" column for different tables.Frederick Muriuki Muriithi
2025-06-02Explicitly 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.
2025-06-02Convert N/A values to NoneType objects.Frederick Muriuki Muriithi
2025-06-02Pass the phenotypes name-to-id map to functions.Frederick Muriuki Muriithi
2025-06-02Compute 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
2025-05-19Simplify handling of publications: Assume a maximum of one.Frederick Muriuki Muriithi
Adding publication details in the R/qtl2 bundle might not be an easy thing, so for now, assume all the phenotypes uploaded in a particular session are all published in one publication.
2025-05-19Add placeholder stub to be implemented later.Frederick Muriuki Muriithi
2025-05-19Add some notes for later.Frederick Muriuki Muriithi
2025-05-19Save numeric/computational data for phenotypes.Frederick Muriuki Muriithi
2025-05-19Retrieve samples' details from the database.Frederick Muriuki Muriithi
2025-05-19Add function to save the numerical data for phenotypes.Frederick Muriuki Muriithi
2025-05-19Use correct files for basic phenotypes data. Add notes to self.Frederick Muriuki Muriithi
The basic phenotype data will be in files under the key "gn-metadata" -> "pheno". We support the possibility of having some descriptions in the "phenocovar" files, since that can happen also.
2025-05-19Rework order of execution of potential steps.Frederick Muriuki Muriithi
2025-05-19Cleanup function call.Frederick Muriuki Muriithi
2025-05-19Fetch next available PublishXRef.DataId value for the phenotypes.Frederick Muriuki Muriithi
2025-05-19Save the basic phenotypes data into the database.Frederick Muriuki Muriithi
2025-05-19Read headers from a CSV file, whether transposed or not.Frederick Muriuki Muriithi