Project

General

Profile

Actions

User story #2296

closed

Build an update script to change existing eventLog after item renaming

Added by François ARMAND about 12 years ago. Updated almost 12 years ago.

Status:
Released
Priority:
N/A
Category:
Architecture - Code maintenance
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

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.


Related issues 1 (0 open1 closed)

Blocked by Rudder - Bug #2361: Eventlog not correctly renamedReleasedFrançois ARMAND2012-03-05Actions
Actions #1

Updated by François ARMAND about 12 years ago

  • Description updated (diff)

Update requirement.

From an implementation point of view, we are leading to a pure XML update.

Actions #2

Updated by Jonathan CLARKE almost 12 years ago

  • Target version changed from 2.4.0~alpha6 to 2.4.0~alpha7
Actions #3

Updated by François ARMAND almost 12 years ago

  • Status changed from New to Pending technical review
  • % Done changed from 0 to 100
Actions #4

Updated by Nicolas CHARLES almost 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)

Actions #5

Updated by Jonathan CLARKE almost 12 years ago

  • Status changed from 10 to Released
Actions

Also available in: Atom PDF