User:Rhelmer/Socorro Postcrash Email Testing/User:Rhelmer/Socorro Postcrash Email Testing/bug 612596
From MozillaWiki
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|*