summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjthorson2013-06-07 22:55:54 (GMT)
committer Neil Drumm2013-06-07 22:55:54 (GMT)
commit6598e3de390e18557ac8ecf9b8e322205da0d80d (patch)
treeeb1f33d23afc82d1457c9832ac412b1d00a556f7
parente69330bb803c8ead182e7c7e0424e47f5c6d33ca (diff)
[#2014983] Update qa.staging.drupal.org DB snapshot scripts
-rw-r--r--snapshot/drupal_qa.staging.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/snapshot/drupal_qa.staging.sql b/snapshot/drupal_qa.staging.sql
index ab517b5..815f742 100644
--- a/snapshot/drupal_qa.staging.sql
+++ b/snapshot/drupal_qa.staging.sql
@@ -1,2 +1,23 @@
UPDATE comments SET mail = CONCAT(name, '@sanitized.invalid');
DELETE FROM actions WHERE callback = 'pifr_server_notification_email_action';
+
+-- Stop active tests in progress
+UPDATE pifr_test SET status = 4, last_requested = unix_timestamp(), last_tested = unix_timestamp() WHERE test_id IN (SELECT test_id FROM pifr_environment_status);
+
+-- Generate placeholder results for any tests in progress (Note: Will throw 3 warnings!)
+INSERT INTO pifr_result (test_id) SELECT test_id from pifr_environment_status WHERE 1;
+
+-- Datafill placeholder results for any tests in progress
+UPDATE pifr_result pr, pifr_environment_status pes SET pr.environment_id = 1, pr.code = 1, pr.details = 'a:1:{s:7:"@reason";s:43:"Test cancelled by admin prior to completion";}' WHERE pr.test_id = pes.test_id;
+
+-- Clear tests in progress from pifr_environment_status
+DELETE FROM pifr_environment_status WHERE 1;
+
+-- Clear any confirmation tests in progress.
+DELETE FROM pifr_client_test WHERE 1;
+
+-- disable all testbots
+UPDATE pifr_client SET status = 1 WHERE 1;
+
+-- enable staging/dev bots
+UPDATE pifr_client SET status = 4 WHERE client_id IN (973, 988);