SQL Context

ANSI SQL scripting inside rules engine

  • Platform bundles with ANSI-99 compliant, horizontally scalable and fault-tolerant distributed SQL database (Apache Ignite). The distribution is provided either by partitioning the data across cluster nodes or by full replication, depending on the use case.

  • As a SQL database, Ignite supports all DML commands including SELECT, UPDATE, INSERT, and DELETE queries and also implements a subset of DDL commands relevant for distributed systems.

  • Documentation

  • Context Variable: sql

API Inrterface

//Update/Merge a record into a table
Integer update(String table, Map<String, Object> data);

//Execute a stored SQL template and return results
Map<String, Object> execute(String tempateId, Map<String, Object> args);

//Execute a SQL query and return results
Map<String, Object> execute(String query);

//Insert a record into a table
Integer insert(String table, Map<String, Object> data);

APIs Inherited

Context Base