Python DBSession.query Examples

Example #1

File: forum_views.py Project: elui/nilsby

def forum_view(request):
    db = DBSession()
    post = db.query(ForumPost).filter(ForumPost.id==request.matchdict['id']).first()
    return {'post': post}

Example #2

File: user_views.py Project: elui/nilsby

def user_index(request):
    db = DBSession()
    people = db.query(Person)
    return {'people': people}

Example #3

File: forum_views.py Project: elui/nilsby

def forum_index(request):
    db = DBSession()
    posts = db.query(ForumPost).order_by(ForumPost.post_time)
    return {'posts': posts}

Example #4

File: user_views.py Project: elui/nilsby

def user_view(request):
    db = DBSession()
    person = db.query(Person).filter(Person.id==request.matchdict['id']).first()
    return {'person': person}