Python generate_result_set Examples

Example #1

File: static_reports.py Project: blighli/Budget-Manager

def expense_by_category():
    results = db.session.query(Category.name.label("Category Name"),
                                Category.description.label("Category Description"),
                                func.sum(Transaction.amount).label("Total Spend")). \
                            outerjoin(TransactionTag). \
                            outerjoin(TransactionToTagMapping). \
                            outerjoin(Transaction). \
                            group_by(Category.name, Category.description)
    results = generate_result_set(results)
    return render_template("report_layout.html", results=results, title="Expense by category")

Example #2

File: static_reports.py Project: svieira/Budget-Manager

def expense_by_category():
    results = db.session.query(Category.name.label("Category Name"),
                                Category.description.label("Category Description"),
                                func.sum(Transaction.amount).label("Total Spend")). \
                            outerjoin(TransactionTag). \
                            outerjoin(TransactionToTagMapping). \
                            outerjoin(Transaction). \
                            group_by(Category.name, Category.description)
    results = generate_result_set(results)
    return render_template("report_layout.html",
                           results=results,
                           title="Expense by category")

Example #3

File: index.py Project: blighli/Budget-Manager

def view_table(table_name=None):
    if table_name is None:
        abort(404)
    else:

        results = []

        try:
            table = db.metadata.tables.get(table_name, None)
            query = db.session.query(table)
            results = generate_result_set(query)
        except Exception:
            abort(404)

        if len(results) < 2:
            flash("The table contains no data")

        return render_template("report_layout.html",
                                results=results,
                                title="Table View for {}".format(table_name))

Example #4

File: index.py Project: svieira/Budget-Manager

def view_table(table_name=None):
    if table_name is None:
        abort(404)
    else:

        results = []

        try:
            table = db.metadata.tables.get(table_name, None)
            query = db.session.query(table)
            results = generate_result_set(query)
        except Exception:
            abort(404)

        if len(results) < 2:
            flash("The table contains no data")

        return render_template("report_layout.html",
                               results=results,
                               title="Table View for {}".format(table_name))