def get_site_list(*connection_args):
if not connection_args: connection_args = config.connection_args
p.get_connection(*connection_args)
c = p.connection
cur = c.cursor()
cur.execute("SELECT DISTINCT site_id FROM site_data.site_info ORDER BY site_id;")
return [c[0] for c in cur.fetchall()]
def do_everything(species_lists, output_csvs_args, connection_args):
import load_entered_data as m1
if not species_lists: species_lists = m1.default_species_lists
correct, unknown = m1.main(species_lists)
import output_csvs as m2
m2.main(*output_csvs_args)
import pg_interface as m3
m3.get_connection(*connection_args)
groups = list(set(str(s[0]) for s in species_lists))
m3.push_data(groups)
return correct, unknown
def get_spp_list(taxon, site, *connection_args):
if not connection_args:
connection_args = config.connection_args
p.get_connection(*connection_args)
c = p.connection
cur = c.cursor()
cur.execute(
"""SELECT DISTINCT t.spp_id, t.scientific_name, t.common_name
FROM species_lists.%s s
JOIN taxonomy.%s t ON s.spp_id=t.spp_id
WHERE s.site_id='%s'
ORDER BY t.spp_id;"""
% (taxon, taxon, site)
)
return cur.fetchall()
