Add a sponsor badge status overview page

This shows which sponsors and scanners have scanned how many badges.

1 files changed, 6 insertions, 0 deletions

diff --git a/postgresqleu/util/db.py b/postgresqleu/util/db.py
index 162df4be..c9d8f5c3 100644
--- a/postgresqleu/util/db.py
+++ b/postgresqleu/util/db.py
@@ -50,6 +50,12 @@ def exec_to_keyed_dict(query, params=None):
     return {r[columns[0]]: r for r in (dict(list(zip(columns, row)))for row in curs.fetchall())}
 
 
+def exec_to_keyed_scalar(query, params=None):
+    curs = connection.cursor()
+    curs.execute(query, params)
+    return dict(curs.fetchall())
+
+
 def exec_to_grouped_dict(query, params=None):
     curs = connection.cursor()
     curs.execute(query, params)