Revision 5661
Added by Aaron Marcuse-Kubitza about 12 years ago
| 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
tnrs_db: Updated with schema changes