import psycopg2
import db


# This controls how many new jobs get inserted by insert_new_jobs function
how_many = 100


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

    This inserts 100 new jobs into jobs job queue table.
    """
    cursor.execute("BEGIN TRANSACTION")
    for i in range(how_many):
        cursor.execute("INSERT INTO jobs(status) VALUES ('REQUESTED')")
    cursor.execute("COMMIT TRANSACTION")


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