It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

GDPR changes for Server - Anonymise Users

Hey Community.


I am considering the effect of this change on Tempo.
We have about 20 database tables to update when userKeys are changed.

From what I see here:


a) I don't see any way of intercepting an event for the update?

b) If there were such an event, would it make sense for one user at a time or all the users?


c) My thinking is that if we get all updated user keys in a single event, we can:

1. Store the user key mappings in a temporary table.
2. Update each database table one at a time with a join to that table (~20 SQL updates).
3. Run all the SQL updates in a single database transaction?
4. Delete the updated users key from the temporary table.
5. Create a UI for users to retry a failed update.
6. Notify users somehow if the app is in an unstable state caused by a `not complete update`.

d) Updating one user at a time will be slower we will need 20XUSER_COUNT SQL updates. I am thinking that is not optimal?

e)  Should Jira be locked while this operation is in progress?



1 comment

I see now this event UserKeyChangedEvent, seems like this will be called per user meaning that we will need to update each user one at a time.


We could save this event to a table and update all together but seems suboptimal.


Is there any good reason to update only one at a time?


Log in or Sign up to comment
Community showcase
Published in Marketplace Apps & Integrations

Cloud Cafe Ep. 1: Getting started with the Atlassian ecosystem

Welcome to Cloud Cafe – our video series about cloud app development on Atlassian. ✨ Ever heard the term Atlassian ecosystem and wondered just exactly what it meant? Grab a cup of ☕ and join ...

50 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you