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