public function testWhereJsonbExistsAllOperator()
{
$builder = new Builder($this->makeConnectionMock(), new PostgresGrammar());
$builder->where('some_field', '?&', 'some_value');
$compiled = $builder->toSql();
$this->assertEquals('select * where jsonb_exists_all("some_field", ?)', $compiled);
}
public function testComplexGroupBy()
{
$builder = new Builder($this->connection);
$builder->from = 'some_table';
$builder->groupBy('aaa', 'bbb')->groupByGroupingSets('ccc', 'ddd', ['eee', 'fff'])->groupByCube('ggg', 'hhh');
$expected = 'select * from "some_table" ' . 'group by ' . '"aaa", "bbb", ' . 'grouping sets ( ("ccc"), ("ddd"), ("eee", "fff") ), ' . 'cube ( "ggg", "hhh" )';
$this->assertEquals($expected, $builder->toSql());
}
