-
Notifications
You must be signed in to change notification settings - Fork 0
/
myDatabasefile.py
76 lines (68 loc) · 2.01 KB
/
myDatabasefile.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
68
69
70
71
72
73
74
75
76
import sqlite3
def createTable():
conn = sqlite3.connect('contacts.db')
conn.execute('DROP table IF EXISTS ABC')
conn.execute('''CREATE TABLE ABC
(Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name TEXT NOT NULL,
Phone CHAR(50) NOT NULL)''')
print ("Table created successfully")
conn.commit()
conn.close()
def updateTable(name, phn, Id):
conn = sqlite3.connect('contacts.db')
sql = "UPDATE ABC SET Name='"+name+"' ,Phone='"+phn+"' WHERE id="+str(Id)
cur = conn.cursor()
cur.execute(sql)
conn.commit()
conn.close()
def delFromTable(Id):
conn = sqlite3.connect('contacts.db')
sql = 'DELETE FROM ABC WHERE id='+ str(Id)
cur = conn.cursor()
cur.execute(sql)
conn.commit()
conn.close()
def insertInTable(name, phn):
conn = sqlite3.connect('contacts.db')
sql = ''' INSERT INTO ABC(Name,Phone)
VALUES(?,?) '''
cur = conn.cursor()
cur.execute(sql, (name, phn))
conn.commit()
conn.close()
def readFromTable(Id):
conn = sqlite3.connect('contacts.db')
cur = conn.cursor()
sql = "SELECT Name,Phone FROM ABC WHERE Id=" + str(Id)
cur.execute(sql)
rows = cur.fetchall()
conn.close()
for row in rows:
return(row)
def readAllTable():
conn = sqlite3.connect('contacts.db')
cur = conn.cursor()
cur.execute("SELECT Name,Phone FROM ABC")
rows = cur.fetchall()
conn.close()
r = [list(ele) for ele in rows]
return(r)
def insertAllInTable(contactlist):
conn = sqlite3.connect('contacts.db')
sql = ''' INSERT INTO ABC(Name,Phone)
VALUES(?,?) '''
cur = conn.cursor()
for a in contactlist:
cur.execute(sql, (a[0], a[1]))
conn.commit()
conn.close()
def readByName(name):
conn = sqlite3.connect('contacts.db')
cur = conn.cursor()
sql = "SELECT id FROM ABC WHERE Name= '" + name + "'"
cur.execute(sql)
rows = cur.fetchall()
conn.close()
for row in rows:
return(int(row[0]))