Talk:Wiki labels/Work log/2016-02-24

Wednesday, February 24, 2016[edit]

Loading up the labeling campaign for Polish Wikipedia. Working from the notes left by Amir here: Research talk:Revision scoring as a service/Work log/2016-02-23.

psql (9.4.6, server 9.4.3)
Type "help" for help.

u_wikilabels=> INSERT INTO campaign (name, wiki, form, view, created, labels_per_task, tasks_per_assignment, active) VALUES ('', 'plwiki', 'damaging_and_goodfaith', 'DiffToPrevious', NOW(), 1, 50, True);
INSERT 0 1
u_wikilabels=> Edycja jakości ( 20k próba losowa , 2015 )^C
u_wikilabels=> select * from campaign;
u_wikilabels=> select * from campaign where id = 24;
u_wikilabels=> update campaign set name = 'Edycja jakości ( 20k próba losowa , 2015 )' where id = 24;
UPDATE 1
u_wikilabels=> select * from campaign where id = 24;
u_wikilabels=> \q

Woops! Messed that up, but recovered OK. When i copy-pasted the name for the campaign, somehow I got a line break in front of the name so the command just executed!

OK. now to load the data.

halfak@wikilabels-01:~/datasets$ cat plwiki.revisions_for_review.5k_2015.tsv | /srv/wikilabels/venv/bin/wikilabels task_inserts 24 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W 
Password for user u_wikilabels: 
INSERT 0 5000

....and it looks like I still need to deploy the i18n for Polish. Doing that. --EpochFail (talk) 01:22, 24 February 2016 (UTC)[reply]

Looks like we have an issue that I'll need some help with. See Phab:T127924 --EpochFail (talk) 01:30, 24 February 2016 (UTC)[reply]