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
