Python error trying to use .execute() SQLite API query With keyword arguments

Question

I'm learning SQLite and have been trying to create a string that stores values and retrieves rows, but I get an error "execute() takes no keyword arguments." This is the way I referenced the database:

import sqlite3
dbb = sqlite3.connect('finance.db')
db = dbb.cursor()
username = request.form.get("username")

#query database for username
rows = db.execute("SELECT * FROM users WHERE username = :username", \ 
username=username)

UPDATE

I misrepresented my parameters. I used the qmarks notation mentioned in the accepted answer below to reference table rows

CL. · Accepted Answer · 2017-12-18 08:24:21Z

3

The documentation says:

The sqlite3 module supports two kinds of placeholders: question marks (qmark style) and named placeholders (named style).

Here’s an example of both styles:
# This is the qmark style:
cur.execute("insert into people values (?, ?)", (who, age))

# And this is the named style:
cur.execute("select * from people where name_last=:who and age=:age", {"who": who, "age": age})

Keyword arguments are not supported. However, you could explicitly convert them into a dictionary (or write a wrapper for execute that does this):

db.execute("SELECT ... :username", dict(username = username))

answered Dec 18, 2017 at 8:24

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Comment

tiff Over a year ago

Thanks, I missed that bit. The qmark style works perfectly for a method of templating I hadn't yet considered.

Collectives™ on Stack Overflow

Python error trying to use .execute() SQLite API query With keyword arguments

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related