ALTER SHADOW RULE

Description

The ALTER SHADOW RULE syntax is used to alter shadow rule.

Syntax

Grammar Railroad diagram

  1. AlterShadowRule ::=
  2.   'ALTER' 'SHADOW' 'RULE' shadowRuleDefinition (',' shadowRuleDefinition)*
  4. shadowRuleDefinition ::=
  5.   ruleName '(' storageUnitMapping shadowTableRule (',' shadowTableRule)* ')'
  7. storageUnitMapping ::=
  8.   'SOURCE' '=' storageUnitName ',' 'SHADOW' '=' storageUnitName
  10. shadowTableRule ::=
  11.   tableName '(' shadowAlgorithm ')'
  13. shadowAlgorithm ::=
  14.   'TYPE' '(' 'NAME' '=' shadowAlgorithmType ',' propertiesDefinition ')'
  16. ruleName ::=
  17.   identifier
  19. storageUnitName ::=
  20.   identifier
  22. tableName ::=
  23.   identifier
  25. algorithmName ::=
  26.   identifier
  28. shadowAlgorithmType ::=
  29.   string
  31. propertiesDefinition ::=
  32.   'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  34. key ::=
  35.   string
  37. value ::=
  38.   literal

Supplement

  • storageUnitMapping specifies the mapping relationship between the source database and the shadow library. You need to use the storage unit managed by RDL, please refer to STORAGE UNIT;
  • shadowAlgorithm can act on multiple shadowTableRule at the same time;
  • If algorithmName is not specified, it will be automatically generated according to ruleName, tableName and shadowAlgorithmType;
  • shadowAlgorithmType currently supports VALUE_MATCH, REGEX_MATCH and SQL_HINT.

Example

  • Create a shadow rule
  1. ALTER SHADOW RULE shadow_rule(
  2.   SOURCE=demo_ds,
  3.   SHADOW=demo_ds_shadow,
  4.   t_order(TYPE(NAME="SQL_HINT")), 
  5.   t_order_item(TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))
  6. );

Reserved word

ALTER, SHADOW, RULE, SOURCE, SHADOW, TYPE, NAME, PROPERTIES