Python & PostgreSQL: Function to insert variable arg into table?

Question

I am trying to do the code as follows to register a player with a given name, but I can't get the argument name to do anything… I thought that %s was the variable to insert a string into a database, but it doesn't seem to work.

import psycopg2

def registerPlayer(name):
    """Registers new player."""
    db = psycopg2.connect("dbname=tournament")
    c = db.cursor()
    c.execute("insert into Players values (%s);")
    db.commit()
    db.close()

registerPlayer("Butter")

When I run it, I get the error message:

ProgrammingError: syntax error at or near "%"    
LINE 1: insert into Players values (%s);

Daniel Roseman · Accepted Answer · 2015-10-12 13:21:43Z

3

You haven't actually passed the parameter into the execute method.

c.execute("insert into Players values (%s);", (name,))

answered Oct 12, 2015 at 13:21

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

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

1 Comment

R Jackson Over a year ago

I knew I was missing something obvious. Thanks!

Collectives™ on Stack Overflow

Python & PostgreSQL: Function to insert variable arg into table?

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related