Icon

KNIME_​execute_​table_​rules

Demo of applying partial sql conditionsstored in a rules table on MySQLdatabase13 May 2021 @takbb Brian Bates Top section creates drops and recreatessample_data and rules_table tables Node 1Find those whereconditions PASSNode 5Execute each conditionand returns a standardresult setSet to either TOP orBOTTOM output priorto running workflowFind those whereconditions FAILCollect resultsBuild sql stringSample RulesSample DataRULES_TABLEPROJECTRead Rules TableBring the rules backinsert rule datainsert project dataSet test_type to "FAIL" Set test_type to "PASS"clear down demo tables(belt and braces - they should not have data in as they were dropped before creation!)Drop tables if they exist MySQL Connector String Manipulation Table Row ToVariable Loop Start DB Query Reader IF Switch String Manipulation End IF Loop End Column Expressions Table Creator Table Creator DB Table Creator DB Table Creator DB Table Selector DB Reader DB Insert DB Insert String Manipulation String Manipulation DB SQL Executor DB SQL Executor Demo of applying partial sql conditionsstored in a rules table on MySQLdatabase13 May 2021 @takbb Brian Bates Top section creates drops and recreatessample_data and rules_table tables Node 1Find those whereconditions PASSNode 5Execute each conditionand returns a standardresult setSet to either TOP orBOTTOM output priorto running workflowFind those whereconditions FAILCollect resultsBuild sql stringSample RulesSample DataRULES_TABLEPROJECTRead Rules TableBring the rules backinsert rule datainsert project dataSet test_type to "FAIL" Set test_type to "PASS"clear down demo tables(belt and braces - they should not have data in as they were dropped before creation!)Drop tables if they existMySQL Connector String Manipulation Table Row ToVariable Loop Start DB Query Reader IF Switch String Manipulation End IF Loop End Column Expressions Table Creator Table Creator DB Table Creator DB Table Creator DB Table Selector DB Reader DB Insert DB Insert String Manipulation String Manipulation DB SQL Executor DB SQL Executor

Nodes

Extensions

Links