histograph / core

Histograph Core: Graph management and inferencing
MIT License
1 stars 3 forks source link

Rejected relations always returns empty array #35

Closed bertspaan closed 9 years ago

bertspaan commented 9 years ago

https://api.histograph.io/sources/ilvb/rejected_relations

wires commented 9 years ago

This is due to wrongly inserted data into postgresql.

SELECT * FROM rejected_relations;

 rel_from |           from_id_method           |        rel_to         |   to_id_method   | rel_label |           rel_source            | rejection_cause |     rejection_cause_id_method
----------+------------------------------------+-----------------------+------------------+-----------+---------------------------------+-----------------+------------------------------------
 HGID     | atlas-verstedelijking/Alkmaar_1200 | atlas-verstedelijking | hg:sameHgConcept | URI       | http://www.geonames.org/2759899 | HGID            | atlas-verstedelijking/Alkmaar_1200
 HGID     | atlas-verstedelijking/Alkmaar_1350 | atlas-verstedelijking | hg:sameHgConcept | URI       | http://www.geonames.org/2759899 | HGID            | atlas-verstedelijking/Alkmaar_1350
 HGID     | atlas-verstedelijking/Alkmaar_1500 | atlas-verstedelijking | hg:sameHgConcept | URI       | http://www.geonames.org/2759899 | HGID            | atlas-verstedelijking/Alkmaar_1500
 HGID     | atlas-verstedelijking/Alkmaar_1650 | atlas-verstedelijking | hg:sameHgConcept | URI       | http://www.geonames.org/2759899 | HGID            | atlas-verstedelijking/Alkmaar_1650
(4 rows)

The curl to the core works fine,

curl http://localhost:13782/rejected\?sourceid=http\:\/\/www.geonames\.org\/2759899|python -m json.tool

Should of course be

curl http://localhost:13782/rejected\?sourceid=geonames

bertspaan commented 9 years ago

Ok. We should refactor PG code (#36). Or stop using PG altogether, and just use Neo!