Bulk insert with SQLAlchemy ORM

by

SQLAlchemy introduced that in version 1.0.0:

Bulk operations – SQLAlchemy docs

With these operations, you can now do bulk inserts or updates!

For instance, you can do:

s = Session()
objects = [
    User(name="u1"),
    User(name="u2"),
    User(name="u3")
]
s.bulk_save_objects(objects)
s.commit()

Here, a bulk insert will be made.

More Related Contents:

  1. How can I verify Column data types in the SQLAlchemy ORM?
  2. SQLAlchemy: how to filter date field?
  3. How do I get the “id” after INSERT into MySQL database with Python?
  4. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  5. How to disable SQLAlchemy caching?
  6. memory-efficient built-in SqlAlchemy iterator/generator?
  7. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  8. SQL Alchemy ORM returning a single column, how to avoid common post processing
  9. SQLAlchemy: cascade delete
  10. Efficiently updating database using SQLAlchemy ORM
  11. SQLAlchemy ON DUPLICATE KEY UPDATE
  12. SQLAlchemy ManyToMany secondary table with additional fields
  13. ImportError: No module named MySQLdb
  14. How to move a model between two Django apps (Django 1.7)
  15. SQLAlchemy: engine, connection and session difference
  16. How do i cast char to integer while querying in django ORM?
  17. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  18. flake8 complains on boolean comparison “==” in filter clause
  19. flask-sqlalchemy or sqlalchemy
  20. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  21. Getting random row through SQLAlchemy
  22. Select NULL Values in SQLAlchemy
  23. How to update sqlalchemy orm object by a python dict
  24. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  25. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  26. Is possible to mapping view with class using mapper in SqlAlchemy?
  27. Retrieve query results as dict in SQLAlchemy
  28. SQLALchemy dynamic filter_by
  29. using sqlalchemy to load csv file into a database
  30. SQLAlchemy ordering by count on a many to many relationship

Leave a Comment