Why SQL query returns None?

Question

Python

The essence of this is the request:

SELECT prod_type_id FROM "PROD_TYPE" WHERE prod_type_id=2

In the SQL editor, it returns the number 2. Now I call the same query in Python and it returns none. What is the reason?

currDst.execute(("""SELECT prod_type_id FROM "PROD_TYPE" WHERE prod_type_id=%s""") %prod_type_id)
      pt = currDst.fetchone()
      print "pt: ", pt # упорно возвращает pt:  None хотя заспрос содержит данные

Answer 1

Are you sure prod_type_id contains 2?
Well, and a mandatory recommendation that you do not need to collect SQL queries from strings, but you need to bind parameters.
Also, it looks like you are trying to mimic a JOIN in python code.

Answer 2

Try this when you raise the connection to the database:
connDst.autocommit(True)