def delete_dsselect(sqlid):
print '----- delete_select ------'
form = DsSelectForm(csrf_enabled=False)
print 'form.data[sqlid]:' + str(form.data['selid'])
dsselect = DsSelect.get_or_404(form.data['selid'])
print str(dsselect)
if dsselect:
dsselect.delete()
# return jsonify({'result':'success', 'selid':form.data['selid']})
data = __list_dsselect(sqlid, 0)
return json.dumps(data)
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)
def list_dsselect(sqlid):
userid = g.user.opid
data = __list_dsselect(sqlid, 0)
return json.dumps(data)
