annotate gpp/legacy/data.py @ 388:c3231af55778

For #191; r410 is wrong: it is returning the wrong posts. Rework. MySQL is not using an index on our query, and it is taking 10+ seconds. Replace this slow query with a loop that loops over the public forums, then sorts and returns the posts.
author Brian Neal <bgneal@gmail.com>
date Sat, 19 Mar 2011 05:03:51 +0000
parents 2367c4795c92
children 4021ea1045f7
rev   line source
bgneal@292 1 """
bgneal@292 2 Misc data for the legacy management commands.
bgneal@292 3
bgneal@292 4 """
bgneal@292 5
bgneal@292 6 # Over time various users asked me to change their username. The legacy site
bgneal@292 7 # rarely stored foreign keys to users; instead it stored the name of the user
bgneal@292 8 # at the time. This dictionary contains mappings from old usernames to new
bgneal@292 9 # usernames.
bgneal@292 10
bgneal@292 11 KNOWN_USERNAME_CHANGES = {
bgneal@292 12 'cavefishbutchdelux': 'butchdelux',
bgneal@292 13 'Findicator1': 'WaveOhhh',
bgneal@292 14 'Tikimania': 'Tikitena',
bgneal@292 15 'sandyfeet': 'RickRhoades',
bgneal@292 16 }
bgneal@292 17