def do_paper_one(): print(request.data) data = json.loads(request.data) print(data) askContent = data["askContent"] stuPaperId = data["stuPaperId"] selectContent = data["selectContent"] sql = "update student_paper set askContent = '%s',selectContent = '%s', status = 1 where stuPaperId = %d" % ( askContent, selectContent, int(stuPaperId)) 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) db2.commit() resp = do_response("success", "true", 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 register(): print(request.data) data = eval(request.data) username = data['username'] password = data['password'] types = data['types'] password = MD5(password) sql = 'insert into user(username,password,types) values("%s","%s", %d)' % ( username, password, int(types)) print(sql) data = '' status = 200 try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") db2.cursor().execute(sql) db2.commit() resp = do_response("success", "true", 200) except Exception as e: print(e) data = str(e) print(e) resp = do_response("error", data, 400) db2.close() return make_response(resp, 200)
def createPaper(): print(request.data) data = json.loads(request.data) print(data) askContent = data["askContent"] paperDescription = data["paperDescription"] paperName = data["paperName"] print(type(data["selectContent"])) print(data["selectContent"]) selectContent = data["selectContent"] print("ss", selectContent) print(type(selectContent)) # json.loads(selectContent) creator = data["creator"] 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) 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) db2.commit() resp = do_response("success", "true", 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 addClassNotification(): print(request.data) data = json.loads(request.data) print(data) className = data['className'] title = data['title'] content = data["content"] noticeTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") sql = 'insert into class_notification(className, title, content, noticeTime) \ values("%s","%s","%s","%s") ' % (className, title, content, noticeTime) 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) db2.commit() resp = do_response("success","true", 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 submitPaper(): print(request.data) data = json.loads(request.data) print(data) askContent = data["askContent"] paperId = data["paperId"] selectContent = data["selectContent"] studentName = data["studentName"] createTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") sql = "insert into student_paper(studentName, paperId, askContent, selectContent, createTime) values('%s','%d','%s','%s','%s') " % ( studentName, int(paperId), askContent, selectContent, createTime) 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) db2.commit() resp = do_response("success", "true", 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 create_bbs_comment(): print(request.data) data = json.loads(request.data) print(data) author = data['author'] bbsId = data['bbsId'] avatar = data['avatar'] content = data['content'] createTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") sql = 'insert into bbs_comment(bbsId,author,avatar, \ content,createTime ) values("%s","%s", "%s","%s", "%s")' \ % (bbsId,author,avatar,content,createTime ) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") db2.cursor().execute(sql) db2.commit() resp = do_response("success", "true", 200) db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def save_book(): print(request.data) data = json.loads(request.data) print(data) ebookId = data["ebookId"] username = data["username"] contentHtml = data["contentHtml"] createTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") updateTime = createTime sql_one = "select * from ebook_note where ebookId = %d \ and username = '******'" % (ebookId, username) sql_two = "update ebook_note set contentHtml = '%s' , updateTime = '%s' where \ ebookId = %d and username = '******' " % \ (contentHtml, updateTime, ebookId, username) sql_three = ''' insert into ebook_note(ebookId, username, contentHtml, createTime, updateTime) values(%d,"%s",'%s',"%s","%s")''' % ( ebookId, username, contentHtml, createTime, updateTime) try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() print(sql_one) cursor.execute(sql_one) all_data = cursor.fetchall() print("all", all_data) if len(all_data) < 1: print(sql_three) cursor.execute(sql_three) else: print(sql_two) cursor.execute(sql_two) db2.commit() resp = do_response("success", "true", 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 delete(): print(request.data) data = json.loads(request.data) print(data) className = data['className'] sql = 'delete from class_teacher where className = "%s"' % (className) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") db2.cursor().execute(sql) db2.commit() resp = do_response("success", "true", 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 create(): print(request.data) data = json.loads(request.data) print(data) teacherName = data['teacherName'] className = data['className'] description = data['description'] sql = 'insert into class_teacher(teacherName,className,description) values("%s","%s", "%s")' % (teacherName,className, description) print(sql) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") db2.cursor().execute(sql) db2.commit() resp = do_response("success", "true", 200) db2.close() except Exception as e: print(e) data = str(e) resp = do_response("error", data, 400) return make_response(resp, 200)
def publish_class(): print(request.data) data = json.loads(request.data) print(data) className = data["className"] askContent = data["askContent"] paperId = data["paperId"] selectContent = data["selectContent"] sql_one = "select studentName from class_student where className = '%s' and status = 1" % className try: db2 = pymysql.connect(host="localhost", user="******", password="******", db="ebook", port=3306, use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql_one) all_data = cursor.fetchall() print("all", all_data) createTime = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") cursor = db2.cursor() for item in all_data: studentName = item[0] sql = "insert into student_paper(studentName, paperId, \ askContent, selectContent, createTime, status) \ values('%s','%d','%s','%s','%s','0') " % \ (studentName, int(paperId), askContent, selectContent, createTime) print(sql) cursor.execute(sql) db2.commit() resp = do_response("success", "true", 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 join(): print(request.data) data = json.loads(request.data) print(data) className = data['className'] studentName = data['studentName'] status = data['status'] sql_one = 'select * from class_student where studentName = "%s" \ and className = "%s"' % (studentName, className) sql_two = 'insert into class_student(studentName,className,status) \ values("%s","%s", %d)' % (studentName,className, status) sql_three = 'update class_student set status = %d \ where studentName = "%s" \ and className = "%s"' % (status, studentName, className) try: db2 = pymysql.connect(host="localhost",user="******",password="******",db="ebook",port=3306,use_unicode=True, charset="utf8mb4") cursor = db2.cursor() cursor.execute(sql_one) print(sql_one) all_data = cursor.fetchall() print("all",all_data) if len(all_data) < 1: cursor.execute(sql_two) print(sql_two) else: cursor.execute(sql_three) print(sql_three) db2.commit() resp = do_response("success", "true", 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)