def getTimes(eventID): r = getRecurring(eventID)[0][0] if (r == 1): query = "select Recurring.timeSlot, Recurring.day, Event.eventGranularity, Event.eventName from Recurring natural join Event where eventID = %s" values = (eventID, ) else: query = "select OneTime.timeSlot, oneTime.date, Event.eventGranularity, Event.eventName from OneTime natural join Event where eventID = %s" values = (eventID, ) return sql.getQueryResults(query, values)
def finalizeEvent(eventID, timeSlot): query = "select userEmail from Responses where eventID = %s and timeSlot = %s" values = (eventID, timeSlot) results = sql.getQueryResults(query, values) for res in results: emailer.eventConfirm(res[0], timeSlot) query = "delete from Responses where eventID = %s and timeSlot !=%s" values = (eventID, timeSlot) sql.createQuery(query, values)
def confirmPass(email, guess): query = "select Pass from Users where userID = %s" values = (email, ) target = sql.getQueryResults(query, values)[0][0] salt = binascii.unhexlify(target[:64]) currentHash = genHash(guess, salt) currentTry = binascii.hexlify(salt).decode() + binascii.hexlify( currentHash).decode() try: routes.session['userID'] = email finally: return currentTry == target
def checkForReset(key, email): query = "select validator, date from passReset where userID = %s" values = (email, ) result = sql.getQueryResults(query, values) validator = result[0] date = result[1] if (key == validator): if ((date - datetime.datetime.now()).getseconds() < 3600): return True else: return False else: return False
def getAllMatching(eventID): query = "select userName, timeSlot from Responses where eventID = %s" values = (eventID, ) res = sql.getQueryResults(query, values) temp1 = [] for r in res: temp1.append(r[1]) temp1 = list(dict.fromkeys(temp1)) final = [] for t in temp1: count = 0 for result in res: if result[1] == t: count += 1 final.append((t, count)) return final
def getLastName(userID): query = "select LName from Users where userID = %s" values = (userID, ) return sql.getQueryResults(query, values)
def getUser(userID): query = "select FName, LName, userID from Users where userID = %s" values = (userID, ) return sql.getQueryResults(query, values)
def attendeeAvailability(userEmail, eventID): query = "select userEmail, timeSlot from Responses where userEmail = %s and eventID = %s" values = (userEmail, eventID) return sql.getQueryResults(query, values)
def getAttendeeName(userEmail, eventID): query = "select userName from Responses where userEmail = %s and eventID = %s" values = (userEmail, eventID) return sql.getQueryResults(query, values)
def getAllEvents(userID): query = "select * from Event where eventCreator = %s" values = (userID, ) return sql.getQueryResults(query, values)
def getAllDetails(eventID): query = "select * from Event where eventID = %s" values = (eventID, ) return sql.getQueryResults(query, values)
def getEventID(eventCreator, eventName): # TODO: formatting for datetime query = "select eventID, eventCreationTime from Event where eventName=%s and eventCreator=%s" values = (eventName, eventCreator) records = sql.getQueryResults(query, values) return records
def getOwner(eventID): query = "select eventCreator from Event where eventID=%s" values = (eventID, ) records = sql.getQueryResults(query, values) return records
def getRecurring(eventID): query = "select eventRecurs from Event where eventID=%s" values = (eventID, ) records = sql.getQueryResults(query, values) return records
def getDuration(eventID): query = "select eventDuration from Event where eventID=%s" values = (eventID, ) records = sql.getQueryResults(query, values) return records
def getAllResponses(eventID): query = "select userName, timeSlot from Responses where eventID = %s" values = (eventID, ) return sql.getQueryResults(query, values)