python inserting into mysql

Question

I am trying to work out what is wrong with my code. I am trying to enter data into a mysql, and python doesn't seem to like how i have done something.

Test Data

Name = "TestRegion"
Perent= "perent"
x1 = -100.0
x2 = -150.0
z1 = 94.0
z2 = 200.0

Code

def NewRegion(Name, Perent, x1, x2, z1, z2):
  try:
    con = SQLConnect()
    cur = con.cursor()
    sql = """INSERT INTO RegionName (Name, Perent, X1, X2, Z1, Z2) VALUES (?,?,?,?,?,?)"""
    cur.execute(sql, (Name, Perent, x1, x2, z1, z2))
    con.commit()

  except mdb.Error, e:
    con.rollback()
    print "Error %d: %s" % (e.args[0],e.args[1])

  finally:           
    if con:    
        con.close()

my issue I am guessing is how I am trying to pass the values to the sql statment.

my Error message is

File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py, line 159, in execute
query = query % db.literal(args)
TypeError: not all arguments converted during string formatting

do u want know other way of same implementation which is easy — sundar nataraj
– sundar nataraj, Commented Apr 17, 2014 at 12:35
u can use peeweee.. easy library .. peewee.readthedocs.org/en/latest/peewee/installation.html for all sort of database actions — sundar nataraj
– sundar nataraj, Commented Apr 17, 2014 at 13:07

Daniel Roseman · Accepted Answer · 2014-04-17 12:42:48Z

1

The MySQL adapter does not use ? for placeholders, it uses %s.

sql = """INSERT INTO RegionName (Name, Perent, X1, X2, Z1, Z2) VALUES (%s, %s, %s, %s, %s, %s)"""
cur.execute(sql, (Name, Perent, x1, x2, z1, z2))

answered Apr 17, 2014 at 12:42

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

2 Comments

TheDuncan Over a year ago

I can only pass a max of 4 arguments. but thanks anyway

Daniel Roseman Over a year ago

I don't know what that means. There are six arguments here.

archetipo · Accepted Answer · 2014-04-17 12:39:00Z

0

try this:

    sql = u'INSERT INTO RegionName (Name, Perent, X1, X2, Z1, Z2) VALUES ("%s","%s",%d,%d,%d,%d)'% (Name, Perent, x1, x2, z1, z2)
    cur.execute(sql)

answered Apr 17, 2014 at 12:39

archetipo

5794 silver badges10 bronze badges

3 Comments

TheDuncan Over a year ago

thanks, what does the u at the front of the sql statement do?

archetipo Over a year ago

u'' is used for utf-8 encoding string if you use a string that have special character like è é ecc.. this prevents encoding problems

Daniel Roseman Over a year ago

This is wrong. You've now totally unnecessarily opened yourself up to SQL injection attacks. Do not do this.

Collectives™ on Stack Overflow

python inserting into mysql

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related