def getByOrigin(self,originId,providerId,isEnglish):
		if originId and providerId and isEnglish:
			sql="""select 	profNewsletter_Ext.id as id,
					profNewsletter_Ext.title as title,
					profNewsletter.editedAt,
					profNewsletter_Ext.content,
					profNewsletter_Ext.origin_id,
					profNewsletter_Ext.provider_id,
					profNewsletter_Ext.isEnglish, 
					profNewsletter_Ext.fk_profNewsletter_id,
					profNewsletter_Ext.createdExtAt 
				from (profNewsletter_Ext INNER JOIN profNewsletter ON profNewsletter_Ext.fk_profNewsletter_id = profNewsletter.id) 
				where profNewsletter_Ext.origin_id ='%s' and profNewsletter_Ext.provider_id=%s and profNewsletter_Ext.isEnglish='%s';
				""" % (originId,providerId,isEnglish)
			try:
				self.cursor_stg.execute(sql)
				row=self.cursor_stg.fetchone()
				if row:
					article=Article()
					article.id=row[0]
					article.title=row[1]
					article.editedAt=row[2]
					article.content=row[3]
					article.originId=row[4]
					article.providerId=row[5]
					article.isEnglish=row[6]
					article.fkProfNewsletterId=row[7]
					article.proDate=row[8]
					article.contentType=Article.CONTENT_TYPE_NEWSLETTER
					return article
				else:
					raise Exception("No professional newsletter with origin_id:%s,provider_id:%s,isEnglish:%s found!" %(originId,providerId,isEnglish))
			except Exception,e:
				self.log.error(e)
				self.log.error(sql)
	def getAll(self):
		sql="""select 	profNewsletter_Ext.id as id,
			      	profNewsletter_Ext.title as title,
			      	profNewsletter.editedAt,
			      	profNewsletter_Ext.content,
				profNewsletter_Ext.origin_id,
				profNewsletter_Ext.provider_id,
				profNewsletter_Ext.isEnglish, 
				profNewsletter_Ext.fk_profNewsletter_id 
			from (profNewsletter_Ext INNER JOIN profNewsletter ON profNewsletter_Ext.fk_profNewsletter_id = profNewsletter.id) 
			where isDisplay=1 and isEnglish='Y';
			"""
		try:
			self.cursor_stg.execute(sql)
			for row in self.cursor_stg.fetchall():
				article=Article()
				article.id=row[0]
				article.title=row[1]
				article.editedAt=row[2]
				article.content=row[3]
				article.originId=row[4]
				article.providerId=row[5]
				article.isEnglish=row[6]
				article.fkProfNewsletterId=row[7]
				article.contentType=Article.CONTENT_TYPE_NEWSLETTER
				yield article
		except Exception,e:
			self.log.error(e)
			self.log.error(sql)