public function testExpressionSelectExpression()
{
$this->assertEquals('(SUM(field1) + SUM(field2)) AS sum_field', QueryAssembler::stringify(ExpressionSelectExpression::createWithAlias(AdditionExpression::create(SumSelectExpression::create('field1'), SumSelectExpression::create('field2')), 'sum_field')));
$this->assertEquals('SELECT (SUM(field1) + SUM(field2)) AS sum_field FROM tbl HAVING sum_field >= 5', QueryAssembler::stringify(QueryBuilder::select(ExpressionSelectExpression::createWithAlias(AdditionExpression::create(SumSelectExpression::create('field1'), SumSelectExpression::create('field2')), 'sum_field'))->from('tbl')->having(GreaterThanOrEqualPredicate::create('sum_field', 5))));
}
public function testSetExpression()
{
$this->assertEquals("{'test',1}", CqlAssembler::stringify(SetExpression::create(['test', 1])));
$this->assertEquals("\"testfield\" + {'test'}", CqlAssembler::stringify(AdditionExpression::create(FieldExpression::create('testfield'), SetExpression::create('test'))));
}
public function testArithmetic()
{
$this->assertEquals('(5 + (10 - 5))', QueryAssembler::stringify(AdditionExpression::create(5, SubtractExpression::create(10, 5))));
$this->assertEquals('(SUM(amt) + (10 - 5))', QueryAssembler::stringify(AdditionExpression::create(SumSelectExpression::create('amt'), SubtractExpression::create(10, 5))));
}
public function testSetExpression()
{
$this->assertEquals("{'test':'myval','test2':2}", CqlAssembler::stringify(MapExpression::create(['test' => 'myval', 'test2' => 2])));
$this->assertEquals("\"testfield\" + {'test'}", CqlAssembler::stringify(AdditionExpression::create(FieldExpression::create('testfield'), SetExpression::create('test'))));
}
