Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sqlalchemy Query into tuple
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Query output in Tuple paulo79 2 1,964 Apr-07-2022, 12:54 PM
Last Post: paulo79
  code with no tuple gets : IndexError: tuple index out of range Aggam 4 2,802 Nov-04-2020, 11:26 AM
Last Post: Aggam
  How to get first line of a tuple and the third item in its tuple. Need Help, Anybody? SukhmeetSingh 5 3,187 May-21-2019, 11:39 AM
Last Post: avorane
  SQLAlchemy query return last row only pascale 0 5,123 Mar-01-2019, 05:47 PM
Last Post: pascale

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020