def login():
data = request.get_json()
h = hashlib.md5()
h.update(data["password"].encode('utf-8'))
h = h.hexdigest()
sqlFormula = "SELECT password, token, idusers FROM users WHERE email = " + "\"" + data[
"email"] + "\""
user = myDB.sqlQuery(sqlFormula)
if user[0][0] == h:
sqlFormula = "UPDATE users SET loginStatus = %s WHERE email = " + "\"" + data[
"email"] + "\""
sqlTuple = (1, )
myDB.sqlChange(sqlFormula, sqlTuple)
response = {"token": user[0][1], "idusers": user[0][2]}
res = make_response("token")
res.set_cookie(key="tokenPL",
value=str(response["token"]),
max_age=60 * 60 * 24 * 30)
res.set_cookie(key="idusersPL",
value=str(response["idusers"]),
max_age=60 * 60 * 24 * 30)
return res
return
def logout():
data = request.get_json()
sqlFormula = "UPDATE users SET loginStatus = %s, token = %s WHERE idusers = %s"
sqlTuple = (0, random.randint(0, 999), data["idusers"])
noError = myDB.sqlChange(sqlFormula, sqlTuple)
return jsonify(noError)
def editEmail():
data = request.get_json()
sqlFormula = "UPDATE users SET email = %s WHERE idusers = %s"
sqlTuple = (data["email"], data["idusers"])
noError = myDB.sqlChange(sqlFormula, sqlTuple)
return jsonify(noError)
def editDelete():
idusersPL = request.cookies.get('idusersPL')
sqlFormula = "DELETE FROM users WHERE idusers = %s"
sqlTuple = (idusersPL, )
noError = myDB.sqlChange(sqlFormula, sqlTuple)
return jsonify(noError)
def signUp():
data = request.get_json()
h = hashlib.md5()
h.update(data["password"].encode('utf-8'))
h = h.hexdigest()
sqlFormula = "INSERT INTO users (email, username, password, loginStatus, token, isActive, admin) VALUES (%s, %s, %s, %s, %s, %s, %s)"
sqlTuple = (data["email"], data["username"], h, False,
random.randint(0, 999), True, False)
noError = myDB.sqlChange(sqlFormula, sqlTuple)
return jsonify(noError)
def setPost():
try:
tokenPL = request.cookies.get('tokenPL')
idusersPL = request.cookies.get('idusersPL')
except AttributeError as error:
print(error)
raise InvalidUsage("Erro na autenticação. Tente novamente.",
status_code=401)
if tokenCheck(idusersPL, tokenPL):
data = request.get_json()
sqlFormula = "INSERT INTO posts (idusers, title, text, time) VALUES (%s, %s, %s, %s)"
sqlTuple = (idusersPL, data["title"], data["text"], data["time"])
noError = myDB.sqlChange(sqlFormula, sqlTuple)
if noError:
return "Post salvo com sucesso."
raise InvalidUsage("Erro ao salvar o post. Tente novamente.",
status_code=410)