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:
