> On Dec 5, 2020, at 07:57, Hagen Finley <ha...@datasundae.com> wrote:
> 1. (Decimal('450992.10'),) to a <class 'int'> 450992.10?
>
> 2. (None,) to 0.00?
> Thanks for your thoughts on this question.
For #2, you can do that directly in the query:
SELECT COALESCE(SUM(revusd), 0) FROM sfdc where saccount = 'Big
Company' AND stage LIKE 'Win%';
For #1, you can write it more compactly, of course:
commitd1 = int(cur.fetchone()[0])
Note that there's no such thing as an int with value 450992.10, because that's
not an integer. It will truncate it if you cast it to int, or you can use
other operations to round it the way you'd like do.
As you probably know, it's returning a tuple because you are getting back a row
of one column, and a Decimal because (presumably) that's what type revusd is in
the database.
--
-- Christophe Pettus
x...@thebuild.com
