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 = conn.cursor()
> c.execute("INSERT INTO users_roles (user_id, role_id) VALUES (1, 1), (1, 2)")
Is it possible that your pysqlite/sqlite3 driver is linked to an older version
of the sqlite3 libraries ? check sqlite3.sqlite_version_info for that
information, then take a look at http://www.sqlite.org/news.html to see if this
is a more recent feature add.
In any case, this is either an out of date sqlite library or a bug in
pysqlite/sqlite3. If a bug in the Python driver, would mean pysqlite is
parsing the SQL, though that seems very surprising. But in any case the issue
is not within SQLAlchemy.
If your sqlite libraries are up to date as well as your sqlite3/pysqlite
libraries, you'd look into scanning bugs.python.org as well as
http://code.google.com/p/pysqlite/issues/list to see if this has been reported
and you can report it there, using a pure sqlite3 test case. Though i have a
feeling you have two versions of the sqlite database libraries installed.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
