aboutsummaryrefslogtreecommitdiff
path: root/gn3/db_utils.py
AgeCommit message (Collapse)Author
2022-08-22Use non-default MySQL port if presentFrederick Muriuki Muriithi
By default, MySQL/Mariadb connects at port 3306, however, the configuration variable `SQL_URI` could contain a different port. In that case, this commit allows the system to connect to the non-default port.
2022-03-11Fix some linting issuesFrederick Muriuki Muriithi
2022-03-08Create database connections within context managersFrederick Muriuki Muriithi
Use the `with` context manager to open database connections, so as to ensure that those connections are closed once the call is completed. This hopefully avoids the 'too many connections' error
2021-05-08gn3: db_utils: Remove mypy ignore stubBonfaceKilz
MySQLdb is already ignored in ".mypy.ini", added in 88c33df.
2021-05-08Fix pep-8 errorsBonfaceKilz
2021-04-12Integrate correlation APIAlexander Kabui
- add new api for gn2-gn3 sample r integration - delete map for sample list to values - add db util file - add python msql-client dependency - add db for fetching lit correlation results - add unittests for db utils - add tests for db_utils - modify api for fetching lit correlation results - refactor Mock Database Connector and unittests - add sql url parser - add SQL URI env variable - refactor code for db utils - modify return data for lit correlation - refactor tissue correlation endpoint - replace db_instance with conn