def save_char_entity(entity): chars = util.str2char(entity.name) db.query('update char_entities set status=0 where entity_id=%d' % (entity.pk_id)) li = [] for c in chars: li.append("('%s',%d,%d,%d,1)"%( c['char'],c['count'],entity.type_id,entity.pk_id ) ) # print ','.join(li) db.query('replace into char_entities (char_one,char_count,entity_type_id,entity_id,status)values%s'%(','.join(li)))
def search(name): chars = util.str2char(name) condi = ' or '.join(["char_one='%s'"%(c['char']) for c in chars]) result = db.query("""select entity_id,count(entity_id) as entity_count ,sum(char_count) as char_count_sum from char_entities where %s group by entity_id order by sum(char_count) desc; """ % (condi)) #char_one='星' or char_one='美' return list(result)[0:3]