Research talk:Revision scoring as a service/Work log/2015-11-23

Monday, November 23, 2015

Loading up some new campaigns. jawiki, etwiki, dewiki and itwiki

u_wikilabels=> SELECT id, name, wiki FROM campaign WHERE wiki IN ('jawiki', 'dewiki', 'etwiki', 'itwiki');
 id |                     name                     |  wiki  
----+----------------------------------------------+--------
 15 | 編集品質（ 20Kランダムサンプル)              | jawiki
 16 | Qualität Edit ( 20k Zufallsstichprobe )      | dewiki
 17 | Edit kvaliteet ( 20k juhuslik valim )        | etwiki
 18 | Modifica la qualità ( 20k campione casuale ) | itwiki
(4 rows)

OK. Ready.

halfak@wikilabels-01:~$ cat datasets/jawiki.prelabeled_revisions.20k_2015.tsv | grep -P "rev_id|[0-9]+\tTrue" | /srv/wikilabels/venv/bin/wikilabels task_inserts 15 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W
Password for user u_wikilabels: 
INSERT 0 9514
halfak@wikilabels-01:~$ cat datasets/dewiki.prelabeled_revisions.20k_2015.tsv | grep -P "rev_id|[0-9]+\tTrue" | /srv/wikilabels/venv/bin/wikilabels task_inserts 16 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W
Password for user u_wikilabels: 
INSERT 0 4177
halfak@wikilabels-01:~$ cat datasets/etwiki.prelabeled_revisions.20k_2015.tsv | grep -P "rev_id|[0-9]+\tTrue" | /srv/wikilabels/venv/bin/wikilabels task_inserts 17 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W
Password for user u_wikilabels: 
INSERT 0 4678
halfak@wikilabels-01:~$ cat datasets/itwiki.prelabeled_revisions.20k_2015.tsv | grep -P "rev_id|[0-9]+\tTrue" | /srv/wikilabels/venv/bin/wikilabels task_inserts 18 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W
Password for user u_wikilabels: 
INSERT 0 5390

Looks like the jawiki labelers are going to need to do a bit more work than most :\. But otherwise, we're ready to go! --Halfak (WMF) (talk) 21:11, 23 November 2015 (UTC)