def new_report(): report = Report('unnamed report') current_user.reports.append(report) session.commit() return redirect(url_for("profile"))
def remove_report(report_id): report = session.query(Report).filter_by(id=report_id, user=current_user.id).first() session.delete(report) session.commit() return redirect(url_for("profile"))
def make_private(report_id): report = session.query(Report).filter_by(id=report_id, user=current_user.id).first() if report is not None: report.public = False session.commit() return redirect(url_for("profile"))
def update_report(report_id): report = session.query(Report).filter_by(id=report_id).first() if not has_privileges(report): return abort(401) report.name = request.form['name'] session.commit() return jsonify(data=None)
def delete_chart(report_id, chart_id): report = session.query(Report).filter_by(id=report_id).first() if not has_privileges(report): return abort(401) session.query(Chart).filter_by(id=chart_id, report=report_id).delete() report.modified = datetime.datetime.now() session.commit() return jsonify(data=None)
def shorten(uri): long_prefix = get_long_prefix(uri) prefix = session.query(Prefix).filter_by(uri=long_prefix).first() if prefix is None: prefix = Prefix(get_long_prefix(uri)) session.add(prefix) session.commit() return uri.replace(prefix.uri, prefix.prefix + ':')
def chart_save(report_id, chart_id): report = session.query(Report).filter_by(id=report_id).first() if not has_privileges(report): return abort(401) if chart_id == 'new': name = request.form['name'] chart = Chart(name) report.charts.append(chart) else: chart = session.query(Chart).filter_by(id=chart_id).first() chart.json = request.form['chart'] report.modified = datetime.datetime.now() session.commit() report = session.query(Report).filter_by(id=chart.report).first() return redirect(url_for("report_edit", report_id=report.id))