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')
