[sqlalchemy] v0.7.9 text() and multi-row inserts failing - sqlite driver issue?

2012-11-15 Thread Adam Venturella
Maybe I am just doing something wrong, but I have been fighting with this for a while to no avail. Here's my code: query = '''INSERT INTO users_roles (user_id, role_id) VALUES (:user_id, :perm0), (:user_id, :perm1)''' t = text(query).execution_options(autocommit=True) self.conn.execute(t,

Re: [sqlalchemy] v0.7.9 text() and multi-row inserts failing - sqlite driver issue?

2012-11-15 Thread Michael Bayer
On Nov 15, 2012, at 2:43 PM, Adam Venturella wrote: Maybe I am just doing something wrong, but I have been fighting with this for a while to no avail. Tried it with the stdlib sqlite3 driver as well, it fails there too: import sqlite3 conn = sqlite3.connect('example.db') c =