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 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 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 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 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 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 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 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 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
def insertHealth(userId, insulin, sportTime, weight, bloodPressure, healthTime,
healthDate):
edHealth = Health(userId=userId,
insulin=insulin,
sportTime=sportTime,
weight=weight,
bloodPressure=bloodPressure,
healthTime=healthTime,
healthDate=healthDate)
effect_row = 0
try:
session = DBSession()
session.add(edHealth)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertUserPrivacy(userId):
adUserPrivacy = UserPrivacy(userId=userId,
isTel=1,
isGender=1,
isAge=1,
isHeight=1,
isWeight=1,
isArea=1,
isJob=1,
isIntegral=1)
effect_raw = 0
try:
session = DBSession()
session.add(adUserPrivacy)
except Exception:
session.rollback()
raise
else:
effect_raw = 1
session.commit()
session.close()
return effect_raw
def insertControlPlan(userId, min1, max1, min2, max2, sleep1, sleep2):
controlTime = datetime.datetime.now()
edControlPlan = ControlPlan(userId=userId,
min1=min1,
max1=max1,
min2=min2,
max2=max2,
sleep1=sleep1,
sleep2=sleep2,
controlTime=controlTime)
effect_row = 0
try:
session = DBSession()
session.add(edControlPlan)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertDietPlan(userId, change, cereals, fruit, meat, milk, fat,
vegetables):
dietTime = datetime.datetime.now()
edDeitPlan = DietPlan(userId=userId,
change=change,
cereals=cereals,
fruit=fruit,
meat=meat,
milk=milk,
fat=fat,
vegetables=vegetables,
dietTime=dietTime)
effect_row = 0
try:
session = DBSession()
session.add(edDeitPlan)
except Exception:
session.rollback()
raise
else:
session.commit()
effect_row = 1
session.close()
return effect_row
def insertReply(userId, topicId, content, picture1, picture2, picture3,
picture4, picture5):
replyTime = datetime.datetime.now()
result = selectFloorByTopicId(topicId)
i = len(result)
if i == 0:
floor = 1
else:
reply = result[i - 1]
floor = reply.floor + 1
edTopic = Reply(content=content,
replyTime=replyTime,
userId=userId,
topicId=topicId,
comNumber=0,
floor=floor,
likes=0,
isRemove=0,
picture1=picture1,
picture2=picture2,
picture3=picture3,
picture4=picture4,
picture5=picture5)
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
