Page MenuHomePhabricator

Write a script to generate fail mail when integrity checks fail
Open, Needs TriagePublic4 Estimated Story Points

Description

We have some integrity checks we have written but not mechanism to run them & ensure they stay clean - e.g send fail-mail if there are contacts with no primary address or blank location types

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 9 2016, 11:45 PM
Eileenmcnaughton set the point value for this task to 4.

Basically 'no information' contacts

select * from civicrm_contact c  LEFT JOIN civicrm_contribution con ON c.id = con.contact_id  LEFT JOIN civicrm_contribution_soft s ON s.contact_id = c.id  LEFT JOIN civicrm_relationship r ON r.contact_id_a  = c.id  LEFT JOIN civicrm_relationship r2 ON r2.contact_id_b  = c.id  LEFT JOIN civicrm_group_contact gc ON gc.contact_id = c.id AND gc.group_id =173 LEFT JOIN civicrm_value_1_prospect_5 v ON v.entity_id = c.id WHERE con.id IS NULL AND s.id IS NULL AND  is_deleted = 0  AND r.id IS NULL AND r2.id IS NULL  AND gc.id IS NULL AND v.id IS NULL ORDER BY c.id DESC LIMIT 5000

Note we should schedule the check from https://phabricator.wikimedia.org/T145873 when we hit this

Eileenmcnaughton renamed this task from Write some integrity check scripts to Write a script to generate fail mail when integrity checks fail.Mar 28 2019, 3:36 AM
Eileenmcnaughton updated the task description. (Show Details)
Aklapper removed Eileenmcnaughton as the assignee of this task.Jun 19 2020, 4:15 PM

This task has been assigned to the same task owner for more than two years. Resetting task assignee due to inactivity, to decrease task cookie-licking and to get a slightly more realistic overview of plans. Please feel free to assign this task to yourself again if you still realistically work or plan to work on this task - it would be welcome!

For tips how to manage individual work in Phabricator (noisy notifications, lists of task, etc.), see https://phabricator.wikimedia.org/T228575#6237124 for available options.
(For the records, two emails were sent to assignee addresses before resetting assignees. See T228575 for more info and for potential feedback. Thanks!)