def setGoogleValue(self, id, google_value, links=''):
sql = 'update GoogleResult_mark set google = %s, url = %s where id = %s limit 1'
if links is None:
linkstr = ''
else:
linkstr = '\n'.join(links)
try:
conn = DB.pool().getConnection()
cursor = conn.cursor()
cursor.execute(sql, (google_value, linkstr, id,))
except Exception, e:
ExceptionHelper.print_exec(e)
finally:
cursor.close()
conn.close()
print '[UPDATE]id:%s, Value:%s' % (id, google_value)
if __name__ == '__main__':
# pool = DB.initpool("localhost", "arnet_local", "root", "root")
DB.initpool("10.1.1.209", "arnet_int2", "root", "root")
# GoogleResultDBUpdater().popTitlesFromDB()
# GoogleResultUpdateThread().run()
GoogleResultDBUpdater().update()
# ResetTimestampThread().run()
