This seems like a great idea. And it's possible as a hook for the "drush sql-sanitize" command which also handles "sql-sync".

CommentFileSizeAuthor
#4 2185669-fb-sanitize.patch503 bytescoltrane
fb.drush_.inc_.txt437 bytesgreggles

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Needs review

To use this:

rename it to remove the .txt.
Put it in the fb/ directory.
"drush cc drush"
"drush sql-sanitize"

It will delete the data on whatever db you care about, so don't use lightly.

Dave Cohen’s picture

Dave Cohen commented
Assigned: Unassigned » Dave Cohen
Status: Needs review » Needs work

Agreed this is the way to do it.

I will modify the code to only remove sensitive data and leave other settings intact.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented

I just tested this out and it works.

coltrane’s picture

coltrane
he/him
commented
Status: Needs work » Needs review
StatusFileSize
new 2185669-fb-sanitize.patch503 bytes

Patch deletes applications and only fb__access_token as it looks to be the sensitive FB variable.