此包已被废弃,不再维护。未建议替代包。

WHERE 匹配项

v1.1 2020-11-09 12:41 UTC

This package is auto-updated.

Last update: 2023-08-09 21:26:42 UTC


README

使用SQL查询中的WHERE部分来评估类似数组的真伪。

基本用法

use EUAutomation\Canon\Processor;
$processor = new Processor();
$expressions = $processor->process('foo = "bar"');
$expressions->evaluate([ "foo" => "bar" ]); // true

支持

  • 基本运算符 (=, !=, >, >=, <, <=) foo > 9000
  • LIKE运算符 foo LIKE "shoes%"
  • LIKE ANY运算符 foo LIKE ANY ("shoes%", "socks%")
  • IN运算符 foo IN (1, 2)
  • 嵌套列引用 foo.bar = 'baz'
  • 括号 foo = 2 AND (bar = 3 OR baz < 10)

致谢