PHP Packaged\QueryBuilder\Predicate NotBetweenPredicate::create Examples

Programming Language: PHP

Namespace/Package Name: Packaged\QueryBuilder\Predicate

Method/Function: create

Examples at hotexamples.com: 1

PHP Packaged\QueryBuilder\Predicate NotBetweenPredicate::create - 1 examples found. These are the top rated real world PHP examples of Packaged\QueryBuilder\Predicate\NotBetweenPredicate::create extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

setField(2)

create(1)

setValues(1)

Frequently Used Methods

setField (2)

create (1)

setValues (1)

Example #1

Show file

File: NotBetweenPredicateTest.php Project: packaged/querybuilder

 public function testAssemble()
 {
     $predicate = new NotBetweenPredicate();
     $predicate->setField('field');
     $this->assertEquals('field NOT BETWEEN NULL AND NULL', QueryAssembler::stringify($predicate));
     $predicate->setValues((new NumericExpression())->setValue(1), (new NumericExpression())->setValue(5));
     $this->assertEquals('field NOT BETWEEN 1 AND 5', QueryAssembler::stringify($predicate));
     $predicate->setValues((new NumericExpression())->setValue('1'), (new NumericExpression())->setValue('5'));
     $this->assertEquals('field NOT BETWEEN 1 AND 5', QueryAssembler::stringify($predicate));
     $predicate->setValues((new StringExpression())->setValue('abc'), (new StringExpression())->setValue('def'));
     $this->assertEquals('field NOT BETWEEN "abc" AND "def"', QueryAssembler::stringify($predicate));
     $predicate = NotBetweenPredicate::create('field', 123, 456);
     $this->assertEquals('field NOT BETWEEN 123 AND 456', QueryAssembler::stringify($predicate));
     $predicate = NotBetweenPredicate::create('field', 'abc', 'def');
     $this->assertEquals('field NOT BETWEEN "abc" AND "def"', QueryAssembler::stringify($predicate));
 }