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

Type missing from org metadata in postgres #122

Closed justinlittman closed 5 years ago

justinlittman commented 5 years ago 
select * from organizations limit 2;
 id |                                                                        uri                                                                   
     |                                             metadata                                             |         created_at         |         upda
ted_at         
----+----------------------------------------------------------------------------------------------------------------------------------------------
-----+--------------------------------------------------------------------------------------------------+----------------------------+-------------
---------------
  2 | http://sul.stanford.edu/rialto/agents/orgs/department-of-athletics-physical-education-and-recreation/coed-sports                             
     | {"name": "Coed Sports (Department of Athletics, Physical Education and Recreation)", "type": ""} | 2018-10-18 20:15:24.537939 | 2018-10-19 1
6:49:38.477884
  4 | http://sul.stanford.edu/rialto/agents/orgs/department-of-athletics-physical-education-and-recreation/womens-sport-programs/womens-fencing-pro
gram | {"name": "Women's Fencing Program (Women's Sport Programs)", "type": ""}                         | 2018-10-18 20:15:24.541536 | 2018-10-19 1
6:49:38.488069
(2 rows)
justinlittman commented 5 years ago

To fix, move each OPTIONAL clause into own OPTIONAL in SparqlReader.queryOrganizations.

Also, clean up the query and organization model to remove unused fields. Also, verify that parent is populated.