Page MenuHomePhabricator
Files F15291517

D14061.id33996.diff
No OneTemporary
Actions

D14061.id33996.diff
View Options

diff --git a/resources/sql/autopatches/20150904.herald.1.sql b/resources/sql/autopatches/20150904.herald.1.sql
new file mode 100644
--- /dev/null
+++ b/resources/sql/autopatches/20150904.herald.1.sql
@@ -0,0 +1,52 @@
+/* The "20150730.herald.5.sql" patch incorrectly swapped blocking and
+ non-blocking "Add Reviewer" rules. This swaps back any rules which
+ were last modified before the patch was applied. */
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.blocking.tmp'
+ WHERE a.action = 'differential.reviewers.add'
+ AND r.dateModified <=
+ (SELECT applied FROM {$NAMESPACE}_meta_data.patch_status
+ WHERE patch = 'phabricator:20150730.herald.5.sql');
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.add'
+ WHERE a.action = 'differential.reviewers.blocking'
+ AND r.dateModified <=
+ (SELECT applied FROM {$NAMESPACE}_meta_data.patch_status
+ WHERE patch = 'phabricator:20150730.herald.5.sql');
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.blocking'
+ WHERE a.action = 'differential.reviewers.blocking.tmp';
+
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.self.blocking.tmp'
+ WHERE a.action = 'differential.reviewers.self.add'
+ AND r.dateModified <=
+ (SELECT applied FROM {$NAMESPACE}_meta_data.patch_status
+ WHERE patch = 'phabricator:20150730.herald.5.sql');
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.self.add'
+ WHERE a.action = 'differential.reviewers.self.blocking'
+ AND r.dateModified <=
+ (SELECT applied FROM {$NAMESPACE}_meta_data.patch_status
+ WHERE patch = 'phabricator:20150730.herald.5.sql');
+
+UPDATE {$NAMESPACE}_herald.herald_action a
+ JOIN {$NAMESPACE}_herald.herald_rule r
+ ON a.ruleID = r.id
+ SET a.action = 'differential.reviewers.self.blocking'
+ WHERE a.action = 'differential.reviewers.self.blocking.tmp';

File Metadata

Mime Type
text/plain
Expires
Thu, Mar 6, 12:48 AM (9 h, 5 m ago)
Storage Engine
blob
Storage Format
Encrypted (AES-256-CBC)
Storage Handle
7228187
Default Alt Text
D14061.id33996.diff (2 KB)

Event Timeline

Phabricator · Built by Phacility