def trackUser(web,vid,userid,userip,mode): # web,vid,vtype,mvid,mtype,userid,userip,requesttime,click try: if mode in click_mod.values() and mode!=click_mod['auto']: tablemerge.increaseClick(web, vid) rows=tablemerge.getRecordsByWebVid(mergetable, web, vid) if rows !=-1 and len(rows)>0: title,vtype,mvid,mtype=rows[0] requesttime=timeformat.getTimeStamp() data=(web,vid,title,vtype,mvid,mtype,userid,userip,requesttime,mode) tablerequest.InsertItem(requesttable, data) except: logging.error('trackUser database visit error')
def getSearchedRelated(web,vid,loadtime='0',topnum=10,mtype=None,click=0): vnInfos=[] rows=tablemerge.getRecordsByWebVid(ctable,web,vid) if rows==-1 or len(rows)<1: return vnInfos title=rows[0][0] print title records=search.searchWithLimit(title,limit=topnum+1) if records!=None and len(records)>0: for item in records: if item['vid']==vid and item['web']==web: continue #vid,title,url,thumb,brief,source,loadtime,duration,web,mtype,click vnInfos.append(NewsInfo(item['vid'],item['title'],item['url'],item['thumb'],item['summary'], item['source'],item['loadtime'],item['duration'],item['web'], item['mtype'],item['click'])) if len(vnInfos)>topnum: return vnInfos[0:topnum] return vnInfos
def getRelatedRecords(web,vid,loadtime='0',topnum=10,mtype=None,click=0): vnInfos=[] rows=tablemerge.getRecordsByWebVid(ctable,web,vid) if rows==-1 or len(rows)<1: return vnInfos title=rows[0][0] records=related.getRelatedNewsList(title, 30,None,topnum+1) # topnum+1 to exclude the news itself if records!=None and len(records)>0: for item in records: #0id,1vid,2title,3url,4thumb,5summary,6keywords,7newsid,8vtype,9source,10related, #11loadtime,12duration,13web,14mvid,15mtype,16click #vid,title,url,thumb,brief,source,loadtime,duration,web,mtype,click # pass the same news if item[1]==vid and item[13]==web: continue vnInfos.append(NewsInfo(item[1],item[2],item[3],item[4],item[5],item[9],item[11], item[12],item[13],item[15],item[16])) if len(vnInfos)>topnum: return vnInfos[0:topnum] return vnInfos