Exemplos de CodeIgniter\Database BaseBuilder::groupStart em PHP

Exemplo n.º 1

Arquivo: GroupTest.php Projeto: titounnes/CodeIgniter4

 public function testAndGroups()
 {
     $builder = new BaseBuilder('user', $this->db);
     $builder->groupStart()->where('id >', 3)->where('name !=', 'Luke')->groupEnd()->where('name', 'Darth');
     $expectedSQL = "SELECT * FROM \"user\" WHERE   ( \"id\" > :id AND \"name\" != :name  ) AND \"name\" = :name0";
     $this->assertEquals($expectedSQL, str_replace("\n", ' ', $builder->getCompiledSelect()));
 }