diff options
| author | John Nduli | 2024-09-24 09:45:30 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2024-09-30 11:14:08 +0300 |
| commit | acf133de4cc482ba8c4954179757e301f52c751a (patch) | |
| tree | c62b56ff60a8e3533b0a64793986382c5e3adbdc /gn3/db/rdf/wiki.py | |
| parent | a72bc11be719b4726f05388ff053d52b192c8a50 (diff) | |
| download | genenetwork3-acf133de4cc482ba8c4954179757e301f52c751a.tar.gz | |
fix: rdf and sql queries for fetching rif data
SQL queries fail because we get bytes instead of strings which cannot be
decoded. We decode results from DictCursor to fix this. For RDF, we cast
`?symbol` to a string.
Diffstat (limited to 'gn3/db/rdf/wiki.py')
| -rw-r--r-- | gn3/db/rdf/wiki.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gn3/db/rdf/wiki.py b/gn3/db/rdf/wiki.py index 4464eed..b2b301a 100644 --- a/gn3/db/rdf/wiki.py +++ b/gn3/db/rdf/wiki.py @@ -86,7 +86,7 @@ CONSTRUCT { rdf:type gnc:GNWikiEntry ; dct:identifier ?id_ ; dct:created ?createTime . - FILTER ( LCASE(?symbol) = LCASE('$symbol') ) . + FILTER ( LCASE(STR(?symbol)) = LCASE("$symbol") ) . { SELECT (MAX(?vers) AS ?max) ?id_ WHERE { ?comment dct:identifier ?id_ ; |