def resultdata():
if request.method == 'POST':
obj = request.json
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
labresult = obj.get("result")
title = labresult.get("title")
value = labresult.get("value")
limit = labresult.get("limit")
rowkey = userid + "_" + appid + "_" + date
_value = str(value) + ',' + str(limit)
# print json.dumps(obj, indent=4, separators=(',', ': '))
manager.insert_data(table_result, rowkey, 'testresults', title, _value)
return jsonify(success="true")
elif request.method == 'GET':
# not use this condition
# data = {}
# column = base64.b64encode("{}:{}".format('activity', title))
# result = manager.fetch_part(table_exercise, start_row, end_row, column)
# data[title] = service.summary_by_date(result, 'activity', title)
data = manager.fetch(table_result, 'lucksika_display01_2017-01-26')
# print data
# print type(data)
title = 'BUN'
value = 1.2
limit = 1.5
check_date = '2015-12-23'
return jsonify(title=title, value=value, limit=limit, check_date=check_date)
def resultdata():
if request.method == 'POST':
obj = request.json
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
labresult = obj.get("result")
title = labresult.get("title")
value = labresult.get("value")
limit = labresult.get("limit")
rowkey = userid + "_" + appid + "_" + date
_value = str(value) + ',' + str(limit)
# print json.dumps(obj, indent=4, separators=(',', ': '))
manager.insert_data(table_result, rowkey, 'testresults', title, _value)
return jsonify(success="true")
elif request.method == 'GET':
data = manager.fetch(table_result, 'lucksika_display01_2017-01-26')
# print data
# print type(data)
title = 'BUN'
value = 1.2
limit = 1.5
check_date = '2015-12-23'
return jsonify(title=title,
value=value,
limit=limit,
check_date=check_date)
def activity_result_1():
if request.method == 'POST':
obj = request.json
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
time = obj.get("time")
results = obj.get("results")
results_json = json.dumps(results, ensure_ascii=False, encoding='utf8')
rowkey = userid + "_" + appid + "_" + date + "_" + time
# data = {}
# data['activity_result_1'] = results_json
# manager.save_batch(table_activity_results_1, rowkey, results_json)
manager.insert_data(table_activity_results_1, rowkey,
'activity_result_1', 'result', results_json)
return jsonify(success="true")
elif request.method == 'GET':
userid = request.args.get("userid")
appid = request.args.get("appid")
begin = request.args.get("start_date") # "2017-09-11"
end = request.args.get("end_date") # 2017-09-15
# Get data
end = dt.datetime.strptime(end, "%Y-%m-%d")
end = end + dt.timedelta(days=1)
start_row = base64.b64encode("{}_{}_{}_".format(userid, appid, begin))
end_row = base64.b64encode("{}_{}_{}_".format(userid, appid, end))
desc = manager.fetch_from_with_row_id(
table_activity_results_1, start_row, end_row)
desc_list = list(desc)
for dl in desc_list:
dl.values()[0]['activity_result_1']['result'] = json.loads(
dl.values()[0]['activity_result_1']['result'].replace("\'", '"'))
return jsonify(data=desc_list)
elif request.method == 'DELETE':
userid = request.args.get("userid")
appid = request.args.get("appid")
date = request.args.get("date")
time = request.args.get("time")
rowkey = userid + "_" + appid + "_" + date + "_" + time
manager.delete_row(table_activity_results_1, rowkey)
return jsonify(success="true")
def six_mins_walk():
if request.method == 'POST':
obj = request.json
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
time = obj.get("time")
results = obj.get("results")
results_json = json.dumps(results, ensure_ascii=False, encoding='utf8')
rowkey = userid + "_" + appid + "_" + date + "_" + time
manager.insert_data(table_6minswalk, rowkey,
'6minswalk', 'result', results_json)
return jsonify(success="true")
rowkey = userid + "_" + appid + "_" + date + "_" + time
elif request.method == 'GET':
userid = request.args.get("userid")
appid = request.args.get("appid")
# Get data
start_row = base64.b64encode("{}_{}_".format(userid, appid))
desc = manager.fetch_from_with_row_id(
table_6minswalk, start_row)
desc_list = list(desc)
for dl in desc_list:
dl.values()[0]['6minswalk']['result'] = json.loads(
dl.values()[0]['6minswalk']['result'].replace("\'", '"'))
return jsonify(data=desc_list)
elif request.method == 'DELETE':
userid = request.args.get("userid")
appid = request.args.get("appid")
date = request.args.get("date")
time = request.args.get("time")
rowkey = userid + "_" + appid + "_" + date + "_" + time
manager.delete_row(table_6minswalk, rowkey)
return jsonify(success="true")
def import_appointment():
if request.method == 'POST':
obj = request.json
appointments = obj
for userid_appid_date, data in appointments.items():
words = userid_appid_date.split('_')
userid = words[0]
appid = words[1]
date = words[2]
description = json.dumps(data['description'], ensure_ascii=False)
rowkey = userid + "_" + appid + "_" + date
manager.insert_data(table_information, rowkey,
'treatment', 'appointment', description)
return jsonify(success="true")
else:
return jsonify(success="false")
def appointment():
if request.method == 'POST':
obj = request.json
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
description = json.dumps(obj.get("description"), ensure_ascii=False)
rowkey = userid + "_" + appid + "_" + date
manager.insert_data(table_information, rowkey,
'treatment', 'appointment', description)
# print json.dumps(obj, indent=4, separators=(',', ': '))
return jsonify(success="true")
elif request.method == 'GET':
userid = request.args.get("userid")
appid = request.args.get("appid")
month = request.args.get("month")
year = request.args.get("year")
begin = year + '-' + month + '-01'
end = year + '-' + month + '-31'
print "===> begin ; ", begin
print "===> end ; ", end
start_row = base64.b64encode("{}_{}_{}".format(userid, appid, begin))
end_row = base64.b64encode("{}_{}_{}".format(userid, appid, end))
column = base64.b64encode("treatment:appointment")
data = manager.fetch_part(
table_information, start_row, end_row, column)
data_json = service.generate_key_value_appointment(data)
return jsonify(data=data_json)
def exercise():
if request.method == 'POST':
obj = request.json
activity = obj.get("activity")
result = obj.get("result")
columnFamily = ""
# print request
userid = obj.get("userid")
appid = obj.get("appid")
date = obj.get("date")
if result != None:
title = result.get("title")
value = result.get("value")
goal = result.get("limit")
columnFamily = 'water'
elif activity != None:
title = activity.get("title")
value = activity.get("value")
goal = activity.get("goal")
columnFamily = 'activity'
time = dt.datetime.now().strftime("%H:%M:%S")
rowkey = userid + "_" + appid + "_" + date + "_" + time
_value = str(value) + ',' + str(goal)
manager.insert_data(table_exercise, rowkey,
columnFamily, title, _value)
# print json.dumps(obj, indent=4, separators=(',', ': '))
return jsonify(success="true")
elif request.method == 'GET':
maxDateAmount = 7
userid = request.args.get("userid")
appid = request.args.get("appid")
title = request.args.get("title")
string_date = request.args.get("date")
amount = request.args.get("amount")
amount = int(amount)
amount = (amount if amount < maxDateAmount and amount >
0 else maxDateAmount) + 2
end = dt.datetime.strptime(string_date, "%Y-%m-%d")
end = end + dt.timedelta(days=1)
begin = end - dt.timedelta(days=(amount))
start_row = base64.b64encode("{}_{}_{}_".format(userid, appid, begin))
end_row = base64.b64encode("{}_{}_{}_".format(userid, appid, end))
column = base64.b64encode("activity")
if not title:
result = manager.fetch_part(
table_exercise, start_row, end_row, column)
_result = list(result)
keys = service.group_by_key(_result, "activity").keys()
data = {}
for _title in keys:
data[_title] = service.summary_by_date(
_result, 'activity', _title)
else:
data = {}
column = base64.b64encode("{}:{}".format('activity', title))
result = manager.fetch_part(
table_exercise, start_row, end_row, column)
data[title] = service.summary_by_date(result, 'activity', title)
chart = service.generate_info_exercise_barchart(data)
return jsonify(chart=chart, data=data)