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