def get_by_id(): print(request.data) data = json.loads(request.data) print(data) paperId = data["paperId"] sql = "select * from teacher_paper where paperId = '%s'" % (paperId) print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = ["paperId", "paperName", "paperDescription", "selectContent", "askContent", "createTime", "creator"] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) cursor.close() db2.close() return make_response(resp, 200)
def get_all(): sql = 'select * from paper_question' print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = [ "questionId", "questionName", "questionContent", "creator", "createTime", "questionType" ] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) cursor.close() db2.close() return make_response(resp, 200)
def getClass(): print("data",request.data) print("sss") data = json.loads(request.data) print(data) teacherName = data['teacherName'] sql = 'select * from class_teacher where teacherName = "%s"' % (teacherName) if teacherName == "": sql = 'select * from class_teacher' print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor =db2.cursor() cursor.execute(sql) print("ssss") all_data = cursor.fetchall() print("all",all_data) key_list = ["className", "teacherName", "description"] resp_data = tuple_to_dict(key_list, all_data) print("resp",resp_data) resp = do_response("success",resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def student_paper(): print(request.data) data = json.loads(request.data) print(data) studentName = data["studentName"] sql = "select stuPaperId,studentName,a.paperId,a.askContent, a.selectContent,a.createTime,score,remark,status, b.paperName,b.paperDescription from student_paper a left join teacher_paper b on a.paperId = b.paperId where a.studentName = '%s' \ order by createTime desc" % (studentName) print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = ["stuPaperId", "studentName", "paperId", "askContent", "selectContent", "createTime", "score", "remark", "status", "paperName", "paperDescription"] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) cursor.close() db2.close() return make_response(resp, 200)
def get_class_one(): print(request.data) data = json.loads(request.data) print(data) className = data['className'] sql = ''' select studentName from class_student where className = "%s" \ and status = 1''' % (className) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor =db2.cursor() cursor.execute(sql) print(sql) all_data = cursor.fetchall() print("all",all_data) key_list = ["studentName"] resp_data = tuple_to_dict(key_list, all_data) print("resp",resp_data) resp = do_response("success",resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def addClassNotificatio(): print(request.data) data = json.loads(request.data) print(data) className = data['className'] sql = 'select * from class_notification where className = "%s"' %(className) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor =db2.cursor() cursor.execute(sql) print(sql) all_data = cursor.fetchall() print("all",all_data) key_list = ["notificationId","className","title","content","noticeTime"] resp_data = tuple_to_dict(key_list, all_data) print("resp",resp_data) resp = do_response("success",resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def get_join_list(): print(request.data) data = json.loads(request.data) print(data) studentName = data['studentName'] sql = 'select a.className,a.teacherName, a.description, b.status \ from class_teacher as a left join class_student as b \ on a.className = b.className \ and b.studentName = "%s"' % (studentName) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor =db2.cursor() cursor.execute(sql) print(sql) all_data = cursor.fetchall() print("all",all_data) key_list = ["className", "teacherName", "description", "status"] resp_data = tuple_to_dict(key_list, all_data) print("resp",resp_data) resp = do_response("success",resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def get_bbs_comment_by_topic(): print(request.data) data = json.loads(request.data) print(data) bbsId = data['bbsId'] sql = 'select * from bbs_comment where bbsId = %d order by createTime asc' \ % (int(bbsId)) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor =db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all",all_data) key_list = ["commentId","bbsId","author","avatar","content","createTime"] resp_data = tuple_to_dict(key_list, all_data) print("resp",resp_data) resp = do_response("success",resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def searchBook(): print(request.data) data = json.loads(request.data) print(data) searchKey = data["searchKey"] sql = "select * from ebook where concat(title, author,createTime) like '%%%s%%' order by createTime asc" % searchKey print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = ["ebookId", "title", "author", "createTime", "contentHtml"] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def get_book_list(): # print(request.data) # data = json.loads(request.data) # print(data) # askContent = data["askContent"] # createTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") # sql = "insert into teacher_paper(paperName, paperDescription, \ # selectContent, askContent, createTime, creator) \ # values('%s','%s','%s','%s','%s','%s') " % \ # (paperName, paperDescription,selectContent, \ # askContent, createTime, creator) sql = "select * from ebook order by createTime asc" print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = ["ebookId", "title", "author", "createTime", "contentHtml"] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def load_book(): print(request.data) data = json.loads(request.data) print(data) ebookId = data["ebookId"] username = data["username"] sql = "select * from ebook_note where ebookId = %d and username \ = '%s'" % (ebookId, username) print(sql) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql) all_data = cursor.fetchall() print("all", all_data) key_list = [ "noteId", "ebookId", "username", "contentHtml", "createTime", "updateTime" ] resp_data = tuple_to_dict(key_list, all_data) print("resp", resp_data) resp = do_response("success", resp_data, 200) cursor.close() db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)