From f28bd37a953eb51dd7a9e5ae6524f651b3f0757a Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Tue, 29 Sep 2015 00:00:01 +0200 Subject: [PATCH] geoip: Tolerate lots of spaces in database fields Signed-off-by: Michael Tremer --- webapp/backend/geoip.py | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/webapp/backend/geoip.py b/webapp/backend/geoip.py index 9a3650f0..16159a58 100644 --- a/webapp/backend/geoip.py +++ b/webapp/backend/geoip.py @@ -24,7 +24,16 @@ class GeoIP(Object): query = "SELECT * FROM geoip \ WHERE %s BETWEEN start_ip AND end_ip LIMIT 1" - return self.db.get(query, addr) + ret = self.db.get(query, addr) + + if ret: + if ret.city: + ret.city = ret.city.strip() + + if ret.postal_code: + ret.postal_code = ret.postal_code.strip() + + return ret def get_asn(self, addr): query = "SELECT asn FROM geoip_asn \ -- 2.39.2