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()); }