aboutsummaryrefslogtreecommitdiff
path: root/gn3/db
AgeCommit message (Collapse)Author
2023-10-27Abstract out (sparql) CONSTRUCT into a function.Munyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Delete gn3.db.rdf.sparql_query.Munyoki Kilyungi
* gn3/api/metadata.py: Remove sparql_query import. * gn3/db/rdf.py: Remove unused imports. (sparql_query): Delete. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Delete db.rdf.get_url_local_name.Munyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Implement "GET /metadata/phenotypes/:name".Munyoki Kilyungi
* gn3/api/metadata.py: Delete gn3.db.rdf.get_phenotype_metadata. (phenotype): Rename this to ... (phenotypes): ... this and implement update logic. * gn3/db/rdf.py (get_phenotype_metadata): Delete. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Delete get_dataset_metadata.Munyoki Kilyungi
* gn3/db/rdf.py (get_dataset_metadata): Delete. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Implement "GET /metadata/publications/:name".Munyoki Kilyungi
* gn3/api/metadata.py: Delete gn3.db.rdf.get_publication_metadata. (publication): Rename this ... (publications): ... to this. Return a json-ld result. * gn3/db/rdf.py (get_publication_metadata): Delete. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Add fabio: and prism: to PREFIXES.Munyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Implement "GET /metadata/datasets/:name".Munyoki Kilyungi
* gn3/api/metadata.py: Import json, SPARQLWrapper.{JSON, JSONLD}. (dataset): Rename this to ... (datasets): ... this. Return a well formatted JSONLD result from a dataset. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Add missing dcat: prefix.Munyoki Kilyungi
2023-10-27Derive RDF_PREFIXES string from PREFIXES.Munyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Remove get_url_local_name when processing result keys.Munyoki Kilyungi
* gn3/db/rdf.py (sparql_query): Delete "get_url_local_name". Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Simplify CONSTRUCT query when fetching a dataset's metadata.Munyoki Kilyungi
* gn3/api/metadata.py (dataset): Update docstring. * gn3/db/rdf.py (get_dataset_metadata): Simplify CONSTRUCT query. Also, now you can fetch metadata using either an accession_id or the dataset's name. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-27Update RDF prefixes.Munyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-10-06Make argument mandatoryFrederick Muriuki Muriithi
Make the `base_dir` argument mandatory to force it to be passed in from the point the function is called.
2023-09-21Fix query in update_cross_referencezsloan
2023-09-05Delete un-used importMunyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-09-05Fix C3001: Lambda expression assigned to a variableMunyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-09-05Remove un-necessary string concatenationMunyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-09-05Replace "escape_string" with safe-query parametersMunyoki Kilyungi
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-09-05Remove type annotations for "none_case_attrs" variablesMunyoki Kilyungi
* gn3/db/sample_data.py (update_sample_data, delete_sample_data, insert_sample_data): Remove type hints for "none_case_attrs". Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
2023-08-24Change get_pheno_csv_sample_data to use group ID instead of phenotype IDzsloan
2023-08-17Fix query for fetching DataId when inserting ProbeSet datazsloan
2023-08-17Fix a couple remaining issues with function parameterszsloan
2023-08-17Combine pheno/mrna update functions + some other fixeszsloan
2023-08-17Fix queries for fetching group nameszsloan
2023-08-17Fix fetch_trait query for phenotypeszsloan
2023-08-17Fix a few misnamed tables in mrna delete/insert functionszsloan
2023-08-17Implement ProbeSet sample data editingzsloan
Currently there's a lot of duplicated code, so I need to ask how best to simplify it later
2023-08-17Fix probeset sample data and CSV sample data functionszsloan
2023-08-17Fix query for retrieving mrna dataset group namezsloan
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 ↵zsloan
assay resources, and change their naming accordingly
2023-08-04Remove the ORM-dependent `update` function.Frederick Muriuki Muriithi
2023-08-02Add deprecation notice to ORM-dependent `update` functionFrederick Muriuki Muriithi
Add a deprecation notice to discourage other devs from using the deprecated `update` function.
2023-08-02Remove ORM-dependent `insert` functionFrederick Muriuki Muriithi
Remove the object-relation-mapping dependent `insert` function to prevent it being used in the code down the line.
2023-08-02Remove ORM-dependent `fetchall` and `fetchone` functionsFrederick Muriuki Muriithi
Remove Object-Relational Mapping dependent function, `fetchall` and `fetchone` so as to prevent theirs use in the code moving forward.
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 moduleFrederick Muriuki Muriithi
Extract the reusable function into a separate `query_tools` module for use in other modules.
2023-07-18Bug: Change from `_id` to `id_` to avoid downstream breakage.Frederick Muriuki Muriithi
The downstream code expects `id_` not `_id`.
2023-07-18Fix wrong import, and typing issues.Frederick Muriuki Muriithi
generated by cgit v1.2.3 (git 2.44.0) at 2024-11-23 01:14:50 +0000