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