Пустой ответ SQL запроса psycop2, а при запросе через консоль возвращает строку?

Question

[Konstantin Malyarov]

def show_all_orders():
    conn = try_connect()
    cursor = conn.cursor()
    try:
        rows = cursor.execute("SELECT * FROM orders")
        conn.commit()
        conn.close()
        cursor.close()
        print('Записи таблицы orders получены')
        return rows
    except Exception as e:
        print(f'Ошибка выборки записей orders: {str(e)}')
    print('Окончание запроса к таблице orders')

print(rows) выдает None

Comments

[sim3x]

Покажите коннект

Попробуйте https://pynative.com/python-postgresql-tutorial/#P...

import psycopg2
try:
    connection = psycopg2.connect(user = "sysadmin",
                                  password = "pynative@#29",
                                  host = "127.0.0.1",
                                  port = "5432",
                                  database = "postgres_db")
    cursor = connection.cursor()
    # Print PostgreSQL Connection properties
    print ( connection.get_dsn_parameters(),"\n")
    # Print PostgreSQL version
    cursor.execute("SELECT version();")
    record = cursor.fetchone()
    print("You are connected to - ", record,"\n")
except (Exception, psycopg2.Error) as error :
    print ("Error while connecting to PostgreSQL", error)
finally:
    #closing database connection.
        if(connection):
            cursor.close()
            connection.close()
            print("PostgreSQL connection is closed")

[Konstantin Malyarov]

У меня fetchall не было.

[VinayKh27604196]

def show_all_orders():
    conn = try_connect()
    cursor = conn.cursor()
    try:
        cursor.execute("SELECT * FROM orders")
        
        # get only first row data
        #result = cursor.fetchone()
     
        #get all the rows
        rows = cusror.fetchall()

       
        print('Записи таблицы orders получены')
        return rows
    except Exception as e:
        print(f'Ошибка выборки записей orders: {str(e)}')
    print('Окончание запроса к таблице orders')
    conn.commit()
    conn.close()
    cursor.close()

Python postgreSQL связь

Answer 1

[deepblack]

fetchall

cur.execute("SELECT * FROM orders;")
rows = cur.fetchall()