just found this - mwalzer/Ligandomat GitHub Wiki

http://docs.pylonsproject.org/projects/pyramid_tutorials/en/latest/single_file_tasks/single_file_tasks.html

@view_config(route_name='list', renderer='list.mako') def list_view(request): rs = request.db.execute("select id, name from tasks where closed = 0") tasks = [dict(id=row[0], name=row[1]) for row in rs.fetchall()] return {'tasks': tasks}