search

sul-dlss-deprecated / rialto-derivatives

Listens to SNS messages and moves data from Neptune to Solr and Postgres to power the RIALTO webapp
0 stars 1 forks source link

Not finding all grants #171

Closed justinlittman closed 5 years ago

justinlittman commented 5 years ago

In the derivative rebuild on staging, seeing messages like:

2019/01/30 21:35:30 No results found for http://vivoweb.org/ontology/core#Grant and http://sul.stanford.edu/rialto/grants/42473

This is probably because the query for grants requires attributes that not all grants possess:

            return fmt.Sprintf(`SELECT ?id ?type ?name ?pi ?pi_label ?assigned ?assigned_label ?start ?end
            WHERE {
              ?id a <http://vivoweb.org/ontology/core#Grant> .
                ?id a ?type .
              ?id <http://www.w3.org/2004/02/skos/core#prefLabel>|<http://www.w3.org/2000/01/rdf-schema#label> ?name .
                ?id <http://vivoweb.org/ontology/core#relates> ?pi_role .
                ?pi_role a <http://vivoweb.org/ontology/core#PrincipalInvestigatorRole> .
                ?pi_role <http://purl.obolibrary.org/obo/RO_0000052> ?pi .
                ?pi <http://www.w3.org/2004/02/skos/core#prefLabel> ?pi_label .
                ?id <http://vivoweb.org/ontology/core#assignedBy> ?assigned .
                ?assigned <http://www.w3.org/2004/02/skos/core#prefLabel> ?assigned_label .
                OPTIONAL {
                    ?id <http://purl.org/cerif/frapo/hasStartDate> ?start .
                }
                OPTIONAL {
                    ?id <http://purl.org/cerif/frapo/hasEndDate> ?end .
                }
                %s
            }
            ORDER BY ?id OFFSET %v LIMIT %v`, r.filter(ids), offset, tripleLimit)