def Submit(self): name = self.depName.text() year = self.year.value() section = self.section.value() try: conn = pymysql.connect(host=host, port=port, user=user, passwd=passwd, db=db) cur = conn.cursor() except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLError) try: query = "CREATE TABLE IF NOT EXISTS DEPARTMENT(SNO INT(3) NOT NULL AUTO_INCREMENT, NAME VARCHAR(20), YEAR VARCHAR(3), SECTION VARCHAR(3), PRIMARY KEY(SNO), UNIQUE(NAME))" cur.execute(query) try: cur.execute( "INSERT INTO DEPARTMENT(NAME, YEAR, SECTION) VALUES(%s,%s,%s)", (str(name), str(year), str(section))) conn.commit() conn.close() except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLInsertError) except Exception as e: print("error2")
def register(self): name = self.name.text() teacherid = self.id.text() email = self.email.text() phone = self.phone.text() password = self.password.text() dob = self.dob.date() department = self.department.currentText() role = self.role.currentText() classes = self.classes.text() cclasses = self.cclasses.text() dob = dob.toPyDate() if (name == "" or teacherid == "" or email == "" or phone == "" or password == ""): messageWin.pop_up_window(messages.errorTitle, messages.emptyFieldError) else: try: query = "CREATE TABLE IF NOT EXISTS TEACHERS(SNO INT(3) NOT NULL AUTO_INCREMENT, NAME VARCHAR(30), ID VARCHAR(30), EMAIL_ID VARCHAR(40), MOBILE_NO VARCHAR(13), DOB VARCHAR(10), CLASSES VARCHAR(100), COORDINATED_CLASSES VARCHAR(100), PASSWORD VARCHAR(50), DEPARTMENT VARCHAR(5), ROLE VARCHAR(10), UNIQUE (ID), PRIMARY KEY (SNO))" cur.execute(query) try: cur.execute( "INSERT INTO TEACHERS(NAME, ID, EMAIL_ID, MOBILE_NO, DOB, CLASSES, COORDINATED_CLASSES, PASSWORD, DEPARTMENT, ROLE) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", (str(name), str(teacherid), str(email), str(phone), str(dob), str(classes), str(cclasses), str(password), str(department), str(role))) conn.commit() except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLInsertError) conn.close() except Exception as e: print("error2")
def Login(self): username = self.userName.text() password = self.password.text() if username == "" or password == "": messageWin.pop_up_window(messages.errorTitle, messages.emptyFieldError) else: if username == res.vars.adminID and password == res.vars.adminPass: self.ui = mainWindow.Ui_MainWindow() self.ui.setupUi(self.MainWindow) self.MainWindow.show() else: query = "SELECT CLASSES, COORDINATED_CLASSES FROM TEACHERS WHERE ID='{0}' AND PASSWORD='******'".format( username, password) cur.execute(query) data = cur.fetchone() if data is None: messageWin.pop_up_window(messages.SQLErrorTitle, messages.noUserFound) else: classes = data[0].split(',') coordClasses = data[1].split(',') count = 0 branch = [] year = [] section = [] b = y = s = "" for doc in classes: b = y = s = "" doc = doc.strip() count = 0 for i in range(len(doc)): if doc[i] == '-': count += 1 elif count == 0: b += doc[i] elif count == 1: y += doc[i] elif count == 2: s += doc[i] branch.append(b) year.append(y) section.append(s) self.ui = selectClass.Ui_Dialog( self.removeDuplicate(branch), self.removeDuplicate(year), self.removeDuplicate(section)) self.ui.setupUi(self.Dialog) self.Dialog.show()
def Submit(self): name = self.name.text() enrollment_no = self.enumber.text() email = self.email.text() phone = self.phone.text() branch = self.branch.currentText() year = self.year.currentText() section = self.section.currentText() if name == "" or enrollment_no == "" or email == "" or phone == "": messageWin.pop_up_window(messages.errorTitle, messages.emptyFieldError) else: try: conn = pymysql.connect(host=host, port=port, user=user, passwd=passwd, db=db) cur = conn.cursor() except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLError) table_name = str(branch + year + section) print(table_name) try: query = "CREATE TABLE IF NOT EXISTS " + table_name + "(SNO INT(3) NOT NULL AUTO_INCREMENT, NAME VARCHAR(30), ENROLLMENT VARCHAR(20), EMAIL VARCHAR(40), PHONE VARCHAR(20), BRANCH VARCHAR(10), YEAR VARCHAR(2), SECTION VARCHAR(3), UNIQUE(ENROLLMENT), PRIMARY KEY(SNO))" cur.execute(query) except Exception as e: print("error2") try: cur.execute( "INSERT INTO " + table_name + "(NAME, ENROLLMENT, EMAIL, PHONE, BRANCH, YEAR, SECTION) VALUES(%s,%s,%s,%s,%s,%s,%s)", (str(name), str(enrollment_no), str(email), str(phone), str(branch), str(year), str(section))) conn.commit() try: detection.start_detection(name, year, section, enrollment_no, branch) messageWin.pop_up_window(messages.successTitle, messages.successMessage) except Exception as e: messageWin.pop_up_window(messages.errorTitle, messages.errorMessage) except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLInsertError) conn.close()
def train(self): branch = self.branch.currentText() year = self.year.currentText() section = self.section.currentText() path = "dataset/" + str(branch) + "/" + str(year) + "/" + str(section) if not os.path.exists(path): messageWin.pop_up_window(messages.errorTitle, messages.noDirectoryError) else: path2 = "recognizer/" + str(branch) + "/" + str(year) + "/" + str( section) if not os.path.exists(path2): os.makedirs(path2) trainer.main(path, path2)
from res import messageWin import pymysql from res.vars import host, port, user, passwd, db import res.vars import mainWindow import selectClass try: conn = pymysql.connect(host=host, port=port, user=user, passwd=passwd, db=db) cur = conn.cursor() except Exception as e: messageWin.pop_up_window(messages.SQLErrorTitle, messages.SQLError) try: _fromUtf8 = QtCore.QString.fromUtf8 except AttributeError: def _fromUtf8(s): return s try: _encoding = QtGui.QApplication.UnicodeUTF8 def _translate(context, text, disambig): return QtGui.QApplication.translate(context, text, disambig, _encoding) except AttributeError: