In a member driven environment I offer to the members the opportunity to delete part of or their whole account
The process is quite involving
Deleting/updating/inserting in six tables
Opening and deleting from a video repository
Opening and deleting from an img gallery
As is it works fine
But I am very concerned by any potential glitches that will half way delete the account and leave me with a mess
So I am wondering if my new sight on the logic is fine or if you have a better way of dealing with it.
Before deleting, create a temp table and load data as those to be soon deleted
Copy img and video in a temp
If all systems go then del all temps
If not go back to what failed and reload, while sending detailed message to the site admin
The process is quite involving
Deleting/updating/inserting in six tables
Opening and deleting from a video repository
Opening and deleting from an img gallery
As is it works fine
But I am very concerned by any potential glitches that will half way delete the account and leave me with a mess
So I am wondering if my new sight on the logic is fine or if you have a better way of dealing with it.
Before deleting, create a temp table and load data as those to be soon deleted
Copy img and video in a temp
If all systems go then del all temps
If not go back to what failed and reload, while sending detailed message to the site admin