-
Notifications
You must be signed in to change notification settings - Fork 0
/
marks_sql.py
21 lines (16 loc) · 740 Bytes
/
marks_sql.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
import mysql.connector as mys
def fetch_all():
connection = mys.connect(user="root", passwd="root", host="localhost", database='SUMA')
cursor = connection.cursor()
cursor.execute(f'select * from Marks')
s = cursor.fetchall()
return s
def add(s):
sid, term, subject, mark, entered_date, year, tid = s
connection = mys.connect(user="root", passwd="root", host="localhost", database='SUMA')
cursor = connection.cursor()
# cursor.execute('delete from Marks where student_id={sid} and Term ="{term}"')
q="insert into Marks values({},'{}','{}',{}, '{}', '{}', {})".format(sid, term, subject, mark, entered_date, year, tid)
cursor.execute(q)
connection.commit()
return "Created"