def UpdateUser():
data = request.get_json()
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[UpdateUser] @firstname=?,
@lastname=?,
@email=?,
@sex=?,
@height=?,
@weight=?,
@age=?,
@token=?
"""
params = [
data['firstname'], data['lastname'], data['email'], data['sex'],
data['height'], data['weight'], data['age'],
request.headers['Authorization']
]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
return jsonify({'status': 0})
def checkAuth():
token = request.headers['Authorization']
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[CheckAuth]
@Token=?
"""
params = (token)
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
status = result[0][0]
userType = result[0][1]
userId = result[0][2]
return jsonify({
'status': status,
'userType': userType,
'user_id': userId
})
def Auth():
data = request.get_json()
email = ""
if ('email' in data):
email = data['email']
password = ""
if ('password' in data):
password = data['password']
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[UserAuthorization] @Email=?,
@Password=?,
@Token=?
"""
token = generate_token()
params = (email, password, token)
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
outToken = result[0][0]
response = jsonify({'status': 1, 'token': token})
return response
def CreateExercise():
data = request.get_json()
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[CreateExercises] @kindOfSports=?,
@type=?,
@time=?,
@distance=?,
@weight=?,
@amount=?,
@blockID=?,
@token=?
"""
params = [
data['kindOfSports'], data['type'], data['time'], data['distance'],
data['weight'], data['amount'], data['blockID'], data['token']
]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
response = jsonify({'status': 1, 'message': 'Ok'})
return response
def GetExercises(id, token):
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[GetExercises] @id=?
@token=?
"""
params = [id, token]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
data = []
for row in result:
currentRow = {
'distance': row[5],
'type': row[4],
'weight': row[3],
'createdAt': row[2],
'amount': row[1],
'id': row[0]
}
data.append(currentRow)
response = jsonify({'status': 1, 'exercises': data})
return response
def UserInfo():
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[GetUserInfo] @token=?
"""
params = [request.headers['Authorization']]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
firstname = ""
lastname = ""
age = ""
email = ""
height = ""
weight = ""
role = None
sex = ""
status = 1
message = ""
if (result):
firstname = result[0][0]
lastname = result[0][1]
age = result[0][2]
email = result[0][3]
image = result[0][4]
role = result[0][7]
height = result[0][6]
weight = result[0][5]
sex = result[0][8]
status = 1
if (role == None):
status = 0
message = "User not found"
response = jsonify({
'status': status,
'message': message,
'firstname': firstname,
'lastname': lastname,
'age': age,
'email': email,
'role': role,
'weight': weight,
'height': height,
'image': image,
'sex': sex
})
return response
def CreateBlock():
data = request.get_json()
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[CreateExersiceBlock] @name=?,
@planID=?,
@token=?
"""
params = [data['name'], data['planID'], data['token']]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
response = jsonify({'status': 1, 'message': 'Ok'})
return response
def UpdatePlan(id):
data = request.get_json()
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[UpdatePlan] @postId=?
@duration=?
@name=?
@token=?
"""
params = [
data['postId'], data['duration'], data['name'], data['token']
]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
status = result[0][0]
cursor.close()
connection.close()
if (status == 0):
response = jsonify({'status': 0, 'message': 'Access denied'})
return response
response = jsonify({
'status': 1,
'message': 'Resume was successfully added'
})
return response
def GetPlan():
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[GetPlans] @token=?
"""
params = [request.headers['Authorization']]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
data = []
for row in result:
currentRow = {
'type': row[3],
'description': row[2],
'name': row[1],
'id': row[0]
}
data.append(currentRow)
response = jsonify(data)
return response
def api_registration():
print(request.get_json())
data = request.get_json()
email = data['email']
is_email_valid = validate_email(email)
if (is_email_valid == False):
return jsonify({'status': 0, 'message': 'Email is not valid!'})
password = data['password']
if (len(password) < 8):
return jsonify({'status': 0, 'message': 'Password is too short'})
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[uspCreateNewUser] @email=?,
@password=?,
@firstname=?,
@lastname=?,
@role=?,
@age=?,
@height=?,
@sex=?,
@weight=?
"""
userType = 0 if data['role'] == 'User' else 1
params = (data['email'], data['password'], data['firstname'],
data['lastname'], userType, data['age'], data['height'],
data['sex'], data['weight'])
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
status = result[0][0]
cursor.close()
del cursor
connection.close()
if (status == 0):
response = jsonify({
'status': 0,
'message': 'This email has already been registered!'
})
return response
response = jsonify({
'status': 1,
'message': 'You have been successfully registered!'
})
return response
def DeleteExercise(id, token):
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[DeleteExercise] @id=?
@token=?
"""
params = [id, token]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
def DeleteBlock():
connection = DBConnection.NewConnection()
data = request.get_json()
sql = """\
EXEC [dbo].[DeleteBlocks] @id=?
@token=?
"""
params = [id, token]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
def UpdateBlock():
data = request.get_json()
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[UpdateBlocks] @id=?
@name=?
@token=?
"""
params = [planId, data['name'], data['token']]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
def CreatePlan():
data = request.get_json()
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[CreatePlans] @description=?,
@type=?,
@name=?,
@token=?
"""
params = [
data['description'], data['type'], data['name'],
request.headers['Authorization']
]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
response = jsonify({'status': 1, 'message': 'Create'})
return response
def getFullPlanInfo(id):
connection = DBConnection.NewConnection()
if (connection == None):
response = jsonify({
'status': 0,
'message': 'Unable to connect to the database'
})
return response
sql = """\
EXEC [dbo].[GetBlocks] @id=?
@token=?
"""
params = [id, request.headers['Authorization']]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
data = []
for row in result:
currentRow = {'name': row[1], 'id': row[0]}
data.append(currentRow)
if (not data):
response = jsonify({
'status': 0,
'message': 'There is not plan with current id'
})
return response
response = jsonify({'status': 1, 'data': data})
return response
def UpdateExercise(id):
data = request.get_json()
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[UpdateExercise] @id=?
@token=?
@distance=?
@type=?
@weight=?
@createdAt=?
@amount=?
"""
params = [
id, data['token'], data['distance'], data['type'], data['weight'],
data['createdAt'], data['amount']
]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
cursor.close()
connection.close()
def DeletePlan(id, token):
connection = DBConnection.NewConnection()
sql = """\
EXEC [dbo].[DeletePlan] @id=?
@token=?
"""
params = [id, token]
cursor = connection.cursor()
cursor.execute(sql, params)
result = cursor.fetchall()
cursor.commit()
status = result[0][0]
cursor.close()
connection.close()
if (status == 0):
response = jsonify({'status': 0, 'message': 'Access denied'})
return response
response = jsonify({
'status': 1,
'message': 'Resume was successfully added'
})
return response