Ejemplo n.º 1
0
def updateYQWwords(path=pathyq):
    filename = open(path)
    chinese = ""
    conn = connectsqlite()
    cnt = 1
    while 1:
        lines = filename.readlines(1000)
        if not lines:
            break
        for line in lines:
            if line == "\n" or line == "":
                continue
            if is_cn_line(line) and not line[0].isdigit() and not "[" in line:
                chinese = dealstring(line)
                #print chinese
                insertAttribute(conn,chinese,cnt)
                cnt = cnt + 1
            if line[0].isdigit():
                words = line.split()
                #print chinese + ":" + words[1]
                value = []
                value.append(words[1])
                value.append(2)
                value.append(cnt-1)
                insertAttriToSqlite(conn,value)
    conn.commit()
    conn.close()
    filename.close()
    print cnt   
Ejemplo n.º 2
0
def writeYQtodisk():
    filename = open(pathadv)
    outfile = open('D:\\advout.txt','w')
    conn = connect()
        
    YQ = {}
    
    #results = getYQrecords(conn)
    results = getAdvrecords(conn)
    #print 'haha'
    for result in results:
        w = Word(result[1],result[3],result[4])
        print result[1]
        YQ[result[1]] = w
    conn.close()    
    print 'lala'
    cnt = 1
    while 1:
        lines = filename.readlines(1000)
        if not lines:
            break
        for line in lines:
            #Blank line
            if line == "\n":
                outfile.writelines(line) 
            #Chinese
            if is_cn_line(line):
                #print "%d : %s" %(cnt,line)
                cnt = 1
                outfile.writelines(line)
                #print chinese
            #English Word
            if is_cn_line(line)==False and line != "\n":
                line = line.strip(' ')
                #line = fetch(line.lower())
                line = line.lower()
                line = dealstring(line)
                
                tmp = YQ[line]
                string = "%s%s%s\n" %(str(cnt).ljust(5),tmp.word.ljust(20),tmp.meanings)
                outfile.writelines(string)
                outfile.writelines("     [" + tmp.soundmark + ']\n')
                cnt = cnt + 1
                 
    file.close()
    outfile.close()