def getLikeStatus(cls,jokeid,userid): db = getDB() sql = 'select type from article_like where article_id = %s and userid=%s and article_type=%s' ret= db.query_tuple_row(sql,jokeid,userid,JOKE_TYPE) if not ret or int(ret[0]) != 1: return False else: return True
def getUserByUserid(cls,userid): db = getDB() sql = 'select userid, email, password from user where userid=%s' ret = {} try: ret = db.query_dict_row(sql,userid) ret = User(ret) except Exception,e: logging.warn('in getUserByEmail %s', e)
def registerByEmail(cls,email,password): db = getDB() sql = 'insert into user(email,password,ctime,utime) values(%s,%s,%s,%s)' ret = '' try: db.insert(sql,email,password,int(time.time()),int(time.time())) except Exception,e: logging.info('register error: %s',e) ret = '该email已经被注册过了'
def likeJoke(cls, jokeid, userid): db = getDB() sql = 'select type from article_like where userid=%s and article_id = %s and article_type=%s' type = db.query_tuple_row(sql, userid, jokeid, JOKE_TYPE) if type and type[0] <= 0: newType = -1 else: newType = 1 sql = 'insert article_like (userid,article_id,article_type,type,ctime,utime) values (%s,%s,%s,%s,UNIX_TIMESTAMP(),UNIX_TIMESTAMP()) on duplicate key update type=%s,utime=UNIX_TIMESTAMP()' db.insert(sql, userid, jokeid, JOKE_TYPE, newType, newType) if not type and newType == 1: sql = 'update joke set like_number = like_number + %s where id = %s' ret = db.update(sql, newType, jokeid) else: sql = 'update joke set like_number= like_number + %s where id = %s' ret = db.update(sql, newType, jokeid) return (True,newType)
def getRandomJoke(cls, seed): db = getDB() sql = 'select * from joke where rand() < %s order by id desc limit 1' joke = db.query_dict_row(sql, seed) return joke
def getJoke(cls, id): db = getDB() sql = 'select * from joke where id = %s' joke = db.query_dict_row(sql, id) return joke
def getTotal(cls): db = getDB() sql = 'select count(1) from joke' return db.query_tuple_row(sql)[0]
def getLatestJokesList(cls, steps): db = getDB() sql = 'select * from joke order by id desc limit %s' jokes = db.query_dict(sql, steps)() return jokes
def getJokesList(cls, begin, limit): db = getDB() sql = 'select * from joke WHERE id < %s order by id desc limit %s' jokes = db.query_dict(sql, begin, limit)() return jokes