On Fri, May 15, 2009 at 10:09:01AM -0700, Daniel Fetchinson wrote:
> Actually, I think TimedeltaCol could be implemented for sqlite as
> well. Although it doesn't have an INTERVAL data type it could use a
> plain TEXT instead and python would do the conversion. As far as I
> know sqlite only knows TEXT anyway so IntCol, StringCol, etc, all
> these things are implemented as TEXT and the data conversion is done
> by python. The TimedeltaCol could be similar.
Well, not exactly - SQLite understands and produces some data types -
pysqlite passes them unmodified AFAIU. But anyway I did a similar trick
with DecimalStringCol - it stores decimals as strings to work around
SQLite's "type affinity" feature.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
