Sorry - that was supposed to be 'show databases' and 'show tables'.
On 1 October 2017 at 05:26, Alex Monk krenair@gmail.com wrote:
You mean, pages like MediaWiki has but modified for use in Labs? I don't think there's MediaWiki-style documentation on that, I'd just use the 'list databases', 'list tables' and 'describe $view' commands. You can use 'show create view $view' to see some restrictions (e.g. it selects NULL in place of user.user_password), but that doesn't always tell you everything as tables (and columns?) can get filtered out before a row even gets to the labsdb machines.
On 1 October 2017 at 05:14, Martin Domdey animalia@gmx.net wrote:
May I ask you, where you could find a database schema?
Regards, Martin
-- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet. Am 01.10.2017, 06:10, Alex Monk krenair@gmail.com schrieb:
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
Cloud mailing list Cloud@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/cloud