How to access each element of a sql query returned to python?

Question

The stock returns the stocks owned by the user. I want to pass a function lookup() on each stock returned to get the price of the stock. How will I do it since the query returns multiple rows?

rows = "SELECT * FROM :p1 ORDER BY id"
db.execute(rows,{'p1':str(session['user_id'])})
rows = db.fetchall()
stock = rows[0]['symbol']
share = rows[0]['shares']
price = []

I myself am not very sure how the data is returned that's why I'm having this problem — Ahijit
– Ahijit, Commented Jul 6, 2018 at 15:48
I know a few of these types of things return data in very odd manners, and it sounds like the data may contain somewhat personal information, you might need to do some digging and figure out the structure, or at least remove personal data and post the structure. — tgikal
– tgikal, Commented Jul 6, 2018 at 15:50
Are you just asking about iterating through the results? Could you use for row in rows:? — bzier
– bzier, Commented Jul 6, 2018 at 16:01
Not able to understand your question. Can't join work for you in this case? — mad_
– mad_, Commented Jul 6, 2018 at 16:34

Mike · Accepted Answer · 2018-07-07 02:37:37Z

1

Hard to say if this is what you're looking for but sounds like you're looking for a way to search a list of dictionaries.

>>> rows = [{'symbol': 'APPL', 'shares':1000},{'symbol': 'GE', 'shares': 2000},{'symbol': 'TWTR', 'shares': 5000}]
>>> def lookup(rows, stock):
...    results = [row for row in rows if row["symbol"] == stock]
...    return results
... 
>>> lookup(rows, 'APPL')
[{'symbol': 'APPL', 'shares': 1000}]

answered Jul 7, 2018 at 2:37

Mike

2,6242 gold badges24 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to access each element of a sql query returned to python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related