def readdb(self, query, iterate=None):
print query
con = DB(self.host, self.port, self.user, self.passwd, self.db)
if iterate:
return con.iterget(query)
else:
return con.get(query)
def readdb(self, query, iterate=None):
print query
try:
con = DB(self.host, self.port, self.user, self.passwd, self.db, self.table)
if iterate:
return con.iterget(query)
else:
return con.get(query)
except Exception, err:
print err
def save(self, keyword, vertical, column, based_on_id, duplicate_name_filter, debug):
db = DB(self.host, self.port, self.user, self.passwd, self.db, self.table)
name_hash = md5(keyword['name'].encode('utf-8').lower()).hexdigest()
if duplicate_name_filter:
con = DB(self.host, self.port, self.user, self.passwd, self.db, self.table)
ids = con.get('select id from %s where name=%s and %s'%(self.table, '%s', duplicate_name_filter), keyword['name'])
if not ids: return
where = 'id in (%s)'%(','.join([str(i['id']) for i in ids]))
elif based_on_id:
where = 'id="%s"'%keyword['ori_id']
else:
where = 'name_hash="%s"'%name_hash
if column:
db.update({column:keyword['idf']}, where)
else:
db.update({'idf%d'%vertical:keyword['idf']}, where)
self.output += 1
if debug: print "!IDFUpdater: Updateded:%s"%name_hash
def readdb(self, iterate=None):
con = DB(self.host, self.port, self.user, self.passwd, self.db, self.table)
if iterate:
return con.iterget(self.query)
else:
return con.get(self.query)
