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)