PySqLite2

[anonymous]

with the new databasebackend, can't someone write a pysqlite2 connector?

According to the benchmarks it's around twice as fast

[anonymous]

The problem is that pysqlite2 doesn't use the same formatting as every other DB 2.0 API on the face of the earth. It uses ? and :name style interploation (which is built into SQLite) rather than the standard %s and %(name)s formatting. If someone were to step up to the plate and implemente this for pysqlite2, then it would literally be 20 minutes of work to set up pysqlite2 (I already did it for ​Argon before I realized the interpolation syntax was different).

[Rede <redetin@…>]

I made parameter formatting fix for cx_Oracle when I tried to use Oracle as Trac-backend. I will give it a try to make same for PySqlite2.

[Christopher Lenz]

Gerhard Haering posted a "proof-of-concept" implementation of this to the ​PySQLite mailing list ​here. As the actual content of the message doesn't show in the pipermail archive, I'll copy it here:

Message:

Attached is proof-of-concept for code that allows you to use the pyformat style with pysqlite 2.0. It needs fleshing out for executemany, and maybe for named parameters (%(foo)s, %(bar)s).

In my opinion, something like this could be used to make TRAC compatible with pysqlite 2.

Maybe it is a useful starting point for somebody.

Attachment:

from pysqlite2 import dbapi2 as sqlite

class PyFormatConnection(sqlite.Connection):
    def cursor(self):
        return sqlite.Connection.cursor(self, PyFormatCursor)

class PyFormatCursor(sqlite.Cursor):
    def execute(self, sql, args=None):
        if args:
            qmarks = ["?"] * len(args)
            sql = sql % tuple(qmarks)
            sqlite.Cursor.execute(self, sql, args)
        else:
            sqlite.Cursor.execute(self, sql)

con = sqlite.connect(":memory:", factory=PyFormatConnection)
cur = con.cursor()
cur.execute("create table test(a, b, c)")
cur.execute("insert into test(a, b, c) values (%s, %s, %s)", ('asdf', 4, 5.2))
cur.execute("select a, b, c from test where c <> %s", (4.27,))
print cur.fetchone()
cur.close()
con.close()

[Rede <redetin@…>]

Well above code is almost identical to mine, (but it's even better than mine), so I'll adapt my code to look more like above and post a patch.

[Rede <redetin@…>]

Patch for pysqlite2 wrapper

[Christopher Lenz]

PySQLite 2 support has now been implemented.