Deleting test report data

[Thomas Wright]

Hi folks,

I'm running fixmystreet using docker, is there a way I can delete all the test reports I've created while keeping the bodies/categories etc that I've set up?

Thanks,
Tom

[Matthew Somerville]

Hi,

You can mark them as hidden in the admin; to delete them entirely from the system, you can log in to the database however you want (`psql fixmystreet`, or install some form of database admin interface) and delete the rows from the table or truncate the whole table.

Alternatively, you could export the bodies/categories using the bin/export-import-data script, recreate a fresh database, then import the bodies/categories back in.

ATB,
Matthew

[Thomas Wright]

Hi Matthew,

Thanks for the response, if I go the route of installing some kind of web gui like pdAdmin will I need to edit my docker compose yaml to include access external to the docker stack?

Right now it's all standard, apart from a few settings I'm overriding:

https://github.com/ThomasHFWright/fixmystreet/blob/fixmybsresort-cobrand/docker-compose.yml

https://github.com/ThomasHFWright/fixmystreet/blob/fixmybsresort-cobrand/docker-compose.override.yml

[Thomas Wright]

Think I figured it out, I added pgadmin to the same stack as fixmystreet. Thanks for the suggestion Matthew.

https://github.com/ThomasHFWright/fixmystreet/blob/pgadmin/docker-compose.override.yml