Project

General

Profile

Actions

Architecture #2143

closed

Historize human readable name of PT

Added by François ARMAND almost 13 years ago. Updated almost 13 years ago.

Status:
Released
Priority:
2
Category:
Web - Compliance & node report
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

For now, the human readable name of a PT is not historized and so we have to rely on its ID, what is not what we would like to display to an human.

A couple of things to take into consideration for this user story:
  • We will need a new database initialization script (.sql) that includes the new column in the initial table creation
  • We will also need a database migration script (.sql) that just adds the new column to an existing database
  • The database schema and any code reading or writing this column should bear in mind that there probably will be some old data which doesn't have a value for this column

Related issues 1 (0 open1 closed)

Precedes Rudder - User story #2253: Automatically update the SQL schema on upgrade from to 2.4 (extra column in policyInstances and groups tables)ReleasedMatthieu CERDA2012-02-09Actions
Actions #1

Updated by François ARMAND almost 13 years ago

  • Target version changed from 2.4.0~alpha2 to 2.4.0~alpha3
Actions #2

Updated by Jonathan CLARKE almost 13 years ago

  • Target version changed from 2.4.0~alpha3 to 2.4.0~alpha4
Actions #3

Updated by François ARMAND almost 13 years ago

  • Target version changed from 2.4.0~alpha4 to 2.4.0~alpha5
Actions #4

Updated by Jonathan CLARKE almost 13 years ago

  • Description updated (diff)
  • Status changed from New to 2
Actions #5

Updated by Jonathan CLARKE almost 13 years ago

  • Assignee set to Nicolas CHARLES
  • Priority changed from 3 to 2

We decided on a simpler approach: given that no PT names have ever changed yet in the history of Rudder, we will just initialize the new column with current names. See #2253 for the task to build this migration script.

Actions #6

Updated by Nicolas CHARLES almost 13 years ago

  • Status changed from 2 to Pending technical review
  • % Done changed from 0 to 100
Actions #7

Updated by François ARMAND almost 13 years ago

  • Status changed from Pending technical review to 10

Tech review ok (and simple :)

Actions #8

Updated by Jonathan CLARKE almost 13 years ago

  • Tracker changed from User story to Architecture
  • Status changed from 10 to Released

This is an architecture issue, no functional review required.

Actions

Also available in: Atom PDF