mysqldb cursor returning type along with result ?

Lie Ryan lie.1296 at gmail.com
Sun Nov 29 16:57:35 CET 2009


On 11/30/2009 12:14 AM, Paul O'Sullivan wrote:
> Just taken to Python (2.5)and started to look at some DB cursor stuff
> using MySQL.  Anyway, after creating a query that in MySQL that has a
> result set of decimals I find that the cursor in python after a
> fetchall() returns a tuple that contains the following ::
>
> ((Decimal("101.10"),), (Decimal("99.32"),), (Decimal("97.95"),),
> (Decimal("98.45"),), (Decimal("97.39"),), (Decimal("97.91"),), (Decimal
> ("98.08"),), (Decimal("97.73"),))
>
> as such :
>    sum(result)
> fails with "TypeError: unsupported operand type(s) for +: 'int' and
> 'tuple'"
>
> How do I either get the resultset back as 'float' or convert the
> returned tuple to 'floats'.?

I believe it returned decimal.Decimal() objects. You can do arithmetic 
with decimal.Decimals, so:

sum(x[0] for x in result)



More information about the Python-list mailing list