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
29
30
31
32
33
34
|
#!/usr/bin/python
# -*- coding: utf-8 -*-
from pysqlite2 import dbapi2 as sqlite
def array_updatedb(table_file):
con = sqlite.connect("array.db")
cur = con.cursor()
cur.execute('select * from main')
main = cur.fetchall()
# read from the text table
f = open(table_file, 'r')
z = map(lambda x:x.split('\t'), f.readlines())
k = map(lambda y:(y[0].lower(), y[1].strip()), z)
f.close()
# update the database
for i, j in k:
cur.execute('insert into main (keys, ch) values ("' + i + '", "' + j + '");')
con.commit()
con.close()
# empty main table
con = sqlite.connect("array.db")
cur = con.cursor()
cur.execute('delete from main where keys not in ("w1", "w2", "w3", "w4", "w5", "w6", "w7", "w8", "w9", "w0");')
con.commit()
con.close()
array_updatedb('array30_27489.utf8')
array_updatedb('array30_ExtB.utf8')
array_updatedb('array30_ExtCD_V2012A.utf8')
|
