How do I use a variable from Python input in sqlite3?

Question

I want the SQL term to search for the ID that has been given by the user as input.

def autoAusgeben():

    autoID = int(input("Id des Autos eingeben: "))
    connection = sqlite3.connect("quartett.db")
    cursor = connection.cursor()

    cursor.execute("SELECT * From autos WHERE Id (?)", (autoID))
    autos = cursor.fetchall()
    print(autos)

Presumably what you've posted _doesn't_ work - errors? Unexpected outputs? — jonrsharpe, Aug 17 '21 at 16:32

score 0 · Answer 1 · answered Aug 17 '21 at 16:48

0

If autoID is defined earlier in code, then I believe you may be receiving some kind of "undefined function 'Id' in expression error" due to missing = sign? Does changing that line to this help?

cursor.execute("SELECT * From autos WHERE Id = (?)", (autoID))

answered Aug 17 '21 at 16:48

SequelSnake

31
3

2

The second argument to `execute` is also missing the `,` that makes it the required tuple. – chepner Aug 17 '21 at 16:50

score 0 · Answer 2 · answered Aug 17 '21 at 17:05

0

After adding to missing "=" it gives the error "parameters are of unsopported type". autoID has never been used before.

EDIT: ive added a "," behind autoID in braces

Works now

Thx

answered Aug 17 '21 at 17:05

philipmrz

31
6

How do I use a variable from Python input in sqlite3?

2 Answers2