def notProcessedRuns():
c = awfy.db.cursor()
c.execute(
"SELECT id \
FROM awfy_run \
WHERE id > 225536 AND \
status = 1 AND \
detector != 1 AND \
machine=28")
runs = []
for row in c.fetchall():
runs.append(tables.Run(row[0]))
return runs
def notProcessedRuns():
# Only look at reports in the last week
newer = int(time.time() - 60 * 60 * 24 * 7)
c = awfy.db.cursor()
c.execute(
"SELECT id \
FROM awfy_run \
WHERE stamp > " + str(newer) +
" AND \
status = 1 AND \
detector != 1 AND \
machine in (28,29,26)")
runs = []
for row in c.fetchall():
runs.append(tables.Run(row[0]))
return runs
def testRuns():
c = awfy.db.cursor()
newer = int(time.time() - 60 * 60 * 24 * 30)
older = int(time.time() - 60 * 60 * 24 * 1)
c.execute(
"SELECT id \
FROM awfy_run \
WHERE stamp > " + str(newer) +
" AND \
stamp < " + str(older) +
" AND \
status = 1 AND \
detector = 1 AND \
machine in (28, 29)")
runs = []
for row in c.fetchall():
runs.append(tables.Run(row[0]))
return runs