Update Active Record docs.

2 files changed, 58 insertions, 3 deletions

diff --git a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
index 953f83e6..7f22afc5 100644
--- a/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
+++ b/tests/simple_unit/ActiveRecord/FindBySqlTestCase.php
@@ -1,7 +1,20 @@
-<?php
-

+<?php

 Prado::using('System.Data.ActiveRecord.TActiveRecord');

 require_once(dirname(__FILE__).'/records/DepartmentRecord.php');

+require_once(dirname(__FILE__).'/records/UserRecord.php');

+

+class UserRecord2 extends UserRecord

+{

+	public $another_value;

+}

+

+class SqlTest extends TActiveRecord

+{

+	public $category;

+	public $item;

+

+	const TABLE='items';

+}

 

 class FindBySqlTestCase extends UnitTestCase

 {

@@ -16,6 +29,18 @@ class FindBySqlTestCase extends UnitTestCase
 		$deps = DepartmentRecord::finder()->findBySql('SELECT * FROM departments');

 		$this->assertTrue(count($deps) > 0);

 	}

+

+	function test_find_by_sql_arb()

+	{

+		$sql = 'SELECT c.name as category, i.name as item

+			FROM items i, categories c

+			WHERE i.category_id = c.category_id LIMIT 2';

+		$items = TActiveRecord::finder('SqlTest')->findBySql($sql);

+

+		$sql = "SELECT users.*, 'hello' as another_value FROM users LIMIT 2";

+		$users = TActiveRecord::finder('UserRecord2')->findBySql($sql);

+		var_dump($users);

+	}

 }

 
 ?>
\ No newline at end of file
diff --git a/tests/simple_unit/ActiveRecord/ForeignObjectUpdateTest.php b/tests/simple_unit/ActiveRecord/ForeignObjectUpdateTest.php
index 77b9cdf3..ad64e4b6 100644
--- a/tests/simple_unit/ActiveRecord/ForeignObjectUpdateTest.php
+++ b/tests/simple_unit/ActiveRecord/ForeignObjectUpdateTest.php
@@ -47,7 +47,7 @@ class PlayerRecord extends BaseFkRecord
     public $team_name;

 

     public $team;

-    public $skills=array();

+    private $_skills;

     public $profile;

 

     protected static $RELATIONS=array

@@ -61,6 +61,26 @@ class PlayerRecord extends BaseFkRecord
     {

         return parent::finder($className);

     }

+

+	public function getSkills()

+	{

+		if($this->_skills===null && $this->player_id !==null)

+		{

+			//lazy load the skill records

+			$this->setSkills($this->withSkills()->findByPk($this->player_id)->skills);

+		}

+		else if($this->_skills===null)

+		{

+			//create new TList;

+			$this->setSkills(new TList());

+		}

+		return $this->_skills;

+	}

+

+	public function setSkills($value)

+	{

+		$this->_skills = $value instanceof TList ? $value : new TList($value);

+	}

 }

 

 class ProfileRecord extends BaseFkRecord

@@ -99,6 +119,8 @@ class SkillRecord extends BaseFkRecord
     {

         return parent::finder($className);

     }

+

+

 }

 

 class ForeignObjectUpdateTest extends UnitTestCase

@@ -205,6 +227,14 @@ class ForeignObjectUpdateTest extends UnitTestCase
 		$this->assertEqual($player3->skills[0]->name, 'Bash');

 		$this->assertEqual($player3->skills[1]->name, 'Push');

 		$this->assertEqual($player3->skills[2]->name, 'Skip');

+

+		//test lazy load

+		$player4 = PlayerRecord::finder()->findByAge(37);

+		$this->assertEqual(count($player4->skills), 3);

+

+		$this->assertEqual($player4->skills[0]->name, 'Bash');

+		$this->assertEqual($player4->skills[1]->name, 'Skip');

+		$this->assertEqual($player4->skills[2]->name, 'Push');

 	}

 }