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)')
