cooker/rule

规则解析,rule,parse,data power

v1.0 2017-03-03 09:18 UTC

This package is not auto-updated.

Last update: 2024-04-28 00:16:06 UTC


README

use Cooker\Rule\Rule;
use Cooker\Rule\RuleGroup;
$rule1 = new Rule();
$rule1
    ->setTable('tablename')
    ->setField('field1')
    ->setOperator('eq')
    ->setValue("value1");

$rule2 = clone $rule1;
$rule2
    ->setTable('tablename')
    ->setField('field2')
    ->setOperator('in')
    ->setValue(array('value1', 'value2'));
    
$ruleGroup = new RuleGroup('Rule1OrRule2',  array($rule1, $rule2), 'OR');
$sqlQueryGenerator = new Cooker\Rule\SqlQueryGenerator();
$sql = $sqlQueryGenerator->generate($ruleGroup);

(tablename.`field1` = 'value1' OR tablename.`field2` in ('value1','value2'))