Exemplo n.º 1
0
	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)
Exemplo n.º 2
0
	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)
Exemplo n.º 3
0
	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")
Exemplo n.º 4
0
	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)