Skip to content
  1. Aug 24, 2012
    • Rene Saarsoo's avatar
      e837a5c8
    • Rene Saarsoo's avatar
      Turn boolean fields into BOOLEAN data type. · 42789ecb
      Rene Saarsoo authored
      Add conversion to change JavaScript booleans into 0 and 1 for MySQL.
      42789ecb
    • Rene Saarsoo's avatar
      a7c9594d
    • Rene Saarsoo's avatar
      Loading of e-mail and moderator status. · 4b488fc2
      Rene Saarsoo authored
      For each user retrieve e-mail and determine if he's a moderator.
      
      Removed the email_hash field from users table - a premature
      optimization, we can calculate it on the fly which should be fast enough
      as it's a simple md5, and it's only needed for displaying comments.
      4b488fc2
    • Rene Saarsoo's avatar
      Add building of readings table data. · 7999a564
      Rene Saarsoo authored
      Rename read_comments table to readings.
      
      Extract readings info from mongo_metas.
      7999a564
    • Rene Saarsoo's avatar
      Add building of subscriptions table data. · 75ea8f68
      Rene Saarsoo authored
      Some users have subscribed without having commented or voted.  This
      added additional complexities as subscription db in mongo lists users by
      external_id unlike all other tables which list the username... oh crap.
      
      Refactored things around considerably.  Mongo comments and subscriptions
      are now loaded up front, so all following procedures can operate on
      them.  Added lots of messy logic into UsersTable, building an additional
      index by external_id and looking up usernames from Sencha Forum db by
      external_id. Thankfully it's a throw-away script, as the resulting code
      is quite fragile and messy.
      
      Also found one user who had subscribed bot no more has an entry in
      Sencha Forum database.  Going to throw away his 3 subscriptions.
      75ea8f68
  2. Aug 23, 2012
  3. Aug 22, 2012
  4. Aug 21, 2012
Loading