Re: [sqlalchemy] How to bulk-insert millions of values into Oracle

2016-09-26 Thread Seth P
Thanks. I guess my confusion is that the example at http://docs.sqlalchemy.org/en/latest/core/tutorial.html#executing-multiple-statements uses an array of dictionaries, not of unlabeled tuples. Meanwhile I ended up using Oracle's sqlldr, which seems to get the job done, though is much more

Re: [sqlalchemy] How to bulk-insert millions of values into Oracle

2016-09-23 Thread Mike Bayer
On 09/21/2016 02:08 PM, Seth P wrote: The answer to this is probably RTFM, but I can't figure it out. Suppose I have a declarative model of the form class MyModel(Model): idx = sa.Column(sa.Integer, primary_key=True) c1 = sa.Column(sa.Float) c2 = sa.Column(sa.Integer) ...

[sqlalchemy] How to bulk-insert millions of values into Oracle

2016-09-23 Thread Seth P
The answer to this is probably RTFM, but I can't figure it out. Suppose I have a declarative model of the form class MyModel(Model): idx = sa.Column(sa.Integer, primary_key=True) c1 = sa.Column(sa.Float) c2 = sa.Column(sa.Integer) ... c10 = sa.Column(sa.Float) And a list of