python sqlite string insertion

Question

I'm trying to insert a string that was received as an argument into a sqlite db using python:

    def addUser(self, name):

            cursor=self.conn.cursor()
            t = (name)
            cursor.execute("INSERT INTO users ( unique_key, name, is_online, translate) VALUES (NULL, ?, 1, 0);", t)
            self.conn.commit()

I don's want to use string concatenation because http://docs.python.org/library/sqlite3.html advises against it.

However, when I run the code, I get the exception

cursor.execute("INSERT INTO users ( unique_key, name, is_online, translate) VALUES (NULL, ?, 1, 0);", t)
pysqlite2.dbapi2.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied

Why is Python splitting the string by characters, and is there a way to prevent it from doing so?

EDIT:

changing to t = (name,) gives the following exception

print "INSERT INTO users ( unique_key, name, is_online, translate) VALUES (NULL, ?, 1, 0)" + t
exceptions.TypeError: cannot concatenate 'str' and 'tuple' objects

RichieHindle · Accepted Answer · 2011-08-05 15:35:34Z

8

You need this:

t = (name,)

to make a single-element tuple.

Remember, it's commas that make a tuple, not brackets!

answered Aug 5, 2011 at 15:35

RichieHindle

283k49 gold badges367 silver badges408 bronze badges

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

2 Comments

iliaden Over a year ago

It now generates a new exception:

print "INSERT INTO users ( unique_key, name, is_online, translate) VALUES (NULL, ?, 1, 0)" + t exceptions.TypeError: cannot concatenate 'str' and 'tuple' objects

RichieHindle Over a year ago

@iliaden: It's your new print statement that's failing. Your original statement cursor.execute("INSERT ... (NULL, ?, 1, 0);", t) will now work. To make the print work, replace the + with a ,.

mdeous · Accepted Answer · 2011-08-05 15:35:50Z

1

Your t variable isn't a tuple, i think it is a 7-length string. To make a tuple, don't forget to put a trailing coma:

t = (name,)

answered Aug 5, 2011 at 15:35

mdeous

18.1k7 gold badges60 silver badges60 bronze badges

1 Comment

iliaden Over a year ago

It now generates a new exception:

print "INSERT INTO users ( unique_key, name, is_online, translate) VALUES (NULL, ?, 1, 0)" + t exceptions.TypeError: cannot concatenate 'str' and 'tuple' objects

Collectives™ on Stack Overflow

python sqlite string insertion

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related