[sysadmin-bin] New host, new python release

[Andrea Veri <averi src gnome org>]

commit 66924036b1934022e17c6073e5e92242fb10586a
Author: Andrea Veri <averi redhat com>
Date:   Wed Feb 19 19:59:51 2020 +0100

    New host, new python release

 rt4/rt.py | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)
---
diff --git a/rt4/rt.py b/rt4/rt.py
index f01d597..3ddd025 100755
--- a/rt4/rt.py
+++ b/rt4/rt.py
@@ -24,34 +24,34 @@ def write_stat_file(cursor, queue):
     qnr = qinfo['nr']
     OUTPUT = '/usr/local/www/rt4stats/%s.html' % queue
 
-    cursor.execute ('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="new"', qnr)
+    cursor.execute('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="new"' % qnr)
     newc = cursor.fetchone ()[0]
 
-    cursor.execute ('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="open"', qnr)
+    cursor.execute('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="open"' % qnr)
     openc = cursor.fetchone ()[0]
 
-    cursor.execute ('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="stalled"', 
qnr)
+    cursor.execute('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status="stalled"' % 
qnr)
     stalledc = cursor.fetchone ()[0]
 
-    cursor.execute ('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND (Status="resolved" OR 
Status="rejected") AND LastUpdated > ADDDATE(CURRENT_DATE, INTERVAL -7 DAY)', qnr)
+    cursor.execute('SELECT COUNT(*) FROM Tickets WHERE Type="ticket" AND Queue=%s AND (Status="resolved" OR 
Status="rejected") AND LastUpdated > ADDDATE(CURRENT_DATE, INTERVAL -7 DAY)' % qnr)
     last = cursor.fetchone ()[0]
 
-    cursor.execute('SELECT id, Status FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN ("new", 
"open", "stalled") ORDER BY id', qnr)
+    cursor.execute('SELECT id, Status FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN ("new", 
"open", "stalled") ORDER BY id' % qnr)
     tickets = {}
     for row in cursor.fetchall():
         tickets[row[0]] = {'Status': row[1]}
 
-    cursor.execute('SELECT id, Subject FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN ("new", 
"open", "stalled") ORDER BY id', qnr)
+    cursor.execute('SELECT id, Subject FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN ("new", 
"open", "stalled") ORDER BY id' % qnr)
     description = {}
     for row in cursor.fetchall():
         description[row[0]] = row[1]
 
-    cursor.execute('SELECT id, LastUpdated FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN 
("new", "open", "stalled") ORDER BY id', qnr)
+    cursor.execute('SELECT id, LastUpdated FROM Tickets WHERE Type="ticket" AND Queue=%s AND Status IN 
("new", "open", "stalled") ORDER BY id' % qnr)
     lastupdated = {}
     for row in cursor.fetchall():
         lastupdated[row[0]] = row[1]
 
-    cursor.execute("SELECT MAX(Transactions.id) AS TID, Tickets.id AS TID from Tickets INNER JOIN 
Transactions ON Tickets.id = Transactions.ObjectId WHERE Tickets.Queue=%s AND ObjectType = 'RT::Ticket' AND 
Transactions.Type = 'Comment' and Tickets.Status = 'stalled' GROUP BY Tickets.id", qnr)
+    cursor.execute("SELECT MAX(Transactions.id) AS TID, Tickets.id AS TID from Tickets INNER JOIN 
Transactions ON Tickets.id = Transactions.ObjectId WHERE Tickets.Queue=%s AND ObjectType = 'RT::Ticket' AND 
Transactions.Type = 'Comment' and Tickets.Status = 'stalled' GROUP BY Tickets.id" % qnr)
     trans = dict(cursor.fetchall())
 
     tid = trans.keys()