-
Notifications
You must be signed in to change notification settings - Fork 0
/
absentice_sql.py
37 lines (32 loc) · 970 Bytes
/
absentice_sql.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
import sql_interface as si
def fetch_absentice(id):
si.cursor.execute(f'select * from absence where Student_Id={id}')
s = si.cursor.fetchone()
return s
def fetch_all():
si.cursor.execute(f'select * from absence')
s = si.cursor.fetchall()
return s
def update(s):
AB_DATE=s[0]
SID=s[1]
REMARK=s[2]
q="select * from absence where SID={}".format(SID)
si.cursor.execute(q)
data=si.cursor.fetchone()
if data==None:
print("record not found")
return False
else:
q="update absence set absence_date={},student_id='{}',remark={},".format(AB_DATE,SID,REMARK)
si.cursor.execute(q)
si.connection.commit()
print(si.cursor.rowcount,"Record updated")
def add_student(s):
AB_DATE=s[0]
SID=s[1]
REMARK=s[2]
q="insert into absence values('{}',{},'{}')".format(AB_DATE,SID,REMARK)
si.cursor.execute(q)
si.connection.commit()
return "Created"