Project

General

Profile

« Previous | Next » 

Revision 5661

tnrs_db: Updated with schema changes

View differences:

bin/tnrs_db
48 48
    # Iterate over unscrubbed verbatim taxonlabels
49 49
    total_pause = 0
50 50
    tables = ['taxonlabel', sql_gen.Join('tnrs',
51
        {'Name_submitted': 'identifyingtaxonomicname'}, sql_gen.filter_out)]
52
    cols = ['identifyingtaxonomicname']
51
        {'Name_submitted': 'taxonomicname'}, sql_gen.filter_out)]
52
    cols = ['taxonomicname']
53 53
    # Has a concatenated name and not already linked to an accepted name
54
    conds = [('identifyingtaxonomicname', sql_gen.CompareCond(None, '!=')),
54
    conds = [('taxonomicname', sql_gen.CompareCond(None, '!=')),
55 55
        ('matched_label_id', None)]
56 56
    while True:
57 57
        # Fetch next set

Also available in: Unified diff