Project

General

Profile

« Previous | Next » 

Revision 5126

Added by Aaron Marcuse-Kubitza over 12 years ago

tnrs_db: Exclude taxonomic names which have already been scrubbed, by using a filter-out LEFT JOIN on TNRS.tnrs

View differences:

bin/tnrs_db
47 47 
    # Iterate over unscrubbed verbatim taxonpaths
48 48 
    start = 0
49 49 
    total_pause = 0
50 
    tables = ['taxonpath', sql_gen.Join('tnrs',
51 
        {'Name_submitted': 'taxonomicnamewithauthor'}, sql_gen.filter_out)]
50 52 
    while True:
51 53 
        # Fetch next set
52 
        cur = sql.select(db, 'taxonpath', ['taxonomicnamewithauthor'],
54 
        cur = sql.select(db, tables, ['taxonomicnamewithauthor'],
53 55 
            [('canon_taxonpath_id', None)], limit=tnrs.max_names,
54 56 
            start=start, cacheable=False)
55 57 
        this_ct = cur.rowcount

Also available in: Unified diff