Page MenuHomePhabricator

[Scraper] Update Database Checks: Quantity Observations
Closed, ResolvedPublic2 Estimated Story Points

Description

Database analysis:

valid_wikibase_quantity_observation_expectation_suite.json

  • total_items: min_value: 1 -> 0
    • Valid - though, check if instances are actual Wikibases
  • total_properties: min_value: 1 -> 0
    • Valid - though, check if instances are actual Wikibases
  • total_triples: min_value: 1 -> 0
    • Valid - though, check if instances are actual Wikibases
  • first investigation: 13 instances self-hosted need manual research
  • there are a few more test instances that we set up and need additional investigation

AC:

  • Investigate all instances with 0 items/triples/properties
  • Assess if test instance, now offline, not a wikibase, etc

Event Timeline

Leif_WMDE updated the task description. (Show Details)
Leif_WMDE set the point value for this task to 2.
SELECT
  COUNT(*),
  COUNT(DISTINCT wikibase_id),
  wb_type
FROM wikibase_quantity_observation
JOIN wikibase ON wikibase_quantity_observation.wikibase_id = wikibase.id
WHERE total_items = 0 OR total_properties = 0 OR total_triples = 0
GROUP BY wb_type;

Returned

count (observations)count (instances)wb_type
556SUITE
34974868CLOUD
1477