+verbose = False
+
+def printStatusInfo(conn):
+ c = conn.cursor()
+
+ c.execute("SELECT count(id) FROM jobs;")
+ nototal, = c.fetchone()
+
+ c.execute("SELECT count(id) FROM jobs WHERE done=1;")
+ nodone, = c.fetchone()
+
+ c.execute("SELECT sum(workloadestm) FROM jobs WHERE done=1;")
+ wldone, = c.fetchone()
+ if wldone == None:
+ wldone = 0.0
+
+ c.execute("SELECT sum(workloadestm) FROM jobs;")
+ wltotal, = c.fetchone()
+
+ c.close()
+
+ print(nototal, nodone, wldone, wltotal)
+ perdone = 100.0*float(nodone)/float(nototal)
+ perwl = 100.0*float(wldone)/float(wltotal)
+
+ print("%d (%.1f%%) of %d jobs done. %.1f%% of the workload finished." % \
+ (nodone, perdone, nototal, perwl))