def delete_student(usn):
try:
with db.DbContext() as Connection:
cursor = Connection.cursor()
cursor.execute("DELETE FROM student WHERE usn=?",(usn,))
except Exception as e:
print(str(e))
def add_student(usn, name, sem, placed):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("INSERT INTO student(usn, name, sem, placed) VALUES(?,?,?,?)",(usn, name, sem, placed))
except Exception as e:
print(str(e))
def reg_stu_internship(usn, iid, status):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("INSERT INTO registration(iid, usn, status) VALUES(?,?,?)",(iid,usn, status))
except Exception as e:
print(str(e))
def delete_internship(id):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("DELETE FROM internship where id=? ",(id,))
except Exception as e:
print(str(e))
def update_stu_intership_status(usn, iid, status):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("UPDATE registration set status=? WHERE usn=? and iid=?",(status,usn,iid))
except Exception as e:
print(str(e))
def delete_internship(id):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("Delete from internship where id = ?", (id, ))
except Exception as e:
print(e)
def update_student(usn,sem):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("UPDATE student set sem=? WHERE usn=?",(sem, usn,))
except Exception as e:
print(str(e))
def delete_internship(name):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("delete the intership where iname=: ", (name, ))
except Exception as e:
print(str(e))
def delete_student(name):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("delete the student where name=: ", (name, ))
except Exception as e:
print(str(e))
def delete_internship(id):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("delete from internship where id=?", (id, ))
print("Internship with ID:{id} deleted!")
except Exception as e:
print(f"{str(e)}")
def delete_student(usn):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("delete from student where usn=?", (usn, ))
print("Student deleted!")
except Exception as e:
print(f"{str(e)}")
def company_ws_count():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("SELECT count(company) FROM (SELECT DISTINCT company FROM internship)")
company_count = cursor.fetchone()
print(f"Total companies that provide internship : {company_count[0]}\n")
except Exception as e:
print(str(e))
def student_ws_count():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("SELECT count(*) from student")
student_count = cursor.fetchone()
print(f"Total students : {student_count[0]}")
except Exception as e:
print(str(e))
def change_status_internship(id, status):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("update internship set status = ? where id=?",
(status, id))
print("Internship With ID:{id} Status updated!")
except Exception as e:
print(f"{str(e)}")
def add_internship(iname,company,i_year):
id = _get_new_id()
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("insert into internship(id,iname,company,i_year,status) values(?,?,?,?,?)",(id,iname,company,i_year,1))
print(f"Internship is added successfully with id:{id}")
except Exception as e:
print(str(e))
def change_status_internship(status, name):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("UPDATE internship set status = ? where iname = ? ",
(status, name))
conn.commit()
except Exception as e:
print(e)
def add_student_internship(usn, iid, status):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("insert into registration values(?,?,?)",
(iid, usn, status))
except Exception as e:
print(e)
def delete_student(usn):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("Delete from student where usn = ?", (usn, ))
print("Successfully deleted")
except Exception as e:
print(e)
def update_stu_intership_status(usn, status):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("update register set status = ? where usn=?",
(status, usn))
print("Status updated!")
except Exception as e:
print(f"{str(e)}")
def view_all_reg_student():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("select iid,usn,status from register")
rows = cursor.fetchall()
register_pro_lst = [Register(*row) for row in rows]
_view_registered_list(register_pro_lst)
except Exception as e:
print(str(e))
def view_all_internships():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("select id,iname,company,i_year,status from internship")
rows = cursor.fetchall()
intern_pro_lst = [Internship(*row) for row in rows]
_view_internship_list(intern_pro_lst)
except Exception as e:
print(str(e))
def reg_student_internship(usn, iid):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute(
"insert into register(iid,usn,status) values(?,?,?)",
(iid, usn, 0))
print(f"Student registered successfully for iid:{iid} internship")
except Exception as e:
print(str(e))
def update_stu_intership_status(usn, status):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("UPDATE registration set status = ? where usn = ?",
(status, usn))
print(f"Status: {status} successfully updated")
except Exception as e:
print(e)
def add_student_internship(name, sem, usn, placed):
iid = _get_new_id()
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("insert into student values(?,?,?,?)",
(usn, name, sem, placed))
print(f"student is added successfully with id:{iid}")
except Exception as e:
print(str(e))
def update_student(usn, sem):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute("UPDATE student set sem = ? where usn = ?",
(sem, usn))
print("Student successfully updated")
except Exception as e:
print(e)
def search_internship_by_name(name):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("select all from intrship where ename:", (name, ))
row = cursor.fetchone()
intern_pro_lst = [Internship(*row)]
_view_internship_list(intern_pro_lst)
except Exception as e:
print(str(e))
def view_all_students():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute("select usn,name,sem,placed from student")
rows = cursor.fetchall()
student_pro_lst = [Student(*row) for row in rows]
_view_student_list(student_pro_lst)
except Exception as e:
print(str(e))
def add_student(usn, name, sem, placed):
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute(
"insert into student(usn,name,sem,placed) values(?,?,?,?)",
(usn, name, sem, placed))
print(f"Student is added successfully!!")
except Exception as e:
print(str(e))
def add_student(usn, name, sem, placed):
try:
with db.DbContext() as conn:
cursor = conn.cursor()
cursor.execute(
"insert into student(usn,name,sem,placed) values(?,?,?,?)",
(usn, name, sem, placed))
print(f"Registration is successfull")
except Exception as e:
print(e)
def company_ws_count():
try:
with db.DbContext() as connection:
cursor = connection.cursor()
cursor.execute(
"select company,count(*) from internship group by company")
rows = cursor.fetchall()
company_pro_lst = [Company(*row) for row in rows]
_view_company_count(company_pro_lst)
except Exception as e:
print(str(e))
