def getLastJobRecord():
conn = make_connection()
c = conn.cursor()
SQL = Q.SelectLastJobRecord()
c.execute(SQL)
value = c.fetchone()[0]
end_connection(conn)
return value
def startJob(newRecord):
conn = make_connection()
c = conn.cursor()
SQL = Q.InsertIntoJobRecord(newRecord)
c.execute(SQL)
conn.commit()
SQL = Q.SelectLastJobRecord()
c.execute(SQL)
JobIndex = c.fetchone()[0]
SQL = Q.InsertInitnialActivity(newRecord, JobIndex)
c.execute(SQL)
conn.commit()
end_connection(conn)