"""One authorized projection for list results and dashboard aggregates.""" from sqlalchemy import text from .jinja_templates import templates def read_invoices(db, username, clauses=(), values=None): query = templates.env.get_template('forderungen/liste/queries/forderungen_liste.sql').render() if clauses: query = query.replace('AND 1 = 1', 'AND 1 = 1 AND ' + ' AND '.join(clauses)) result = db.execute(text(query).execution_options(query_name='forderungen/liste/queries/forderungen_liste.sql'), dict(values or {}, auth_username=username)) columns = list(result.keys()) tenant, number = columns.index('Client_DB'), columns.index('Beleg_Nr') seen, rows = set(), [] for row in result.fetchall(): identity = (str(row[tenant]), str(row[number])) if identity not in seen: rows.append(row) seen.add(identity) return columns, rows