public function testAssemble()
{
$this->assertEquals('', QueryAssembler::stringify(PredicateSet::create()));
$eq = new EqualPredicate();
$eq->setField("first")->setExpression(ValueExpression::create('val1'));
$neq = new NotEqualPredicate();
$neq->setField("second")->setExpression(ValueExpression::create('val1'));
$set = PredicateSet::create($eq, $neq);
$this->assertEquals('(first = "val1" AND second <> "val1")', QueryAssembler::stringify($set));
}
public function testAssemble()
{
$predicate = new NotEqualPredicate();
$predicate->setField('field');
$this->assertEquals('field IS NOT NULL', QueryAssembler::stringify($predicate));
$predicate->setExpression((new NumericExpression())->setValue(1));
$this->assertEquals('field <> 1', QueryAssembler::stringify($predicate));
$predicate->setExpression((new NumericExpression())->setValue('1'));
$this->assertEquals('field <> 1', QueryAssembler::stringify($predicate));
$predicate->setExpression((new StringExpression())->setValue('abc'));
$this->assertEquals('field <> "abc"', QueryAssembler::stringify($predicate));
}
public function testAssemble()
{
$clause = new FinalAbstractPredicateClause();
$eq = new EqualPredicate();
$string = (new StringExpression())->setValue('val');
$eq->setField('one')->setExpression($string);
$neq = new NotEqualPredicate();
$neq->setField('two')->setExpression($string);
$clause->addPredicate($eq);
$this->assertEquals('T one = "val"', QueryAssembler::stringify($clause));
$clause->clearPredicates();
$clause->setPredicates([$eq, $neq]);
$this->assertEquals('T one = "val" AND two <> "val"', QueryAssembler::stringify($clause));
}
