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