/** * @param ExpressionBuilder $expressionBuilder * @param string $tableAlias * @return \Doctrine\DBAL\Query\Expression\CompositeExpression * @internal */ protected function userConstraints(ExpressionBuilder $expressionBuilder, string $tableAlias = '') : \Doctrine\DBAL\Query\Expression\CompositeExpression { if ($tableAlias === '') { $tableAlias = $this->user_table; } $constraints = $expressionBuilder->andX(); if ($this->enablecolumns['rootLevel']) { $constraints->add($expressionBuilder->eq($tableAlias . '.pid', 0)); } if ($this->enablecolumns['disabled']) { $constraints->add($expressionBuilder->eq($tableAlias . '.' . $this->enablecolumns['disabled'], 0)); } if ($this->enablecolumns['deleted']) { $constraints->add($expressionBuilder->eq($tableAlias . '.' . $this->enablecolumns['deleted'], 0)); } if ($this->enablecolumns['starttime']) { $constraints->add($expressionBuilder->lte($tableAlias . '.' . $this->enablecolumns['starttime'], $GLOBALS['EXEC_TIME'])); } if ($this->enablecolumns['endtime']) { $constraints->add($expressionBuilder->orX($expressionBuilder->eq($tableAlias . '.' . $this->enablecolumns['endtime'], 0), $expressionBuilder->gt($tableAlias . '.' . $this->enablecolumns['endtime'], $GLOBALS['EXEC_TIME']))); } return $constraints; }
/** * @test */ public function gtQuotesIdentifier() { $result = $this->subject->gt('aField', 1); $this->connectionProphet->quoteIdentifier('aField')->shouldHaveBeenCalled(); $this->assertSame('aField > 1', $result); }