python - Error selecting items from a drop down list using Flask -


i trying create flask app allow me query postgres database. on "data" page. display list of tables in database along top. when select table want drop down list of columns in table appear. want able select variable, bring couple of boxes can define range(min, max, etc) , use button perform query , pull data of interest.

i new flask , app design in general there chance missing simple. using lists fill in until database , running.

i can select table , drop down or list appear. when pick drop down item , hit select bad request error, highlights field.

app.py:

from flask import flask, render_template, request, redirect, url_for, abort, session  app=flask(__name__)  @app.route('/stack', methods=['get','post']) def stack():     tables=['a','b']     temp_list=[]     if request.method == 'post':         table_id = request.form['table']         print table_id         variable_id =request.form.get('first_select', 'error')         if table_id == 'a':             temp_list=['a1','a2']         elif table_id == 'b':             temp_list =['b1','b2']         print temp_list         return render_template('stack.html',                                 tables=tables,                                 temp_list=temp_list                                 )     else:         return render_template('stack.html',                                 tables=tables,                                 )  if __name__ == "__main__":     app.run(debug=true)

stack.html:

<div class=container>     <div class='one'>         <p>tables</p>             <ul class='databases'>                 {% tbl in tables %}                 <div class="inner"><li><form action="" method="post"><button class="on" type="submit" name="table" value={{tbl}}>{{tbl}}</button></form></li></div>                 {% endfor %}             </ul>                    </div>      <div class="col">         <p>variables within {{ table_id }}</p>             <form method="post" action="">                 <div class="dropdown">                     <select name="first_select">                         {% item in temp_list %}                         <option value="{{item}}" selected>{{item}}</option>                         {% endfor %}                     </select>                 </div>                 <button type="submit" class="btn btn-default">select</button>             </form>         </div>      <div class="col">         <ul class='firstlist'>             <li>select filters apply {{variable_id}}</li>         </ul>     </div> </div>

basically picking item in drop down list, when hit select button bad request error?

variable_id reads: 'error', there must wrong in how processing select command, don't understand going wrong.

any appreciated.


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more