Get inserted key before commit session

by

You could use flush() to flush changes to the database and thus have your primary-key field updated: 

parent = Parent()
db.session.add(parent)
db.session.flush()

print parent.id  # after flush(), parent object would be automatically
                 # assigned with a unique primary key to its id field 

child = Child()
child.parent_id = parent.id
db.session.add(child)

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. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  7. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  8. Getting first row from sqlalchemy
  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. Flask-SQLAlchemy import/context issue
  15. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  16. Case Insensitive Flask-SQLAlchemy Query
  17. Flask-SQLalchemy update a row’s information
  18. Serve image stored in SQLAlchemy LargeBinary column
  19. Flask Download a File
  20. Implementing Flask-Login with multiple User Classes
  21. Updates to JSON field don’t persist to DB
  22. Is a SQLAlchemy query vulnerable to injection attacks?
  23. Flask-SQLAlchemy db.create_all() raises RuntimeError working outside of application context
  24. ImportError: No module named flaskext.sqlalchemy
  25. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  26. ImportError: No module named sqlalchemy
  27. Using SQLAlchemy models in and out of Flask
  28. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  29. Retrieve query results as dict in SQLAlchemy
  30. Tyring to set up modelview with Flask-Admin causes ImportError

Leave a Comment