python - 是否有更 pythonic 的方法来构建 INSERT 语句？

Question

正在尝试为 execute 构建 SQL 语句。这行得通，但现在确定它可能是多么 pythonic:

user_fields = ("id", "name", "email", "password", "phone")

fields = [field for field in user_fields if field != "id"]  # The only field we don't want is "id"
percent_s = ["%s"] * len(fields)
fields = ",".join(fields)
percent_s = ",".join(percent_s)

sql = "INSERT INTO user_table (" + fields + ") VALUES (" + percent_s + ")"
cursor.execute(sql, row_data)

Answer 1

你可以替换:

sql = "INSERT INTO user_table (" + fields + ") VALUES (" + percent_s + ")"

与

sql = "INSERT INTO user_table ({}) VALUES ({})".format(fields,percent_s)