Pfthb

I am trying to query a database through my website and dynamically add columns with the results using Jinja templates. I am using flask and on my views function. I am rendering the values like this

return render_template('query.html',my_list=my_list )

The thing is that when I load the page the user hasn't queried the database yet, so my_list is empty. The user queries the database by pressing a button on the html page and making an ajax request through jquery. My question now is if its possible to return my_list using jinja templates even after the page is already loaded, meaning I have to return render_template a second time (after submit button) to get the values for my_list.

p.s. I prefer not to use json parsing.

Here is some sample code. I query the database with the values of intranetID of column SubmitterID and platform of column Platforms to return the whole entry to the database with the values of the rest of the columns as well.

@app.route('/querydbvalues',methods=['POST', 'GET'])
def querydbvalues():
 if request.method == 'POST' or request.method == 'GET':
 results = models.mydatabase.query.filter_by(SubmitterID=qIntranetID,Platforms=qPlatform).all()
 my_list = [i.user for i in results]
 return render_template('query.html',my_list=my_list ) 

and on my html page

% for n in my_list %
<li>n</li>
% endfor %

on the Javascript file when you press the button i make the ajax request like this

$("#SearchDatabase").click(function()
 var tmp = document.getElementById("qIntranetID").value;
 var tmp2 = document.getElementById("qPlatform").value;
 jQuery.ajax(
 dataType: "json",
 url:"/querydbvalues", //tell the script where to send requests
 data:text:tmp,text2:tmp2,
 type:'GET',
 contentType: 'application/json',
 success: function(results)
 //do something
 
 );
);

The Ajax call is a completely separate request. You can do what you want in that request, including render templates.