Use Flask framework to make drop-down menus of two correlations to grab database data

previously made a drop-down menu to connect to the database, but if you want to make a double associated drop-down, select the button, and then grab data from the database, but there has been no way, the database is as follows:

< table > < thead > < tr > < th > ID < / th > < th > Model_Name < / th > < th > value_without < / th > < th > time < / th > < / tr > < / thead > < tbody > < tr > < td > 0050 < / td > < td > Multiple Regression < / td > < td > 0.5781 < / td > < td > 13.03 < / td > < / tr > < tr > < td > 0050 < / td > < td > Logistic Regression < / td > < td > 0.587 < / td > < td > 10.93 < / td > < / tr > < tr > < td > 0051 < / td > < td > Multiple Regression < / td > < td > 0.5158 < / td > < td > 10.98 < / td > < / tr > < tr > < td > 0051 < / td > < td > Logistic Regression < / td > < td > 0.572 < / td > < td > 10.16 < / td > < / tr > < tr > < td > 0052 < / td > < td > Multiple Regression < / td > < td > 0.5734 < / td > < td > 14.67 < / td > < / tr > < tr > < td > 0052 < / td > < td > Logistic Regression < / td > < td > 0.5396 < / td > < td > 12.42 < / td > < / tr > < / tbody > < / table >

currently written Python:


    <br>
</form>

{% if step1 %}
    <div>ID:{{step1.ID}}</div>
    <div>Model Name:{{step1.Model_Name}}</div>
    <div>Value Without:{{step1.value_without}}</div>
    <div>Time:{{step1.time}}</div>
{% endif %}
</body>
</html>

now the question wants to be made into two related drop-down menus, that is, in the web page, let the user select the field ID, and then select Model_Name, and then press the button to confirm that the selected ID, Model_Name, value_without and time fields are crawled from the database. Then add those grammars in Python and HTML. Please solve the problem. Thank you.


emulate the existing model_name field, and
write this when querying:
ETL.query.filter (db.and_ (ETL.ID==eid, ETL.Model_Name==model_name))

Menu