I'm talking about something like this: https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg , a graphical database schema, but I guess that it is outdated and needs to be updated.
Martin
Gesendet: Sonntag, 01. Oktober 2017 um 04:26 Uhr
Von: "Alex Monk" <kren...@gmail.com>
An: "Wikimedia Cloud Services general discussion and support" <cloud@lists.wikimedia.org>
Betreff: Re: [Cloud] revision.rev_text_id is always 0?
Von: "Alex Monk" <kren...@gmail.com>
An: "Wikimedia Cloud Services general discussion and support" <cloud@lists.wikimedia.org>
Betreff: Re: [Cloud] revision.rev_text_id is always 0?
Sorry - that was supposed to be 'show databases' and 'show tables'.
On 1 October 2017 at 05:26, Alex Monk <kren...@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 <anima...@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 <kren...@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 <r...@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
>>
_______________________________________________
Cloud mailing list
Cloud@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/cloud
On 1 October 2017 at 05:26, Alex Monk <kren...@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 <anima...@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 <kren...@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 <r...@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
>>
_______________________________________________
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