Function query_results

code/IO/postgres_crud.py:64–70

(cursor)

    print(f'inserted {n_records} rows in {time.time()-T_start:.3} sec')

def query_results(cursor):
    query = "select sum(price), sum(n), pet from myvalues group by pet"
    cursor.execute(query)
    print(f'Result of {query}:')
    for sum_price, sum_n, pet in cursor.fetchall():
        print(f'  {sum_price:.2f}  {sum_n:6d}  {pet:>7s}')
    print('-' * 60)

def rename_pets(cursor, before, after):
    update_cmd = f"update myvalues set pet='{after}' where pet='{before}'"