From a4e4e193173d24f0f1b2020a61cee432418d5284 Mon Sep 17 00:00:00 2001
From: Eugene Crosser <crosser@average.org>
Date: Wed, 3 Aug 2022 12:19:46 +0200
Subject: [PATCH] opencellid: detach mem db when lookup failed

---
 loctrkd/opencellid.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

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
-- 
2.43.0