forderung_data.py 907 B

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