X-Git-Url: http://average.org/gitweb/?a=blobdiff_plain;f=loctrkd%2Fopencellid.py;h=a70dc26b2ae39c7e8a2b36a28304fa4837a9aedf;hb=1a544ee9aa7429cd1a6a3a819c111c1b58d02507;hp=22aedcf6e777fa44c2b97ea4039fbc23fb2a7a45;hpb=456fcc5a8964c84385d34a6687e83ae05ab2ddc3;p=loctrkd.git 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