start = time.time()
possible_hit_jobs = Session.query(Job)\
.filter(Job.failed == False)\
.order_by('-id')\
.limit(100)\
.all()
end = time.time()
print end - start
print len(possible_hit_jobs)
top_job = possible_hit_jobs[0]
for s in top_job.spacers:
print s.sequence, s.score
Session.flush()
Session.rollback()
for j in possible_hit_jobs:
print j.date_submitted, j.date_completed, j.computed_hits, j.key, len(j.spacers)
print d = datetime.now() - j.date_submitted
#check job submission after 1,1
t1 = datetime(2016, 1, 1, 0, 0)
start = time.time()
possible_hit_jobs = Session.query(Job)\
.filter(Job.date_submitted > t1)\
.order_by('-id')\
.all()
end = time.time()
