-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_helper.py
54 lines (47 loc) · 1.32 KB
/
db_helper.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
import sqlite3
def create_table(database,table_name,**columns):
db = sqlite3.connect(database)
cursor = db.cursor()
q_str =''
for c, t in columns.items():
q_str += '{} {}, '.format(c, t)
q_str = q_str[:-2]
cursor.execute('create table ' + table_name + '(' + q_str + ')')
db.commit()
db.close()
def insert(database,table_name,**columns):
db = sqlite3.connect(database)
cursor = db.cursor()
q_str =''
value_str = ''
for c, t in columns.items():
q_str += "{}, ".format(c)
value_str += "'{}', ".format(t)
q_str = q_str[:-2]
value_str = value_str[:-2]
print(q_str)
print(value_str)
sql = 'Insert into ' + table_name + '('+ q_str +') Values(' + value_str + ')'
print(sql)
cursor.execute(sql)
sql = 'select * from student'
cursor.execute(sql)
result = cursor.fetchall()
print(result)
db.commit()
db.close()
def select(database,table_name,**columns):
db = sqlite3.connect(database)
cursor = db.cursor()
q_str =''
for c, t in columns.items():
q_str += "{}='{}' and ".format(c,t)
q_str = q_str[:-4]
print(q_str)
sql = 'select * from ' + table_name + ' Where '+ q_str +''
print(sql)
cursor.execute(sql)
result = cursor.fetchall()
print(result)
db.commit()
db.close()