public function testGettersAndSetters() { $predicate = new BetweenPredicate(); $predicate->setValues((new NumericExpression())->setValue(1), (new NumericExpression())->setValue(5)); $this->assertEquals([(new NumericExpression())->setValue(1), (new NumericExpression())->setValue(5)], $predicate->getRangeValues()); $this->assertEquals((new NumericExpression())->setValue(1), $predicate->getRangeStart()); $this->assertEquals((new NumericExpression())->setValue(5), $predicate->getRangeEnd()); $predicate->setField('test'); $this->assertEquals(FieldExpression::create('test'), $predicate->getField()); }
public function assembleBetweenPredicate(BetweenPredicate $predicate) { $start = $this->_assemblePrepared($predicate->getRangeStart()) ?: $this->assembleSegment($predicate->getRangeStart()); $end = $this->_assemblePrepared($predicate->getRangeEnd()) ?: $this->assembleSegment($predicate->getRangeEnd()); $not = $predicate instanceof NotBetweenPredicate ? ' NOT' : ''; return $this->assembleSegment($predicate->getField()) . $not . ' BETWEEN ' . $start . ' AND ' . $end; }
public function testAssemblerPrepare() { $stm = new QueryStatement(); $stm->addClause(new SelectClause())->from('mytable'); $stm->where(EqualPredicate::create('field1', 'value1')); $assembler = new QueryAssembler($stm, false); $this->assertEmpty($assembler->getParameters()); $this->assertFalse($assembler->isForPrepare()); $this->assertEquals('SELECT * FROM mytable WHERE field1 = "value1"', (string) $assembler); $stm->andWhere(['AND' => [EqualPredicate::create('field2', null), NotEqualPredicate::create('field3', null)], 'OR' => BetweenPredicate::create('field4', 123, 456)]); $assembler = new QueryAssembler($stm, true); $this->assertNotEmpty($assembler->getParameters()); $this->assertTrue($assembler->isForPrepare()); $this->assertEquals('SELECT * FROM mytable WHERE field1 = ? AND ((field2 IS NULL AND field3 IS NOT NULL) AND field4 BETWEEN ? AND ?)', (string) $assembler); $this->assertEquals(['value1', 123, 456], $assembler->getParameters()); }
public function testBetween() { $predicate = new NotBetweenPredicate(); $predicate->setField('field'); $predicate->setValues((new NumericExpression())->setValue(1), (new NumericExpression())->setValue(5)); $this->assertEquals('"field" <= 1 AND "field" >= 5', CqlAssembler::stringify($predicate)); $predicate = new BetweenPredicate(); $predicate->setField('field'); $this->assertEquals('"field" >= NULL AND "field" <= NULL', CqlAssembler::stringify($predicate)); $predicate->setValues((new NumericExpression())->setValue(1), (new NumericExpression())->setValue(5)); $this->assertEquals('"field" >= 1 AND "field" <= 5', CqlAssembler::stringify($predicate)); $predicate->setValues((new NumericExpression())->setValue('1'), (new NumericExpression())->setValue('5')); $this->assertEquals('"field" >= 1 AND "field" <= 5', CqlAssembler::stringify($predicate)); $predicate->setValues((new StringExpression())->setValue('abc'), (new StringExpression())->setValue('def')); $this->assertEquals('"field" >= \'abc\' AND "field" <= \'def\'', CqlAssembler::stringify($predicate)); $set = new PredicateSet(); $set->addPredicate($predicate); $set->addPredicate(BetweenPredicate::create('field2', 123, 456)); $this->assertEquals('"field" >= \'abc\' AND "field" <= \'def\' AND "field2" >= 123 AND "field2" <= 456', CqlAssembler::stringify($set)); }
public function assembleBetween(BetweenPredicate $betweenPredicate) { $gte = new GreaterThanOrEqualPredicate(); $gte->setField($betweenPredicate->getField()); $lte = new LessThanOrEqualPredicate(); $lte->setField($betweenPredicate->getField()); $set = new PredicateSet(); if ($betweenPredicate instanceof NotBetweenPredicate) { $gte->setExpression($betweenPredicate->getRangeEnd()); $lte->setExpression($betweenPredicate->getRangeStart()); $set->addPredicate($lte); $set->addPredicate($gte); } else { $gte->setExpression($betweenPredicate->getRangeStart()); $lte->setExpression($betweenPredicate->getRangeEnd()); $set->addPredicate($gte); $set->addPredicate($lte); } return $this->assembleSegment($set); }