def dump_examples(filename, format="tsv"): query = """\ SELECT g.id, array_to_string(g.grounded_topics, ' '), la.text FROM grouped_taxonomy_articles g, long_abstracts la WHERE g.id = la.id """ pg.export_to_file(filename, query=query)
def dump_examples(filename, format='tsv'): query = """\ SELECT g.id, array_to_string(g.grounded_topics, ' '), la.text FROM grouped_taxonomy_articles g, long_abstracts la WHERE g.id = la.id """ pg.export_to_file(filename, query=query)
def dump_taxonomy(filename): """""" query = """\ SELECT d.id, string_agg(d.grounded_broader, ' ' ORDER BY d.grounded_broader), first_agg(d.article) FROM ( SELECT DISTINCT id, grounded_broader, article FROM taxonomy_dag WHERE grounded = 't' ) AS d GROUP BY d.id """ pg.export_to_file(filename, query=query)