def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
self.list = []
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
temp = semester_query.value(0).replace('_', ' Term')
self.list.append(temp)
self.ui.Semester_comboBox.addItem(temp)
semester_query.exec_(
"Select Current_term from System where System_id = 1")
semester_query.next()
index = self.ui.Semester_comboBox.findText(
semester_query.value(0).replace('_', ' Term'))
self.ui.Semester_comboBox.setCurrentIndex(index)
self.ui.Year_spinBox.setMaximum(3000)
self.ui.Year_spinBox.setMinimum(1970)
self.ui.Year_spinBox.setValue(int(semester_query.value(0)[0:4]))
self.ui.Set_btn.clicked.connect(self.set)
self.ui.Add_btn.clicked.connect(self.add)
class semester_set_dialog(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
self.ui.Semester_comboBox.addItem(
semester_query.value(0).replace('_', ' Term'))
self.ui.Set_btn.clicked.connect(self.set)
def set(self):
semester_query = QSqlQuery()
if semester_query.exec_("Update System set Current_term = '%s' where System_id = 1" % \
self.ui.Semester_comboBox.currentText().replace(' Term', '_')):
QtGui.QMessageBox.information(self, 'success', 'Success!')
else:
QtGui.QMessageBox.information(self, 'fail', 'Fail!')
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
class semester_set_dialog(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
self.ui.Semester_comboBox.addItem(semester_query.value(0).replace('_', ' Term'))
self.ui.Set_btn.clicked.connect(self.set)
def set(self):
semester_query = QSqlQuery()
if semester_query.exec_("Update System set Current_term = '%s' where System_id = 1" % \
self.ui.Semester_comboBox.currentText().replace(' Term', '_')):
QtGui.QMessageBox.information(self, 'success', 'Success!')
else:
QtGui.QMessageBox.information(self, 'fail', 'Fail!')
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
self.ui.Semester_comboBox.addItem(
semester_query.value(0).replace('_', ' Term'))
self.ui.Set_btn.clicked.connect(self.set)
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
self.list = []
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
temp = semester_query.value(0).replace('_', ' Term')
self.list.append(temp)
self.ui.Semester_comboBox.addItem(temp)
semester_query.exec_("Select Current_term from System where System_id = 1")
semester_query.next()
index = self.ui.Semester_comboBox.findText(semester_query.value(0).replace('_', ' Term'))
self.ui.Semester_comboBox.setCurrentIndex(index)
self.ui.Year_spinBox.setMaximum(3000)
self.ui.Year_spinBox.setMinimum(1970)
self.ui.Year_spinBox.setValue(int(semester_query.value(0)[0:4]))
self.ui.Set_btn.clicked.connect(self.set)
self.ui.Add_btn.clicked.connect(self.add)
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
self.ui.Semester_comboBox.addItem(semester_query.value(0).replace('_', ' Term'))
self.ui.Set_btn.clicked.connect(self.set)
class semester_set_dialog(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
self.list = []
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
temp = semester_query.value(0).replace('_', ' Term')
self.list.append(temp)
self.ui.Semester_comboBox.addItem(temp)
semester_query.exec_(
"Select Current_term from System where System_id = 1")
semester_query.next()
index = self.ui.Semester_comboBox.findText(
semester_query.value(0).replace('_', ' Term'))
self.ui.Semester_comboBox.setCurrentIndex(index)
self.ui.Year_spinBox.setMaximum(3000)
self.ui.Year_spinBox.setMinimum(1970)
self.ui.Year_spinBox.setValue(int(semester_query.value(0)[0:4]))
self.ui.Set_btn.clicked.connect(self.set)
self.ui.Add_btn.clicked.connect(self.add)
def add(self):
year = self.ui.Year_spinBox.value()
term = self.ui.Term_comboBox.currentText()
new = str(year) + ' ' + term
if new in self.list:
QtGui.QMessageBox.warning(self, 'error',
'semester already existed!')
else:
self.list.append(new)
self.ui.Semester_comboBox.addItem(new)
semester_query = QSqlQuery()
semester_query.exec_(
"Select System_id from System order by System_id desc")
semester_query.next()
s_id = semester_query.value(0) + 1
if semester_query.exec_("insert into System \
(System_id, Term) values (%d, '%s')" % \
(s_id, new.replace(' Term', '_'))):
QtGui.QMessageBox.information(self, 'success',
'add semester success!')
else:
QtGui.QMessageBox.warning(self, 'error',
'add semester failed!')
def set(self):
semester_query = QSqlQuery()
if semester_query.exec_("Update System set Current_term = '%s' where System_id = 1" % \
self.ui.Semester_comboBox.currentText().replace(' Term', '_')):
QtGui.QMessageBox.information(self, 'success', 'Success!')
else:
QtGui.QMessageBox.warning(self, 'fail', 'Fail!')
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
class semester_set_dialog(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.ui = Ui_Semester_set_Dialog()
self.ui.setupUi(self)
self.conn()
self.list = []
semester_query = QSqlQuery()
semester_query.exec_("Select Term from System")
while semester_query.next():
temp = semester_query.value(0).replace('_', ' Term')
self.list.append(temp)
self.ui.Semester_comboBox.addItem(temp)
semester_query.exec_("Select Current_term from System where System_id = 1")
semester_query.next()
index = self.ui.Semester_comboBox.findText(semester_query.value(0).replace('_', ' Term'))
self.ui.Semester_comboBox.setCurrentIndex(index)
self.ui.Year_spinBox.setMaximum(3000)
self.ui.Year_spinBox.setMinimum(1970)
self.ui.Year_spinBox.setValue(int(semester_query.value(0)[0:4]))
self.ui.Set_btn.clicked.connect(self.set)
self.ui.Add_btn.clicked.connect(self.add)
def add(self):
year = self.ui.Year_spinBox.value()
term = self.ui.Term_comboBox.currentText()
new = str(year) + ' ' + term
if new in self.list:
QtGui.QMessageBox.warning(self, 'error', 'semester already existed!')
else:
self.list.append(new)
self.ui.Semester_comboBox.addItem(new)
semester_query = QSqlQuery()
semester_query.exec_("Select System_id from System order by System_id desc")
semester_query.next()
s_id = semester_query.value(0)+1
if semester_query.exec_("insert into System \
(System_id, Term) values (%d, '%s')" % \
(s_id, new.replace(' Term', '_'))):
QtGui.QMessageBox.information(self, 'success', 'add semester success!')
else:
QtGui.QMessageBox.warning(self, 'error', 'add semester failed!')
def set(self):
semester_query = QSqlQuery()
if semester_query.exec_("Update System set Current_term = '%s' where System_id = 1" % \
self.ui.Semester_comboBox.currentText().replace(' Term', '_')):
QtGui.QMessageBox.information(self, 'success', 'Success!')
else:
QtGui.QMessageBox.warning(self, 'fail', 'Fail!')
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
