From 113740c7790e775867e5e6e31ec24299c13be06b Mon Sep 17 00:00:00 2001 From: Stephen Soltesz Date: Thu, 11 Feb 2010 20:08:28 +0000 Subject: [PATCH] test --- statistics/rtsurvey.py | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/statistics/rtsurvey.py b/statistics/rtsurvey.py index c89af56..c1c004e 100755 --- a/statistics/rtsurvey.py +++ b/statistics/rtsurvey.py @@ -62,11 +62,13 @@ def get_rt_tickets(): tr.Created, at.id, at.Subject, at.Content, us.Name FROM Tickets as tk, Transactions as tr, Users as us LEFT OUTER JOIN Attachments as at ON tr.id=at.TransactionId - WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>40800 AND + WHERE (tk.Queue=3 OR tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>0 AND us.id=tr.Creator""" + #WHERE (tk.Queue=3 OR tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>12506 AND + # WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>40800 AND #WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>39896 AND tk.id<42241 AND ## (oct15th2008) #WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>40800 AND ## (1st3months) - #WHERE (tk.Queue=3 OR tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>10000 """ + #WHERE (tk.Queue=3 OR tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>12506 # 12506 jan-1-2006 print "run query" raw = fetch_from_db(db, sql) @@ -207,8 +209,8 @@ def main(): parser.print_help() sys.exit(1) - for i,(name, pattern) in enumerate(re_map): - print i, name + #for i,(name, pattern) in enumerate(re_map): + # print i, name if config.runsql: tickets = get_rt_tickets() -- 2.43.0