Easiest way to clean up a FHIR database?

Question

Question

Dmitrii Baranov · Feb 23, 2023

#FHIR #SQL #InterSystems IRIS for Health

Hi, what is the easiest way to clear all the tables which store FHIR data? The most straitforward approach is to get a list of tables using the information_schema.tables view, then execute dynamic SQL with the "delete from" clause, but perhaps some helper class has already been written for this purpose?

Product version: IRIS 2022.3

Discussion (6)3

Log in or sign up to continue

Patrick Jamieson · Feb 23, 2023

Great question. We routinely need to do this in our internal testing. To clean out your repo, use the following commands at the IRIS terminal:

Set strategy = ##class(HS.FHIRServer.API.InteractionsStrategy).GetStrategyForEndpoint(appKey)
Set options("deleteDataOnly") = 1
Do strategy.Delete(.options)

The FHIR Server config page should have your app key.

Good luck.

4 1

score 0 · Answer 1 · 2023-02-23T15:32:45-05:00

Dmitrii Baranov · Feb 23, 2023

Great answer! And yes, I badly need that for testing!

0 0

score 0 · Answer 2 · 2023-08-11T10:53:51-04:00

For those who wants to purge it regularly on a test environment, you can use this task definition based on this method.

score 0 · Answer 3 · 2024-03-12T03:53:48-04:00

Benny Shtemer · Mar 12

is it possible to delete all resources of a specific type?

0 0

score 0 · Answer 4 · 2023-08-15T08:08:27-04:00

If this is for testing I'd suggest to use iris docker container with FHIR db inside. So just container relaunch will do the thing.

score 1 · Answer 5 · 2023-08-16T03:35:08-04:00

The use of docker obviously simplifies the solution to the problem and completely meets the need.
However, sometimes our customers don't use docker, even in their dev/test or staging environments.