From a1c85c3d28d9e7e7885d121d58470c0ba2e72eb9 Mon Sep 17 00:00:00 2001 From: Benji Dial Date: Tue, 17 Sep 2024 07:42:43 -0400 Subject: have process-polls properly handle global_name = null --- process-polls.py | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/process-polls.py b/process-polls.py index 63d3692..cd64764 100644 --- a/process-polls.py +++ b/process-polls.py @@ -67,8 +67,14 @@ for row in rows: voters_1 = get_all_voters(s, row[4], row[5], answer_list_1[0]['answer_id']) voters_2 = get_all_voters(s, row[4], row[5], answer_list_2[0]['answer_id']) + def user_to_params(user): + name = user['global_name'] + if name is None: + name = user['username'] + return (user['id'], name, user['avatar'], the_time) + cur.executemany('INSERT OR REPLACE INTO users VALUES(?, ?, ?, ?)', - list(map(lambda x: (x['id'], x['global_name'], x['avatar'], the_time), voters_1 + voters_2))) + list(map(user_to_params, voters_1 + voters_2))) cur.execute(''' UPDATE polls -- cgit v1.2.3