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 26e4d0d2bfe77118f615f00b33dd48e82e82389c..645144acc2e627ba9703233e0de937714be9c784 100644 (file)
--- 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