mydata-filter v1.0.3

myData Filter

Small filter library for working with immutable AST(abstract syntax trees) and queries

Installation

npm install mydata-filter

Usage

Compile a JSON-AST code that can be used later by a transformer:

import { Parse } from "mydata-filter";

const code = `(user.username == "Ana") or (username == "Mari")`;

Parse(code).then(ast => {
    console.log(ast); // { type: "...", ... }
}).catch(error => {
    console.error(error);
});

Compile a mysql where clause from a string using a transformer:

import { Parse } from "mydata-filter";
import MySqlTransformer from "mydata-filter-mysql";

const code = `(user.username == "Ana") or (username == "Ana")`;

Parse(code, {
    transformer: new MySqlTransformer({
        clause: "WHERE"
    })
}).then(query => {
    console.log(query); // (`user`.`username` == 'Ana') OR (`username` == 'Ana')
}).catch(error => {
    console.error(error);
});

Supported Functions

Parse(code, {
  cache?: boolean,
  transformer?: ITransformer
}): Promise<any>;

ParseSync(code, {
  cache?: boolean,
  transformer?: ITransformer
}): any;

Available Common Transformers

• mydata-filter-mysql
• mydata-filter-postgresql

Functions Syntax

FunctionName(arg1)
FUNCTION_NAME(arg1, arg2, ...)

Supported Operators

Supported Features Identifiers Name