[SQLObject] sum and floats

[Josu O. <jo...@ub...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

i don't know if this is discussed.

I'm trying to use SelectResults.sum to get the total for a column of
floats. I think that it is trying to convert the result to an integer.

Example:

#-------------
from sqlobject import *

class Invoice(SQLObject):
~  provider = StringCol()
~  total = FloatCol()


conn = SQLiteConnection(':memory:')
Invoice._connection = conn

Invoice.createTable()

Invoice(provider='A', total=3.27)
Invoice(provider='B', total=9.63)

q = Invoice.select()

print q.sum(Invoice.q.total)
#----------------------

gets:

- -------------------------
Traceback (most recent call last):
~  File "sql_sum_test.py", line 19, in ?
~    print q.sum(Invoice.q.total)
~  File "/usr/lib/python2.2/site-packages/sqlobject/main.py", line 1271,
in sum
~    return self.accumulate(expression)
~  File "/usr/lib/python2.2/site-packages/sqlobject/main.py", line 1251,
in accumulate
~    return conn.accumulateSelect(self,expression)
~  File "/usr/lib/python2.2/site-packages/sqlobject/dbconnection.py",
line 248, in accumulateSelect
~    val = int(self.queryOne(q)[0])
ValueError: invalid literal for int(): 12.9
- -------------------------

(SQLObject version in 0.6)

is this a bug or a feature?


- --



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBil9B5ju4HVxhuqQRAjcTAKDXtSrCYLzR3/EeQ+iO7gMlTmyATgCfYpsM
vShKUUQ9kocy22toP9D2pIc=
=xHKA
-----END PGP SIGNATURE-----