import pymysql
import sqlite3
import sys
conn1 = pymysql.connect(host="localhost",user="root",database="mi",charset="utf8")
cur1 = conn1.cursor()
cur1.execute("select * from Mi_userInfoExt where uid=7 order by id")
infoList1 = cur1.fetchall()
conn1.close()
conn2 = sqlite3.connect("database.sqlite")
conn2.text_factory = str
cur2 = conn2.cursor()
for info in infoList1:
cur2.execute( "INSERT INTO `Mi_userInfoExt` (`id`, `uid`,'date_time','data_type','data','deviceid','summary') VALUES (?,?,?,?,?,?,?)",
(info[0], info[1], info[2], info[3],info[4],info[5],info[6]))
conn2.commit()
conn2.close()