From fc1e1d66c35807b856591caa470886ea51507a0e Mon Sep 17 00:00:00 2001 From: Wojciech Kosior Date: Wed, 17 Jun 2020 17:28:11 +0200 Subject: [PATCH] change column name (user_side_service.name -> user_side_service.web_address) --- src/perform_queries.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/perform_queries.py b/src/perform_queries.py index 4e22f1b..029651b 100755 --- a/src/perform_queries.py +++ b/src/perform_queries.py @@ -45,7 +45,7 @@ def query_planned_queries(cursor, hour, vpn_id): for dns_IP, dns_id in dnss: cursor.execute(''' - SELECT s.id, s.name + SELECT s.id, s.web_address FROM user_side_service AS s JOIN user_side_queries AS q ON s.id = q.service_id WHERE q.vpn_id = %s AND q.dns_id = %s -- 2.11.4.GIT