How to easily concatenate strings from a list with some format in python?

Question

I'm using MySQLdb for inserting to a database, naturally my code looks similar to this:

db = MySQLdb.connect(host="111.111.111.111", port=3306,user="dba",passwd="somepass",db="somedb")
cursor = db.cursor()
cursor.execute("""
                    INSERT IGNORE INTO a (id,name) VALUES ('b', """+'diego' + """)""")

But it gets more and more cumbersome as more fields and values are added. I have to concatenate strings and sharp my eye to type in.

How can I print the execute string argument from two lists for fields and values, each?

For the example I would have:

fields = ['id','name']
values = ['b','diego']

Should that name have apostrophes around it or am I misinterpreting what you meant? — matt
– matt, Commented Apr 9, 2014 at 4:58

matt · Accepted Answer · 2014-04-09 05:07:51Z

1

fields = ['id', 'name', 'row3', 'row4']
values = ['b', 'diego', 3, 4]

fields_str = (", ").join([x for x in fields])
values_str = (", ").join([("'" + str(x) + "'") for x in values])

cursor.execute("INSERT IGNORE INTO a (" + fields_str + ") VALUES (" + values_str + ")")

Printing the value of the concatenated string returned this for me:

INSERT IGNORE INTO a (id, name, row3, row4) VALUES ('b', 'diego', '3', '4')

answered Apr 9, 2014 at 5:07

matt

2,4652 gold badges19 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to easily concatenate strings from a list with some format in python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related