Re: [sqlalchemy] Batching INSERT statements

On Fri, Feb 12, 2021, at 2:06 PM, Cristian Bulgaru wrote: > Hi Vineet, Mike, > > @Vineet, thank you for the interesting blog post on bulk insert with > SQLAlchemy ORM: >

Re: [sqlalchemy] Batching INSERT statements

I'm not familiar with this exactly, but have a bit of experience in this area. I just took a look at this module (nice work!). It's VERY well documented in the docstrings (even nicer work!) I think the core bit of this technique looks to be in `_get_next_sequence_values` -

Re: [sqlalchemy] Batching INSERT statements

Hi Vineet, Mike, @Vineet, thank you for the interesting blog post on bulk insert with SQLAlchemy ORM: https://benchling.engineering/sqlalchemy-batch-inserts-a-module-for-when-youre-inserting-thousands-of-rows-and-it-s-slow-16ece0ef5bf7 A few questions: 1. Do we need to get the incremented IDs

[sqlalchemy] Re: Relationship with 2 intermediary tables

This is, IMHO, one of the most complex parts of SQLAlchemy. In this public project, i have a handful of secondary/secondaryjoin examples that may help you https://github.com/aptise/peter_sslers/blob/main/peter_sslers/model/objects.py#L3778-L4714 There is a section in the docs that should help