pgdml.py Part 3

pgdml_3.py

def update_photos():

    update_dict = {"description": "Edinburgh Photo 2", "photoid": 10}

    try:

        conn = pgconnection.get_connection("codeinpython")
        cursor = conn.cursor()

        cursor.execute("UPDATE photos SET description = %(description)s WHERE photoid = %(photoid)s;", update_dict)

        conn.commit()

        print("Photo updated")

        cursor.close()
        conn.close()

    except psycopg2.Error as e:

        print(type(e))

        print(e)