def getW2vRelated(web,mvid,loadtime='0',topnum=10,mtype=None,click=0):
vnInfos=[]
rows=tablemerge.getTitleByMVid(ctable,mvid)
if rows==-1 or len(rows)<1:
return vnInfos
title=rows[0][0]
records=w2vclient.getRelatedRecords2(title)
if records!=None and len(records)>0:
for item in records:
#0id,1webid,2vid,3title,4url,5thumb,6summary,7keywords,8newsid,9vtype,10source,
#11related,12loadtime,13duration,14web,15mvid,16mtype,17click
#2vid,3title,4url,5thumb,6brief,10source,12loadtime,13duration,14web,15mvid,16mtype,17click
# pass the same news
if item[15]==mvid:
continue
vnInfos.append(NewsInfo(item[2],item[3],item[4],item[5],item[6],item[10],
item[12],item[13],item[14],item[15],item[16],item[17]))
if len(vnInfos)>topnum:
return vnInfos[0:topnum]
return vnInfos
def getW2vRelated(newsid,ctime='0',topnum=10,mtype=None,click=0):
nInfos=[]
rows=tablemerge2.getRecordsByNewsid(mergetable2,newsid)
if rows==-1 or len(rows)<1:
return nInfos
title=rows[0][3]
print title
records=w2vclient.getRelatedRecords2(title)
if records!=None and len(records)>0:
for item in records:
#0id,1webid/mtid,2url,3title,4newsid,5thumb,6summary,7keywords,8ctime,9source,
#10author,11description,12mtype,13click/related
#4newsid,3title,2url,5thumb,6brief,9source,8ctime,10author,11description,12mtype,13click/related
# pass the same news
if item[4]==newsid:
continue
nInfos.append(NewsInfo(item[4],item[3],item[2],item[5],item[6],item[9],item[8],
item[10],item[11],item[12],[],0))
if len(nInfos)>topnum:
return nInfos[0:topnum]
return nInfos
