-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_DB.py
67 lines (64 loc) · 1.17 KB
/
insert_DB.py
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
import json
import sqlite3 as sqlite
import re
connection = sqlite.connect('RusDict.db')
cursor = connection.cursor()
cursor.execute('''
CREATE TABLE Sources(
Id INTEGER,
Lower TEXT,
Name TEXT,
Sokr TEXT,
Pusto TEXT,
Time1 TEXT,
Time2 TEXT,
Bib TEXT,
Gomilet TEXT,
Bog TEXT,
Agiogr TEXT,
Pov TEXT,
Litur TEXT,
Epi TEXT,
Letop TEXT,
Hron TEXT,
Docum TEXT,
Lang TEXT,
Bib1 TEXT,
Gom1 TEXT,
Bog1 TEXT,
Agiogr1 TEXT,
Pov1 TEXT,
Litur1 TEXT,
Epi1 TEXT,
Hron1 TEXT,
Docum1 TEXT
);
''')
f = open('merged.json','r',encoding='utf-8')
f1 = open('test3.csv','w',encoding='utf-8')
d = ''
for i in f:
d+=i
arr = json.loads(d)
co = 0
for e in arr:
print(co)
co+=1
try:
sql = 'INSERT INTO Sources VALUES(' + str(e)+", '"+arr[e][0].lower()+"'"
except:
sql = 'INSERT INTO Sources VALUES(' + str(e)+", ''"
if len(arr[e]) < 25:
ar = arr[e] + ['']*(25-len(arr[e]))
else:
ar = arr[e][0:25]
for b in ar:
d = re.sub("\'","",d)
d = re.sub('\"',"",d)
sql += ",'" + b + "'"
sql+=')'
#print(sql)
cursor.execute(sql)
connection.commit()
f1.close()
f.close()