字典格式数据插入数据库

def get_insert_str(data_dict):
key_str = ",".join(list(data_dict.keys()))
print(key_str)
value_str = ",".join(map(lambda x: "{}".format(x) if str(x).isdigit() else "'{}'".format(x), data_dict.values()))
print(value_str)
insert_str = """
INSERT INTO area_area({})
VALUES({});
""".format(key_str, value_str)
return insert_str
posted @ 2018-08-24 14:52  hyu9999  Views(514)  Comments(0)    收藏  举报