In the context of https://github.com/gridsuite/report-server/pull/91
We changed the storing logic of reports. Node invalidation delete all network modification and computation reports but not import reports. So we want before deployement, to delete all the reports that will be invalidated anyway and keep only import reports, so that during deploy liquibase migration script can run on import reports. We cannot invalidate the nodes before the deployment because this script is too long, this is why we will run this one beforehand to make liquibase migration work and then we will run node invaliation after deployments to clean the platform with having time constraints on the script run.
In this script, to make it fast, we copy the reports and the severities that concern imports (there are very few 118 in recette and 1992 in production) into temporary tables and then we drop the legacy ones and rename the new ones. It makes the process really fast.
In the context of https://github.com/gridsuite/report-server/pull/91 We changed the storing logic of reports. Node invalidation delete all network modification and computation reports but not import reports. So we want before deployement, to delete all the reports that will be invalidated anyway and keep only import reports, so that during deploy liquibase migration script can run on import reports. We cannot invalidate the nodes before the deployment because this script is too long, this is why we will run this one beforehand to make liquibase migration work and then we will run node invaliation after deployments to clean the platform with having time constraints on the script run.
In this script, to make it fast, we copy the reports and the severities that concern imports (there are very few 118 in recette and 1992 in production) into temporary tables and then we drop the legacy ones and rename the new ones. It makes the process really fast.