aboutsummaryrefslogtreecommitdiff
path: root/wqflask/db/webqtlDatabaseFunction.py
AgeCommit message (Collapse)Author
2022-09-12Check db resultset before indexing into itFrederick Muriuki Muriithi
The assumption that the resultset will never be empty was leading to a lot of errors.
2022-08-31Replace fetchall, fetchone, fetch1 with database_connectionMunyoki Kilyungi
* wqflask/base/data_set.py: Replace "db.call" import with "database_connection". (create_datasets_list): Use "database_connection" to fetch data. (DatasetGroup.__init__): Ditto. (DataSet.retrieve_other_names): Ditto. (PhenotypeDataSet.setup): Remove query escaping in string and format the string. (GenotypeDataSet.setup): Ditto. (MrnaAssayDataSet.setup): Ditto. * wqflask/db/webqtlDatabaseFunction.py: Remove db.call import. (retrieve_species): Use database_connection() to fetch data. (retrieve_species_id): Ditto.
2021-05-26db: webqtlDatabaseFunction: Remove commentBonfaceKilz
2021-05-26db: webqtlDatabaseFunction: Remove logger infoBonfaceKilz
2021-04-30autopep8: Fix E501BonfaceKilz
2021-04-30autopep8: Fix E301,E302,E303,E304,E305,E306BonfaceKilz
2021-04-30autopep8: Fix E20-E27BonfaceKilz
Run: python -m autopep8 --in-place --recrusive ./ --select\ E20,E211,E22,E224,E224,E225,E226,E227,E228,E231,E241,\ E242,E251,E252,E26,E265,E266,E27 -p 3
2020-08-19Remove extra whitespace(or add it) from comma separated itemsBonfaceKilz
See: <https://docs.python.org/2/library/2to3.html#2to3fixer-urllib>
2018-04-18Removed a little more code in webqtlDatabaseFunction.py and do_searchzsloan
2016-06-26gn_server: introduced one new query to fetch a dataset record and force ↵Pjotr Prins
fetch1 to return a tuple
2016-06-23Remove headersPjotr Prins
2016-06-23Added REST call for species_idPjotr Prins
2016-06-23Removed unused functionsPjotr Prins
2016-06-23DB: created fetch1 function which can do both SQL and GN_SERVERPjotr Prins
2016-06-23Backend: moved methods into call modulePjotr Prins
2016-06-23Refactored dir name dbFunction to dbPjotr Prins