Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove member ID #UES6AJ7JQ #49

Open
trismit opened this issue Mar 22, 2022 · 2 comments
Open

Remove member ID #UES6AJ7JQ #49

trismit opened this issue Mar 22, 2022 · 2 comments
Labels
🟢 Ready for review Ready for review ⛔ Data deletion request Data deletion request

Comments

@trismit
Copy link

trismit commented Mar 22, 2022

Thank you!

@zacstewart zacstewart added the 🚧 In progress Work in orogress label Mar 23, 2022
@zacstewart
Copy link
Owner

I've added support for opting out users and applied it to yours. Going forward, indexbot will not update your name, real name, or profile pic, and any messages from you will be recorded as "[redacted]".

This doesn't yet redact your profile data and historic messages, but I will be creating a new PR to handle that soon.

Please enter the user's ID (It looks like U03H0B61B)
> UES6AJ7JQ
A, [2022-03-23T03:12:44.851087 #4]   ANY -- : 2022-03-23 03:12:44 +0000 severity=INFO, (0.001287s) BEGIN
A, [2022-03-23T03:12:44.853240 #4]   ANY -- : 2022-03-23 03:12:44 +0000 severity=INFO, (0.001730s) SELECT CAST(current_setting('server_version_num') AS integer) AS v
A, [2022-03-23T03:12:44.856682 #4]   ANY -- : 2022-03-23 03:12:44 +0000 severity=INFO, (0.002802s) SELECT * FROM "users" WHERE ("id" = 'UES6AJ7JQ') LIMIT 1
{:id=>"UES6AJ7JQ",
 :name=>"thetrishasmith",
 :real_name=>"trish reynolds",
 :image=>
  "https://avatars.slack-edge.com/2021-12-03/2790985376966_3c69dcad5ad4971c95cd_48.jpg",
 :opted_out=>false}
Are you sure you want to opt this user out? [Y/n] y
A, [2022-03-23T03:12:53.874134 #4]   ANY -- : 2022-03-23 03:12:53 +0000 severity=INFO, (0.001832s) UPDATE "users" SET "opted_out" = true WHERE ("id" = 'UES6AJ7JQ')
User has been opted out.
A, [2022-03-23T03:12:53.876459 #4]   ANY -- : 2022-03-23 03:12:53 +0000 severity=INFO, (0.001887s) COMMIT

@zacstewart zacstewart added the ⛔ Data deletion request Data deletion request label Apr 2, 2022
@zacstewart
Copy link
Owner

I finished up the historic message redactor task and ran it for your account. Your profile information has been blanked out and all 4399 messages redacted. You can verify results by searching your user id here.

Note that this does not alter chat logs from any other users who may have said your name, however, in cases where people used Slack's @mention to mention you, it will now appear as @[deleted], because the chat log actually stores your user id and not the username, and I replace it with current username at page render time.

If this satisfies your request, please close the ticket. If not, please let me know what else I can do.

Please enter the user's ID (It looks like U03H0B61B)
> UES6AJ7JQ
A, [2022-04-02T10:17:44.972276 #4]   ANY -- : 2022-04-02 10:17:44 +0000 severity=INFO, (0.000828s) BEGIN
A, [2022-04-02T10:17:44.974256 #4]   ANY -- : 2022-04-02 10:17:44 +0000 severity=INFO, (0.001629s) SELECT CAST(current_setting('server_version_num') AS integer) AS v
A, [2022-04-02T10:17:44.978291 #4]   ANY -- : 2022-04-02 10:17:44 +0000 severity=INFO, (0.003605s) SELECT * FROM "users" WHERE ("id" = 'UES6AJ7JQ') LIMIT 1
{:id=>"UES6AJ7JQ",
 :name=>"thetrishasmith",
 :real_name=>"trish reynolds",
 :image=>
  "https://avatars.slack-edge.com/2021-12-03/2790985376966_3c69dcad5ad4971c95cd_48.jpg",
 :opted_out=>true}
A, [2022-04-02T10:17:45.080127 #4]   ANY -- : 2022-04-02 10:17:45 +0000 severity=INFO, (0.100816s) SELECT count(*) AS "count" FROM "messages" WHERE ("user_id" = 'UES6AJ7JQ') LIMIT 1
4399 messages
Are you sure you want to redact this user? [Y/n] y
A, [2022-04-02T10:18:33.752800 #4]   ANY -- : 2022-04-02 10:18:33 +0000 severity=INFO, (0.001400s) UPDATE "users" SET "name" = '[deleted]', "real_name" = '[deleted]', "image" = '/deleted-user.png' WHERE ("id" = 'UES6AJ7JQ')
A, [2022-04-02T10:18:33.946661 #4]   ANY -- : 2022-04-02 10:18:33 +0000 severity=INFO, (0.193533s) UPDATE "messages" SET "text" = '[redacted]' WHERE ("user_id" = 'UES6AJ7JQ')
A, [2022-04-02T10:18:33.991132 #4]   ANY -- : 2022-04-02 10:18:33 +0000 severity=INFO, (0.044157s) COMMIT

@zacstewart zacstewart added 🟢 Ready for review Ready for review and removed 🚧 In progress Work in orogress labels Apr 2, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🟢 Ready for review Ready for review ⛔ Data deletion request Data deletion request
Projects
None yet
Development

No branches or pull requests

2 participants