app.py 文件源码

def get_categories(request, conf, current_user):

    language = 'en'

    sql = ("SELECT * FROM categories "
           "JOIN category_names ON categories.category_id = category_names.category_id AND category_names.language = $1"
           "ORDER BY categories.category_id DESC ")

    async with conf.db.id.acquire() as con:
        rows = await con.fetch(sql, language)

    return html(await env.get_template("categories.html").render_async(
        categories=rows, current_user=current_user, environment=conf.name, page="categories"))