FHIR Chat · How to remove all the test data in the HAPI FHIR JPA's da... · hapi

Stream: hapi

Topic: How to remove all the test data in the HAPI FHIR JPA's da...


view this post on Zulip Lin Zhang (Oct 07 2020 at 04:21):

Is there any simple command to do it? Thanks.

view this post on Zulip Joel Schneider (Oct 08 2020 at 04:18):

Maybe use SQL to drop the database and create a new, empty one. E.g. while logged in to an interactive SQL session, DROP DATABASE XYZ followed by CREATE DATABASE XYZ.

view this post on Zulip Lin Zhang (Oct 08 2020 at 05:35):

@Joel Schneider Thanks.

view this post on Zulip Jens Villadsen (Oct 08 2020 at 07:53):

@Lin Zhang given that all the data in your server is test data, then what @Joel Schneider describes is correct. @Joel Schneider instructions does not take into account what data is production data and what is test data

view this post on Zulip Lin Zhang (Oct 08 2020 at 10:00):

@Jens Villadsen That's right. Thanks.

view this post on Zulip Lin Zhang (Oct 08 2020 at 14:08):

@Joel Schneider Truncate the tables (CASCADE) and Alter the sequences (restart with 1), then it can restart from fresh.


Last updated: Apr 12 2022 at 19:14 UTC