tests/unit/Data/SqlMap/GroupByTest.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

<?php
require_once(dirname(__FILE__).'/BaseCase.php');

class AccountWithOrders extends Account
{
	private $_orders = array();

	public function setOrders($orders)
	{
		$this->_orders = $orders;
	}

	public function getOrders()
	{
		return $this->_orders;
	}
}

/**
 * @package System.Data.SqlMap
 */
class GroupByTest extends BaseCase
{
	function __construct()
	{
		parent::__construct();
		$this->initSqlMap();
	}

	function testAccountWithOrders()
	{
		$this->initScript('account-init.sql');
		$accounts = $this->sqlmap->queryForList("getAccountWithOrders");
		$this->assertSame(5, count($accounts));
		foreach($accounts as $account)
			$this->assertSame(2, count($account->getOrders()));
	}
}