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

Latest comment: 8 years ago by EpochFail in topic Wednesday, February 24, 2016

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

Return to "Wiki labels/Work log/2016-02-24" page.