euautomation/canon

This package is abandoned and no longer maintained. No replacement package was suggested.

A WHERE matching thing

Maintainers

Details

github.com/euautomation/canon

Source

Issues

Installs: 16 892

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0

Open Issues: 0

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

Requires

Requires (Dev)

BSD-3-Clause 8e9aa9ee04a27fba9bf2b86a3872026257e3cd7e

  • Rob Wells <rob.wells.woop@euautomation.com>

This package is auto-updated.

Last update: 2023-08-09 21:26:42 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