Execute Returning None with PostgreSQL in Python

Question

Here is my code

conn_string = "dbname=detector user=postgres password=1234 host=localhost port=5432"
print "Connecting to database\n    ->%s" % (conn_string)     
# get a connection, if a connect cannot be made an exception will be raised here
conn = psycopg2.connect(conn_string)

which it is outputting this, which seems to be ok.

Connecting to database
    ->dbname=detector user=postgres password=1234 host=localhost port=5432

I use this connection as function(data, conn). Now, I noticed strange outputs with the test command:

_measurement_id = cursor.execute(
    'SELECT measurement_id FROM measurements ORDER BY time desc limit 1;'
);

which returns None through Python but inside psql, I get an integer. I think the mistake is in not using try-catch-except in creating the connection.

And if that is the problem, how can I pass a PostgreSQL connection to functions in Python?

Colonel Thirty Two · Accepted Answer · 2015-07-29 19:54:22Z

4

cursor.execute doesn't return anything. You need to use cursor.fetchone, cursor.fetchall, or for row in cursor: after executing the query to retrieve the results.

cursor.execute("...")
_measurement_id = cursor.fetchone()

It has nothing to do with exception handling.

answered Jul 29, 2015 at 19:54

Colonel Thirty Two

27k9 gold badges52 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dima Kudosh · Accepted Answer · 2015-07-29 19:50:52Z

0

try do this

try:
    cursor.execute(
    'SELECT measurement_id FROM measurements ORDER BY time desc limit 1;')
    _measurement_id = cursor.fetchone()
except psycopg2.Error as e:
    pass
finally:
    cursor.close()

answered Jul 29, 2015 at 19:50

Dima Kudosh

7,4245 gold badges40 silver badges53 bronze badges

Collectives™ on Stack Overflow

Execute Returning None with PostgreSQL in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related