399588 - Need to migrate existing bouncer data to use newly supported locales

Status: RESOLVED INVALID

(Webtools :: Bouncer, defect)

Description

[Fred Wenzel [:wenzel]]

We need to run a script, and some SQL (or so) to convert all current entries in the locations table to properly localized entries, one per supported locale.

Comment 1

[Fred Wenzel [:wenzel]]

Attachment: Languages table

This is the languages table, containing the locales from http://lxr.mozilla.org/mozilla/source/browser/locales/all-locales plus en-US.

Comment 2

[Fred Wenzel [:wenzel]]

Attachment: Locations migration SQL

This marks all existing location table entries as en-US, then for each of them creates entries for each other locale too.

Though not all files are present in all locales, this probably won't hurt as they shouldn't be linked anywhere then and they would result in a 404 just as well if they were not present in bouncer at all.

Problem with this: In my tests, the locations table ended up with well over 35.000 entries. I assume this won't harm the bounce speed because it's well indexed (and cached IIRC), but this will make the admin interface in its current form hardly usable.

Comment 3

[Fred Wenzel [:wenzel]]

Justdave: are we using the locale stuff in production? Has this been run / is it not needed anymore?

Comment 4

[Fred Wenzel [:wenzel]]

To answer my own question, this is not in production yet. I'll file a bug to get us on going on deploying the languages patch that's been sitting on bouncer trunk for quite some time now.

Comment 5

[Fred Wenzel [:wenzel]]

This has been rotting away and I merged this SQL into http://github.com/fwenzel/tuxedo/tree/master/sql/ today, with instructions in http://github.com/fwenzel/tuxedo/blob/master/README.md .

We'll need a general "migrate to tuxedo" bug later.