import psycopg2
import db


def reset_job_table(cursor):
    """ reset_job_table(cursor) -> None

    This sets each job in jobs table to 'REQUESTED' status'
    """
    cursor.execute("BEGIN TRANSACTION")
    cursor.execute("UPDATE jobs set status='REQUESTED'")
    cursor.execute("COMMIT TRANSACTION")


connection = db.connect_db()
cursor = connection.cursor()
reset_job_table(cursor)
connection.close()