def getByContentTypeStatus(self,contentType,status,actionType=''): """ Get hyperlink queue item by content type and status param contentType param status """ try: if actionType: sql="SELECT opr_id,content_type,origin_id,provider_id,is_english,target_id,action_type,status,dc_status_code,dc_error_desc,upd_time,infiledate FROM %s where content_type='%s' and status=%s and action_type='%s';" % (HyperlinkQueueDAO.table,contentType,status,actionType) else: sql="SELECT opr_id,content_type,origin_id,provider_id,is_english,target_id,action_type,status,dc_status_code,dc_error_desc,upd_time,infiledate FROM %s where content_type='%s' and status=%s" % (HyperlinkQueueDAO.table,contentType,status) self.cursor_stg.execute(sql) for row in self.cursor_stg.fetchall(): queueItem=QueueItem() queueItem.id=row[0] queueItem.contentType=row[1] queueItem.originId=row[2] queueItem.providerId=row[3] queueItem.isEnglish=row[4] queueItem.targetId=row[5] queueItem.actionType=row[6] queueItem.status=row[7] queueItem.updTime=row[10] queueItem.infiledate=row[11] yield queueItem except Exception,e: self.log.error(e)
def getByStatus(self,status=Article.STATUS_WAIT_UPLOAD):
try:
self.cursor_stg.execute("SELECT opr_id,content_type,origin_id,provider_id,is_english,target_id,action_type,status,dc_status_code,dc_error_desc,upd_time,infiledate FROM %s where action_type in ('N','U','D') and status=%s order by content_type asc" % (HyperlinkQueueDAO.table,status))
for row in self.cursor_stg.fetchall():
queueItem=QueueItem()
queueItem.id=row[0]
queueItem.contentType=row[1]
queueItem.originId=row[2]
queueItem.providerId=row[3]
queueItem.isEnglish=row[4]
queueItem.targetId=row[5]
queueItem.actionType=row[6]
queueItem.status=row[7]
queueItem.updTime=row[10]
queueItem.infiledate=row[11]
yield queueItem
except Exception,e:
self.log.error(e)
def getByContentType(self,contentType=''):
try:
self.cursor_stg.execute("SELECT opr_id,content_type,origin_id,provider_id,is_english,target_id,action_type,status,dc_status_code,dc_error_desc,upd_time,infiledate FROM %s where status=1 and content_type='%s'" % (HyperlinkQueueDAO.table,contentType))
for row in self.cursor_stg.fetchall():
queueItem=QueueItem()
queueItem.id=row[0]
queueItem.contentType=row[1]
queueItem.originId=row[2]
queueItem.providerId=row[3]
queueItem.isEnglish=row[4]
queueItem.targetId=row[5]
queueItem.actionType=row[6]
queueItem.status=row[7]
queueItem.updTime=row[10]
queueItem.infiledate=row[11]
yield queueItem
except Exception,e:
self.log.error(e)
self.log.error("Error occured in getByContentType() of HyperlinkQueueDAO.py")
def getByTargetIdContentType(self,targetId,contentType,isEnglish='Y'): try: if targetId and contentType and isEnglish: sql="SELECT opr_id,content_type,origin_id,provider_id,is_english,target_id,action_type,status,\ dc_status_code,dc_error_desc,upd_time,infiledate FROM %s \ where target_id=%s and content_type='%s' and is_english='%s';" \ % (HyperlinkQueueDAO.table,targetId,contentType,isEnglish) self.cursor_stg.execute(sql) row=self.cursor_stg.fetchone() if row: queueItem=QueueItem() queueItem.id=row[0] queueItem.contentType=row[1] queueItem.originId=row[2] queueItem.providerId=row[3] queueItem.isEnglish=row[4] queueItem.targetId=row[5] queueItem.actionType=row[6] queueItem.status=row[7] queueItem.updTime=row[10] queueItem.infiledate=row[11] return queueItem except Exception,e: self.log.error(e)