public inbox for [email protected]  

help / color / mirror / Atom feed

From: Hagen Finley <[email protected]>
To: [email protected]
To: [email protected]
Subject: Handling (None,) Query Results
Date: Sat, 5 Dec 2020 08:57:06 -0700
Message-ID: <[email protected]> (raw)

Hello,

I was thinking ‘finally, something I know how to do’ but alas simple 
sum(revenue) where select statements in psycopg2 have proven to be more 
complex than I imagined.

First, there’s the Decimal tuple parsing which I can do (albeit somewhat 
unnaturally)  (Decimal('450992.10'),)

cur.execute("SELECT SUM(revusd) FROM sfdc where saccount = 'Big Company' AND stage 
LIKE 'Commit%';")
commitd1 = cur.fetchone()
conn.commit()
commitd2 = commitd1[0]


if type(commitd2)is not None:commit =int(commitd2)
   
else:
     commit =0

450992.10

<class 'int'>

If there is a better way to get to int I'd be all ears.


Second, there’s the NoneType  (None,) result from queries with no values.

cur.execute("SELECT SUM(revusd) FROM sfdc where saccount = 'Big Company' AND stage 
LIKE 'Win%';")
wind1 = cur.fetchone()
conn.commit()
wind2 = wind1[0]


if type(wind2)is int:win =int(wind2)

else:
     win =0

My goal is to return 0.00 when there are no results and an int when 
there are results using the same code. Right now my if statements are 
different:

if type(commitd2)is not None:

if type(wind2)is int:

Possibly ignoring my fledgling attempts to solve this problem, is there 
a simple method by which people convert the:

1. (Decimal('450992.10'),) to a <class 'int'> 450992.10?

2. (None,) to 0.00?

  Thanks for your thoughts on this question.

Best,

Hagen Finley

Fort Collins, CO

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Handling (None,) Query Results
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox