运用Python从一个数据库的某个表中导数据到另一个数据库的某个表

亦凉 2022-06-03 05:08 335阅读 0赞

之前写过一篇通过Node.js从一个数据库的某个表中导数据到另一个数据库的某个表，现在是通过python来进行导数据，个人感觉操作起来还是比node.js方便不少，具体代码如下：

import pymysql
    
    
    def readAndWrite():
        for i in range(len(readDB)):
            # 四个参数分别为数据库地址，用户名，密码，数据库名称
            read = pymysql.connect("localhost", "root", "", "****")
            Rcursor = read.cursor()
            readSql = "SELECT id,phone,regist_time,login_lasttime,type FROM `user` WHERE DATE_FORMAT(login_lasttime,'%Y-%m-%d') = " + loginDate[i]
            Rcursor.execute(readSql)
            readResult = Rcursor.fetchall()
            for value in readResult:
                write = pymysql.connect("localhost", "root", "", "test")
                Wcursor = write.cursor()
                writeSql = "INSERT INTO userlogininfo(id,phone,regist_time,login_lasttime,type) " \
                           " VALUES ('%s', '%s', '%s', '%s', '%s' )" %\
                           (value[0], value[1], value[2], value[3], value[4])
                print(writeSql)
                try:
                    Wcursor.execute(writeSql)
                    write.commit()
                except:
                    write.rollback()
                write.close()
            read.close()
    
    
    if __name__ == '__main__':
        readAndWrite()