Shadow

Syntax

  1. CREATE SHADOW RULE shadowRuleDefinition [, shadowRuleDefinition] ... 
  3. ALTER SHADOW RULE shadowRuleDefinition [, shadowRuleDefinition] ... 
  5. CREATE SHADOW ALGORITHM shadowAlgorithm [, shadowAlgorithm] ...
  7. ALTER SHADOW ALGORITHM shadowAlgorithm [, shadowAlgorithm] ...
  9. DROP SHADOW RULE ruleName [, ruleName] ...
  11. DROP SHADOW ALGORITHM algorithmName [, algorithmName] ...
  13. CREATE DEFAULT SHADOW ALGORITHM NAME = algorithmName
  15. shadowRuleDefinition: ruleName(resourceMapping, shadowTableRule [, shadowTableRule] ...)
  17. resourceMapping: SOURCE=resourceName, SHADOW=resourceName
  19. shadowTableRule: tableName(shadowAlgorithm [, shadowAlgorithm] ...)
  21. shadowAlgorithm: ([algorithmName, ] TYPE(NAME=shadowAlgorithmType, PROPERTIES([algorithmProperties] ...)))
  23. algorithmProperties: algorithmProperty [, algorithmProperty] ... 
  25. algorithmProperty: key=value

Parameters Explained

nameDateTypeDescription
ruleNameIDENTIFIERRule name
resourceNameIDENTIFIERResource name
tableNameIDENTIFIERShadow table name
algorithmNameIDENTIFIERShadow algorithm name
shadowAlgorithmTypeSTRINGShadow algorithm type

Notes

  • Duplicate ruleName cannot be created
  • resourceMapping specifies the mapping relationship between the source database and the shadow library. You need to use the resource managed by RDL, please refer to resource
  • 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 SIMPLE_HINT
  • shadowTableRule can be reused by different shadowRuleDefinition, so when executing DROP SHADOW RULE, the corresponding shadowTableRule will not be removed
  • shadowAlgorithm can be reused by different shadowTableRule, so when executing ALTER SHADOW RULE, the corresponding shadowAlgorithm will not be removed

Example

  1. CREATE SHADOW RULE shadow_rule(
  2. SOURCE=demo_ds,
  3. SHADOW=demo_ds_shadow,
  4. t_order((simple_hint_algorithm, TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))),(TYPE(NAME="REGEX_MATCH", PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]')))), 
  5. t_order_item((TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))));
  7. ALTER SHADOW RULE shadow_rule(
  8. SOURCE=demo_ds,
  9. SHADOW=demo_ds_shadow,
  10. t_order((simple_hint_algorithm, TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))),(TYPE(NAME="REGEX_MATCH", PROPERTIES("operation"="insert","column"="user_id", "regex"='[1]')))), 
  11. t_order_item((TYPE(NAME="VALUE_MATCH", PROPERTIES("operation"="insert","column"="user_id", "value"='1')))));
  13. CREATE SHADOW ALGORITHM 
  14. (simple_hint_algorithm, TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="true", "foo"="bar"))), 
  15. (user_id_match_algorithm, TYPE(NAME="REGEX_MATCH",PROPERTIES("operation"="insert", "column"="user_id", "regex"='[1]')));
  18. ALTER SHADOW ALGORITHM 
  19. (simple_hint_algorithm, TYPE(NAME="SIMPLE_HINT", PROPERTIES("shadow"="false", "foo"="bar"))), 
  20. (user_id_match_algorithm, TYPE(NAME="VALUE_MATCH",PROPERTIES("operation"="insert", "column"="user_id", "value"='1')));
  22. DROP SHADOW RULE shadow_rule;
  24. DROP SHADOW ALGORITHM simple_hint_algorithm;
  26. CREATE DEFAULT SHADOW ALGORITHM NAME = simple_hint_algorithm;