def setCustomersByMembership(m_id):
'''This function is used to set the customer based on membership_id as a foriegn key'''
with SessionManager(Session) as session:
try:
first_name = request.json['first_name']
last_name = request.json['last_name']
middle_name = request.json.get('middle_name', 'NA')
contact_number = request.json.get('contact_number', 'NA')
address = request.json.get('address', 'NA')
gender = request.json['gender']
age = request.json['age']
email = request.json.get('email', 'NA')
if not 6 <= int(age) < 99:
return jsonify(error_envelop(400, "Age Error", "Please enter the age between 6 and 99 "))
c = Customer(first_name = first_name,
last_name = last_name,
contact_number = contact_number,
address = address,
gender = gender,
age =age,
membership_id=m_id,
middle_name=middle_name,
email=email)
session.add(c)
session.commit()
return jsonify(post_envelop(200, data=request.json))
except DataError: #this excepyion might probably occur if the value key has a value of non integer
return jsonify(error_envelop(400, 'DataError', 'Use the correct value'))
except IntegrityError:
return jsonify(error_envelop(400, 'IntegrityError','Violates foreign key ({0}) constraint'.format(m_id)))
except:
return jsonify(error_envelop(400,'UnknownError','Error need to be identified'))
评论列表
文章目录