Cleanup teams and projects when an account is deleted

[jldec]

Users are reporting not being able to create projects after deleting (and recreating) their Gitpod account.

The New Project repo list will show "already taken" for projects left behind in deleted accounts

This happens because projects under deleted accounts were not cleaned up, preventing re-use of the repositories in those orphan projects.

To Reproduce

• Delete an account which has an existing/working Project.
• Try to create a new Project (under a different account) using the same repo.
• Observe "already taken" for that repo.

Expected Behavior when deleting an account

• Projects under the User account should be deleted
• Teams, and the projects under them, exclusively held by the account should be deleted
• Teams which also have a another owner, should not be deleted

[laushinka]

@jldec I can reproduce. Did we give them a quick fix yet? (The Front link didn't redirect to the specific issue). If not we can mark the projects they need as deleted in the DB as a quick fix.

[laushinka]

/schedule after checking with @jldec

[laushinka]

/schedule

[roboquat]

@laushinka: Issue scheduled in the meta team (WIP: 0)

In response to this:

/schedule

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

[laushinka]

/assign

[laushinka]

• Deleting an account should delete any projects exclusively held by the account
• Projects in teams which also have a another owner, should not be deleted

@jldec Should the teams that they are an owner in, also be deleted?

[laushinka]

@jldec The issue talks about what happens to projects when an account is deleted, but teams are also affected, and when a team is deleted, so are the projects. How about we update this issue to be about what happens to teams and projects when an account is deleted?

[jldec]

@laushinka - good suggestion - thank you!
I have updated the issue title and description.