query_PersonKeyword.py

import math, sys
from SPARQLWrapper import SPARQLWrapper, JSON
from queries.peopleKeywordCount import peopleKeywordCount
from queries.createPeopleKeywordQuery import createPeopleKeywordQuery

# get the year to query from the user
year = input("Enter year to query: ")
year = str(year)

# there are too many results to get all at once
# here we ask the database how many results there 
# are for the year we are interested in. Given that
# we can get 10,000 results per query, we do a little
# math to compute how many times we need to query the database 
# to get all the results
offset = 0
limit = float(peopleKeywordCount(year))
numQueries = math.ceil(limit/10000)

# setting up the query 
# specifying the web address of the database
# setting the return format to JSON - JavaScript Object Notation
sparql = SPARQLWrapper("http://abstractsearch.agu.org:8890/sparql")
sparql.setReturnFormat(JSON)

# keep looping and querying until we get all the results
while (numQueries > 0):
	query = createPeopleKeywordQuery(year,str(offset))
	sparql.setQuery(query)
	offset = offset + 10000
	results = sparql.query().convert()
	for result in results["results"]["bindings"]:
		print(result["keyword"]["value"] + " " + result["name"]["value"])
	numQueries = numQueries - 1