Getting first row from sqlalchemy

by

Use query.one() to get one, and exactly one result. In all other cases it will raise an exception you can handle:

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

There’s also query.first(), which will give you just the first result of possibly many, without raising those exceptions. But since you want to deal with the case of there being no result or more than you thought, query.one() is exactly what you should use.

More Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. jsonify a SQLAlchemy result set in Flask [duplicate]
  3. How to build a flask application around an already existing database?
  4. Flask sqlalchemy many-to-many insert data
  5. How to delete a record by id in Flask-SQLAlchemy
  6. Get inserted key before commit session
  7. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  8. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  9. flask-sqlalchemy or sqlalchemy
  10. Flask-SQLAlchemy Constructor
  11. SQLAlchemy ordering by count on a many to many relationship
  12. flask sqlalchemy query with keyword as variable
  13. Flask SQLAlchemy query, specify column names
  14. SQLAlchemy ORM conversion to pandas DataFrame
  15. Flask-SQLAlchemy import/context issue
  16. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  17. Case Insensitive Flask-SQLAlchemy Query
  18. How to update SQLAlchemy row entry?
  19. Serve image stored in SQLAlchemy LargeBinary column
  20. SQLAlchemy ManyToMany secondary table with additional fields
  21. Can SQLAlchemy be used with Google Cloud SQL?
  22. Updates to JSON field don’t persist to DB
  23. ImportError: No module named MySQLdb
  24. Flask-SQLAlchemy db.create_all() raises RuntimeError working outside of application context
  25. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  26. ImportError: No module named sqlalchemy
  27. creating a database outside the application context
  28. Using SQLAlchemy models in and out of Flask
  29. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  30. Tyring to set up modelview with Flask-Admin causes ImportError

Leave a Comment