From 86da4588d5f5110c0784678411c2b2a8e72aca92 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Franti=C5=A1ek=20Dvo=C5=99=C3=A1k?= Date: Thu, 5 Mar 2015 17:47:58 +0100 Subject: [PATCH] Write also number of jobs processed. --- stat2pbs.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/stat2pbs.py b/stat2pbs.py index 70b994c..2aa202a 100755 --- a/stat2pbs.py +++ b/stat2pbs.py @@ -149,15 +149,18 @@ if ts: st.execute('SELECT * FROM jobs WHERE changed > %s AND TIMESTAMPDIFF(SECOND,changed,NOW()) > 5 ORDER BY CHANGED', ts) else: st.execute('SELECT * FROM jobs WHERE TIMESTAMPDIFF(SECOND,changed,NOW()) > 5 ORDER BY changed') +counter=0 while 1: job = st.fetchone() if not job: break + counter += 1 ts = job['changed'] print gen_string(job) db.close() +print 'Processed: %d jobs' % counter if ts: f = open(statfile, 'w') f.write(str(ts) + '\n') -- 1.8.2.3