Re: [SQLObject] Decimals in sqlite

[Christopher S. <csi...@gm...>]

On Friday 08 February 2008 11:25:57 Oleg Broytmann wrote:
>    If you are going to use (or allow to use) the DB in external non-python
> tools you have to document the mapping, and even the documents could not
> help in case of standard tools that don't know anything about the mapping.
> The mapping is a function of PySQLite2, not SQLite itself:
> http://initd.org/pub/software/pysqlite/doc/usage-guide.html#sqlite-and-pyth
>on-types

I guess the mapping Decimal <-> str ought to be pretty easy, since it's 
supported by Python's decimal module.

Are we talking about modifying sqlobject.sqlite.sqliteconnection.__init__() to 
define adapter/converter function and register them with pysqlite?  Wouldn't 
that just be about 4 lines of code?  Or what are the relevant data 
structures?

You'll have to pardon me.  I don't mind doing work, but looking at the 
SQLObject source code makes my head spin a little bit.

cs