sqlite3 INSERT INTO query in python, string format

Question

python 3.7, vscode

This works:

def insert_song(cursor):
    header = get_header(cursor)
    query = "INSERT INTO `songs` ('song', 'album', 'artist', 'genre', 'duration', 'price') VALUES (?,?,?,?,?,?);"
    cursor.execute(query, get_info(cursor))
    connection.commit()

This:

def insert_song(cursor):
    header = get_header(cursor)
    query = "INSERT INTO `songs` ({}) VALUES (?,?,?,?,?,?);".format(header)
    cursor.execute(query, get_info(cursor))
    connection.commit()

generates following error:

sqlite3.OperationalError: near "(": syntax error

the return of the "get_header(cursor)" function is following tuple:

('song', 'album', 'artist', 'genre', 'duration', 'price')

as i get hinted, it's a problem with .format which i have to define something additional but i didn't find it...

buran · Accepted Answer · 2021-10-20 07:51:17Z

1

When you pass tuple, you get also the brackets, so you will have double brackets in your query

Try

query = "INSERT INTO `songs` {} VALUES (?,?,?,?,?,?);".format(header)

or even better using f-string

query = f"INSERT INTO `songs` {header} VALUES (?,?,?,?,?,?);"

or directly

query = f"INSERT INTO `songs` {get_header()} VALUES (?,?,?,?,?,?);"

answered Oct 20, 2021 at 7:51

buran

14.4k13 gold badges45 silver badges76 bronze badges

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

Comments

Ptit Xav · Accepted Answer · 2021-10-20 07:53:14Z

1

I think the format of the problem comes from the format string . It will have double () because formatting of header will include header () :

header=('a','b')
query="-({})-".format(header)
print(query)

This will print :

-(('a', 'b'))-

If you suppress the () from the format, you gay what you want :

query2="-{}-".format(header)
print(query2)

Prints out :

-('a', 'b')-

answered Oct 20, 2021 at 7:53

Ptit Xav

3,2272 gold badges10 silver badges18 bronze badges

Comments

alpoehi · Accepted Answer · 2021-10-20 07:53:43Z

0

as buran in the comment stated:

query = "INSERT INTO songs` {} VALUES (?,?,?,?,?,?);".format(header)

works

answered Oct 20, 2021 at 7:53

alpoehi

454 bronze badges

Collectives™ on Stack Overflow

sqlite3 INSERT INTO query in python, string format

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related