From: Eugene Crosser <crosser@average.org>
Date: Wed, 3 Aug 2022 10:19:46 +0000 (+0200)
Subject: opencellid: detach mem db when lookup failed
X-Git-Tag: 1.91~1
X-Git-Url: http://www.average.org/gitweb/?p=loctrkd.git;a=commitdiff_plain;h=a4e4e193173d24f0f1b2020a61cee432418d5284

opencellid: detach mem db when lookup failed
---

diff --git a/loctrkd/opencellid.py b/loctrkd/opencellid.py
index 22aedcf..a70dc26 100644
--- a/loctrkd/opencellid.py
+++ b/loctrkd/opencellid.py
@@ -42,13 +42,13 @@ def lookup(
         (mcc,),
     )
     data = list(lc.fetchall())
+    # lc.execute("drop table mem.seen")
+    lc.execute("""detach database mem""")
+    lc.close()
     if not data:
         return 0.0, 0.0
     sumsig = sum([1 / sig for _, _, sig in data])
     nsigs = [1 / sig / sumsig for _, _, sig in data]
     avlat = sum([lat * nsig for (lat, _, _), nsig in zip(data, nsigs)])
     avlon = sum([lon * nsig for (_, lon, _), nsig in zip(data, nsigs)])
-    # lc.execute("drop table mem.seen")
-    lc.execute("""detach database mem""")
-    lc.close()
     return avlat, avlon