Page MenuHomestyx hydra
Files F83631

No OneTemporary
Actions

View Options

diff --git a/resources/sql/autopatches/20150904.herald.1.sql b/resources/sql/autopatches/20150904.herald.1.sql
new file mode 100644
index 0000000000..17f945cc30
--- /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/x-diff
Expires
Sun, Mar 16, 3:37 AM (1 d, 8 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
72135
Default Alt Text
(2 KB)

Event Timeline

styx copyright 2020 sirocyl / ellie (kymkdd) / ncommander / styx contributors
Use of other names and brands is not intended to reflect a claim of, or right to, use the name or brand.
styx is an operating system using the Linux kernel and components, and "styx Linux" as a phrase does not reflect the inclusion of the Linux brand or trademark in the styx project.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Terms and Conditions (TODO: fix this!)