Bogus accounts in patchwork

Jeremy Kerr jk at ozlabs.org
Wed May 7 13:11:02 EST 2014


Hi all,

> DELETE FROM patchwork_person WHERE id NOT IN (
> 	SELECT submitter_id FROM patchwork_patch
> 	UNION
> 	SELECT submitter_id FROM patchwork_comment

Make that:

DELETE FROM patchwork_person WHERE id NOT IN (
	SELECT submitter_id FROM patchwork_patch
	UNION
 	SELECT submitter_id FROM patchwork_comment)
    AND user_id IS NULL;

- so we retain linkages for folks that haven't submitted a patch or comment.

Cheers,


Jeremy




More information about the Patchwork mailing list