def insert_teacher(teacher_id, name): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() sql = "insert into teacher(id,password,name) values(\ '%s','%s','%s')" % (teacher_id, teacher_id, name) cursor.execute(sql) db.commit() return True except: db.rollback() return False
def delete_course(course_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() sql = "delete from course where id = '%s'" % ( course_id) print(sql) cursor.execute(sql) db.commit() return True except: db.rollback() return False
def add_stu(stu_id,name,sex,birthdate,entrance_date,class_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() sql = "insert into student(id,password,name,sex,birthdate,entrance_date,class_id) values(\ '%s','%s','%s',%s,'%s','%s','%s')" % (stu_id,stu_id,name,sex,birthdate,entrance_date,class_id) print(sql) cursor.execute(sql) db.commit() return True except: db.rollback() return False
def update_stu(stu_id,name,sex,birthdate,entrance_date,class_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() sql = "update student set name = '%s', sex = %s, \ birthdate = '%s', entrance_date='%s', class_id = '%s'\ where id = '%s'" % (name,sex,birthdate,entrance_date,class_id,stu_id) print(sql) cursor.execute(sql) db.commit() return True except: db.rollback() return False
def get_adm_by_id(id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select * from admin where id= '%s'" % (id)) res = cursor.fetchall()[0] admin = { 'id': id, 'name': res[1], 'password': res[2], } return admin except IndexError as ie: print(ie) return None
def get_course_by_id(course_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select * from course where id= '%s'" % (course_id)) res = cursor.fetchall()[0] course = { 'id': course_id, 'name': res[1], 'credit': res[2], } return course except IndexError as ie: print(ie) return None
def get_tea_list(): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select id,name from teacher") res = cursor.fetchall() teacher_list = [] for row in res: teacher = {} teacher['id'] = row[0] teacher['name'] = row[1] teacher_list.append(teacher) return teacher_list except IndexError as ie: print(ie) return None
def get_class_list(): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select * from class") res = cursor.fetchall() class_list = [] for row in res: cl = {} cl['id'] = row[0] class_list.append(cl) db.commit() return class_list except: db.rollback() return None
def get_course_list(): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select id,name from course") res = cursor.fetchall() course_list = [] for row in res: course = {} course['id'] = row[0] course['name'] = row[1] course_list.append(course) return course_list except IndexError as ie: print(ie) return None
def get_seudent_course_bu_course_id(course_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute( "select * from student_course where course_id = '%s'" % (course_id)) res = cursor.fetchall() stu_course_list = [] for row in res: list_item = {} list_item['student_id'] = row[0] list_item['course_id'] = row[1] list_item['score'] = row[2] stu_course_list.append(list_item) db.commit() return stu_course_list except: db.rollback() return []
def get_stu_by_id(id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() cursor.execute("select * from student where id= '%s'" % (id)) res = cursor.fetchall()[0] student = { 'id': id, 'name': res[1], 'password': res[2], 'sex': res[3], 'birthdate': str(res[4]), 'entrance_date': str(res[5]), 'class_id': str(res[6]) } db.commit() return student except IndexError as ie: print(ie) return None
def get_tea_course_class_by_course_id(course_id): with app.app_context(): try: db = dbconnect.get_conn() cursor = db.cursor() sql = "select t.id,t.name,tcc.class_id from teacher_course_class tcc\ join teacher t on tcc.teacher_id = t.id\ where tcc.course_id = '%s'" % (course_id) cursor.execute(sql) res = cursor.fetchall() tea_course_list = [] for row in res: list_item = {} list_item['tea_id'] = row[0] list_item['tea_name'] = row[1] list_item['class_id'] = row[2] tea_course_list.append(list_item) db.commit() return tea_course_list except: db.rollback() return []
""" This script runs the URP_Server application using a development server. """ from os import environ from URP_Server import app from URP_Server.db import dbconnect if __name__ == '__main__': HOST = environ.get('SERVER_HOST', 'localhost') try: PORT = int(environ.get('SERVER_PORT', '5555')) except ValueError: PORT = 5555 with app.app_context(): dbconnect.get_conn() app.run(HOST, PORT, debug=True)