def add_dsselect(sqlid): print 'add_dsquery called ' print 'request.form in all is ' + str(request.form) # print 'request.form.get in sqlid is ' + str(request.form.get('sqlid',None)) form = DsSelectForm(csrf_enabled=False) if request.method == 'POST' and form.validate(): form.data['sqlid'] = sqlid print 'form.data is ' + str(form.data) dsselect = DsSelect.create(**form.data) if request.form['templates']: __add_dsviewtmpl(sqlid, dsselect.selid, request.form['templates']) print form.errors # query = DsSelect.query.filter(DsSelect).filter().filter().order_by(DsSelect.selid.desc()).limit(1) data = __list_dsselect(sqlid, 0) print data print '-------- add data return value end ----------' return json.dumps(data)
def edit_dsselect(sqlid): print 'edit_select called ' print 'request.form in all is ' + str(request.form) form = DsSelectForm(csrf_enabled=False) print 'form.data[sqlid] is ' + str(form.data) dsselect = DsSelect.get_or_404(form.data['selid']) # print dsselect if request.method == 'POST' and form.validate(): form.data['sqlid'] = sqlid print '>>>>>>form.data is ' + str(form.data) dsselect.update(**form.data) print 'request.form[templates] is ' + str(request.form['templates']) if request.form['templates']: __add_dsviewtmpl(sqlid, form.data['selid'], request.form['templates']) print form.errors # query = DsSelect.query.filter(DsSelect.sqlid == sqlid).filter(DsSelect.selid==form.data['selid']) # data = query_to_list_json(query) data = __list_dsselect(sqlid, 0) return json.dumps(data)