sanitk / sql-elasticsearch-query-converter
库,用于将类似 AND OR 的 SQL 查询转换为 Elastic Search 查询
0.1.5
2017-11-29 20:37 UTC
Requires
- php: ^7.0
- ramsey/uuid: ^3.7
This package is not auto-updated.
Last update: 2024-09-29 04:20:17 UTC
README
将类似 AND OR 的 SQL 查询转换为 Elastic Search 查询
((("query1 query 2" OR query3) OR query4) AND (query5 OR query6)) AND query7
转换为
{"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"}}]}}
安装
$ composer require santik/sql-elasticsearch-query-converter
使用方法
查看 examples/example1.php 示例