odata-filter-mysql v1.0.5

OData Filter - Mysql Transformer

Postgre transformer for odata-filter package

Installation

npm install odata-filter-mysql

Usage

Transform a filter string to a Mysql query

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

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

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

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

Transform a filter string to a Mysql query asynchronously

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

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

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

Constructor optional options

Supported Inline Functions