-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase_exception.py
More file actions
82 lines (63 loc) · 2.34 KB
/
database_exception.py
File metadata and controls
82 lines (63 loc) · 2.34 KB
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
77
78
79
80
81
82
# Advaced Database class.
import random
import datetime , time
import sqlite3
conn=sqlite3.connect("Advanced12.db")
c=conn.cursor()
def create_table():
c.execute("CREATE TABLE IF NOT EXISTS TABLENAME(COLUMNNAME1 INTEGER,DATESTAMP TEXT,COLUMNO3 TEXT,VALUE REAL)")
def dynamic_data_entry():
COLUMNNAME1=time.time()
print("time.time():",time.time())
#create_table()
#dynamic_data_entry()
#break
#exit()
DATE=str(datetime.datetime.fromtimestamp(COLUMNNAME1).strftime("%Y-%m-%d %H:%M:%S"))
COLUMNO3='Python database'
VALUE=random.randrange(0,10)
#"INSERT INTO TABLENAME VALUES(1,"jOHN","INDIA")"
c.execute("INSERT INTO TABLENAME(COLUMNNAME1,DATESTAMP,COLUMNO3,VALUE)VALUES(?,?,?,?)",
(COLUMNNAME1,DATE,COLUMNO3,VALUE))
conn.commit()
###############################################################################
def read_from_db():
print("select *from tabename")
c.execute("SELECT * FROM TABLENAME ")
#c.execute("SELECT * FROM TABLENAME WHERE VALUE<2")
c.execute("SELECT COLUMNNAME1,COLUMNO3 FROM TABLENAME WHERE VALUE<2")
dataoneline=c.fetchone()
print("fetching only dataonline 1 row:",dataoneline)
#dataall=c.fetchall()
#print("dataoneline :",dataoneline)
#print("data allL:",dataall)
print("c.fetchall()")
for row in c.fetchall():
print(row)
#print(row[0])
def del_and_update():
c.execute('SELECT * FROM TABLENAME3333333')
[print(row) for row in c.fetchall()]
print(50 *'*')
c.execute("UPDATE TABLENAME SET VALUE=88 WHERE VALUE=4")
# update done at above line.
conn.commit()
c.execute("SELECT * FROM TABLENAME")
print("Length of rows after update :",len(c.fetchall()))
c.execute("DELETE FROM TABLENAME WHERE VALUE=1")
conn.commit()
print(50*'#')
c.execute("SELECT * FROM TABLENAME")
print("Length of rows after delete:",len(c.fetchall()))
[print(row )for row in c.fetchall()]
print("starting of db operation.")
create_table()
for i in range(3):
dynamic_data_entry()
time.sleep(2)
read_from_db()
del_and_update()
read_from_db()
c.close()
print("End line execution")
conn.close()