Research talk:Revision scoring as a service/Work log/2015-12-05

Saturday, December 5, 2015

Today, I'm loading Wikidata's edit quality campaign.

u_wikilabels=> INSERT INTO campaign (name, wiki, form, view, created, labels_per_task, tasks_per_assignment, active) VALUES ('Edit quality (20k balanced sampled)', 'wikidatawiki', 'damaging_and_goodfaith', 'DiffToPrevious', NOW(), 1, 50, True);
INSERT 0 1
u_wikilabels=> SELECT id, name, wiki FROM campaign WHERE wiki IN ('wikidatawiki'); 
 id |                name                 |     wiki     
----+-------------------------------------+--------------
 19 | Edit quality (20k balanced sampled) | wikidatawiki
(1 row)

OK. Time to load some items into the campaign.

halfak@wikilabels-01:~$ cat datasets/wikidata.prelabeled_revisions.20k_balanced_2015.tsv | grep -P "rev_id|[0-9]+\tTrue" | /srv/wikilabels/venv/bin/wikilabels task_inserts 19 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W
Password for user u_wikilabels: 
INSERT 0 4283

See wikidata:Wikidata:Edit_labels. --Halfak (WMF) (talk) 17:31, 5 December 2015 (UTC)