开发者

Python MySQLdb placeholders syntax

开发者 https://www.devze.com 2022-12-25 00:39 出处:网络
I\'d like 开发者_StackOverflow社区to use placeholders as seen in this example: cursor.execute (\"\"\"

I'd like 开发者_StackOverflow社区to use placeholders as seen in this example:

cursor.execute ("""
    UPDATE animal SET name = %s
    WHERE name = %s
    """, ("snake", "turtle"))

Except I'd like to have the query be its own variable as I need to insert a query into multiple databases, as in:

query = """UPDATE animal SET name = %s
           WHERE name = %s
           """, ("snake", "turtle"))
cursor.execute(query)
cursor2.execute(query)
cursor3.execute(query)

What would be the proper syntax for doing something like this?


query = """UPDATE animal SET name = %s
           WHERE name = %s
           """
values = ("snake", "turtle")

cursor.execute(query, values)
cursor2.execute(query, values)

or if you want group them together...

arglist = [query, values]
cursor.execute(*arglist)
cursor2.execute(*arglist)

but it's probably more readable to do it the first way.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号