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

Tuesday, February 16, 2016[edit]

Hey! Today, I'm loading up a 500 revision pilot for the edit types campaign.

u_wikilabels=> INSERT INTO campaign (name, wiki, form, view, created, labels_per_task, tasks_per_assignment, active) VALUES ('Edit types (0.5k sample)', 'enwiki', 'edit_type', 'DiffToPrevious', NOW(), 2, 10, True);
INSERT 0 1
u_wikilabels=> select * from campaign where active and wiki = 'enwiki';
 id |                  name                  |  wiki  |          form          |      view      |          created           | labels_per_task | tasks_per_assignment | active 
----+----------------------------------------+--------+------------------------+----------------+----------------------------+-----------------+----------------------+--------
  4 | Edit quality (20k random sample, 2015) | enwiki | damaging_and_goodfaith | DiffToPrevious | 2015-05-07 15:23:39.872544 |               1 |                   50 | t
 22 | Edit types (0.5k sample)               | enwiki | edit_type              | DiffToPrevious | 2016-02-16 16:38:31.014521 |               2 |                   10 | t
(2 rows)

u_wikilabels=> \q
halfak@wikilabels-01:~/datasets$ cat enwiki.0.5k_2015.tsv | /srv/wikilabels/venv/bin/wikilabels task_inserts 22 | psql -h wikilabels-database --user u_wikilabels u_wikilabels -W 
Password for user u_wikilabels: 
INSERT 0 500

Simple enough. --EpochFail (talk) 16:51, 16 February 2016 (UTC)[reply]

Forgot to note the query that generated these 500 revisions. See Random 500 size-changing article edits (Feb 2016) --EpochFail (talk) 16:52, 16 February 2016 (UTC)[reply]