Creator of š° News feeds, @xblock.aendra.dev, @moji.blue, founder of @shoots.green, co-organiser @atproto.london. Opinions my own. Not a journalist or an engineer, but a secret third thing (on medical leave). she/her/ze/hir š³ļøāā§ļø š aendra.com šļø ft.com/Ʀ
![It's two functions in Google AppScript:
function QueryDBPediaByName(nameString) {
const q = `SELECT DISTINCT ?owner ?ownerLabel WHERE {{
?newspaper a dbo:Newspaper ;
rdfs:label ?label;
dbo:owner ?owner .
?owner rdfs:label ?ownerLabel .
filter contains(?label,"${nameString}")
}}
LIMIT 1`;
const uri = `https://dbpedia.org/sparql?query=${encodeURIComponent(q)}&format=json`
const res = JSON.parse(UrlFetchApp.fetch(uri).getContentText());
console.log(res);
if (res.results.bindings.length) {
return res.results.bindings[0].ownerLabel.value;
}
return null;
}
function QueryDBPediaByDomain(domainiString) {
const q = `SELECT DISTINCT ?owner ?ownerLabel WHERE {{
?newspaper a dbo:Newspaper ;
dbo:website ?website ;
dbo:owner ?owner .
?owner rdfs:label ?ownerLabel .
FILTER(regex(?website, "{handle}", "i"))
}}
LIMIT 1`;
const uri = `https://dbpedia.org/sparql?query=${encodeURIComponent(q)}&format=json`
const res = JSON.parse(UrlFetchApp.fetch(uri).getContentText());
console.log(res);
if (res.results.bindings.length) {
return res.results.bindings[0].ownerLabel.value;
}
return null;
}](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:kkf4naxqmweop7dv4l2iqqf5/bafkreid6hslwqbq46mw34zwzsgxskb4ebrxqtqlxxcama7wl35nle3axze)
