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()