Need sanitisation script for production database

[Tom Haddon]

We need a script that can sanitise the production database so that we can allow developers to have access to a "production data set" for testing.

[Diogo Matsubara (matsubara)]

Hi Tom, we have one already in lib/lp/scripts/utilities/sanitizedb.py. Does that cover your use case?

[Tom Haddon (mthaddon)]

Wow, we've been looking for one of these for a while now - can you confirm how it's run? Can we do this before loading into the staging DB?

[Diogo Matsubara (matsubara)]

Hi Tom, there's a test in lib/lp/scripts/utilities/tests/test_sanitizedb.py but that doesn't make things much clearer. Stuart is doing test runs for this script and knows more details about its functionality. Do you mind if I close this bug report, since the script is already in trunk?

[Tom Haddon (mthaddon)]

I'd rather we wait til it's confirmed to be working, if that's okay.

[Diogo Matsubara (matsubara)]

Moving to foundations and assigning to Stuart. Stuart, once you have a complete run of the sanitisation script, could you please report back and close this bug?
Thanks

[Stuart Bishop (stub)]

Test run completed. Final set of patches currently in review.