Differential D16005 Diff 38527 resources/sql/autopatches/20160601.user.02.copyprefs.php

Changeset View

Standalone View

				<?php

				// Move timezone, translation and pronoun from the user object to preferences
				// so they can be defaulted and edited like other settings.

				$table = new PhabricatorUser();
				$conn_w = $table->establishConnection('w');
				$table_name = $table->getTableName();
				$prefs_table = new PhabricatorUserPreferences();

				foreach (new LiskRawMigrationIterator($conn_w, $table_name) as $row) {
				$phid = $row['phid'];

				$pref_row = queryfx_one(
				$conn_w,
				'SELECT preferences FROM %T WHERE userPHID = %s',
				$prefs_table->getTableName(),
				$phid);

				if ($pref_row) {
				try {
				$prefs = phutil_json_decode($pref_row['preferences']);
				} catch (Exception $ex) {
				$prefs = array();
				}
				} else {
				$prefs = array();
				}

				$zone = $row['timezoneIdentifier'];
				if (strlen($zone)) {
				$prefs[PhabricatorTimezoneSetting::SETTINGKEY] = $zone;
				}

				$pronoun = $row['sex'];
				if (strlen($pronoun)) {
				$prefs[PhabricatorPronounSetting::SETTINGKEY] = $pronoun;
				}

				$translation = $row['translation'];
				if (strlen($translation)) {
				$prefs[PhabricatorTranslationSetting::SETTINGKEY] = $translation;
				}

				if ($prefs) {
				queryfx(
				$conn_w,
				'INSERT INTO %T (phid, userPHID, preferences, dateModified, dateCreated)
				VALUES (%s, %s, %s, UNIX_TIMESTAMP(), UNIX_TIMESTAMP())
				ON DUPLICATE KEY UPDATE preferences = VALUES(preferences)',
				$prefs_table->getTableName(),
				$prefs_table->generatePHID(),
				$phid,
				phutil_json_encode($prefs));
				}
				}

				$prefs_key = PhabricatorUserPreferencesCacheType::KEY_PREFERENCES;
				PhabricatorUserCache::clearCacheForAllUsers($prefs_key);