python 将数据库导入mysql

来源：互联网发布：java 统一异常处理编辑：程序博客网时间：2024/06/15 00:32
#!/usr/bin/python#coding=utf-8import MySQLdbimport leancloudimport sysleancloud.init('7GfUliPOBfzUBqcufluOrAjT', 'cMK8E9N6NvweDvhuigbMxM0o')conn=MySQLdb.connect(host="localhost",user="root",passwd="",db="AndroidMsg",port=3306,charset="utf8")cursor = conn.cursor(MySQLdb.cursors.DictCursor)reload(sys)sys.setdefaultencoding('utf-8')from leancloud import Objectfrom leancloud import LeanCloudError·from leancloud import Queryresult = Query.do_cloud_query('select * from AndroidMsg')results = result.resultsvalues=[]for android in results:values.append((android.get("model_number"),android.get("android_version"),android.get("sdk_version"),android.get("usb_host"),android.get("usb_audio"),android.get("baseband_version"),android.get("board"),android.get("brand"),android.get("cpu_abi"),android.get("device"),android.get("display"),android.get("finger_print"),android.get("host"),android.get("id"),android.get("manufacturer"),android.get("model"),android.get("product"),android.get("tags"),android.get("time"),android.get("type"),android.get("user"),android.get("code_name_version"),android.get("sdk_int_verstion")))for i in values:for msg in i:    print(msg)cursor.executemany('insert into AboutUSB (model_number,android_version,sdk_version,usb_host,usb_audio,baseband_version,board,brand,cpu_abi,device,display,finger_print,host,id,manufacturer,model,product,tags,time,type,user,code_name_version,sdk_int_verstion) values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',values)# cursor.execute("insert into AboutUSB (objectId) values ('dsfdsfdss')")conn.commit()cursor.close()conn.close()
0 0