pgdml.py Part 7

pgdml_7.py

def reset_serial():

    try:

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

        cursor.execute("ALTER SEQUENCE photos_photoid_seq RESTART WITH 1")

        print("photo table serial reset")

        cursor.close()
        conn.close()

    except psycopg2.Error as e:

        print(type(e))

        print(e)