How to join multiple where() with OR

I decided to modify the SqlBuilder

namespace Nette\Database\Table;

class SqlBuilder
{
	use Nette\SmartObject;

    /** @var boolean my new property */
    public $joinWheresWithOr = FALSE;

	/*code*/

	/**
	 * Modified method buildConditions()
	 * @return string
	 */
	protected function buildConditions()
	{
	    if($this->joinWheresWithOr === TRUE){
    		$this->joinWheresWithOr = FALSE;
    		return $this->where ? ' WHERE (' . implode(') OR (', $this->where) . ')' : '';
    	}

    	return $this->where ? ' WHERE (' . implode(') AND (', $this->where) . ')' : '';
	}

I iterate over selected rows in the presenter so I can use:

$query = $this->database->table('tableName');
$query->select('id');
$query->where('column1 = ? AND column2 = ?', 1, 2);
$query->where('column3 = ?', 3);
$query->getSqlBuilder()->joinWheresWithOr = TRUE;

foreach($query as $row){
	/*do stuff*/
}

And now the sql query looks like “SELECT id FROM tableName WHERE (column1 = ? AND column2 = ?) OR (column3 = ?)”

GEpic wrote:

What about whereOr (doc here | api here)?

as I wrote above. In docs there is written: Multiple where or whereOr conditions are connected with the AND operator.
For him it is not solution, whereOr is for connection several params with OR but not for multiple where or whereOr

Last edited by Ondřej Kubíček (2018-05-24 23:04)