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'))