diff options
Diffstat (limited to 'tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php')
-rw-r--r-- | tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php | 382 |
1 files changed, 191 insertions, 191 deletions
diff --git a/tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php b/tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php index 77408631..c43db032 100644 --- a/tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php +++ b/tests/simple_unit/ActiveRecord/MultipleForeignKeyTestCase.php @@ -1,192 +1,192 @@ -<?php
-
-Prado::using('System.Data.ActiveRecord.TActiveRecord');
-
-abstract class MultipleFKSqliteRecord extends TActiveRecord
-{
- protected static $conn;
-
- public function getDbConnection()
- {
- if(self::$conn===null)
- self::$conn = new TDbConnection('sqlite:'.dirname(__FILE__).'/test1.sqlite');
- return self::$conn;
- }
-}
-
-/**
- *
-CREATE TABLE table1 (
-id integer PRIMARY KEY AUTOINCREMENT,
-field1 varchar,
-fk1 integer CONSTRAINT fk_id1 REFERENCES table2(id) ON DELETE CASCADE,
-fk2 integer CONSTRAINT fk_id2 REFERENCES table2(id) ON DELETE CASCADE,
-fk3 integer CONSTRAINT fk_id3 REFERENCES table2(id) ON DELETE CASCADE)
- */
-class Table1 extends MultipleFKSqliteRecord
-{
- public $id;
- public $field1;
- public $fk1;
- public $fk2;
- public $fk3;
-
- public $object1;
- //public $object2; //commented out for testing __get/__set
- public $object3;
-
- public static $RELATIONS = array
- (
- 'object1' => array(self::BELONGS_TO, 'Table2', 'fk1'),
- 'object2' => array(self::BELONGS_TO, 'Table2', 'fk2'),
- 'object3' => array(self::BELONGS_TO, 'Table2', 'fk3'),
- );
-
- public static function finder($class=__CLASS__)
- {
- return parent::finder($class);
- }
-}
-
-/**
- * CREATE TABLE table2 (id integer PRIMARY KEY AUTOINCREMENT,field1 varchar)
- */
-class Table2 extends MultipleFKSqliteRecord
-{
- public $id;
- public $field1;
-
- private $_state1;
- //public $state2; //commented out for testing __get/__set
- public $state3;
-
- public static $RELATIONS = array
- (
- 'state1' => array(self::HAS_MANY, 'Table1', 'fk1'),
- 'state2' => array(self::HAS_MANY, 'Table1', 'fk2'),
- 'state3' => array(self::HAS_ONE, 'Table1', 'fk3'),
- );
-
- public function setState1($obj)
- {
- $this->_state1 = $obj;
- }
-
- public function getState1()
- {
- if(is_null($this->_state1))
- $this->fetchResultsFor('state1');
- return $this->_state1;
- }
-
- public static function finder($class=__CLASS__)
- {
- return parent::finder($class);
- }
-}
-
-
-class Category extends MultipleFKSqliteRecord
-{
- public $cat_id;
- public $category_name;
- public $parent_cat;
-
- public $parent_category;
- public $child_categories=array();
-
- public static $RELATIONS=array
- (
- 'parent_category' => array(self::BELONGS_TO, 'Category'),
- 'child_categories' => array(self::HAS_MANY, 'Category'),
- );
-
- public static function finder($class=__CLASS__)
- {
- return parent::finder($class);
- }
-}
-
-class MultipleForeignKeyTestCase extends UnitTestCase
-{
- function testBelongsTo()
- {
- $obj = Table1::finder()->withObject1()->findAll();
- $this->assertEqual(count($obj), 3);
- $this->assertEqual($obj[0]->id, '1');
- $this->assertEqual($obj[1]->id, '2');
- $this->assertEqual($obj[2]->id, '3');
-
- $this->assertEqual($obj[0]->object1->id, '1');
- $this->assertEqual($obj[1]->object1->id, '2');
- $this->assertEqual($obj[2]->object1->id, '2');
- }
-
- function testHasMany()
- {
- $obj = Table2::finder()->withState1()->findAll();
- $this->assertEqual(count($obj), 5);
-
- $this->assertEqual(count($obj[0]->state1), 1);
- $this->assertEqual($obj[0]->state1[0]->id, '1');
-
- $this->assertEqual(count($obj[1]->state1), 2);
- $this->assertEqual($obj[1]->state1[0]->id, '2');
- $this->assertEqual($obj[1]->state1[1]->id, '3');
-
- $this->assertEqual(count($obj[2]->state1), 0);
- $this->assertEqual($obj[2]->id, '3');
-
- $this->assertEqual(count($obj[3]->state1), 0);
- $this->assertEqual($obj[3]->id, '4');
- }
-
- function testHasOne()
- {
- $obj = Table2::finder()->withState3('id = 3')->findAll();
-
- $this->assertEqual(count($obj), 5);
-
- $this->assertEqual($obj[0]->id, '1');
- $this->assertNull($obj[0]->state3);
-
- $this->assertEqual($obj[1]->id, '2');
- $this->assertNull($obj[1]->state3);
-
- $this->assertEqual($obj[2]->id, '3');
- $this->assertNotNull($obj[2]->state3);
- $this->assertEqual($obj[2]->state3->id, '3');
-
- $this->assertEqual($obj[3]->id, '4');
- $this->assertNull($obj[3]->state3);
- }
-
- function testParentChild()
- {
- $obj = Category::finder()->withChild_Categories()->withParent_Category()->findByPk(2);
-
- $this->assertEqual($obj->cat_id, '2');
- $this->assertEqual(count($obj->child_categories), 2);
- $this->assertNotNull($obj->parent_category);
-
- $this->assertEqual($obj->child_categories[0]->cat_id, 3);
- $this->assertEqual($obj->child_categories[1]->cat_id, 4);
-
- $this->assertEqual($obj->parent_category->cat_id, 1);
- }
-
- function testLazyLoadingGetterSetter_hasMany()
- {
- $arr = Table2::finder()->findByPk(2);
-
- $this->assertNotNull($arr->state2); //lazy load
- $this->assertEqual(count($arr->state2), 1);
- $this->assertEqual($arr->state2[0]->id, "1");
- $this->assertNotNull($arr->state2[0]->object2);
- $this->assertEqual($arr->state2[0]->object2->id, "2");
-
- $this->assertNotIdentical($arr, $arr->state2[0]->object2);
- }
-}
-
+<?php + +Prado::using('System.Data.ActiveRecord.TActiveRecord'); + +abstract class MultipleFKSqliteRecord extends TActiveRecord +{ + protected static $conn; + + public function getDbConnection() + { + if(self::$conn===null) + self::$conn = new TDbConnection('sqlite:'.dirname(__FILE__).'/test1.sqlite'); + return self::$conn; + } +} + +/** + * +CREATE TABLE table1 ( +id integer PRIMARY KEY AUTOINCREMENT, +field1 varchar, +fk1 integer CONSTRAINT fk_id1 REFERENCES table2(id) ON DELETE CASCADE, +fk2 integer CONSTRAINT fk_id2 REFERENCES table2(id) ON DELETE CASCADE, +fk3 integer CONSTRAINT fk_id3 REFERENCES table2(id) ON DELETE CASCADE) + */ +class Table1 extends MultipleFKSqliteRecord +{ + public $id; + public $field1; + public $fk1; + public $fk2; + public $fk3; + + public $object1; + //public $object2; //commented out for testing __get/__set + public $object3; + + public static $RELATIONS = array + ( + 'object1' => array(self::BELONGS_TO, 'Table2', 'fk1'), + 'object2' => array(self::BELONGS_TO, 'Table2', 'fk2'), + 'object3' => array(self::BELONGS_TO, 'Table2', 'fk3'), + ); + + public static function finder($class=__CLASS__) + { + return parent::finder($class); + } +} + +/** + * CREATE TABLE table2 (id integer PRIMARY KEY AUTOINCREMENT,field1 varchar) + */ +class Table2 extends MultipleFKSqliteRecord +{ + public $id; + public $field1; + + private $_state1; + //public $state2; //commented out for testing __get/__set + public $state3; + + public static $RELATIONS = array + ( + 'state1' => array(self::HAS_MANY, 'Table1', 'fk1'), + 'state2' => array(self::HAS_MANY, 'Table1', 'fk2'), + 'state3' => array(self::HAS_ONE, 'Table1', 'fk3'), + ); + + public function setState1($obj) + { + $this->_state1 = $obj; + } + + public function getState1() + { + if(is_null($this->_state1)) + $this->fetchResultsFor('state1'); + return $this->_state1; + } + + public static function finder($class=__CLASS__) + { + return parent::finder($class); + } +} + + +class Category extends MultipleFKSqliteRecord +{ + public $cat_id; + public $category_name; + public $parent_cat; + + public $parent_category; + public $child_categories=array(); + + public static $RELATIONS=array + ( + 'parent_category' => array(self::BELONGS_TO, 'Category'), + 'child_categories' => array(self::HAS_MANY, 'Category'), + ); + + public static function finder($class=__CLASS__) + { + return parent::finder($class); + } +} + +class MultipleForeignKeyTestCase extends UnitTestCase +{ + function testBelongsTo() + { + $obj = Table1::finder()->withObject1()->findAll(); + $this->assertEqual(count($obj), 3); + $this->assertEqual($obj[0]->id, '1'); + $this->assertEqual($obj[1]->id, '2'); + $this->assertEqual($obj[2]->id, '3'); + + $this->assertEqual($obj[0]->object1->id, '1'); + $this->assertEqual($obj[1]->object1->id, '2'); + $this->assertEqual($obj[2]->object1->id, '2'); + } + + function testHasMany() + { + $obj = Table2::finder()->withState1()->findAll(); + $this->assertEqual(count($obj), 5); + + $this->assertEqual(count($obj[0]->state1), 1); + $this->assertEqual($obj[0]->state1[0]->id, '1'); + + $this->assertEqual(count($obj[1]->state1), 2); + $this->assertEqual($obj[1]->state1[0]->id, '2'); + $this->assertEqual($obj[1]->state1[1]->id, '3'); + + $this->assertEqual(count($obj[2]->state1), 0); + $this->assertEqual($obj[2]->id, '3'); + + $this->assertEqual(count($obj[3]->state1), 0); + $this->assertEqual($obj[3]->id, '4'); + } + + function testHasOne() + { + $obj = Table2::finder()->withState3('id = 3')->findAll(); + + $this->assertEqual(count($obj), 5); + + $this->assertEqual($obj[0]->id, '1'); + $this->assertNull($obj[0]->state3); + + $this->assertEqual($obj[1]->id, '2'); + $this->assertNull($obj[1]->state3); + + $this->assertEqual($obj[2]->id, '3'); + $this->assertNotNull($obj[2]->state3); + $this->assertEqual($obj[2]->state3->id, '3'); + + $this->assertEqual($obj[3]->id, '4'); + $this->assertNull($obj[3]->state3); + } + + function testParentChild() + { + $obj = Category::finder()->withChild_Categories()->withParent_Category()->findByPk(2); + + $this->assertEqual($obj->cat_id, '2'); + $this->assertEqual(count($obj->child_categories), 2); + $this->assertNotNull($obj->parent_category); + + $this->assertEqual($obj->child_categories[0]->cat_id, 3); + $this->assertEqual($obj->child_categories[1]->cat_id, 4); + + $this->assertEqual($obj->parent_category->cat_id, 1); + } + + function testLazyLoadingGetterSetter_hasMany() + { + $arr = Table2::finder()->findByPk(2); + + $this->assertNotNull($arr->state2); //lazy load + $this->assertEqual(count($arr->state2), 1); + $this->assertEqual($arr->state2[0]->id, "1"); + $this->assertNotNull($arr->state2[0]->object2); + $this->assertEqual($arr->state2[0]->object2->id, "2"); + + $this->assertNotIdentical($arr, $arr->state2[0]->object2); + } +} + ?>
\ No newline at end of file |