2

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);
colidyre
  • 4,170
  • 12
  • 37
  • 53
R Jackson
  • 105
  • 3
  • 13

1 Answers1

3

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

c.execute("insert into Players values (%s);", (name,))
Daniel Roseman
  • 588,541
  • 66
  • 880
  • 895