def updatePostUrlExtracted(self,postid,value): try: dbObj=MySQLHelper() query="update posts set urlextracted="+str(value)+" where id="+str(postid) result=dbObj.query(query) return result except: self.logger.logInfo('Exception in updatePostStatus method (dal/twitterprovider.py)')
def getURLs(self): try: dbObj=MySQLHelper() query="select * from urls where status=0" result=dbObj.query(query) return result except: self.logger.logInfo('Exception in updatePostStatus method (dal/twitterprovider.py)')
def getPosts(self): try: dbObj=MySQLHelper() query="select * from posts where urlextracted=0 order by id;" result=dbObj.query(query) return result except: self.logger.logInfo('Exception in getPosts method (dal/urlprovider.py)')
def updateUrlStatus(self,urlid,value): try: dbObj=MySQLHelper() query="update urls set status="+str(value)+" where id="+str(urlid) result=dbObj.query(query) return result except: self.logger.logInfo('Exception in updateUrlStatus method (dal/twitterprovider.py)')
def saveUrlIMG(self,urlid,filename): try: dbObj=MySQLHelper() tubleData=(urlid,filename) query="insert into urlimgs (urlid,filename) values (%s,%s)" result=dbObj.executequery(query,tubleData) return result except: self.logger.logInfo('Exception in saveUrlIMG method (dal/twitterprovider.py)')
def addUrlHeaderInfo(self,urlid,metatitle,metadescription): try: dbObj=MySQLHelper() tubleData=(metatitle,metadescription) query="update urls set metatitle=%s,metadescription=%s where id="+str(urlid) result=dbObj.executequery(query,tubleData) return result except: self.logger.logInfo('Exception in updatePostStatus method (dal/twitterprovider.py)')
def getPosts(self): try: dbObj = MySQLHelper() query = "select * from posts where urlextracted=0 order by id;" result = dbObj.query(query) return result except: self.logger.logInfo( 'Exception in getPosts method (dal/urlprovider.py)')
def updateUrlStatus(self, urlid, value): try: dbObj = MySQLHelper() query = "update urls set status=" + str( value) + " where id=" + str(urlid) result = dbObj.query(query) return result except: self.logger.logInfo( 'Exception in updateUrlStatus method (dal/twitterprovider.py)')
def saveUrlIMG(self, urlid, filename): try: dbObj = MySQLHelper() tubleData = (urlid, filename) query = "insert into urlimgs (urlid,filename) values (%s,%s)" result = dbObj.executequery(query, tubleData) return result except: self.logger.logInfo( 'Exception in saveUrlIMG method (dal/twitterprovider.py)')
def getURLs(self): try: dbObj = MySQLHelper() query = "select * from urls where status=0" result = dbObj.query(query) return result except: self.logger.logInfo( 'Exception in updatePostStatus method (dal/twitterprovider.py)' )
def updatePostUrlExtracted(self, postid, value): try: dbObj = MySQLHelper() query = "update posts set urlextracted=" + str( value) + " where id=" + str(postid) result = dbObj.query(query) return result except: self.logger.logInfo( 'Exception in updatePostStatus method (dal/twitterprovider.py)' )
def addUrlHeaderInfo(self, urlid, metatitle, metadescription): try: dbObj = MySQLHelper() tubleData = (metatitle, metadescription) query = "update urls set metatitle=%s,metadescription=%s where id=" + str( urlid) result = dbObj.executequery(query, tubleData) return result except: self.logger.logInfo( 'Exception in updatePostStatus method (dal/twitterprovider.py)' )
def addURL(self,url,orgurl,postid): try: dbObj=MySQLHelper() query="select id,counter from urls where orgurl='"+orgurl+"'" result=dbObj.query(query) if len(result) == 0: tubleData=(url,orgurl,postid) query="insert into urls (url,orgurl,postid) values (%s,%s,%s)" result=dbObj.executequery(query,tubleData) else: query='' id=result[0]['id'] counter=result[0]['counter'] if counter is None: counter=0 counter += 1 query="update urls set counter="+str(counter)+" where id="+str(id) result=dbObj.query(query) except: self.logger.logInfo('Exception in addURL method (dal/urlprovider.py)')
def addURL(self, url, orgurl, postid): try: dbObj = MySQLHelper() query = "select id,counter from urls where orgurl='" + orgurl + "'" result = dbObj.query(query) if len(result) == 0: tubleData = (url, orgurl, postid) query = "insert into urls (url,orgurl,postid) values (%s,%s,%s)" result = dbObj.executequery(query, tubleData) else: query = '' id = result[0]['id'] counter = result[0]['counter'] if counter is None: counter = 0 counter += 1 query = "update urls set counter=" + str( counter) + " where id=" + str(id) result = dbObj.query(query) except: self.logger.logInfo( 'Exception in addURL method (dal/urlprovider.py)')