Add a project deletion/undeletion function(ality)

[pbchase]

We need a project deletion function that implements REDCap's normal "soft deletion" as implemented in REDCap's ProjectGeneral/delete_project.php. That process makes three changes:

$sql = "update redcap_projects set date_deleted = '".NOW."'
	     where project_id = $project_id and date_deleted is null";
...
ToDoList::updateTodoStatus($project_id, 'delete project','completed');
...
Logging::logEvent($sql,"redcap_projects","MANAGE",PROJECT_ID,"project_id = ".PROJECT_ID,"Delete project");

It's not clear to me what the best approach would be. We could write an R function that makes the database changes above. We could write an external module that adds an API method to delete projects with a super token. We could include a portion of REDCap code and call that using and external call to command line PHP.

What do you think we should do?

[ChemiKyle]

I think an R function is easiest. IIRC the project deletion process in REDCap backend is just setting that date_deleted column so until they add something fancier we should take the KISS option of just doing the same thing.

[pbchase]

... IIRC the project deletion process in REDCap backend is just setting that date_deleted column so until they add something fancier we should take the KISS option of just doing the same thing.

The backend also calls ToDoList::updateTodoStatus and Logging::logEvent

[pbchase]

I asked the community if they wrote us an API extension: https://community.projectredcap.org/questions/133969/is-there-a-project-deletion-api-extension.html

[pbchase]

We probably wouldn't need to call or emulate ToDoList::updateTodoStatus as this is outside the ToDoList

[ChemiKyle]

I'm also going to add an un-delete function. These might end up as a PR to redcapcustodian since they're generically useful.

[pbchase]

Putting the delete/undelete functionality in REDCapCustodian makes lots of sense.

[pbchase]

@pbchase moved this to a REDCap custodian issue. As such, this issue can be closed