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...
Chris
On Sun, Aug 30, 2015 at 3:01 PM, Christophe Pettus <xof@thebuild.com> wrote:
On Aug 30, 2015, at 11:59 AM, Christopher Brooks <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'?