Extracting the value from SQLite query as integer in Python

Question

I made a SQLite query in Python like that:

SharesOwned = db.execute("SELECT SUM(Shares) FROM transactionTable WHERE Share='FB'")

print(SharesOwned)
if sharesOwned < sharesToSell:
    return errorMessage("You don't own that many shares of FB")

It prints:

[{'SUM(Shares)':10}]

Then it gives me this error:

TypeError: "List indices must be integers or slices not str"

How can I extract the number as an integer?

Stoicas · Accepted Answer · 2018-04-02 00:43:00Z

2

It looks like SharesOwned is a list of dictionaries. To return the number of shares you need to do the following in this particular case:

SharesOwned[0]['SUM(Shares)']

SharesOwned[0] accesses the first element of the list, in this case a dictionary {'SUM(Shares)':10}. Now you just need to lookup the value by key - 'SUM(Shares)' in this case.

Additionally, it looks like you have a typo in sharesOwned, s should be capitalized.

answered Apr 2, 2018 at 0:43

Stoicas

1014 bronze badges

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

Comments

Rehan Azher · Accepted Answer · 2018-04-02 00:51:21Z

1

Try below changes : Update your query:

SELECT SUM(Shares) AS total FROM transactionTable WHERE Share='FB'

Then access SharedOwned:

if SharedOwned[0]['total']<sharesToSell:

edited Apr 2, 2018 at 0:51

answered Apr 2, 2018 at 0:43

Rehan Azher

1,3401 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

Extracting the value from SQLite query as integer in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related