function toDialectString(IDialect $dialect) { if (empty($this->set)) { return null; } $values = new SqlValueExpressionArray($this->set); $compiledSlices = array(); $compiledSlices[] = '('; $compiledSlices[] = $this->subject->toDialectString($dialect); $compiledSlices[] = ')'; $compiledSlices[] = $this->operator->toDialectString($dialect); $compiledSlices[] = '('; $compiledSlices[] = $values->toDialectString($dialect); $compiledSlices[] = ')'; $compiledString = join(' ', $compiledSlices); return $compiledString; }
/** * Creates an instance of binary expression node, representing the construction: subject not in set * * @param mixed $subject logical subject * @param array $set set of value the subject should match * * SQL example: * @code * // "type" NOT IN ("completed", "pending") * Expression::notIn("type", array("completed", "pending")); * @endcode * @return InSetExpression */ static function notIn($subject, $set) { return new InSetExpression($subject, $set, InSetLogicalOperator::notIn()); }