/**
* @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);
}
