CookBook

[dneise]

I did something horribly inefficient to learn about the current status of our last submission...

Then I came up with this ... wanted to share it:

database.close(); database.connect()  # obligatory to stay connected ... :-(
x = XML.get(XML.name == 'single_pe_extraction_pass_1')
states = ProcessingState.select()
for s in states:
    print(s, Job.select().where(Job.xml == x).where(Job.status == s).count())

failed 77
inserted 100670
queued 199
running 101
success 1868
walltime_exceeded 717