Hmmm, interesting. I did read [[Help:Toolforge/Database]] where it says:
Tool and Tools users are granted access to replicas of the production databases. Private user data has been redacted from these replicas (some rows are elided and/or some columns are made NULL depending on the table). For most practical purposes this is identical to the production databases and sharded into clusters in much the same way.
But didn’t realize that applied to things like rev_text_id. I assumed it was just stuff like user’s passwords and email addresses. If stuff as basic as rev_text_id is redacted, that really stretches the meaning of "For most practical purposes this is identical to the production databases”.
I assume by “the API” you mean https://www.mediawiki.org/wiki/API:Main_page https://www.mediawiki.org/wiki/API:Main_page ?
On Oct 1, 2017, at 12:10 AM, Alex Monk krenair@gmail.com wrote:
The MediaWiki schema description is only valid for the underlying database, you do not have access to that as a labs user - you just have security-sanitised views. rev_text_ids are not useful to you as you cannot access revision texts via the DBs - you must go through the API.
On 1 October 2017 at 04:31, Roy Smith roy@panix.com wrote:
I’ve been exploring the enwiki database. I can find the page row for [[Iron]]
MariaDB [enwiki_p]> select page_title from page where page_id = 14734; +------------+ | page_title | +------------+ | Iron | +------------+
It looks like it has the right number of revisions:
MariaDB [enwiki_p]> select count(*) from revision where rev_page = 14734; +----------+ | count(*) | +----------+ | 5560 | +----------+
But, all of the rev_text_ids are 0
MariaDB [enwiki_p]> select rev_text_id from revision where rev_page = 14734 and rev_text_id != 0; Empty set (0.02 sec)
The schema description seems pretty straight-forward. What am I not understanding?
Cloud mailing list Cloud@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/cloud
Cloud mailing list Cloud@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/cloud