[ANN] PySQLite 0.4.0 released

Gerhard Haering gerhard.haering at gmx.de
Wed Feb 12 20:25:24 EST 2003


* Gerhard H?ring <gerhard.haering at gmx.de> [2003-02-11 14:06 +0000]:
> IMPORTANT BACKWARDS INCOMPATIBLE CHANGE:
> ========================================
> 
> SQLite is typeless, that's why we had the special command
> "pysqlite_pragma expected types = type1, type2, ..., typen" which was parsed
> in the Python layer.
> 
> Of course, this isn't standard SQL so such code isn't portable to other DB-API
> modules.
> 
> That's why I changed this mechanism. The new syntax is
> 
>     -- types = type1, type2, ..., typen

Sorry, typo here.

The syntax is really

    -- types type1, ..., typen


*without* the '='. My new parser for the "-- types" at the C level hardly does
any error checking, so it will accept the first (wrong) form, but return None
for that column, because it cannot find any type converter for the "= type1"
type :-/

-- Gerhard





More information about the Python-list mailing list