Python Forum

Full Version: Sqlalchemy Query into tuple
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
If i was to query a SQLALCHEMY database for a row, like so:
product_query= test_result.query.filter(test_result.test_details =='Overall').filter(test_result.product_serial_number == product_search_value).first()
Then take the query's output and turn it into a tuple. Can this be achieved ( assume so) and how can it be achieved?

Background:My desired outcome is to take this row, pull a certain 'cell' from the row and use the value of the cell to search other tables and also take the values and display on a html page.

If there is another / easier way then tupling i am all ears