<?php

$table = new PhabricatorUserPreferences();
$conn_w = $table->establishConnection('w');
// Convert "Mail Format", "Re Prefix" and "Vary Subjects" mail settings to
// string constants to avoid weird stuff where we store "true" and "false" as
// strings in the database.
// Each of these keys will be converted to the first value if present and
// truthy, or the second value if present and falsey.
$remap = array('html-emails' => array('html', 'text'), 're-prefix' => array('re', 'none'), 'vary-subject' => array('vary', 'static'));
foreach (new LiskMigrationIterator($table) as $row) {
    $dict = $row->getPreferences();
    $should_update = false;
    foreach ($remap as $key => $value) {
        if (isset($dict[$key])) {
            if ($dict[$key]) {
                $dict[$key] = $value[0];
            } else {
                $dict[$key] = $value[1];
            }
            $should_update = true;
        }
    }
    if (!$should_update) {
        continue;
    }
    queryfx($conn_w, 'UPDATE %T SET preferences = %s WHERE id = %d', $table->getTableName(), phutil_json_encode($dict), $row->getID());
}
$prefs_key = PhabricatorUserPreferencesCacheType::KEY_PREFERENCES;
PhabricatorUserCache::clearCacheForAllUsers($prefs_key);
 protected function applyFinalEffects(PhabricatorLiskDAO $object, array $xactions)
 {
     $user_phid = $object->getUserPHID();
     if ($user_phid) {
         PhabricatorUserCache::clearCache(PhabricatorUserPreferencesCacheType::KEY_PREFERENCES, $user_phid);
     } else {
         PhabricatorUserCache::clearCacheForAllUsers(PhabricatorUserPreferencesCacheType::KEY_PREFERENCES);
     }
     return $xactions;
 }