Differences

This shows you the differences between two versions of the page.

--- leaks-when-analysis [2018/11/20 12:00]
pullonen
+++ leaks-when-analysis [2019/12/09 12:17]
pullonen
@@ Line 33: / Line 33: @@
 More detailed instructions with example queries will be added soon.
+**Supported SQL**
+In general, the supported queries are SELECT queries with possible joins, various where statements and Group by as well as order by. The analyzer uses PostgreSQL.
+<code>
+create or replace function function_name( inputs)
+  returns TABLE(definition ) as
+$$
+select ... into ... From (join) where... Group by... Order by..
+$$
+language SQL IMMUTABLE returns NULL on NULL INPUT;
+select ... into ... From (join) where... Group by... Order by..;
+</code>
+The supported aggregations are SUM, MIN, MAX, COUNT, and AVG.
+The supported operations are +, -, /, *, @ (geographical distance), =, <, <=, >, >=.
+The names of the used tables must match the inputs of this task on the model. INTO should specify the table that is used as the output of that task on the model.
+The updated set of operations supported by the SQL leaks-when front-end can be seen in [[https://github.com/pleak-tools/pleak-leaks-when-ast-transformation/blob/master/src/ast_rewriter.js|this file in the repository.]]
 ===== Source code =====
 The source code of the analysis tool is available at [[https://github.com/pleak-tools/pleak-leaks-when-analysis|pleak-leaks-when-analysis]] repository. The user interface of the analysis tool consists of [[https://github.com/pleak-tools/pleak-leaks-when-ast-transformation|pleak-leaks-when-ast-transformation]] and [[https://github.com/pleak-tools/pleak-sql-editor|pleak-sql-editor]].

PLEAK Wiki

User Tools

Site Tools

Differences

Page Tools