def addAppUrl(self, app_url, recruit_type):
md5sum = Util.urlMd5(app_url)
count = mq.queryRow("select count(id) from tb_yjs_app_url where md5sum='" + md5sum + "'")
if count and int(count[0]) > 0:
print '>>>>>>>>>>>>>>>crawl has save the url %s' % (app_url)
return 0
else:
# save yjs_url
p_data = {'md5sum': md5sum, 'url': app_url, 'recruit_type': str(recruit_type)}
mq.insert("tb_yjs_app_url", p_data)
mq.commit()
return 1
def updateAppUrl(self, app_url, status):
md5sum = Util.urlMd5(app_url)
p_data = {'status': status}
mq.update("tb_yjs_app_url", p_data, " where md5sum='" + md5sum + "'")
mq.commit()
