inserting data into mysql using python with external variables

Question

I have a table where I need to populate email addresses from txt file, date and source from python variables. Down the code, a is the variable am getting from txt and b, c are the python variables I need to insert along

import csv,MySQLdb,os,os.path,datetime as dt
from sys import argv
path = argv
prompt = '>'
filename = raw_input(prompt)
fname = os.path.basename(filename)
source = fname
print "",source
date = dt.datetime.today().strftime("%d/%m/%y")
date_log = date
print "",date_log
db = MySQLdb.connect("localhost","root","passwd","testdb")
x = db.cursor()
csv_data  = csv.reader(file(filename))
for row in csv_data:
    print row
    query = (" INSERT INTO test(a,b,c) VALUES (%s,%s,%s)",row)
    x.execute(query, (date_log, source))
db.commit()
db.close()

Here am getting some error as follows:

File "csv2mysql.py", line 31, in <module>
    x.execute(query, (date_log, source))
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py",line159,in execute
    query = query % db.literal(args)
TypeError: unsupported operand type(s) for %: 'tuple' and 'tuple'

any help is much appreciated

query is not fine... checkout the query string... Your query is like something ('INSERT INTO test(a,b,c) VALUES (%s, %s, %s)', (val1, val2,...)) — user4866105
– user4866105, Commented May 25, 2015 at 9:19

user4866105 · Accepted Answer · 2015-05-25 09:29:05Z

4

Replace query string

 query = (" INSERT INTO test(a,b,c) VALUES %s") %(row,)

or

 query = (" INSERT INTO test(a,b,c) VALUES %s") % str(row)

Hope it will work for you...

answered May 25, 2015 at 9:29

user4866105

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

2 Comments

Sailendra Varma Over a year ago

Hi Dhaval , i changed the query as u said, am getting this error, can u suugest what to do ['[email protected]'] Traceback (most recent call last): File "2csv2mysql.py", line 27, in <module> x.execute(query, (date,fname)) 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

user4866105 Over a year ago

It will be useful: stackoverflow.com/questions/18053500/…

Collectives™ on Stack Overflow

inserting data into mysql using python with external variables

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related