[Wikidata-bugs] [Maniphest] [Commented On] T169986: Find how to mark rejected suggestions in the back-end

[Hjfocs]

Hjfocs added a comment.

State named graphs solution experiment.

The input dataset is the same as above, but the named graph http://chuck-berry/new is minted at upload time.

On data retrieval

SELECT ?property ?statement_property ?statement_value ?reference_property ?reference_value
WHERE {
  GRAPH <http://chuck-berry/new> {
    # Claim
    wd:Q5921 ?property ?statement .
    # Qualifier
    ?statement ?statement_property ?statement_value .
    # Reference
    OPTIONAL {
      ?statement_value ?reference_property ?reference_value .
    }
  }
}

On claim approval

DELETE {
  GRAPH <http://chuck-berry/new> {
    wd:Q5921 ?property ?statement .
    ?statement ?statement_property ?statement_value .
    ?statement_value ?reference_property ?reference_value .
  }
}
INSERT {
  GRAPH <http://chuck-berry/approved> {
    wd:Q5921 ?property ?statement .
    ?statement ?statement_property ?statement_value .
    ?statement_value ?reference_property ?reference_value .
  }
}
WHERE {
  wd:Q5921 ?property ?statement .
  ?statement ?statement_property ?statement_value .
  OPTIONAL {
    ?statement_value ?reference_property ?reference_value .
  }
}



On qualifier approval

DELETE {
  GRAPH <http://chuck-berry/new> {
    ?statement pq:P2096 ?statement_value .
  }
}
INSERT {
  GRAPH <http://chuck-berry/approved> {
    ?statement pq:P2096 ?statement_value .
  }
}
WHERE {
  wd:Q5921 ?property ?statement .
  ?statement pq:P2096 ?statement_value .
}



On reference approval

DELETE {
  GRAPH <http://chuck-berry-new> {
    ?statement_value pr:P143 ?reference_value .
  }
}
INSERT {
  GRAPH <http://chuck-berry/approved> {
    ?statement_value pr:P143 ?reference_value .
  }
}
WHERE {
  wd:Q5921 ?property ?statement .
  ?statement ?statement_property ?statement_value .
  ?statement_value pr:P143 ?reference_value .
}



Notes


no additional triples needed;
quite easy queries to retrieve and update the data;
explicit triples grouping based on the state.

TASK DETAIL

https://phabricator.wikimedia.org/T169986

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Hjfocs
Cc: Aklapper, Hjfocs, Kiailandi, dachary, Wikidata-bugs, Ricordisamoa, Sjoerddebruin, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs