Yes, this is what I was aiming to do. Maybe I've got the sql alchemy syntax wrong? I though insert().values took in iterables for row by row inserts...
The Insert construct also supports multiply-rendered VALUES construct, for those backends which support this SQL syntax (SQLite, Postgresql, MySQL). This mode is indicated by passing a list of one or more dictionaries/tuples:
users.insert().values([ {"name": "some name"}, {"name": "some other name"}, {"name": "yet another name"}, ])
On Aug 30, 2015, at 11:59 AM, Christopher Brooks <brooksch@umich.edu <mailto:brooksch@umich.edu>> wrote: > [SQL: 'INSERT INTO qualtrics_dim (k, v) VALUES (%(k)s, %(v)s)'] [parameters: {'v': ['aa', 'bb'], 'k': ['a', 'b']}]
The values you've written there are two arrays of TEXT values, but the columns aren't declared as TEXT or VARCHAR arrays, but as single VARCHAR values. Are you trying to insert two rows of the form 'aa', 'a' and 'bb', 'b'?