mysql2sqlite3

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()