def main(changes):
really = "-n" not in sys.argv
with session_manager() as session:
Base.metadata.create_all(bind=session.bind)
applied = 0
for name in sorted(os.listdir(changes)):
if name.endswith("~"):
continue
if session.query(AppliedChanges).get(name):
continue
print "Applying %s . . ." % name
applied += 1
if really:
script = os.path.join(changes, name)
apply_script(session, script)
change = AppliedChanges(applied=datetime.utcnow(), name=name)
session.add(change)
session.commit()
if not applied:
print "No database-changes is good news!"
def job(job_id):
with session_manager() as session:
job = Job.get(session, job_id)
return render_response('job.html', {
'job': job,
'results': job.results.limit(7).all(),
})
def index():
with session_manager() as session:
jobs = (session
.query(Job)
.filter(Job.deleted == None)
.order_by(Job.login, Job.host, Job.name))
text = Job.login + ' ' + Job.host + ' ' + Job.name
for q in request.args.get('q', '').strip().split():
jobs = jobs.filter(text.contains(q))
return render_response('index.html', {'jobs': jobs.all()})
def main():
log.debug('doing periodic tasks')
with session_manager() as session:
send_lateness_notifications(session)
send_still_bad_notifications(session)
delete_old_results(session)
def to_database(result):
with session_manager() as session:
job = update_proccer_job(session, result)
add_proccer_result(session, job, result)
def delete_job(job_id):
with session_manager() as session:
job = Job.get(session, job_id)
job.deleted = datetime.utcnow()
flash('Job deleted')
return redirect(url_for('index'))
