From 3038106a16248d9d05b1545e019101e54f8291cc Mon Sep 17 00:00:00 2001 From: Wojciech Kosior Date: Fri, 12 Jun 2020 16:04:21 +0200 Subject: specify query result type as a string value --- src/perform_queries.py | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/src/perform_queries.py b/src/perform_queries.py index 32c4edf..06dc578 100755 --- a/src/perform_queries.py +++ b/src/perform_queries.py @@ -58,13 +58,16 @@ def resolve_call_back(mydata, status, result): # debugging print("callback called for {}".format(result.qname)) if status==0 and result.havedata: + result_info = 'successful' print("Result:",result.data.address_list) + else: + result_info = 'not found' # write to database query.cursor.execute(''' INSERT INTO user_side_responses (date, result, dns_id, service_id, vpn_id) - VALUES (current_timestamp, '', %s, %s, %s) + VALUES (current_timestamp, %s, %s, %s, %s) RETURNING id - ''', (query.dns_id, query.service_id, query.vpn_id)) + ''', (query.dns_id, result_info, query.service_id, query.vpn_id)) responses_id = query.cursor.fetchone()[0] -- cgit v1.2.3