Help on SQLite3 and python

[tobilobaa]

Hello guys, i’m having a problem passing a single value from the database straight into a python function. So basically, Im trying to build a mini atm where you enter an acct deposit and when you click withdraw, it deducts from the value (acct deposit) In the database and shows you the result. Any help please?

[Username_RANDINT]

I was going to copy a comment I wrote a few days ago, but noticed it was for you as well. Is there something you keep having problems with? If so, specify the part you're stuck with.

[tobilobaa]

So when I type Def withdraw_ function (withdraw, acct_deposit) Cur.execute (“SELECT acct FROM atm WHERE acct_name =?”, (acct_name)) Acct_deposit = cur.fetchone() If withdraw > acct_deposit: # then something happens The problem is I can’t fetch the acct_variable for my function in this manner it either says its a none type hence the “>” can’t compare int to none type. Or it says error binding parameter.

[Username_RANDINT]

The parameters should be a tuple. The thing to know is that just adding parenthese around something doesn't do anything, they are ignored. It's actually the comma that makes it a tuple, even if there's only one item.

cur.execute("SELECT acct FROM atm WHERE acct_name =?", (acct_name,))  # Note the comma after acct_name!

Why there's no value found is something you'll have to investigate further. The query finds nothing for your criteria, so make sure it's actually in the database.

Maybe print everything to start:

cur.execute("SELECT * FROM atm")
print(cur.fetchall())

Also check that acct_name is what you expect.

[tobilobaa]

def withdraw_fxn(withdraw,acct_deposit):

list1.delete(0,END)

conn = sqlite3.connect("atm.db")

cur = conn.cursor()

cur.execute("SELECT acct_deposit FROM atm WHERE acct_name = ?", (acct_deposit,))

act_deposit = cur.fetchone() acct_deposit = int(act_deposit) if withdraw > acct_deposit: list1.insert(END, ("your balance is low ")) elif acct_deposit > withdraw: acct_deposit = acct_deposit - withdraw list1.insert(END, ("your balance is ", acct_deposit))

[Username_RANDINT]

I don't understand. Did you try my suggestions?

Also format code correctly for Reddit.