Project

General

Profile

Actions

User story #2253

closed

Automatically update the SQL schema on upgrade from to 2.4 (extra column in policyInstances and groups tables)

Added by Jonathan CLARKE about 12 years ago. Updated about 9 years ago.

Status:
Released
Priority:
2
Assignee:
Matthieu CERDA
Category:
Packaging
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

After #2012 and #2143 we will need to add two new columns to SQL tables that historize group and PT names.

This will need to be implemented in the migration script, in particular:

  • Check if column for group type exists, and add if not
  • Check if column for PT name exists and if not:
    • Add the column
    • Run a script to fetch all existing lines in the table and add in the PT name, after searching for it in the /var/rudder/configuration-rules/policy-templates repository

Files

dbMigration.sql (2.04 KB) dbMigration.sql Nicolas CHARLES, 2012-02-09 10:33
rudder-upgrade-database-2.3-2.4-PT-names.pl (1.39 KB) rudder-upgrade-database-2.3-2.4-PT-names.pl Jonathan CLARKE, 2012-02-15 10:41

Related issues 2 (0 open2 closed)

Follows Rudder - Architecture #2012: The historization of the group doesn't store if the group is static or dynamicReleasedNicolas CHARLES2011-11-08Actions
Follows Rudder - Architecture #2143: Historize human readable name of PTReleasedNicolas CHARLES2011-12-23Actions
Actions

Also available in: Atom PDF