diff options
| author | Frederick Muriuki Muriithi | 2022-03-10 08:55:26 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-03-10 08:55:26 +0300 |
| commit | 4a7e2c1602ed82aabd7d04953067ba49cb1cebff (patch) | |
| tree | ea8c0cf11f1629d79844b2a4e9bb49a69e0bba33 /scripts/maintenance/QTL_Reaper_v6.py | |
| parent | 80b02d37f60d172be01bf8cd62bd84b406b1e0dd (diff) | |
| download | genenetwork2-4a7e2c1602ed82aabd7d04953067ba49cb1cebff.tar.gz | |
Use context manager with database connection
Use the `with` context manager with database connections and cursors
to ensure that they are closed once they are no longer needed.
Where it was not feasible to use the `with` context manager without a
huge refactor/rewrite, the cursors and connections are closed manually.
Diffstat (limited to 'scripts/maintenance/QTL_Reaper_v6.py')
| -rwxr-xr-x | scripts/maintenance/QTL_Reaper_v6.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/scripts/maintenance/QTL_Reaper_v6.py b/scripts/maintenance/QTL_Reaper_v6.py index 35f2d1a1..20fd8e3b 100755 --- a/scripts/maintenance/QTL_Reaper_v6.py +++ b/scripts/maintenance/QTL_Reaper_v6.py @@ -106,3 +106,6 @@ for ProbeSetFreezeId in ProbeSetFreezeIds: print(ProbeSetFreezeIds) + +cursor.close() +con.close() |