santik/sql-elasticsearch-query-converter

Library for converting AND OR SQL like query to Elastic Search query

SqlElasticSearchQueryConverter

Converts AND OR SQL like query to Elastic Search query, _(*1)

((("query1 query 2" OR query3) OR query4) AND (query5 OR query6)) AND query7, _(*2)

TO, _(*3)

{"bool":{"must":[{"bool":{"must":[{"bool":{"should":[{"bool":{"should":[{"match_phrase":{"field":"query1 query 2"}},{"match":{"field":"query3"}}]}},{"match":{"field":"query4"}}]}},{"bool":{"should":[{"match":{"field":"query5"}},{"match":{"field":"query6"}}]}}]}},{"match":{"field":"query7"}}]}}, _(*4)

Installation

$ composer require santik/sql-elasticsearch-query-converter

Usage

Look at examples/example1.php, _(*5)