Updating business rules configs in dashboard/deployment.yaml
@@ -257,14 +257,15 @@ business.rules:
datasource: BUSINESS_RULES_DB
nodes:
# ruleTemplate IDs against node urls on which business rules needed to be deployed.
- # example,
+ # sample,
- 0.0.0.0:9091:
- # - stock-data-analysis
- # - stock-exchange-input
- # - stock-exchange-output
+ - stock-data-analysis
+ - stock-exchange-input
+ - stock-exchange-output
+
queries:
mysql:
- CREATE_TABLE: CREATE TABLE IF NOT EXISTS business_rules ( uuid varchar(50), business_rule blob, deployment_status tinyInt(1), artifact_count int )
+ CREATE_BUSINESS_RULES_TABLE: CREATE TABLE IF NOT EXISTS business_rules ( uuid varchar(50) PRIMARY KEY, business_rule blob, deployment_status tinyInt(1), artifact_count int )
ADD_BUSINESS_RULE: INSERT INTO business_rules VALUES (?, ?, ?, ?)
UPDATE_BUSINESS_RULE: UPDATE business_rules SET business_rule = ?, deployment_status = ? WHERE business_rules.uuid = ?
UPDATE_DEPLOYMENT_STATUS: UPDATE business_rules SET deployment_status = ? WHERE business_rules.uuid = ?
@@ -274,3 +275,8 @@ business.rules:
RETRIEVE_ARTIFACT_COUNT: SELECT artifact_count FROM business_rules WHERE business_rules.uuid = ?
RETRIEVE_DEPLOYMENT_STATUS: SELECT deployment_status FROM business_rules WHERE business_rules.uuid = ?
DELETE_BUSINESS_RULE: DELETE FROM business_rules WHERE business_rules.uuid = ?
+ CREATE_RULE_TEMPLATES_TABLE: CREATE TABLE IF NOT EXISTS rule_templates ( uuid varchar(50))
+ ADD_RULE_TEMPLATE: INSERT INTO rule_templates VALUES (?)
+ RETRIEVE_ALL_RULE_TEMPLATES: SELECT * FROM rule_templates
+ DELETE_RULE_TEMPLATE: DELETE FROM rule_templates WHERE rule_templates.uuid = ?
+
