Python Taxon.raw Examples

Example #1

File: shell.py Project: JelleZijlstra/taxonomy

def childless_taxa():
    return Taxon.raw(
        "SELECT * FROM taxon WHERE rank > 5 AND id NOT IN (SELECT parent_id FROM taxon WHERE parent_id IS NOT NULL)"
    )

Example #2

File: shell.py Project: JelleZijlstra/taxonomy

def bad_base_names():
    return Taxon.raw("SELECT * FROM taxon WHERE base_name_id IS NULL OR base_name_id NOT IN (SELECT id FROM name)")