def get_one_customer(id):
customer = CustomerEntity(customer_id=id)
c = Customer(connection_data)
result = c.get_one_Customer(customer)
return jsonify({'data': result})
def get_all_customer():
c = Customer(connection_data)
result = c.get_all_Customer()
return jsonify({'data': result})
def add_customer():
data = request.json
customer = CustomerEntity(customer_name=data['customer_name'],
contact_name=data['contact_name'],
address=data['address'],
city=data['city'],
postal_code=data['postal_code'],
country=data['country'])
c = Customer(connection_data)
message = c.insert(customer)
if message is None:
return jsonify({'message': 'Cannot insert data'}), 500
return jsonify({'message': message})
def delete_customer_by_id(id):
if request.method == 'DELETE':
# Delete user by id
customer = CustomerEntity(customer_id=id)
c = Customer(connection_data)
result = c.delete_Customer(customer)
return jsonify({'message': result[0]}), result[1]
else:
# Update user by id
data = request.json
customer = CustomerEntity(customer_id=id,
customer_name=data['customer_name'],
contact_name=data['contact_name'],
address=data['address'],
city=data['city'],
postal_code=data['postal_code'],
country=data['country'])
c = Customer(connection_data)
result = c.update_Customer(customer)
return jsonify({'message': result[0]}), result[1]