Re: [DB-SIG] documenting whether or not the seq_of_parameters to executemany is expected to be run in order given

2023-04-09 Thread Mike Bayer
It's my understanding that a lot of executemany() implementations will actually run the given statement once per each element in the sequence of parameters. such as, it creates a prepared statement handle for the statement, then runs each parameter set. a driver that works this way can documen

Re: [DB-SIG] documenting whether or not the seq_of_parameters to executemany is expected to be run in order given

2023-04-09 Thread Tony Locke
My initial thought is that the driver must pass the executemany parameters on to the server without changing the order of the parameters. Maybe that should be explicitly stated in the spec. Once the server has the parameters then I think the behaviour becomes DBMS dependent. I guess my philosophy i

Re: [DB-SIG] documenting whether or not the seq_of_parameters to executemany is expected to be run in order given

2023-04-09 Thread Erlend Egeberg Aasland
On Fri, 7 Apr 2023 at 19:15, Mike Bayer wrote: > > […] The scope here is, should pep-249 add some verbiage: "the order in > which parameters are processed by executemany() should not be assumed to be > in the order the parameters were given". […] > Sounds good to me. Erlend > _