euautomation / canon
此包已被废弃,不再维护。未建议替代包。
WHERE 匹配项
v1.1
2020-11-09 12:41 UTC
Requires
- php: >=7.3.0
- ext-mbstring: *
Requires (Dev)
- mockery/mockery: ^1.4
- phpunit/phpunit: ^9
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)
致谢
- https://github.com/greenlion/PHP-SQL-Parser - 解析器的大部分代码来自这里