示例#1
0
    dbh.execute("DROP TABLE dictionary")

dbh.execute(
    """ CREATE TABLE if not exists `dictionary` (
    `id` int auto_increment,
    `word` VARCHAR( 250 ) binary NOT NULL ,
    `class` VARCHAR( 50 ) NOT NULL ,
    `encoding` SET( 'all', 'asci', 'ucs16' ) DEFAULT 'all' NOT NULL,
    `type` set ( 'word','literal','regex' ) DEFAULT 'literal' NOT NULL,
    PRIMARY KEY  (`id`)
    )""")

count=0
for file in args[0:]:
    fd=open(file)
    print "Reading File %s" % file
    for line in fd:
        if len(line)>3:
            try:
                dbh.execute("insert into dictionary set word=\"%s\",class=\"%s\",type=%r" %
                            (DB.escape(line.strip()),wordclass,type))
                count+=1
            except DB.DBError:
                pass

            if (count % 1000) == 0:
                sys.stdout.write("Added %s words\r" % count)
                sys.stdout.flush()
                
    fd.close()
示例#2
0
    dbh.execute("DROP TABLE dictionary")

dbh.execute(""" CREATE TABLE if not exists `dictionary` (
    `id` int auto_increment,
    `word` VARCHAR( 250 ) binary NOT NULL ,
    `class` VARCHAR( 50 ) NOT NULL ,
    `encoding` SET( 'all', 'asci', 'ucs16' ) DEFAULT 'all' NOT NULL,
    `type` set ( 'word','literal','regex' ) DEFAULT 'literal' NOT NULL,
    PRIMARY KEY  (`id`)
    )""")

count = 0
for file in args[0:]:
    fd = open(file)
    print "Reading File %s" % file
    for line in fd:
        if len(line) > 3:
            try:
                dbh.execute(
                    "insert into dictionary set word=\"%s\",class=\"%s\",type=%r"
                    % (DB.escape(line.strip()), wordclass, type))
                count += 1
            except DB.DBError:
                pass

            if (count % 1000) == 0:
                sys.stdout.write("Added %s words\r" % count)
                sys.stdout.flush()

    fd.close()