def deleteTeacher(self, id): record = self.getFromID(id) self._deleteRecord(record['idClient']) if record['idClientGroup'] == 2: sql = "DELETE FROM riidb.teacherinfo " \ "WHERE id ='%s'"%record['idInfo'] DataBaseModule.ExecuteSQL(sql=sql, nameDB='riidb')
def insertDiscipline(self, idTeacher, idCathGroup, discipline, numDay, numLesson, idAud): sql = "INSERT INTO riidb.timetable (idTeacher, idCathGroup, discipline, " \ "numDay, numLesson, idAud) " \ "VALUES ('%s', '%s', '%s', '%s', '%s', '%s');" \ % (idTeacher, idCathGroup, discipline, numDay, numLesson, idAud) index = DBM.ExecuteSQL(sql=sql, nameDB='riidb') return index
def updateDiscipline(self, idTimeTable, idTeacher, idCathGroup, discipline, numDay, numLesson, idAud): sql = "UPDATE riidb.timetable " \ "SET idTeacher='%s', idCathGroup='%s', discipline='%s', numDay='%s', " \ "numLesson='%s', idAud='%s' " \ "WHERE id='%s'" \ % (idTeacher, idCathGroup, discipline, numDay, numLesson, idAud, idTimeTable) DBM.ExecuteSQL(sql=sql, nameDB='botdb')
def AddRecord(self, idGroup, idContext): idG = str(idGroup) idCon = str(idContext) id = DataBaseModule.ExecuteSQL(""" INSERT accesstab (idGroup, idContext) VALUES ('""" + idG +"','" + idCon +"');") return id
def UpdateRecord(self,id,action, note, scrypt =0): if scrypt: check =1 else: check = 0 DataBaseModule.ExecuteSQL(''' UPDATE actiontab SET action=\'''' + action +"', note='" + note +"', scrypt ='" + str(check) +"' " + "WHERE id='" + str(id) +"';")
def updateTeacher(self, idClient, fio, shortfio, dolzhnost, obrazovanie, stepen, zvanie, kvalifikacia, idCath): idInfo = self.getFromID(idClient)['idInfo'] sql = "UPDATE riidb.teacherinfo " \ "SET dolzhnost='%s', obrazovanie='%s', stepen='%s', zvanie='%s', " \ "kvalifikacia='%s', idCath='%s' " \ "WHERE id='%s';"%(dolzhnost,obrazovanie,stepen,zvanie, kvalifikacia,idCath, idInfo) DataBaseModule.ExecuteSQL(sql,'riidb') self._updateRecord(idClient,fio, shortfio)
def _updateRecord(self, id, fio, shortfio, idInfo=0): if idInfo: sql = "UPDATE riidb.clients " \ "SET fio='%s', shortfio='%s', idInfo='%s' " \ "WHERE id='%s';"%(fio,shortfio,idInfo,id) else: sql = "UPDATE riidb.clients " \ "SET fio='%s', shortfio='%s' " \ "WHERE id='%s';" % (fio,shortfio, id) DataBaseModule.ExecuteSQL(sql=sql, nameDB='riidb')
def InsertRecord(self, action, note, scrypt = 0): if scrypt: check =1 else: check = 0 currentid = DataBaseModule.ExecuteSQL(''' INSERT INTO actiontab (action,note,scrypt) VALUES (\'''' + action +"','" + note +"','" + str(check) +"');") return currentid
def insertTeacher(self, fio, shortfio, dolzhnost, obrazovanie, stepen, zvanie, kvalifikacia, idCath): sql = "INSERT INTO riidb.teacherinfo (dolzhnost,obrazovanie,stepen," \ "zvanie,kvalifikacia, idCath) " \ "VALUES ('%s','%s','%s','%s','%s','%s');"%\ (dolzhnost, obrazovanie, stepen, zvanie, kvalifikacia, idCath) idInfo = DataBaseModule.ExecuteSQL(sql=sql, nameDB='riidb') if idInfo: idClient = self._insertRecord(fio,shortfio,idInfo, idClientGroup=2) return idClient else: return 0
def updateRecord(self, id, name=0, numAud=0, idClient=0): sql = "UPDATE riidb.projectors SET " if name and idAud: sql += "name = '%s', idAud = '%s' " % (name, numAud) elif name: sql += "name = '%s' " % name else: sql += "numAud = '%s', idClient='%s'" % (numAud, idClient) sql += "WHERE id = '%s';" % id DBM.ExecuteSQL(sql=sql, nameDB='riidb')
def returnToCath(self, idClient): data = self.getList() device = 0 for row in data: if row['idClient'] == idClient: device = row['name'] sql = "UPDATE riidb.projectors " \ "SET numAud = 0, idClient =0 " \ "WHERE idClient = '%s'" % idClient DBM.ExecuteSQL(sql=sql, nameDB='riidb') return device
def UpdateRecord(self, id, header): DataBaseModule.ExecuteSQL("""UPDATE contexttab SET header='""" + header + """' WHERE id ='""" + str(id) + "';")
def _DeleteRecordFromID(self, idContext): QuestionTable().DeleteFromContextID(idContext) AnswerTable().DeleteFromContextID(idContext) AccessTable().DeleteFromContextID(idContext) DataBaseModule.ExecuteSQL("""DELETE FROM contexttab WHERE id = '""" + str(idContext) + "';")
def InsertRecord(self, header, idParent, level): id = DataBaseModule.ExecuteSQL(""" INSERT INTO contexttab (header, idParent, level) VALUES ('""" + header + "','" + str(idParent) + "','" + str(level) + "');") return id
def UpdateRecord(self, **rec): DataBaseModule.ExecuteSQL(''' UPDATE usergrouptab SET nameGroup=\'''' + rec['nameGroup'] + "', editDB='" + str(rec['editDB']) + "'" + "WHERE id='" + str(rec['id']) + "';")
def InsertRecord(self, question, idContext): currentid = DataBaseModule.ExecuteSQL(""" INSERT INTO questiontab (question, idContext) VALUES('""" + question + "','" + str(idContext) + "');") return currentid
def deleteClient(self, idTelegram): sql = "DELETE FROM botdb.clientstab " \ "WHERE id = '%s'" % idTelegram DBM.ExecuteSQL(sql=sql, nameDB='botdb')
def UpdateRecordFromIDAndText(self, id, question): DataBaseModule.ExecuteSQL("UPDATE questiontab " + "SET question ='" + question + "' " + "WHERE id='" + str(id) + "';")
def updateRecord(self, id, name, idCath, idTeacher, course): sql = "UPDATE riidb.cathGroup " \ "SET name='%s', idCathedra='%s', idCurator='%s', course='%s' " \ "WHERE id='%s';"%(name,idCath,idTeacher,course,id) DBM.ExecuteSQL(sql=sql, nameDB='riidb')
def insertRecord(self, name, idCath, idTeacher, course): sql = "INSERT INTO riidb.cathGroup " \ "(name, idCathedra, idCurator, course) " \ "VALUES ('%s', '%s', '%s', '%s')" % (name,idCath,idTeacher, course) idCathGroup = DBM.ExecuteSQL(sql=sql, nameDB='riidb') return idCathGroup
def DeleteFromContextID(self, idContext): DataBaseModule.ExecuteSQL("""DELETE FROM answertab WHERE idContext = '""" + str(idContext) + "';")
def UpdateRecord(self, id, answer, idAction): DataBaseModule.ExecuteSQL("UPDATE answertab " + "SET answer ='" + answer + "', idAction ='" + str(idAction) + "' " + "WHERE id='" + str(id) + "';")
def DeleteFromID(self, id): DataBaseModule.ExecuteSQL("""DELETE FROM answertab WHERE answertab.id = '""" + str(id) + "';")
def InsertRecord(self, answer, idContext, idAction): currentid = DataBaseModule.ExecuteSQL( "INSERT INTO answertab (answer, idContext, idAction) " + "VALUES('%s','%s', '%s');" % (answer, idContext, idAction)) return currentid
def insertClient(self, idClient, idClientGroup, idTelegram): sql = "INSERT INTO botdb.clientstab (idRii, idClientGroup, idTelegram) " \ "VALUES ('%s', '%s','%s')" % (idClient, idClientGroup, idTelegram) insertID = DBM.ExecuteSQL(sql=sql, nameDB='botdb') return insertID
def InsertRecord(self, **rec): currentid = DataBaseModule.ExecuteSQL(''' INSERT INTO usergrouptab (nameGroup, editDB) VALUES (\'''' + rec['nameGroup'] + "', '" + str(rec['editDB']) +"');") return currentid
def _deleteRecord(self, id): sql = "DELETE FROM riidb.clients " \ "WHERE id ='%s'"%str(id) DataBaseModule.ExecuteSQL(sql=sql, nameDB='riidb')
def DeleteRecord(self, id): DataBaseModule.ExecuteSQL( "DELETE FROM usergrouptab WHERE id ='" + str(id) + "';")
def _insertRecord(self, fio, shortfio, idInfo, idClientGroup=3): sql = "INSERT INTO riidb.clients (fio, shortfio, idInfo, idClientGroup) " \ "VALUES ('%s', '%s','%s', '%s')" % (fio, shortfio,str(idInfo), str(idClientGroup)) idClient = DataBaseModule.ExecuteSQL(sql=sql, nameDB='riidb') return idClient
def deleteDiscipline(self, id): sql = "DELETE FROM riidb.timetable " \ "WHERE id = '%s';" % id DBM.ExecuteSQL(sql=sql, nameDB='riidb')