/** * * @dataProvider getWhereStringProvider */ public function testGetWhereString($wheres, $expected, $expectedFormatted, $expectedBoundParameters) { foreach ($wheres as $where) { $nbWhere = count($where); if ($nbWhere == 4) { $this->queryBuilder->where($where[0], $where[1], $where[2], $where[3]); } elseif ($nbWhere >= 1 && $nbWhere <= 2) { if ($where[0] == '(') { if (isset($where[1])) { $this->queryBuilder->_open($where[1]); } else { $this->queryBuilder->_open(); } } elseif ($where[0] == ')') { $this->queryBuilder->_close(); } } } $this->assertEquals($expected, $this->queryBuilder->getWhereString()); $this->assertEquals($expectedFormatted, $this->queryBuilder->getWhereString(true)); $this->assertEquals($expectedBoundParameters, $this->queryBuilder->getBoundParameters()); $this->assertEquals($expectedBoundParameters, $this->queryBuilder->getBoundParameters(false, 'where')); $this->assertEquals(array(), $this->queryBuilder->getBoundParameters(false, 'having')); }
/** * Adds a closing bracket for nesting WHERE conditions. * * @return \SQL\DeleteQueryBuilder */ public function _close() { return parent::_close(); }