def del_teacher():
try:
cur.execute(
f"DELETE FROM `teachers` WHERE id = '{request.json['id']}';")
db.commit()
return {"success": True}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def upd_filial():
try:
cur.execute(
f"UPDATE `filials` SET `full_name` = '{request.json['full_name']}', `coop_date` = '{request.json['coop_date']}' WHERE `filials`.`id` = {request.json['id']}; ")
db.commit()
return {"success": True}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def upd_teacher():
try:
cur.execute(
f"UPDATE `teachers` SET `first_name`='{request.json['first_name']}', `last_name`='{request.json['last_name']}', `middle_name`='{request.json['middle_name']}', `college_date`='{request.json['college_date']}' WHERE `teachers`.`id`={request.json['id']};")
db.commit()
return {"success": True}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def upd_classroom():
try:
cur.execute(
f"UPDATE `classrooms` SET `is_tech` = '{request.json['is_tech']}', `number` = '{request.json['number']}' WHERE `classrooms`.`id` = {request.json['id']}; ")
db.commit()
return {"success": True}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def add_filial():
fid = hashlib.md5(str(str(request.json['full_name']) + str(request.json['coop_date']) + str(request.content_length)).encode(
"utf-8")).hexdigest()
qr = f"INSERT INTO `filials` (`id`, `full_name`, `coop_date`, `filial_id`) VALUES (NULL, '{request.json['full_name']}', '{request.json['coop_date']}', '{fid}'); "
try:
cur.execute(qr)
db.commit()
return {"success": True, "fid": fid}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def del_t(message):
fid = message.text.split()[0]
try:
cur.execute(f"DELETE FROM `teachers` WHERE id = '{fid}';")
db.commit()
bot.send_message(message.chat.id,
text='Преподаватель <b>успешно</> удален!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def del_s(message):
fid = message.text.split()[0]
try:
cur.execute(f"DELETE FROM `students` WHERE id = '{fid}';")
db.commit()
bot.send_message(message.chat.id,
text='Студент <b>успешно</> удален!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def del_c(message):
fid = message.text.split()[0]
try:
cur.execute(f"DELETE FROM `classrooms` WHERE id = '{fid}';")
db.commit()
bot.send_message(message.chat.id,
text='Аудитория <b>успешно</> удалена!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def add_teacher():
tid = hashlib.md5(
(request.json['first_name'] + request.json['last_name'] + request.json['middle_name'] + request.json['college_date'] + str(request.content_length)).encode("utf-8")).hexdigest()
qr = f"INSERT INTO `teachers` (`id`, `first_name`, `last_name`, `middle_name`, `college_date`, `teacher_id`, `filial_id`) VALUES (NULL, '{request.json['first_name']}', '{request.json['last_name']}', '{request.json['middle_name']}', '{request.json['college_date']}', '{tid}', '{request.json['filial_id']}'); "
try:
cur.execute(qr)
db.commit()
return {"success": True, "tid": tid}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def add_classroom():
cid = hashlib.md5(str(str(request.json['number']) + str(request.json['is_tech']) + str(request.content_length)).encode(
"utf-8")).hexdigest()
qr = f"INSERT INTO `classrooms` (`id`, `is_tech`, `number`, `filial_id`, `classroom_id`) VALUES (NULL, '{request.json['is_tech']}', '{request.json['number']}', '{request.json['filial_id']}', '{cid}'); "
try:
cur.execute(qr)
db.commit()
return {"success": True, "cid": cid}
except MySQLError as e:
return {"success": False, "error": e.args[0]}
def upd_insert_teacher(message, *args):
ti = message.text.split('/')
tcr = ti[0].split()
qr = f"UPDATE `teachers` SET `first_name` = '{tcr[1]}', `last_name` = '{tcr[0]}', `middle_name` = '{tcr[2]}', `college_date` = '{ti[1]}' WHERE `teachers`.`id` = {args[0]}; "
try:
cur.execute(qr)
db.commit()
bot.send_message(
message.chat.id,
text='Преподаватель <b>успешно</b> отредактирован и обновлен!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def insert_classroom(message, *args):
ci = message.text.split()
cid = hashlib.md5((str(ci[0]) + str(ci[1]) +
str(message.message_id)).encode("utf-8")).hexdigest()
qr = f"INSERT INTO `classrooms` (`id`, `is_tech`, `number`, `filial_id`, `classroom_id`) VALUES (NULL, '{ci[1]}', '{ci[0]}', '{args[0][0][0]}', '{cid}'); "
try:
cur.execute(qr)
db.commit()
bot.send_message(message.chat.id,
text='Аудитория <b>успешно</b> зарегистрирована!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def upd_insert_filial(message, *args):
fi = message.text.split("/")
try:
cur.execute(
f"UPDATE `filials` SET `full_name` = '{fi[0]}', `coop_date` = '{fi[1]}' WHERE `filials`.`id` = {args[0]}; "
)
db.commit()
bot.send_message(
message.chat.id,
text='Филиал <b>успешно</> отредактирован и обновлен!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def upd_insert_classroom(message, *args):
ci = message.text.split()
try:
cur.execute(
f"UPDATE `classrooms` SET `is_tech` = '{ci[1]}', `number` = '{ci[0]}' WHERE `classrooms`.`id` = {args[0][0][0]}; "
)
db.commit()
bot.send_message(
message.chat.id,
text='Аудитория <b>успешно</> отредактирована и обновлена!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def add_f(message):
fi = message.text.split('/')
fid = hashlib.md5((str(fi[0]) + str(fi[1]) +
str(message.message_id)).encode("utf-8")).hexdigest()
qr = f"INSERT INTO `filials` (`id`, `full_name`, `coop_date`, `filial_id`) VALUES (NULL, '{fi[0]}', '{fi[1]}', '{fid}'); "
try:
cur.execute(qr)
db.commit()
bot.send_message(message.chat.id,
text='Филиал <b>успешно</b> зарегистрирован!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def insert_teacher(message, *args):
ti = message.text.split('/')
tcr = ti[0].split()
tid = hashlib.md5((str(ti[0]) + str(ti[1]) +
str(message.message_id)).encode("utf-8")).hexdigest()
qr = f"INSERT INTO `teachers` (`id`, `last_name`, `first_name`, `middle_name`, `college_date`, `filial_id`, `teacher_id`) VALUES (NULL, '{tcr[0]}', '{tcr[1]}', '{tcr[2]}', '{ti[1]}', '{args[0][0][0]}', '{tid}'); "
try:
cur.execute(qr)
db.commit()
bot.send_message(message.chat.id,
text='Преподаватель <b>успешно</b> зарегистрирован!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
def insert_student(message, *args):
si = message.text.split('/')
scr = si[0].split()
sid = hashlib.md5((str(si[0]) + str(si[1]) +
str(message.message_id)).encode("utf-8")).hexdigest()
qr = f"INSERT INTO `students` (`id`, `last_name`, `first_name`, `middle_name`, `college_date`, `filial_id`, `student_id`) VALUES (NULL, '{scr[0]}', '{scr[1]}', '{scr[2]}', '{si[1]}', '{args[0][0][0]}', '{sid}'); "
try:
cur.execute(qr)
db.commit()
bot.send_message(message.chat.id,
text='Студент <b>успешно</b> зарегистрирован!',
parse_mode='html')
except MySQLError as e:
bot.send_message(message.chat.id, text=e.args[0])
