Project

General

Profile

task #6535

MetaDataPropertyName from number to string in DB

Added by Andreas Müller over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Highest
Category:
cdm
Target version:
Start date:
03/23/2017
Due date:
% Done:

50%

Severity:
normal

Description

MetaDataPropertyName is stored as number in CdmMetaData. We use string for TermType at other places and should do so here, too. This allows reordering the enum.


Related issues

Related to Edit - task #6699: Delete term version from CdmMetaData Closed 12/17/2014

Associated revisions

Revision cfe723e5 (diff)
Added by Andreas Müller over 1 year ago

fix #6535 change CdmMetaData.propertyName from int to string

Revision 440d74a5 (diff)
Added by Andreas Müller over 1 year ago

fix #6535 change CdmMetaData.propertyName from int to string, adapt test schema and test

Revision aabdc3fa (diff)
Added by Andreas Müller over 1 year ago

ref #6535 add quotation marks for hardcoded SQL propertyname parameter

Revision 6740eed5 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 adapt TaxEdtior to new CdmMetaDataPropertyName

Revision 3c533966 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 final adaptations to CdmMetaDataPropertyName in taxEditor

Revision 126e4675 (diff)
Added by Andreas Müller over 1 year ago

ref #6258, #6535, #3734 some updates to CdmUpdater after checking against H2

Revision f2652c39 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix update script for renaming CdmMetaData.propertyName and remove old column

Revision 730d4da6 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix strange bug in SQL that reads all records from CdmMetaData for propertyname = 0

Revision 825e3afb (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix calls to version number from other places

Revision 2c71b889 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix updated test H2 in cdmlib

Revision a7b9fdeb (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix updated test H2 in vaadin

Revision 5d0eae58 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix updated test H2 in taxeditor

Revision 6a88d3e5 (diff)
Added by Andreas Müller over 1 year ago

ref #6535 fix updated test H2 in taxeditor

History

#1 Updated by Andreas Müller over 1 year ago

  • Tracker changed from bug to task

#2 Updated by Andreas Müller over 1 year ago

  • Status changed from New to In Progress

#3 Updated by Andreas Müller over 1 year ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50

#4 Updated by Andreas Müller over 1 year ago

  • Related to task #6699: Delete term version from CdmMetaData added

#5 Updated by Andreas Müller over 1 year ago

Update script for incorrect update

UPDATE CdmMetaData SET PropertyName = 'TERM_VERSION' WHERE PropertyNameOld = 0;

UPDATE CdmMetaData SET PropertyName = 'SCHEMA_VERSION' WHERE PropertyNameOld = 1;

UPDATE CdmMetaData SET PropertyName = 'CREATED' WHERE PropertyNameOld = 2;

ALTER TABLE CdmMetaData  DROP COLUMN PropertyNameOld ;

#6 Updated by Andreas Müller over 1 year ago

Finally this should be fixed now.

#7 Updated by Andreas Müller over 1 year ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)