[pypy-dev] Bad news about pysqlite-ctypes

[Maciej Fijalkowski]

I'm not sure we should use this. It's seems to be broken. Tests of
divmod's axiom (ORM) on top of cpython + sqlite-ctypes show:
FAILED (skips=5, expectedFailures=1, errors=400, successes=47)
JP Calderone also provided some simple code snippets that explode, ie:

>>> from pysqlite2.dbapi2 import connect
>>> db = connect(':memory:')
>>> db.execute('BEGIN IMMEDIATE TRANSACTION')
<pysqlite2.dbapi2.Cursor object at 0xb7dc4f6c>
>>> db.execute('COMMIT')
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/home/exarkun/Scratch/Source/pysqlite3/pysqlite2/dbapi2.py",
line 315, in execute
    return cur.execute(*args)
  File "/home/exarkun/Scratch/Source/pysqlite3/pysqlite2/dbapi2.py",
line 483, in execute
    raise self.connection._get_exception()
pysqlite2.dbapi2.OperationalError: SQL logic error or missing database
>>>

>>> from pysqlite2.dbapi2 import connect
>>> db = connect(':memory:')
>>> db.execute('create table foo ( x int )')
<pysqlite2.dbapi2.Cursor object at 0xb7d63f6c>
>>> list(_)
[infinite rec]

Not sure where to go from now....

Cheers,
fijal