On Thu, Feb 07, 2008 at 04:38:04PM -0600, Christopher Singley wrote:
> On Thursday 07 February 2008 15:58:37 Oleg Broytmann wrote:
> > Alas! There were two wiki sites but both are dead now. The lack of
> > resources on the admin site, and probably the lack of interest on the user
> > side.
>
> Strange... isn't there supposed to be some renaissance of interest in ORM
> tools happening now? (Web 2.0 etc. etc.)
Probably, but SQLObject is far from being the only ORM in the Python
world, or even the most popular, though it's one of the most popular.
> Anyway, if you're not tired of answering questions yet... what about
> SQLObject's mapping of DecimalCol to sqlite?
SQLObject has its own methods of converting/coercing data to/from Python
from/to DB. Of course, SQLObject can only operate on the data returned by
DB API driver - PySQLite in your case, so if PySQLite returns a float,
SQLObject converts the float to a Decimal (via str(), yes).
> Have you had any experience with sqlite's storage fidelity for decimal #s?
I have, as I have a few Decimal columns in the database of one of our
company's commercial programs - we count money (dollars and cents). Until
now none of our customers has problems, though I doubt one has tried to
sum up all those cents and fractions.
If you find a problem - please publish more details. In case of PySQLite
there is a way to map data to/from strings for any data; currently
SQLObject uses this feature to map strings to/from unicode, and map
date/time strings; it would be possible to add a mapping for Decimals.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
