Every source table and the monuments_all tabe should have a field wd_item field of type int to store the relevant wikidata item id.
The harvester bot should pick it up :
{
'source' : u'wd_item',
'dest' : u'wd_item',
'type' : 'int',
},It should be aggregated in the main table and should be visible in the api.
Version: unspecified
Severity: normal
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Add wikidata connection to monuments_all and Qid tester to updater | labs/tools/heritage | master | +113 -4 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T55807 Monuments database future (tracking) | |||
| Resolved | JeanFred | T137457 Hold a Wiki Loves Monuments coding sprint at Wikimania Hackathon 2016 | |||
| Resolved | JeanFred | T55808 Add wd_item to the database |
Change 295594 had a related patch set uploaded (by Lokal Profil):
Add wikidata connection to monuments_all and Qid tester to updater
In the patch I didn't force the value to be int. Instead I added a checker to ensure any value is of the form "Q<int>".
Change 295594 merged by jenkins-bot:
Add wikidata connection to monuments_all and Qid tester to updater
Mentioned in SAL [2016-06-23T15:33:17Z] <JeanFred> Added column wd_item to monuments_all, by copying monuments_all to tmp, alter table, and rename back to avoid locks. (T55808)