def getUsers():
mycursor.execute("SELECT * FROM USERS")
return mycursor.fetchall()
def getRandomId(str, id):
print("SELECT " + str + "_id from " + str + "s where " + str + "_id='" +
id + "';")
mycursor.execute("SELECT " + str + "_id from " + str + "s where " + str +
"_id='" + id + "';")
return mycursor.fetchall()
def getTasks(user_id):
mycursor.execute("SELECT * FROM TASKS where user_id='" + user_id + "';")
return mycursor.fetchall()
def getCandidates():
mycursor.execute("SELECT * FROM CANDIDATES")
return mycursor.fetchall()
def getPlacedCandidates():
mycursor.execute("SELECT * FROM CANDIDATES where state='4'")
return mycursor.fetchall()
def getHiringCandidates():
mycursor.execute("SELECT * FROM CANDIDATES where state='0'")
return mycursor.fetchall()
def getInterviews():
mycursor.execute("SELECT * FROM INTERVIEWS")
return mycursor.fetchall()