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)
