def MockAddEvent(title1, datee, desc1):
sqlx = DBAccess.bld_add_sql(title1, datee, desc1)
list_result = DBAccess.add_event(sqlx)
if list_result[0] == 'error':
print "MockAddEvent: error - {}".format(list_result[1])
else:
print "MockAddEvent: success - {}".format(list_result[1])
return list_result[0]
def _MockAddEvent(data_json):
"""
test the web url "/add_event"
"""
title1, date1, desc1 = Tg1Srvr.get_events_values(data_json)
sqlx = DBAccess.bld_add_sql(title1, date1, desc1)
list_result = DBAccess.add_event(sqlx)
if list_result[0] == 'error':
print "MockAddEvent: error - {}".format(list_result[1])
else:
print "MockAddEvent: success - {}".format(list_result[1])
return list_result[0]
def add_event():
"""
Add event function, post request thru form
"""
# add_data_json = request.args.get('add_data')
# data_json = json.loads(add_data_json)
title = request.form.get('event_title')
date1 = request.form.get('event_date')
desc = request.form.get('event_desc')
# title, date1, desc = get_events_values(data_json)
sqlx = DBAccess.bld_add_sql(title, date1, desc)
list_result = DBAccess.add_event(sqlx)
if list_result[0] == 'error':
sj = jsonify({"add_event": list_result[1]})
else:
sj = jsonify({"add_event": list_result[1]})
rmsg = DBAccess.save_new_diary()
return sj
@app.route('/')
def main_index_html():
req = request # debug only
args = req.args # debug only
return send_file("www/templates/index.html")
@app.route('/add_event', methods=["POST"]
def add_event();
title = request.args.get('title')
date1 = request.args.get('date')
desc = request.args.get('desc')
sqlx = DBAccess.bld_add_sql(title, date1, desc)
list_result = DBAccess.add_event(sqlx)
if list_result[0] == 'error':
sj = jsonify({"add_event_error": list_result[1]})
else:
sj = jsonify({"add_event successeded": list_result[1]})
return sj
@app.route('/get_events', method=["GET"])
def get_events():
req = request
start_date = request.args.get("start_date")
end_date = request.args.get("end_date")
context = request.args.get("context")
sqlx, sqlx_count = DBAccess.bld_sql(start_date, end_date, context)
