hv-service/Objekte.py

from dbpool import getConnection, getMany, getOne
from auth import check_scope

def get_objekte(token_info):
    check_scope(token_info, "objekt/read")
    return getMany("SELECT id, shortname, flaeche FROM objekt", [], "Objekt")

def get_objekt(id, token_info):
    check_scope(token_info, "objekt/read")
    return getOne("SELECT id, shortname, flaeche FROM objekt WHERE id = ?", 
                  (id,), "Objekt")