Talk:Wiki labels/Work log/2016-02-24
Jump to navigation Jump to search
Wednesday, February 24, 2016
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)
Looks like we have an issue that I'll need some help with. See Phab:T127924 --EpochFail (talk) 01:30, 24 February 2016 (UTC)