Inserting variables into a SQL Query in Python using requests

Question

I have the following:

for name in set(short_names):
    n = name.title()

    url = 'https://query.wikidata.org/sparql'
    query = """
    SELECT ?item WHERE {
      ?item rdfs:label "____________"@en

    }
    """
    r = requests.get(url, params = {'format': 'json', 'query': query})
    data = r.json()
    url = data.get('results').get('bindings')[0].get('item').get('value')
    q_id = re.search('Q.*', url).group()

    client = Client()  
    entity = client.get(q_id, load=True)
    d = entity.description
    desc.append(d)

Essentially what I am trying to do is insert the 'n' variable into _______ on every iteration of the loop.

Answer 1

It looks like your indentation may be off if you want your query variable to change on each iteration of the loop but you can do something like this:

for name in set(short_names):
    n = name.title()

    url = 'https://query.wikidata.org/sparql'
    query = """
    SELECT ?item WHERE {
      ?item rdfs:label "%s"@en

    }
    """ % (n)
    r = requests.get(url, params = {'format': 'json', 'query': query})
    data = r.json()
    url = data.get('results').get('bindings')[0].get('item').get('value')
    q_id = re.search('Q.*', url).group()

    client = Client()  
    entity = client.get(q_id, load=True)
    d = entity.description
    desc.append(d)

https://www.w3schools.com/python/ref_string_format.asp

%s formatting: What's the difference between %s and %d in Python string formatting?

Edited: realized that the other {} after the WHERE brake the format and f-string functions. Using the %s string formatting to avoid that potential issue.