From: Michael Tremer <michael.tremer@ipfire.org>
Date: Wed, 13 May 2020 17:30:05 +0000 (+0000)
Subject: python: Use closest match for countries
X-Git-Tag: 0.9.1~59
X-Git-Url: http://git.ipfire.org/?p=people%2Fms%2Flibloc.git;a=commitdiff_plain;h=b6fdae1e72c377e00f4206aeb52bd39aa27e220d;hp=6e97c44b9dc11cfd3ad27abc6066b03d98f60880

python: Use closest match for countries

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
---

diff --git a/src/python/location-importer.in b/src/python/location-importer.in
index 26e4d0d..645144a 100644
--- a/src/python/location-importer.in
+++ b/src/python/location-importer.in
@@ -221,6 +221,8 @@ class CLI(object):
 				(
 					SELECT networks.country FROM networks
 						WHERE announcements.network <<= networks.network
+						ORDER BY masklen(networks.network) DESC
+						LIMIT 1
 				) AS country,
 
 				-- Flags