def updateTeacher(id, username, password, xm, gender, qq, email, address, phone): try: result = session.query( model.Teacher).filter(model.Teacher.id == id).update( json.loads( model.fjson(username=username, password=password, xm=xm, gender=gender, qq=qq, email=email, address=address, phone=phone).f2)) session.commit() model.collection1.update_many( json.loads(model.fjson(userid=id).f10), {'$set': json.loads(model.fjson(xm=xm).f8)}) model.content.update_many(json.loads(model.fjson(userid=id).f10), {'$set': json.loads(model.fjson(xm=xm).f8)}) return result except Exception as e: print(e) finally: session.close()
def updateContent(_id, content, userid): try: xm = checkTeacher1(userid).xm model.content.update_one( json_util.loads(model.fjson(_id=_id).f4), { '$set': json.loads( model.fjson(content=content, userid=userid, xm=xm).f9) }) except Exception as e: print(e)
def deleteTeacher(userid): try: session.query( model.Teacher).filter(model.Teacher.id == userid).delete() session.commit() model.content.delete_many(json.loads(model.fjson(userid=userid).f10)) model.collection1.delete_many( json.loads(model.fjson(userid=userid).f10)) except Exception as e: print(e) finally: session.close()
def addContent(content, userid): try: xm = checkTeacher1(userid).xm model.content.insert( json.loads(model.fjson(content=content, userid=userid, xm=xm).f9)) except Exception as e: print(e)
def checkTeacherFinance2(id): try: result = model.collection1.find(json.loads(model.fjson(userid=id).f10)) if result: return result else: return None except Exception as e: print(e)
def deleteUser(userid): try: session.query(model.User).filter(model.User.id == userid).delete() session.commit() model.collection.delete_many(json.dumps(model.fjson(userid=userid).f1)) except Exception as e: print(e) finally: session.close()
def checkTeacherFinance1(id): try: result = model.collection1.find_one( json_util.loads(model.fjson(_id=id).f4)) if result: return result else: return None except Exception as e: print(e)
def checkContent1(_id): try: result = model.content.find_one( json_util.loads(model.fjson(_id=_id).f4)) if result: return result else: return None except Exception as e: print(e)
def updateUserFinance(_id, user_xuefei, user_shufei, user_zhusufei, user_sum, user_zhifu, user_qian, userid): try: xm = checkUser1(userid).xm model.collection.update_one( json_util.loads(model.fjson(_id=_id).f4), { '$set': json.loads( model.fjson(user_xuefei=user_xuefei, user_shufei=user_shufei, user_zhusufei=user_zhusufei, user_sum=user_sum, user_zhifu=user_zhifu, user_qian=user_qian, userid=userid, xm=xm).f3) }) except Exception as e: print(e)
def updateTeacherFinance(_id, t_wages, t_subsidy, t_allowance, t_tax, t_sum, t_data, userid): try: xm = checkTeacher1(userid).xm model.collection1.update_one( json_util.loads(model.fjson(_id=_id).f4), { '$set': json.loads( model.fjson(t_wages=t_wages, t_subsidy=t_subsidy, t_allowance=t_allowance, t_tax=t_tax, t_sum=t_sum, t_data=t_data, userid=userid, xm=xm).f11) }) except Exception as e: print(e)
def updateUserpassword(id, password): try: result = session.query(model.User).filter(model.User.id == id).update( json.loads(model.fjson(password=password).f6)) session.commit() return result except Exception as e: print(e) finally: session.close()
def updateuser1(id, xm, gender, qq, email, address, phone): try: result = session.query(model.User).filter(model.User.id == id).update( json.loads( model.fjson(xm=xm, gender=gender, qq=qq, email=email, address=address, phone=phone).f7)) session.commit() model.collection.update_many( json.dumps(model.fjson(userid=id).f1), {'$set': json.loads(model.fjson(xm=xm).f8)}) return result except Exception as e: print(e) finally: session.close()
def checkContent4(id): try: result = model.content.find(json.loads( model.fjson(userid=id).f10)).sort([("_id", pymongo.DESCENDING)]) if result: return result else: return None except Exception as e: print(e)
def updateUserLeavingschool(id, user_liyou): try: result = session.query( model.Leavingschool).filter(model.Leavingschool.id == id).update( json.loads(model.fjson(user_liyou=user_liyou).f52)) session.commit() return result except Exception as e: print(e) finally: session.close()
def updateLeavingschoo2(id, radio): try: result = session.query( model.Leavingschool).filter(model.Leavingschool.id == id).update( json.loads(model.fjson(gender=radio).f51)) session.commit() return result except Exception as e: print(e) finally: session.close()
def addUserFinance(user_xuefei, user_shufei, user_zhusufei, user_sum, user_zhifu, user_qian, userid): try: xm = checkUser1(userid).xm model.collection.insert( json.loads( model.fjson(user_xuefei=user_xuefei, user_shufei=user_shufei, user_zhusufei=user_zhusufei, user_sum=user_sum, user_zhifu=user_zhifu, user_qian=user_qian, userid=userid, xm=xm).f3)) except Exception as e: print(e)
def addTeacherFinance(t_wages, t_subsidy, t_allowance, t_tax, t_sum, t_data, userid): try: xm = checkTeacher1(userid).xm model.collection1.insert( json.loads( model.fjson(t_wages=t_wages, t_subsidy=t_subsidy, t_allowance=t_allowance, t_tax=t_tax, t_sum=t_sum, t_data=t_data, userid=userid, xm=xm).f11)) except Exception as e: print(e)
def updateLeavingschool(id, user_liyou, radio, userid): try: xm = checkUser1(userid).xm tid = checkUser1(userid).tid result = session.query( model.Leavingschool).filter(model.Leavingschool.id == id).update( json.loads( model.fjson(xm=xm, user_liyou=user_liyou, gender=radio, userid=userid, tid=tid).f5)) session.commit() return result except Exception as e: print(e) finally: session.close()
def deleteContent(_id): try: model.content.delete_one(json_util.loads(model.fjson(_id=_id).f4)) except Exception as e: print(e)
def deleteTeacherFinance(_id): try: model.collection1.delete_one(json_util.loads(model.fjson(_id=_id).f4)) except Exception as e: print(e)