Sorry - that was supposed to be 'show databases' and 'show tables'.
On 1 October 2017 at 05:26, Alex Monk <krenair(a)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(a)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(a)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(a)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(a)lists.wikimedia.org
>> >
https://lists.wikimedia.org/mailman/listinfo/cloud
>> >
>>
>> _______________________________________________
>> Cloud mailing list
>> Cloud(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/cloud
>
>
> _______________________________________________
> Cloud mailing list
> Cloud(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/cloud
>