def getLastSession():
query = "SELECT MAX(id) FROM session"
record = ""
con = Connection(query,record)
user = con.fetchOneQuerySQL()
query = """
SELECT user FROM session
WHERE id = %s
"""
record = (user[0],)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
return result[0]
def returnMinDate(user):
query = "SELECT MIN(dateCreated) FROM lift WHERE user_id = %s"
record = (user,)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
try:
return result[0].strftime("%Y-%m-%d")
except:
return datetime.now().strftime('%Y-%m-%d')
def ifUser(username):
query = "SELECT user_id FROM user WHERE name = %s"
record = (username,)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
if result == None:
return 0
else:
return result[0]
def checkLoginValid(username,password):
query = "SELECT password FROM user WHERE name = %s"
record = (username,)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
if result == None:
return 0
elif result[0] != password:
return -1
else:
return 1
def fromExcToAbr(exc):
query = "SELECT abbreviation FROM excercise WHERE name = %s"
record = (exc,)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
return result[0]
def idFromUser(user):
query = "SELECT user_id FROM user WHERE name = %s"
record = (user,)
con = Connection(query,record)
result = con.fetchOneQuerySQL()
return result[0]
