def create_question(question, instructor, course, time): if not isinstance(time, (int, long)): time = 0 session.add(Question(instructor, course, question, False, time)) session.commit() return render_template('handleQuestion.html',question=question)
def add_list(list): for a_id, u_id in list: if session.query(Schedule).filter(Schedule.answer_id == a_id, Schedule.user_id == u_id).first() is None: session.add(Schedule(a_id, u_id)) session.commit()
def process(self): userid = g.lti.get_user_id() try: answer0 = int(request.values['answerzero']) answer1 = int(request.values['answerone']) bestanswer = int(request.values['bestanswer']) except KeyError: return abort(404) except ValueError: return abort(404) if answer0 == bestanswer: best = answer0 other = answer1 elif answer1 == bestanswer: best = answer1 other = answer0 else: return abort(404) #try: session.add(AnswerChoiceModel(userid,best,other)) session.commit() #except: # session.rollback() return redirect('/')
def save(questionID, userID, answerText): try: ranking = ((session.query(UserModel).filter_by(userid=userID).one().trust - 1000.0) / 4) + 1000.0 except exc.InvalidRequestError: ranking = 1000.0 session.add(AnswerModel(questionID=questionID, userID=userID, text=answerText, edit=0, ranking=ranking)) session.commit()
def edit_question(q_id, question, time): """Updates a question with given contents and activation status.""" if g.lti.is_instructor(): if question is None: escaped_question = None else: escaped_question = escape(question) escaped_time = escape(time) q = Question.by_id(q_id) q.question = escaped_question q.time = int(time) activate = q.answerable session.add(q) session.commit() return json.dumps({"id": q_id, "text": escaped_question, "answerable": activate, "time":time, "check": g.lti.is_instructor()}) else: return json.dumps({"id": q_id, "text": question, "answerable": activate, "time": time, "check": g.lti.is_instructor()})
def add_tag(name): if session.query(Tag.name).filter(Tag.name == name).first() is None: tag = Tag(name) session.add(tag) session.commit() return tag.id else: return False
def create_question(question, instructor, course, active, time, comment, tags, rating): '''formats a question for database insertion and inserts it, calls a result screen afterwards''' try: time = int(time) except ValueError: time = 0 session.add(Question(instructor, course, question, active, time, comment, tags, rating)) session.commit()
def save(uid,uname): user = UserModel.by_user_id(uid) if user is None: session.add(UserModel(userid=uid,username=uname)) session.commit() elif user.username != uname: user.username = uname session.commit()
def setTrust(uID, trust): # set current trust (in usermodel) user = session.query(UserModel).filter_by(userid=uID).one() user.trust = trust # fetch last known history record old = UserHistoryModel.get_user_latest_data(uID) # create a new trust entry in userhistory history = UserHistoryModel(uID, trust, old.answered, old.asked) session.add(history) session.commit()
def create_question(question, instructor, course, active, time, comment, tags, rating): '''Formats a question for database insertion and inserts it, calls a result screen afterwards. Returns the id of the added question.''' try: time = int(time) except ValueError: time = 0 q = Question(instructor, course, question, active, time, comment, tags, rating) session.add(q) session.commit() return q.id
def calc_new_trust(self): print "GET HERE " winner = AnswerModel.get_by_answer_id(self.best_answer_id) loser = AnswerModel.get_by_answer_id(self.other_answer_id) winner_h = UserHistoryModel.get_by_user_id(winner.userID) loser_h = UserHistoryModel.get_by_user_id(loser.userID) new_trust = UserModel.newTrust(winner.userID, loser.userID) #UserHistoryModel(winner.userID, new_trust[0], winner_h.answered, winner_h.asked) #UserHistoryModel(loser.userID, new_trust[1], loser_h.answered, loser_h.asked) session.add(UserHistoryModel(winner.userID, new_trust[0], 17, 22)) session.commit() session.add(UserHistoryModel(loser.userID, new_trust[1], 17, 25)) session.commit()
def save(uid,uname): user = UserModel.by_user_id(uid) if user is None: # add user to UserModel tmp = UserModel(userid=uid,username=uname) tmp.trust = 1000.0 session.add(tmp) session.commit() # add user's first entry to UserHistoryModel history = UserHistoryModel(uid, 1000.0, 0, 0) session.add(history) session.commit() elif user.username != uname: user.username = uname session.commit()
def add_q_stats(uid, qid): answered = (session.query(AnswerModel).filter_by(userID=uid, questionID=qid)).one() recorded = (session.query(UserHistoryModel).filter_by(userid=uid, source_id=qid)).first() if (recorded != None): boole = recorded.qanswered thing = UserHistoryModel.get_user_latest_data(uid) # in case the question was immediately answered if (answered != None) and (recorded == None): thing = UserHistoryModel.get_user_latest_data(uid) thing.asked = thing.asked + 1 thing.answered = thing.answered + 1 thing.qanswered = True session.add(UserHistoryModel(thing.userid, thing.trust, thing.answered, thing.asked)) session.commit # in case the question was not answered at all elif (answered == None) and (recorded == None): thing = UserHistoryModel.get_user_latest_data(uid) thing.asked = thing.asked + 1 #thing.answered = thing.answered + 0 thing.qanswered = False session.add(UserHistoryModel(thing.userid, thing.trust, thing.answered, thing.asked)) session.commit # in case the question was previously asked, but only answered after unlocking it elif (answered != None) and (recorded != None) and not (boole): thing = UserHistoryModel.get_user_latest_data(uid) #thing.asked = thing.asked + 0 thing.answered = thing.answered + 1 thing.qanswered = True session.add(UserHistoryModel(thing.userid, thing.trust, thing.answered, thing.asked)) session.commit
def __init__(self): # create a few database items for model in session.query(Question): break else: session.add(Question("1","What am I?",True)) session.add(Question("1","Who am I?",True)) session.add(Question("1","Where am I?",True)) session.commit()
def add_answerrating(aid, rid): if session.query(AnswerRating).filter( AnswerRating.answer_id==aid, AnswerRating.rating_id==rid).first() is None: session.add(AnswerRating(aid, rid))
def inactive(self, value): self._inactive = value session.add(self) session.commit()
def __init__(self, request): # lele add dummy questions le if len(Question.get_all()) == 0: print "I MAEK DUMMY SHIZZLE" userID = g.lti.get_user_id() q1 = Question("1","1","What am I?",True,1000) q2 = Question("2","1","Who am I?",True,1000) q3 = Question("3","1","Where am I?",True,1000) session.add(q1) session.add(q2) session.add(q3) a11 = AnswerModel("einseins",1,userID,0,1000.0) a12 = AnswerModel("einszwei",1,1338, 0,1000.0) a13 = AnswerModel("einsdrei",1,1339, 0,1000.0) a21 = AnswerModel("zweieins",2,userID,0,1000.0) a22 = AnswerModel("zweizwei",2,1338, 0,1000.0) a23 = AnswerModel("zweidrei",2,1339, 0,1000.0) a31 = AnswerModel("dreieins",3,userID,0,1000.0) a32 = AnswerModel("dreizwei",3,1338, 0,1000.0) a33 = AnswerModel("dreidrei",3,1339, 0,1000.0) session.add(a11) session.add(a12) session.add(a13) session.add(a21) session.add(a22) session.add(a23) session.add(a31) session.add(a32) session.add(a33) session.commit()
def submit_rating(rating): session.add(Rating(rating)) session.commit()
def save(questionID, userID, answerText): session.add(AnswerModel( questionID=questionID, userID=userID, text=answerText, edit=0)) session.commit()
def savereview(questionID, userID, answerText, edit): session.add(AnswerModel(questionID=questionID, userID=userID, text=answerText, edit=edit + 1)) session.commit()
def add(answer_id, user_id): if session.query(Schedule).filter(Schedule.answer_id == answer_id, Schedule.user_id == user_id).first() is None: session.add(Schedule(answer_id, user_id)) session.commit()
def archived(self, value): self._archived = value session.add(self) session.commit()
def add_tag(name): if session.query(Tag.name).filter(Tag.name == name).first() is None: session.add(Tag(name)) session.commit()
def add_answertag(aid, tid): if session.query(AnswerTag).filter( AnswerTag.answer_id==aid, AnswerTag.tag_id==tid).first() is None: session.add(AnswerTag(aid, tid)) session.commit()
def closed(self, value): self._closed = value session.add(self) session.commit()
def reviewable(self, value): self._reviewable = value session.add(self) session.commit()
def answerable(self, value): self._answerable = value session.add(self) session.commit()
def add(cls, user_id, text): session.add(cls(user_id, text)) session.commit()
def add(answer_id, user_id, rating, text): if session.query(Review).filter(Review.answer_id == answer_id, Review.user_id == user_id).first() is None: session.add(Review(answer_id, user_id, rating, text)) session.commit()