python 将数据库导入mysql

#!/usr/bin/python
#coding=utf-8
import MySQLdb

import leancloud
import sys

leancloud.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 Object
from leancloud import LeanCloudError·
from leancloud import Query

result = Query.do_cloud_query('select * from AndroidMsg')
results = result.results

values=[]
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
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值