Breaking News: Grepper is joining You.com. Read the official announcement!

get first row sqlalchemy

Bug Killer answered on April 13, 2022 Popularity 7/10 Helpfulness 5/10

answer get first row sqlalchemy

get first row sqlalchemy

Comment

result = session.query(profile.name).filter(...).first()
if not result:
    print 'No result found'
# Alternatively you can use one(), which will give you the only item, 
# but raise exceptions for a query with zero or multiple results
from sqlalchemy.orm.exc import NoResultFound
from sqlalchemy.orm.exc import MultipleResultsFound

try:
    user = session.query(User).one()
except MultipleResultsFound, e:
    print e
    # Deal with it
except NoResultFound, e:
    print e
    # Deal with that as well

Popularity 7/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: get python row sqlalchemy

Link to this answer
Share Copy Link