test/unit/lib/AkActiveRecord/_AkActiveRecord_calculations.php

   1 <?php
   2
   3 defined('AK_ACTIVE_RECORD_PROTECT_GET_RECURSION') ? null : define('AK_ACTIVE_RECORD_PROTECT_GET_RECURSION', false);
   4 defined('AK_TEST_DATABASE_ON') ? null : define('AK_TEST_DATABASE_ON', true);
   5
   6 require_once(dirname(__FILE__).'/../../../fixtures/config/config.php');
   7
   8 class test_AkActiveRecord_calculations extends  AkUnitTest
   9 {
  10     function test_start()
  11     {
  12         $this->installAndIncludeModels('Account', array('populate'=>true,'instantiate'=>true));
  13     }
  14
  15     function test_should_sum_field()
  16     {
  17         $this->assertEqual(318, $this->Account->sum('credit_limit'));
  18     }
  19
  20     function test_should_average_field()
  21     {
  22         $average = $this->Account->average('credit_limit');
  23         $this->assertTrue(is_float($average));
  24         $this->assertEqual(53.0, $average);
  25     }
  26
  27     function test_should_get_maximum_of_field()
  28     {
  29         $this->assertEqual(60, $this->Account->maximum('credit_limit'));
  30     }
  31
  32     function test_should_get_minimum_of_field()
  33     {
  34         $this->assertEqual(50, $this->Account->minimum('credit_limit'));
  35     }
  36
  37     function test_should_group_by_field()
  38     {
  39         $credit = $this->Account->sum('credit_limit',array('group'=>'firm_id'));
  40         foreach (array(1 => 50,2 => 60, 6 => 105, 9 => 53) as $k=>$v){
  41             $this->assertTrue(array_key_exists($k,$credit));
  42             $this->assertEqual($credit[$k], $v);
  43         }
  44     }
  45
  46     function test_should_order_by_grouped_field()
  47     {
  48         $credit = $this->Account->sum('credit_limit',array('group'=>'firm_id','order'=>'firm_id DESC'));
  49         $this->assertEqual(join(array_diff(array_keys($credit),array(''))), join(array(9,6,2,1)));
  50     }
  51
  52     function test_should_order_by_calculation()
  53     {
  54         $credit = $this->Account->sum('credit_limit',array('group'=>'firm_id','order'=>'sum_credit_limit desc, firm_id'));
  55         $this->assertEqual(array_values($credit), array(105, 60, 53, 50, 50));
  56         $this->assertEqual(join(array_keys($credit)), join(array(6,2,9,null,1)));
  57     }
  58
  59     function test_should_limit_calculation()
  60     {
  61         $credit = $this->Account->sum('credit_limit',array('conditions' => "firm_id IS NOT NULL", 'group'=>'firm_id','order'=>'firm_id','limit'=>2));
  62         $this->assertEqual(array_keys($credit), array(1,2));
  63     }
  64
  65     function test_should_limit_calculation_with_offset()
  66     {
  67         $credit = $this->Account->sum('credit_limit',array('conditions' => "firm_id IS NOT NULL", 'group'=>'firm_id','order'=>'firm_id','limit'=>2, 'offset'=>1));
  68         $this->assertEqual(array_keys($credit), array(2,6));
  69     }
  70
  71     function test_should_group_by_summed_field_having_condition()
  72     {
  73         $credit = $this->Account->sum('credit_limit',array('conditions' => "firm_id IS NOT NULL", 'group'=>'firm_id','having' => 'sum(credit_limit) > 50'));
  74         foreach (array(1 => null, 6 => 105, 2 => 60) as $k=>$v){
  75             $this->assertEqual(@$credit[$k], $v);
  76         }
  77     }
  78
  79     function test_should_sum_field_with_conditions()
  80     {
  81         $this->assertEqual(105, $this->Account->sum('credit_limit',array('conditions' => "firm_id = 6")));
  82     }
  83
  84     function test_should_group_by_summed_field_with_conditions()
  85     {
  86         $credit = $this->Account->sum('credit_limit',array('conditions' => "firm_id > 1", 'group'=>'firm_id'));
  87         foreach (array(1 => null, 6 => 105, 2 => 60) as $k=>$v){
  88             $this->assertEqual(@$credit[$k], $v);
  89         }
  90     }
  91
  92     function test_should_group_by_summed_field_with_conditions_and_having()
  93     {
  94         $credit = $this->Account->sum('credit_limit',array('conditions' => "firm_id > 1", 'group'=>'firm_id', 'having' => 'sum(credit_limit) > 60'));
  95         foreach (array(1 => null, 6 => 105, 2 => null) as $k=>$v){
  96             $this->assertEqual(@$credit[$k], $v);
  97         }
  98     }
  99
 100     function test_should_group_by_fields_with_table_alias()
 101     {
 102         $credit = $this->Account->sum('credit_limit',array('group'=>'accounts.firm_id'));
 103         foreach (array(1 => 50, 6 => 105, 2 => 60) as $k=>$v){
 104             $this->assertEqual($credit[$k], $v);
 105         }
 106     }
 107
 108     function test_should_calculate_with_invalid_field()
 109     {
 110         $this->assertEqual(6, $this->Account->calculate('count','*'));
 111         $this->assertEqual(6, $this->Account->calculate('count','all'));
 112     }
 113
 114     function test_should_calculate_grouped_with_invalid_field()
 115     {
 116         $credit = $this->Account->count('all',array('group'=>'accounts.firm_id'));
 117         foreach (array(1 => 1, 6 => 2, 2 => 1) as $k=>$v){
 118             $this->assertEqual($credit[$k], $v);
 119         }
 120     }
 121
 122 }
 123
 124 ak_test('test_AkActiveRecord_calculations',true);
 125
 126 ?>