Re: [sqlalchemy] Multiple inserts parameter inconsistency

2018-01-03 Thread Aubrey
Hello, I came across this while I was building an experimental project to get to grips with sqlalchemy. I wanted to only set some fields when inserting rows, but wanted to decouple the code that actually built the SQL from the decision logic, which led me to pass column references, which led me

Re: [sqlalchemy] Multiple inserts parameter inconsistency

2018-01-02 Thread Mike Bayer
On Tue, Jan 2, 2018 at 7:53 PM, Aubrey wrote: > Hello, > > I've just been thrown by what seems like an inconsistency in how parameters > can be passed to an insert statement that adds multiple rows. > > To demonstrate: > > > from sqlalchemy import MetaData, String, Integer, Table, Column > from s

[sqlalchemy] Multiple inserts parameter inconsistency

2018-01-02 Thread Aubrey
Hello, I've just been thrown by what seems like an inconsistency in how parameters can be passed to an insert statement that adds multiple rows. To demonstrate: from sqlalchemy import MetaData, String, Integer, Table, Column from sqlalchemy.dialects.postgresql.base import PGDialect m = MetaDa