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