mydata-filter-mysql v1.0.3

myData Filter - Mysql Transformer

MySql transformer for mydata-filter package

Installation

npm install mydata-filter-mysql

Usage

Transform a filter query string into a MySQL WHERE clause query

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

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

try {
    const query = ParseSync(filter, {
        transformer: new MySqlTransformer({
            clause: "WHERE"
        })
    });

    console.log(query); // (`user`.`username" = 'Ana') OR (`username` = 'Ana')
} catch (error) {
    console.error(error);
}

Transform a filter query string into a MySQL ORDER BY clause query

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

const filter = `person.age ASC`;

try {
    const query = ParseSync(filter, {
        transformer: new MySqlTransformer({
            clause: "ORDER"
        })
    });

    console.log(query); // `person`.`age` ASC
} catch (error) {
    console.error(error);
}

Transform a filter query string into a MySQL query with specific features

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

const filter = `"ana" == "Ana"`;

try {
    const query = ParseSync(filter, {
        transformer: new MySqlTransformer({
            features: [
                "EQ",
                "NEQ",

                "BOOLEAN",
                "NUMBER",
                "STRING",
            ],
            root_features: [
                "EQ",
                "NEQ",
            ]
        })
    });

    console.log(query); // "ana" == "Ana"
} catch (error) {
    console.error(error);
}

Constructor optional options

Supported Inline Functions

Supported Sorting