python sqlite数据库画图_Python对Sqlite3数据库操作

创建数据库/插入数据库实例

# 对paper文本进行数据库录入工作和统计年份，并画图

# 2016年07月12日22:17:39

# Linux python3

# author lee

import sqlite3

import os

import time

def createDatabase(dbname):

if os.path.exists(dbname):

os.remove(dbname)

conn = sqlite3.connect(dbname)

cursor = conn.cursor()

sql_createDatabase = "create table paper(index_id int primary key, \

Paper_ID text, \

Original_Paper_Title text, \

Normalized_Paper_Title text, \

Paper_Publish_Year int, \

Paper_Publish_Date text, \

Paper_DOI text, \

Original_Venue_Name text, \

Normalized_Venue_Name text, \

Journal_ID_Mapped_To_Venue_Name text, \

Conference_Series_ID_Mapped_To_Venue_Name text, \

Paper_Rank text)"

cursor.execute(sql_createDatabase)

conn.commit()

cursor.close()

conn.close()

print("datebase created success!")

def insertDatabase(filename, dbname):

conn = sqlite3.connect(dbname)

cursor = conn.cursor()

f = open(filename, "rb")

line = f.readline().decode('utf-8')

index = 0