json数据自动生成MySQL建表语句_刺客python-CSDN博客_json mysql 建表

安宇雨 - 随手采集
2020-08-12 10:29:53
随手采集
0000-未整理-等待研究

#_*_coding:utf-8_*_#author: cike#date: 18-9-13import pymysql.cursors  connection = pymysql.connect(host='localhost',                            port = 3306,                            user='root',                            passwd='root',                            db ='jsontest',                            charset='utf8mb4',                            cursorclass=pymysql.cursors.DictCursor,) #这里设置表名table_name = "test12"#这里设置需要的字典数据dict1 = {            "id": "971",            "payout_id": "10602",            "payin_id": "0",            "pay_nums": "500.00",            "pay_state": "0",            "pay_time": "1536829856",            "pay_no": "PAY2018091348534951",            "card_id": "664",            "trade_notes": "null",            "trans_type": "0",            "trans_img": "null",            "get_moneytime": "null",            "fee_nums": "100.00",            "out_card": "null"} #数据插入函数def insert1(sql):    try:        with connection.cursor() as cursor:            cursor.execute(sql)        connection.commit()        print(u"创建表%s成功" %(table_name))    finally:        connection.close()#根据元祖数据生成mysql语句def make_sql(tuple2):    str1 = "CREATE TABLE `%s`" %(table_name)    str2 = "ENGINE=InnoDB DEFAULT CHARSET=utf8;"    str4=""    for i in tuple2:        str3 = "`"+i+"`"+" "+"varchar(255) DEFAULT NULL,"        str4 = str4+str3    str5 = "("+str4.rstrip(",")+")"    str6 = str1+" "+str5+str2    return str6#把字典数据转化为元祖数据def tuple1(dict1):    list1 = []    print(u"总字段数:"+str(len(dict1)))    for i in dict1.keys():        list1.append(i)    m = tuple(list1)    return m def main():    tuple2 = tuple1(dict1)    sql_str = make_sql(tuple2)    insert1(sql_str) if __name__ == '__main__':    main()

Original url: Access
Created at: 2020-08-12 10:29:53
Category: default
Tags: none

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到

请先后发表评论