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