auto.js B0043 字符串转字典 写入数据库 2021-10-312021-11-02

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

@author: Administrator
"""
import sqlite3
path="C:\\Users\Administrator\\Desktop\\tiku20211101.txt"
# 连接数据库(如果不存在则创建)
conn = sqlite3.connect('tiku20211120.db')
print("Opened database successfully")
 
# 创建游标
cursor = conn.cursor()

 
# 创建表
sql = 'CREATE TABLE TiKu(id integer PRIMARY KEY autoincrement, question  varchar(300), a varchar(200),ans varchar(200))'
cursor.execute(sql)
 
# 提交事物
conn.commit()
        
with open(path,'r') as f:
    for line in f:
        str1=''
        str2=''
        str3=''
        str_to_dict= eval(line)
        if type(str_to_dict['q']) == type("s"):
            str1=str_to_dict['q']
        else:
            str1=repr(str_to_dict['q'])
        if type(str_to_dict['a']) == type("s"):
            str2=str_to_dict['a']
        else:
            str2=repr(str_to_dict['a'])
        if type(str_to_dict['ans']) == type("s"):
            str3=str_to_dict['ans']
        else:
            str3=repr(str_to_dict['ans']) 
        
        data =(str1,str2,str3)
        sql = "INSERT INTO TiKu(question,a, ans) VALUES(?, ?, ?)"
        cursor.execute(sql, data)
        
f.close()

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