def insertUser(tel, password, username):
result = 1
try:
if selectUserByTel(tel) is None:
session = DBSession()
signTime = datetime.datetime.now()
iconUrl = '/static/userImg/usertile' + str(random.randint(
10, 44)) + '.jpg'
edUser = User(tel=tel,
password=password,
username=username,
signTime=signTime,
iconUrl=iconUrl,
checkTime=signTime)
session.add(edUser)
else:
result = 2
return result
except Exception:
session.rollback()
raise
else:
session.commit()
result = 0
session.close()
return result
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 insertSportPlan(userId, sport1, sport2, sport3, sport4, time1, time2,
time3, time4, week1, week2, week3, week4):
sportTime = datetime.datetime.now()
edSportPlan = SportPlan(userId=userId,
sport1=sport1,
sport2=sport2,
sport3=sport3,
sport4=sport4,
time1=time1,
time2=time2,
time3=time3,
time4=time4,
week1=week1,
week2=week2,
week3=week3,
week4=week4,
sportTime=sportTime)
effect_row = 0
try:
session = DBSession()
session.add(edSportPlan)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
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 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 insertTopic(userId, content, picture1, picture2, picture3, picture4,
picture5):
topicTime = datetime.datetime.now()
lastTime = datetime.datetime.now()
edTopic = Topic(content=content,
topicTime=topicTime,
userId=userId,
lastTime=lastTime,
picture1=picture1,
picture2=picture2,
picture3=picture3,
picture4=picture4,
picture5=picture5,
likes=0,
replyNum=0,
comNum=0)
effect_row = 0
try:
session = DBSession()
session.add(edTopic)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertArticle(title, content, labelOne, labelTwo, labelThree, labelFour,
labelFive, imgId):
session = DBSession()
articleTime = datetime.datetime.now()
edArticle = Article(title=title,
content=content,
articleTime=articleTime,
labelOne=labelOne,
labelTwo=labelTwo,
labelThree=labelThree,
labelFour=labelFour,
labelFive=labelFive,
imgId=imgId,
views=0,
comNumber=0)
effect_row = 0
try:
session.add(edArticle)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
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 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 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 insertFollow(userId, followId):
edFollow = Follow(userId=userId, followId=followId)
effect_row = 0
try:
session = DBSession()
session.add(edFollow)
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
effect_row = 1
return effect_row
def insertGBlood(userId, level, bloodTime, bloodDate):
edBlood = Blood(userId=userId, level=level, bloodTime=bloodTime, bloodDate=bloodDate)
effect_row = 0
try:
session = DBSession()
session.add(edBlood)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertFavoriteArticle(userId, articleId):
edFavorite = FavoriteArticle(userId=userId, articleId=articleId)
effect_row = 0
try:
session = DBSession()
session.add(edFavorite)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertFamily(userId, tel, nickname):
edFamily = Family(userId=userId, tel=tel, nickname=nickname)
effect_row = 0
try:
session = DBSession()
session.add(edFamily)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def updateLikes(topicId, likes):
try:
session = DBSession()
topic = session.query(Topic).filter(Topic.topicId == topicId).first()
if topic is None:
return 0
else:
topic.likes = topic.likes + likes
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def insertSubReply(userId, replyId, content):
effect_raw = 0
try:
session = DBSession()
subreplyTime = datetime.datetime.now()
adSubReply = SubReply(content=content, subreplyTime=subreplyTime, replyId=replyId, userId=userId, likes=0)
session.add(adSubReply)
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
effect_raw = 1
return effect_raw
def updateTopicLastTime(topicId):
try:
session = DBSession()
topic = session.query(Topic).filter(Topic.topicId == topicId).first()
if topic is None:
return 0
else:
topic.lastTime = datetime.datetime.now()
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def updateLikes(replyId, likes):
try:
session = DBSession()
reply = session.query(Reply).filter(Reply.replyId == replyId).first()
if reply is None:
return 0
else:
reply.likes = reply.likes + likes
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def updateLikes(commentId, isLike):
try:
session = DBSession()
comment = session.query(Comment).filter(
Comment.commentId == commentId).first()
if comment is None:
return 0
else:
comment.likes = comment.likes + isLike
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def updateUserPassword(tel, password):
try:
session = DBSession()
user = session.query(User).filter(User.tel == tel).first()
if user is None:
effect_raw = 0
else:
effect_raw = 1
user.password = password
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def updateUserIntegral(userId, integral):
try:
session = DBSession()
user = session.query(User).filter(User.userId == userId).first()
if user is None:
effect_raw = 0
else:
effect_raw = 1
user.integral = user.integral + integral
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
def updateComNumber(replyId, num):
try:
session = DBSession()
reply = session.query(Reply).filter(Reply.replyId == replyId).first()
if reply is None:
return 0
else:
reply.comNumber = reply.comNumber + num
if reply.comNumber < 0:
reply.comNumber = 0
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def updateComnumber(topicId, num):
try:
session = DBSession()
topic = session.query(Topic).filter(Topic.topicId == topicId).first()
if topic is None:
return 0
else:
topic.comNum = topic.comNum + num
if topic.comNum < 0:
topic.comNum = 0
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return 1
def updateCheckTime(userId):
checkTime = datetime.datetime.now()
try:
session = DBSession()
user = session.query(User).filter(User.userId == userId).first()
if user is None:
effect_raw = 0
else:
effect_raw = 1
user.checkTime = checkTime
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
return effect_raw
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 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 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 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 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 insertComment(content, userId, articleId):
effect_raw = 0
try:
session = DBSession()
commentTime = datetime.datetime.now()
adComment = Comment(content=content,
userId=userId,
articleId=articleId,
commentTime=commentTime)
session.add(adComment)
except Exception:
session.rollback()
raise
else:
session.commit()
session.close()
effect_raw = 1
return effect_raw
