Python DBSession.query Examples

Example #1

File: views.py Project: binarydud/ppl

def home(request):
    session = DBSession()
    people = session.query(func.count(Profile.id)).scalar()
    companies = session.query(func.count(Company.id)).scalar()
    groups = session.query(func.count(Group.id)).scalar()
    return {'people': people, 'companies': companies,'groups': groups}

Example #2

def home(request):
    session = DBSession()
    people = session.query(func.count(Profile.id)).scalar()
    companies = session.query(func.count(Company.id)).scalar()
    groups = session.query(func.count(Group.id)).scalar()
    return {'people': people, 'companies': companies, 'groups': groups}