def listOfExcercise():
query = "SELECT name FROM excercise ORDER BY type DESC, name"
record = ""
con = Connection(query,record)
result = con.fetchAllQuerySQL()
exc = [r[0] for r in result]
#exc.append(" ")
return exc
def returnDateLogin(user_id):
query = "SELECT DISTINCT dateCreated FROM lift WHERE user_id = %s"
record = (user_id,)
#result = list(fetchAllQuerySQL(query,record))
con = Connection(query,record)
result = con.fetchAllQuerySQL()
date = [d[0] for d in result]
dateString = [dt.strftime("%Y-%m-%d") for dt in date]
return dateString
