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)