File size: 679 Bytes
94ecfcc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
#!/usr/local/bin/python3
# coding: utf-8
# ytdlbot - migrate_to_mysql.py
# 12/29/21 15:28
#
__author__ = "Benny <benny.think@gmail.com>"
import sqlite3
import pymysql
mysql_con = pymysql.connect(host='localhost', user='root', passwd='root', db='vip', charset='utf8mb4')
sqlite_con = sqlite3.connect('vip.sqlite')
vips = sqlite_con.execute('SELECT * FROM VIP').fetchall()
for vip in vips:
mysql_con.cursor().execute('INSERT INTO vip VALUES (%s, %s, %s, %s, %s, %s)', vip)
settings = sqlite_con.execute('SELECT * FROM settings').fetchall()
for setting in settings:
mysql_con.cursor().execute("INSERT INTO settings VALUES (%s,%s,%s)", setting)
mysql_con.commit()
|