aboutsummaryrefslogtreecommitdiff
path: root/gn3/db
AgeCommit message (Expand)Author
2023-08-17Fix get_mrna_sample_data queryzsloan
2023-08-17Fix mrna group name queryzsloan
2023-08-17Remove Id select from probeset metadata query, since it's included in colszsloan
2023-08-17Add function for retrieving mRNA Assay group namezsloan
2023-08-17Make several sample_data fetching functions specific to phenotype or mrna ass...zsloan
2023-08-04Remove the ORM-dependent `update` function.Frederick Muriuki Muriithi
2023-08-02Add deprecation notice to ORM-dependent `update` function...Add a deprecation notice to discourage other devs from using the deprecated `update` function. Frederick Muriuki Muriithi
2023-08-02Remove ORM-dependent `insert` function...Remove the object-relation-mapping dependent `insert` function to prevent it being used in the code down the line. Frederick Muriuki Muriithi
2023-08-02Remove ORM-dependent `fetchall` and `fetchone` functions...Remove Object-Relational Mapping dependent function, `fetchall` and `fetchone` so as to prevent theirs use in the code moving forward. Frederick Muriuki Muriithi
2023-07-26Fix variable name.Frederick Muriuki Muriithi
2023-07-26Remove debug statement.Frederick Muriuki Muriithi
2023-07-26Fetch `metadata_audit` trail with direct query functions.Frederick Muriuki Muriithi
2023-07-26Function to create a metadata audit trail.Frederick Muriuki Muriithi
2023-07-21Update a Publication in the database.Frederick Muriuki Muriithi
2023-07-21Fetch a publication by its PubMed IDFrederick Muriuki Muriithi
2023-07-21Rename function: fetch_publication ==> fetch_publication_by_idFrederick Muriuki Muriithi
2023-07-19Extract code dealing with ProbeSets to their own module.Frederick Muriuki Muriithi
2023-07-19Extract reusable code to separate module...Extract the reusable function into a separate `query_tools` module for use in other modules. Frederick Muriuki Muriithi
2023-07-18Bug: Change from `_id` to `id_` to avoid downstream breakage....The downstream code expects `id_` not `_id`. Frederick Muriuki Muriithi
2023-07-18Fix wrong import, and typing issues.Frederick Muriuki Muriithi
2023-07-18Fetch a single publication by `PublicationId`Frederick Muriuki Muriithi
2023-07-18Fetch metadata for a single phenotype.Frederick Muriuki Muriithi
2023-07-18Fetch single phenotype trait by `dataset_id` and `trait_name`.Frederick Muriuki Muriithi
2023-07-18Bug: Fetch group name by dataset_id...Change the code to fetch the group name by the dataset ID, since according to usage[1] of the `retrieve_group_name` function, the value passed in is the `dataset_id` and not the `group_id`. Change the name from `retrieve_group_name` to `retrieve_phenotype_group_name` to more clearly indicate that this function concerns itself with the groups that relate to phenotypes. [1](https://github.com/genenetwork/genenetwork2/blob/1bbb0430732b7fa5102d7dcbda80ebda252f5424/wqflask/wqflask/metadata_edits.py) Frederick Muriuki Muriithi
2023-07-17Fix dict key name...Remove extra colon (:) at the end of the name that was leading to the number of cases not being presented as expected. Frederick Muriuki Muriithi
2023-07-12Bug: Set the `data_exists` variable within the context manager...The `cursor.fetchone()` call that was used as the condition to the `if` was called outside of the context manager, and therefore would always give a non-truthy value at best and an inconsistent result at worst. This commit gets the value before the context manager has exited and stores it for later use. Frederick Muriuki Muriithi
2023-07-12Bug: Retrieve configs from app, not environment...Retrieve the configuration values from the application object, not from the environment. We are assured of having the configuration values set in the application - we do not have that assurance for the environment. Frederick Muriuki Muriithi
2023-06-15Fetch genotypes from virtuoso...* gn3/api/metadata.py: Import get_genotype_metadata. (genotype): New end-point. * gn3/db/rdf.py (get_phenotype_metadata): New function. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-12Delete unused import...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-12Fetch phenotypes from virtuoso...* gn3/api/metadata.py: Import get_phenotype_metadata. (phenotype): New end-point. * gn3/db/rdf.py (get_phenotype_metadata): New function. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-12Delete unused get_trait_metadata function...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-07Add publication end-point...* gn3/api/metadata.py: Import get_publication_metadata (publication): New endpoint. * gn3/db/rdf.py (get_dataset_metadata): New function. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-07Nest duplicate entries into a list from a sparql result...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-06Pass geoSeries as a URL...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-06Rename gn:geoPlatform -> gn:geoPlatformUrl...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-06Match how dataset metadata is fetched with GN1...* gn3/db/rdf.py (sparql_query): Parse CONSTRUCTS and SELECTS differently. (strip_url): Rename to ... (get_url_local_name): ... this. (get_dataset_metadata): Fetch extra fields in RDF. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-06Replace taxon prefix with ncbiTaxon which references NCBI...Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-02Replace SELECT with CONSTRUCT when fetching a dataset's metadata...* gn3/db/rdf.py: Importh pymonad.Nothing. (get_dataset_metadata): Replace SELECT with CONSTRUCT. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-06-02Create a function for stripping the last bit from a URL...* gn3/db/rdf.py: Import unquote and urlparse. (strip_url): New function. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com> Munyoki Kilyungi
2023-05-22Use string literal concatenation to make genofile_path line shorterzsloan
2023-05-22Fix quotes when setting genofile_pathzsloan
2023-05-22Fix return typing for get_trait_sample_datazsloan
2023-05-22Change type from 'any' to 'Any'zsloan
2023-05-22Use f-string for setting genofile_path...Also set default value for os.environ.get("GENENETWORK_FILES") zsloan
2023-05-22Include encoding in open statement to address pylint W1514zsloan
2023-05-22Initialize 'line'; previous pylint complained because line might not be initi...zsloan
2023-05-22Use 'with open()' syntax...Initialize samplelist variable zsloan
2023-05-22Remove unused variable this_datazsloan
2023-05-22Include all samples in trait sample data...This is necessary in order to allow for editing the values of samples that don't currently have values zsloan
2023-05-22Fix sample data CSV query to only fetch distinct samples...There's probably a better way to fix this query (it was previously returning each sample twice), but DISTINCT was the easiest way I could come up with zsloan