def find_by_customer_id(customer_id):
try:
db = DbController()
query = "SELECT * FROM tbl_clv_prediction where customer_id = %s"
return db.execute_select(query, [customer_id])
except Exception as e:
raise e
def read_total():
response = {}
try:
db_object = DbController()
query = "SELECT COUNT(*) as total FROM tbl_clv_prediction"
data = db_object.execute_select(query)
response["data"] = data[0]
except Exception as e:
response['error'] = '%s' % e
return jsonify(response)