User story #2296
closed
Build an update script to change existing eventLog after item renaming
Description
Following #2295, we will need to update the existing events log in database to change from old names to new ones.
That could be done thanks to Postgres XML functions (see: http://www.postgresql.org/docs/9.1/static/xml2.html) or a custom Scala script.
It will be done when the webapp starts, and look for the lowest version of fileFormat in base (see #2363 and #2364). Depending on them, compared to the required fileFormat, the script will update the database.
Updated by François ARMAND almost 13 years ago
- Description updated (diff)
Update requirement.
From an implementation point of view, we are leading to a pure XML update.
Updated by Jonathan CLARKE over 12 years ago
- Target version changed from 2.4.0~alpha6 to 2.4.0~alpha7
Updated by François ARMAND over 12 years ago
- Status changed from New to Pending technical review
- % Done changed from 0 to 100
Applied in changeset e6ae98b06c728ba7ff67405248d3be84abb6bf3b.
Updated by Nicolas CHARLES over 12 years ago
- Status changed from Pending technical review to 10
This looks valid.
I note that some SQL parts are not as expected, but latter commits corrected it ( c27d310cde9d649373cb9924508d5e0120a04ad3 to use temporary table, and b2298b24481c131d01e7c65527d3ada3427b4b19 for restoring timezone in the migration table)