search

MaRDI4NFDI / portal-compose

docker-composer repo for mardi
https://portal.mardi4nfdi.de
GNU General Public License v3.0
3 stars 1 forks source link

Enable federated queries to the FactGrid SPARQL endpoint #534

Closed Daniel-Mietchen closed 1 month ago

Daniel-Mietchen commented 1 month ago

New feature description in words: Add https://database.factgrid.de/sparql to the allowlist of external SPARQL endpoints.

TODOS:

Checklist for this issue:

physikerwelt commented 1 month ago

Eventually, it was successfully deployed Could you please test it on https://query.staging.mardi4nfdi.org/

physikerwelt commented 1 month ago

It was good that we tested this, as there were several roadblocks in the context of the allowlist, and the 15-minute task eventually took a full hour.

Daniel-Mietchen commented 1 month ago

Thanks — works fine on the staging server:

#defaultView:Map

PREFIX FactGrid_wd: <https://database.factgrid.de/entity/>
PREFIX FactGrid_wdt: <https://database.factgrid.de/prop/direct/>

SELECT DISTINCT ?mathematician ?mathematicianLabel ?addressLabel ?coord WHERE {
  SERVICE <https://database.factgrid.de/sparql> {

    SELECT ?mathematician ?mathematicianLabel ?addressLabel ?coord
                          WHERE 
                          {
                            ?mathematician FactGrid_wdt:P2 FactGrid_wd:Q7;
                                           FactGrid_wdt:P165/FactGrid_wdt:P3* FactGrid_wd:Q152945;
                                           FactGrid_wdt:P208 ?address.
                            ?address FactGrid_wdt:P47 FactGrid_wd:Q10441;
                                     FactGrid_wdt:P48 ?coord.
                            SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
                          }
    limit 100  }
}

Screenshot 2024-05-27 at 20-50-20 MaRDIQueryService

physikerwelt commented 1 month ago

Ok, then, let's move on to production.

physikerwelt commented 1 month ago

Works as well in production https://tinyurl.com/2aebroao

Daniel-Mietchen commented 1 month ago

Yep. Now we can make the list of prefixes more complete.

physikerwelt commented 1 month ago

@Daniel-Mietchen yes. All we need is a list in the form

PREFIX FactGrid: https://database.factgrid.de/sparql

Maybe we can also develop a generic test query that can be applied to all endpoint, just to check if the connection works.

Daniel-Mietchen commented 1 month ago

PREFIX FactGrid_wd: http://database.factgrid.de/entity/ PREFIX FactGrid_wdt: http://database.factgrid.de/prop/direct/ PREFIX FactGrid_p: http://database.factgrid.de/prop/ PREFIX FactGrid_ps: http://database.factgrid.de/prop/statement/ PREFIX FactGrid_pq: http://database.factgrid.de/prop/qualifier/ PREFIX FactGrid_wdata: http://database.factgrid.de/wiki/Special:EntityData/ PREFIX FactGrid_wdno: http://database.factgrid.de/prop/novalue/ PREFIX FactGrid_prn: http://database.factgrid.de/prop/reference/value-normalized/ PREFIX FactGrid_prv: http://database.factgrid.de/prop/reference/value/ PREFIX FactGrid_pr: http://database.factgrid.de/prop/reference/ PREFIX FactGrid_pqn: http://database.factgrid.de/prop/qualifier/value-normalized/ PREFIX FactGrid_pqv: http://database.factgrid.de/prop/qualifier/value/ PREFIX FactGrid_psn: http://database.factgrid.de/prop/statement/value-normalized/ PREFIX FactGrid_psv: http://database.factgrid.de/prop/statement/value/ PREFIX FactGrid_wdv: http://database.factgrid.de/value/ PREFIX FactGrid_wdref: http://database.factgrid.de/reference/ PREFIX FactGrid_wds: http://database.factgrid.de/entity/statement/ PREFIX FactGrid_wdtn: http://database.factgrid.de/prop/direct-normalized/

physikerwelt commented 1 month ago

PS: For staging, the list can be directly edited on github and will be immediately deployed.

https://github.com/MaRDI4NFDI/srv-mardi03/blob/main/portal-compose-override/wdqs/prefixes.conf