def updateBloodbeforeBF(userId, bLevel, bTime, bIndex, bloodDate):
effect_raw = 0
try:
session = DBSession()
blood = session.query(Blood).filter(Blood.userId == userId, Blood.bloodDate == bloodDate).first()
if blood is None:
level = {'0': '0', '1': '0', '2': '0', '3': '0', '4': '0', '5': '0', '6': '0'}
bloodTime = {'0': '0', '1': '0', '2': '0', '3': '0', '4': '0', '5': '0', '6': '0'}
level[bIndex] = bLevel
bloodTime[bIndex] = bTime
effect_raw = insertGBlood(userId, json.dumps(level), json.dumps(bloodTime), bloodDate)
else:
level = json.loads(blood.level)
bloodTime = json.loads(blood.bloodTime)
level[bIndex] = bLevel
bloodTime[bIndex] = bTime
blood.level = json.dumps(level)
blood.bloodTime = json.dumps(bloodTime)
effect_raw = 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def selectUserByUserId(userId):
try:
session = DBSession()
user = session.query(User).filter(User.userId == userId).first()
if user is None:
result = None
else:
result = {
'tel': user.tel,
'username': user.username,
'gender': user.gender,
'age': user.age,
'height': user.height,
'weight': user.weight,
'area': user.area,
'job': user.job,
'iconUrl': user.iconUrl,
'integral': user.integral,
}
except Exception:
raise
else:
session.close()
return result
def updateUser(userId, username, gender, age, height, weight, area, job):
try:
session = DBSession()
user = session.query(User).filter(User.userId == userId).first()
if user is None:
effect_raw = 0
else:
effect_raw = 1
user.username = username
user.gender = gender
user.age = age
user.height = height
user.weight = weight
user.area = area
user.job = job
'''
session.query(User).filter(User.userId == userId).update(
{
User.username: username,
User.gender: gender,
User.age: age
}, synchronize_session=False)
'''
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def updateDietPlan(userId, change, cereals, fruit, meat, milk, fat,
vegetables):
try:
session = DBSession()
dietPlan = session.query(DietPlan).filter(
DietPlan.userId == userId).first()
if dietPlan is None:
effect_row = insertDietPlan(userId, change, cereals, fruit, meat,
milk, fat, vegetables)
if effect_row == 1:
result = 1
else:
result = 0
else:
dietPlan.change = change
dietPlan.cereals = cereals
dietPlan.fruit = fruit
dietPlan.meat = meat
dietPlan.milk = milk
dietPlan.fat = fat
dietPlan.vegetables = vegetables
dietPlan.dietTime = datetime.datetime.now()
result = 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return result
def updateUserPrivacy(userId, isTel, isGender, isAge, isHeight, isWeight,
isArea, isJob, isIntegral):
try:
session = DBSession()
userPrivacy = session.query(UserPrivacy).filter(
UserPrivacy.userId == userId).first()
if userPrivacy is None:
effect_raw = 0
else:
userPrivacy.isTel = isTel
userPrivacy.isGender = isGender
userPrivacy.isAge = isAge
userPrivacy.isHeight = isHeight
userPrivacy.isWeight = isWeight
userPrivacy.isArea = isArea
userPrivacy.isJob = isJob
userPrivacy.isIntegral = isIntegral
effect_raw = 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def updateControlPlan(userId, min1, max1, min2, max2, sleep1, sleep2):
try:
session = DBSession()
controlPlan = session.query(ControlPlan).filter(
ControlPlan.userId == userId).first()
if controlPlan is None:
effect_row = insertControlPlan(userId, min1, max1, min2, max2,
sleep1, sleep2)
session.close()
if effect_row == 1:
result = 1
else:
result = 0
else:
controlPlan.min1 = min1
controlPlan.max1 = max1
controlPlan.min2 = min2
controlPlan.max2 = max2
controlPlan.sleep1 = sleep1
controlPlan.sleep2 = sleep2
controlPlan.controlTime = datetime.datetime.now()
result = 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def deleteUser(userId):
try:
session = DBSession()
user = session.query(User).filter(User.userId == userId).first()
if user is None:
effect_raw = 0
else:
effect_raw = 1
session.query(User).filter(User.userId == userId).delete()
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def deleteSubReply(subreplyId):
effect_raw = 0
try:
session = DBSession()
subreply = session.query(SubReply).filter(SubReply.subreplyId == subreplyId).first()
if subreply is None:
effect_raw = 0
return effect_raw
else:
session.query(SubReply).filter_by(subreplyId=subreplyId).delete()
effect_raw = 1
except:
session.rollback()
effect_raw = 0
else:
session.commit()
session.close()
return effect_raw
def selectSumHealth(userId):
try:
session = DBSession()
result = session.query(Health).filter(Health.userId == userId).count()
except Exception:
raise
else:
session.close()
return result
def deleteFollow(userId, followId):
try:
session = DBSession()
follow = session.query(Follow).filter(
Follow.userId == userId, Follow.followId == followId).first()
if follow is None:
effect_raw = 0
else:
effect_raw = 1
session.query(Follow).filter(Follow.userId == userId,
Follow.followId == followId).delete()
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def selectSumBlood(userId):
try:
session = DBSession()
result = session.query(Blood).filter(Blood.userId == userId).count()
except Exception:
raise
else:
session.close()
return result
def deleteArticle(articleId):
try:
session = DBSession()
article = session.query(Article).filter(
Article.articleId == articleId).first()
if article is None:
effect_raw = 0
else:
effect_raw = 1
session.query(Article).filter(
Article.articleId == articleId).delete()
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def deleteTopic(topicId):
effect_raw = 0
try:
session = DBSession()
topic = session.query(Topic).filter(Topic.topicId == topicId).first()
if topic is None:
effect_raw = 0
return effect_raw
else:
session.query(Topic).filter_by(topicId=topicId).delete()
effect_raw = 1
except:
session.rollback()
effect_raw = 0
else:
session.commit()
session.close()
return effect_raw
def selectSumFamily(userId):
try:
session = DBSession()
result = session.query(Family).filter(Family.userId == userId).count()
except Exception:
raise
else:
session.close()
return result
def deleteFamily(familyId, userId):
effect_raw = 0
try:
session = DBSession()
family = session.query(Family).filter(Family.familyId == familyId,
Family.userId == userId).first()
if family is None:
effect_raw = 0
else:
session.query(Family).filter(Family.familyId == familyId,
Family.userId == userId).delete()
effect_raw = 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def selectSumTopicLikeContent(content):
try:
session = DBSession()
result = session.query(Topic).filter(
Topic.content.like('%' + content + '%')).count()
except Exception:
raise
else:
session.close()
return result
def selectSumReplyByUserId(userId):
result = 0
try:
session = DBSession()
result = session.query(Reply).filter(Reply.userId == userId).count()
except Exception:
raise
else:
session.close()
return result
def selectSumArticle():
result = 0
try:
session = DBSession()
result = session.query(Article).count()
except Exception:
raise
else:
session.close()
return result
def selectSumSubReply():
result = 0
try:
session = DBSession()
result = session.query(SubReply).count()
except Exception:
raise
else:
session.close()
return result
def deleteComment(commentId):
effect_raw = 0
try:
session = DBSession()
comment = session.query(Comment).filter(
Comment.commentId == commentId).first()
if comment is None:
effect_raw = 0
return effect_raw
else:
session.query(Comment).filter_by(commentId=commentId).delete()
except:
session.rollback()
effect_raw = 0
else:
effect_raw = 1
session.commit()
session.close()
return effect_raw
def selectSumSubReplyByReplyId(replyId):
result = 0
try:
session = DBSession()
result = session.query(SubReply).filter(SubReply.replyId == replyId).count()
except Exception:
raise
else:
session.close()
return result
def selectSumCommentByArticleId(articleId):
result = 0
try:
session = DBSession()
result = session.query(Comment).filter(
Comment.articleId == articleId).count()
except Exception:
raise
else:
session.close()
return result
def deleteFavoriteTopic(userId, topicId):
try:
session = DBSession()
topic = session.query(FavoriteTopic).filter(
FavoriteTopic.userId == userId,
FavoriteTopic.topicId == topicId).first()
if topic is None:
effect_raw = 0
else:
effect_raw = 1
session.query(FavoriteTopic).filter(
FavoriteTopic.userId == userId,
FavoriteTopic.topicId == topicId).delete()
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def selectSumTopicByTopicId(topicId):
try:
session = DBSession()
result = session.query(FavoriteTopic).filter(
FavoriteTopic.topicId == topicId).count()
except Exception:
session.rollback()
raise
else:
session.close()
return result
def selectFromXGetNTopic(x, n):
try:
session = DBSession()
offset = x
num = x + n
topic = session.query(Topic).slice(offset, num).all()
except Exception:
raise
else:
session.close()
return topic
def selectSumFollowByFollowId(userId):
result = 0
try:
session = DBSession()
result = session.query(Follow).filter(
Follow.followId == userId).count()
except Exception:
raise
else:
session.close()
return result
def selectFromXGetNUser(x, n):
try:
session = DBSession()
offset = x
num = x + n
user = session.query(User).slice(offset, num).all()
except Exception:
raise
else:
session.close()
return user
def selectSumFavoriteArticleByUserId(userId):
result = 0
try:
session = DBSession()
result = session.query(FavoriteArticle).filter(
FavoriteArticle.userId == userId).count()
except Exception:
raise
else:
session.close()
return result
def updateArticleComNumber(articleId):
try:
session = DBSession()
article = session.query(Article).filter(
Article.articleId == articleId).first()
article.comNumber = article.comNumber + 1
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
def selectReplyByReplyId(replyId):
try:
session = DBSession()
reply = session.query(Reply).filter(Reply.replyId == replyId).first()
if reply is None:
result = None
else:
result = reply
except Exception:
raise
else:
session.close()
return result
