Python export_to_file Examples

Example #1

File: build_taxonomy.py Project: sapresearch/dbpediakit

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)

Example #2

File: build_taxonomy.py Project: swemoh/dbpediakit

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)

Example #3

File: build_taxonomy.py Project: sapresearch/dbpediakit

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)

Example #4

File: build_taxonomy.py Project: swemoh/dbpediakit

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)