StringTemplate.Context refdata should be internal

Overview:

It should not be possible to delete values from the StringTemplate.Context refdata category in agreements

Steps to Reproduce:

1. Got to Settings -> Agreements -> Pick list values

2. Select StringTemplate.Context  in pick list drop down

3. See that the values display with a trashcan icon

Expected Results:

No trashcan icon

Should be controlled with `@CategoryId(defaultInternal=true)` on the reference data category. Migration may also be needed to fix existing instances

Dev task breakdown

This is a multi step process:

1. Change domain class to make use of defaultInternal

2. Ensure we have no missing data:

   • Write migration for all missing entries (should be at most 2, unless something really funky has gone on)

   • Something like:

     changeSet(author: "efreestone (manual)", id: "20210922-1534-002") { grailsChange { change { sql.eachRow(""" SELECT DISTINCT strt_context FROM ${database.defaultSchemaName}.string_template INNER JOIN ${database.defaultSchemaName}.refdata_value ON string_template.strt_context = refdata_value.rdv_id WHERE NOT EXISTS ( SELECT rdv_id FROM ${database.defaultSchemaName}.refdata_value WHERE rdv_id = strt_context )""".toString() ) { def row -> sql.execute(""" INSERT INTO ${database.defaultSchemaName}.refdata_value (rdv_id, rdv_version, rdv_value, rdv_owner, rdv_label) ${row.strt_context} as id, 0 as version, 'missing_context_${row.strt_context}' as value,          ( SELECT rdc_id FROM ${database.defaultSchemaName}.refdata_category WHERE rdc_description='StringTemplate.Context' ) as owner,          'Missing context ${row.strt_context}' as label """.toString()) } } } }

•  

  • This SQL and closure need testing, as I've written it without double checking it works. The top part should find all StringTemplate contexts which do not exist as refdata values, then pass those to the Closure below as "row", where we can use that in a different SQL query to insert a new refdata value with that id.

1. In this case (Not necessarily always true) we went from String -> refdata, so we should add a migration changing the column type from VARCHAR(255) to VARCHAR(36)

2. Add migration for foreign key constraint

3. Add migration changing defaultInternal to true for the refdata category