auto.js B0053 python sqlite3 数据库合并

# -*- coding: utf-8 -*-
"""
Created on Mon Nov  1 12:11:43 2021

@author: Administrator
"""
import sqlite3

# 连接数据库(如果不存在则创建)
conn = sqlite3.connect('tiku.db')
print("Opened database successfully")
 
INSERTconn = sqlite3.connect('tiku20211204.db')
print("Opened database insert successfully")
# 创建游标
cursor = conn.cursor()

INSERTcursor = INSERTconn.cursor()

list=[];
num=0
# 查询数据
sql = "select * from tiku"
values = cursor.execute(sql)
for i in values:
    num=num+1
    print(num)
    print('question:', i[0])
    print('ans:', i[1])
    data =( i[0],"",i[1])
    INSERTsql = "INSERT INTO tiku(question,a, answer) VALUES(?, ?, ?)"
    INSERTcursor.execute(INSERTsql, data)

    
# 关闭游标
cursor.close()
# 提交事物
conn.commit()
# 关闭连接
conn.close()

# 关闭游标
INSERTcursor.close()
# 提交事物
INSERTconn.commit()
# 关闭连接
INSERTconn.close()