Beispiel #1
0
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)))
Beispiel #2
0
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]