User:Rhelmer/Socorro Postcrash Email Testing/User:Rhelmer/Socorro Postcrash Email Testing/bug 612596

From MozillaWiki
Jump to: navigation, search

Setup

 breakpad=> select id from reports where product = 'Firefox' and version = '4.0b12' limit 10;
     id
 -----------
 247482189
 247482376
 247482442
 247483162
 247482800
 247482343
 247482234
 247482232
 247482041
 247482502
(10 rows)
breakpad=> update reports set signature='test1', email =  where id in (select id from reports where product = 'Firefox' and version = '4.0b12' limit 10);
 UPDATE 10
 breakpad=> update reports set email = '(test email 1...)' where id = '225058458';
 UPDATE 1

Repeat above, inserting 4 unique test emails throughout 10 crashes.

breakpad=> select min(date_processed),max(date_processed) from reports where signature='test1';
            min            |            max             
---------------------------+----------------------------
 2011-04-25 00:00:01.40031 | 2011-04-25 00:05:29.743063
(1 row)


QA Test

Campaign creation

 https://crash-stats-dev.allizom.org/admin/email
 Product: Firefox
 Exact Signature: test1
 Version: 4.0b12
 Start Date: 25/02/2011
 End Date: 01/06/2011
 Clicked Next
 Confirm Email                           
 Sending this email will contact 3 Firefox 4.0b12 users who crashed on test1 between 25/02/2011 and 01/06/2011
          
 Subject:
 test email, please ignore
          
 Email Body:
 Test email, please ignore
 *|UNSUBSCRIBE_URL|*
 *|CRASH_DATE|*
 *|CRASH_URL|*