PHP CodeIgniter\Database BaseBuilder::selectAvgの例

コード例 #1

ファイル: SelectTest.php プロジェクト: titounnes/CodeIgniter4

 public function testSelectAvgWithAlias()
 {
     $builder = new BaseBuilder('invoices', $this->db);
     $builder->selectAvg('payments', 'myAlias');
     $expected = "SELECT AVG(\"payments\") AS \"myAlias\" FROM \"invoices\"";
     $this->assertEquals($expected, str_replace("\n", ' ', $builder->getCompiledSelect()));
 }