下面代碼可以直接用于將數(shù)組數(shù)據(jù)存儲到數(shù)據(jù)庫中

第一步準(zhǔn)備數(shù)據(jù)

• 定義一下列名稱
  para_name=[‘mkey’,‘uni_int’,‘pinyin’]
• 提供一下數(shù)據(jù)
  para_list=[(‘中’,‘20013’,‘zhong’),(‘國’,‘22269’,‘zhong’)]

將數(shù)據(jù)存儲到sqlite數(shù)據(jù)庫中

dbname=‘pypinyin.db’
tname=‘pypinyin_dict’
para2db(dbname,tname,para_name,para_list)

完整代碼

            
              import sqlite3
import os

'''
from pinyin2db import *
para_name=['mkey','uni_int','pinyin']
para_list=[('中','20013','zhong'),('國','22269','zhong')]
dbname='pypinyin.db'
tname='pypinyin_dict'
para2db(dbname,tname,para_name,para_list)
'''



def para2db(dbname,tname,para_name,para_list,need_remove=False):
	# 通常可以關(guān)閉，不刪除
	if need_remove:createdb(dbname)
	droptable(dbname,tname)
	createtable(dbname,tname,para_name)
	save2db(dbname,tname,para_name,para_list)

# 數(shù)據(jù)庫如果存在就刪除
def createdb(dbname):
	if os.path.isfile(dbname):os.remove(dbname)
	import sqlite3
	conn = sqlite3.connect(dbname)
	conn.close()
	return 

# 刪除表格
def droptable(dbname,tname):
    conn = sqlite3.connect(dbname)
    c = conn.cursor()
    
    c.execute('''DROP TABLE IF EXISTS ''' +tname)
    conn.commit()
    conn.close()
    return 'ok'

# 創(chuàng)建表格
def createtable(dbname,tname,para_name):
    conn = sqlite3.connect(dbname)
    c = conn.cursor()
    paraStr,vstr,cstr=getParaStr(para_name)
    c.execute('CREATE TABLE ' +tname+' (ID INTEGER PRIMARY KEY  AUTOINCREMENT,'+cstr+');')
       
    conn.commit()
    conn.close()
    return 'ok'

#保存到數(shù)據(jù)庫
def save2db(dbname,tname,para_name,para_list):
	conn = sqlite3.connect(dbname)
	c = conn.cursor()
	paraStr,vstr,cstr=getParaStr(para_name)
	for item in para_list: 
		msql='INSERT INTO '+tname+' ('+paraStr+') VALUES ('+ vstr+')'
		para=item
		#print(msql)
		#print(para)
		c.execute(msql,para)
        
	conn.commit()
	conn.close()
	return 


#------------
#輔助
#-----------
'''
para_name=['mkey','uni_int','pinyin']
getParaStr(para_name)
 ('mkey,uni_int,pinyin', '?,?,?', 'mkey TEXT,uni_int TEXT,pinyin TEXT ')

rs: 列名稱，wh:列問號，cstr: 列屬性
'''
def getParaStr(mcol_list):
	rs=''
	wh=''
	cstr=''
	for item in mcol_list:
		if item == mcol_list[-1]:
			rs=rs+item
			wh=wh+'?'
			cstr=cstr+item+' TEXT '
		else:
			rs=rs+item+','
			wh=wh+'?,'
			cstr=cstr+item+' TEXT,'
	return rs,wh,cstr