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/readProbeSetMean_v7.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/readProbeSetMean_v7.py')
| -rwxr-xr-x | scripts/maintenance/readProbeSetMean_v7.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/scripts/maintenance/readProbeSetMean_v7.py b/scripts/maintenance/readProbeSetMean_v7.py index 43f084f4..56adcdfd 100755 --- a/scripts/maintenance/readProbeSetMean_v7.py +++ b/scripts/maintenance/readProbeSetMean_v7.py @@ -269,4 +269,5 @@ if len(values1) > 0: cmd = 'insert into ProbeSetXRef(ProbeSetFreezeId, ProbeSetId, DataId) values %s' % cmd db.execute(cmd) +db.close() con.close() |