def add(self):
if self.Name_var.get()=="" or self.Roll_No_var.get()=="" or self.email_var.get=="" or self.gender_var.get()=="" or \
self.contact_var.get()=="" or self.dob_var.get()=="" :
messagebox.showerror("Error","imcomplete")
else:
student_obj=studentt(self.Name_var.get(),self.Roll_No_var.get(),self.email_var.get(),self.gender_var.get()
,self.contact_var.get(),self.dob_var.get())
query='insert into student values(%s,%s,%s,%s,%s,%s);'
values=(student_obj.get_Name(),student_obj.get_Roll_no(),student_obj.get_email(),student_obj.get_gender()
,student_obj.get_contact(),student_obj.get_dob())
self.dbconnect.insert(query,values)
messagebox.showinfo('sucess','information inserted sucessfully')
self.fetch()
def update(self):
student_obj=studentt(self.Name_var.get(),self.Roll_No_var.get(),self.email_var.get(),self.gender_var.get()
,self.contact_var.get(),self.dob_var.get())
query='update student set Name=%s, email=%s, gender=%s, contact=%s, dob=%s where Roll_no=%s;'
Name=self.Name_var.get()
Roll_no=self.Roll_No_var.get()
email=self.email_var.get()
gender=self.gender_var.get()
contact=self.contact_var.get()
dob=self.dob_var.get()
values=(Roll_no,gender,contact,email,gender,Name)
self.dbconnect.update(query,values)
messagebox.showinfo('sucess', 'data updated sucessfully')
self.fetch()
def test_get_name(self):
e = studentt('1', '2', '3', 'male', '3', '4')
self.assertTrue('1', e.get_Name())
def test_get_contact(self):
e = studentt('samsung', '77', '*****@*****.**', 'male', '77889900',
'1995')
self.assertEqual('77889900', e.get_contact())
def test_get_gender(self):
e = studentt('softwarica', '2', '*****@*****.**', 'others',
'123456789', '2010')
self.assertEqual('others', e.get_gender())
def test_get_email(self):
e = studentt('hello', '1', '213123', 'male', '123', '213')
self.assertEqual('213123', e.get_email())
def test_get_rollno(self):
e = studentt('john', '2', '*****@*****.**', 'male', '090990099',
'1988')
self.assertEqual('2', e.get_Roll_no())