On Thu, Nov 19, 2015 at 3:44 AM, Jaime Crespo <[email protected]> wrote:
> On Thu, Nov 19, 2015 at 12:26 PM, Yetkin Sakal <[email protected]> > wrote: > >> Are namespaces stored in replica databases? How can we link the >> page_namespae column in the page table to retrieve the full page name? >> > > The name of the column is not stored on the database (neither on labs dbs > nor in production). There is not such a thing as a canonical name for > namespaces, but you can go to > There are such things as canonical namespaces, they're the english translations. The code is littered with instances of this. But otherwise you're right, we don't store the names in the databases, they're by number. > a) the source code of mediawiki for the predefined names and its > translations to each language > For core namespaces, you can check out Defines.php which will clearly give you the number -> name match. > b) our custoom/publicly available configuration for custom names/namespaces > < > https://github.com/wikimedia/operations-mediawiki-config/blob/master/wmf-config/InitialiseSettings.php#L1947 > > > > Please note that the same page/namespace can redirect to different names, > depending on the local language: > e.g. https://es.wikipedia.org/wiki/Talk:Portada redirects to > https://es.wikipedia.org/wiki/Discusi%C3%B3n:Portada. > > I'll also add api.php, which can easily give you this for any wiki. For example: https://es.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces|namespacealiases This is probably your best bet, actually. -Chad
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
