activity-browser icon indicating copy to clipboard operation
activity-browser copied to clipboard

Activity parameter group not deleting properly with database

Open MaximeAgez opened this issue 3 years ago • 0 comments

Seems like the group_table table of the parameters.db database is not reset properly when deleting a database through AB.

To replicate:

  • Make an empty "test" database (only biosphere in there)
  • Create a "testing" database with a single "test_act" activity in these where there are activity parameters used and also simple formula used (as shown below)

image

  • Delete the testing database through AB
  • Go check the group_table table of the parameters.db database. The test_act_... group previously created for the calculation of formulas in test_act is still there:

image

I think not having it erased alongside the database creates issues when re-downloading databases through Excel (I'm not 100% sure though), because only one group of activity parameters can exist per activity.

MaximeAgez avatar Aug 02 '22 14:08 MaximeAgez