Python error: int argument required

Question

What am I doing wrong here?

 i = 0
 cursor.execute("insert into core_room (order) values (%i)", (int(i))

Error:

 int argument required

The database field is an int(11), but I think the %i is generating the error.

Update:

Here's a more thorough example:

time = datetime.datetime.now()
floor = 0
i = 0

try: booster_cursor.execute('insert into core_room (extern_id, name, order, unit_id, created, updated) values (%s, %s, %s, %s, %s, %s)', (row[0], row[0], i, floor, time, time,)) except Exception, e: print e

Error:

  (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order, unit_id, created, updated) values ('99', '99', '235', '12', '2009-07-24 1' at line 1")

Pavel Minaev · Accepted Answer · 2009-07-25 00:03:06Z

4

Two things. First, use %s and not %i. Second, parameters must be in a tuple - so you need (i,) (with comma after i).

Also, ORDER is a keyword, and should be escaped if you're using it as field name.

edited Jul 25, 2009 at 0:03

answered Jul 24, 2009 at 23:39

Pavel Minaev

102k27 gold badges222 silver badges293 bronze badges

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

7 Comments

slypete Over a year ago

The %i argument is a int in the db. I need to use %s?

mechanical_meat Over a year ago

@slypete: Yes, use %s. MySQLdb uses format as its default paramstyle. PEP 249 for more info: python.org/dev/peps/pep-0249

slypete Over a year ago

So, MySQLdb is only capable of inserting into columns that are varchar? That cannot be!!

S.Lott Over a year ago

@slypete: "a sql error from the MySQL server". Please update the question with the new code and the actual error message.

Pavel Minaev Over a year ago

%s doesn't mean string here, so it's not limited to VARCHAR. If you give it an int, it will expand to a numeric literal in SQL. For the reason why your query still doesn't work, see the updated answer.

|

Mark Roddy · Accepted Answer · 2009-07-24 23:40:22Z

1

I believe the second argument to execute() is expected to be an iterable. IF this is the case you need to change:

(int(i))

to:

(int(i),)

to make it into a tuple.

answered Jul 24, 2009 at 23:40

Mark Roddy

28.1k20 gold badges70 silver badges72 bronze badges

Comments

Evan Fosmark · Accepted Answer · 2009-07-24 23:41:12Z

1

You should be using ? instead of %i probably. And you're missing a parenthesis.

cursor.execute("insert into core_room (order) values (?)", (int(i),))

answered Jul 24, 2009 at 23:41

Evan Fosmark

102k36 gold badges109 silver badges118 bronze badges

2 Comments

mechanical_meat Over a year ago

@Evan: you definitely have the right idea, but this paramstyle is known as qmark, and AFAIK is not supported by MySQLdb.

slypete Over a year ago

Ya, I just wrote it quick to demo my bad.

Collectives™ on Stack Overflow

Python error: int argument required

3 Answers 3

7 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related