db_handler.py 文件源码

def getUserProgress(self, user, eval_set):
        """
        Returns user progress into eval_set, format:
            {
                "progress": 541
            }
        """
        try:
            cur = self.mysql.connection.cursor()
            cur.execute('SELECT COUNT(*) FROM evaluation '+
                        'WHERE eval_set=%s '+
                        'AND evaluator=%s', (eval_set, user))
            # COUNT(*) always returns a number, so no need for a try block here
            progress = cur.fetchone()[0]
        except MySQLError as e:
            msg = 'Error getting user progress.'
            log(msg + ' Eval_set: {}, user: {}'.format(eval_set, user), e)
            return (msg, 500)

        return (json.dumps(dict(progress=progress)), 200)