euautomation / canon

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

Requires

• php: >=7.3.0
• ext-mbstring: *

Requires (Dev)

• mockery/mockery: ^1.4
• phpunit/phpunit: ^9

BSD-3-Clause

• Rob Wells

Published on Packagist.org on 2020-11-09 15:38 UTC

README

Using something like the WHERE part of an SQL query to evaluate an array like thing is true or false.

Basic Usage

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

Supports

• Basic Operators (=, !=, >, >=, <, <=) foo > 9000
• LIKE Operator foo LIKE "shoes%"
• LIKE ANY Operator foo LIKE ANY ("shoes%", "socks%")
• IN Operator foo IN (1, 2)
• Nested Columns Refs foo.bar = 'baz'
• Brackets foo = 2 AND (bar = 3 OR baz < 10)

Acknowledgments

• https://github.com/greenlion/PHP-SQL-Parser - lots of the parser code is from here