Doctrine

Timestamp:

09/09/08 15:34:04 (10 months ago)

Author:

jasoneisen

Message:

Adding coverage for #1131

Files:

• branches/1.0/tests/Ticket/1131TestCase.php (modified) (9 diffs)

branches/1.0/tests/Ticket/1131TestCase.php

@@ -38 +38 @@
         $this->tables[] = 'Ticket_1131_User';
         $this->tables[] = 'Ticket_1131_Group';
+        $this->tables[] = 'Ticket_1131_Role';
         parent::prepareTables();
     }
@@ -46 +47 @@
         parent::prepareData();
         
+        $role = new Ticket_1131_Role();
+        $role->name = 'Role One';
+        $role->save();
+        $this->role_one = $role->id;
+        
+        $role = new Ticket_1131_Role();
+        $role->name = 'Role Two';
+        $role->save();
+        $this->role_two = $role->id;
+        
         $group = new Ticket_1131_Group();
+        $group->role_id = $this->role_one;
         $group->name = 'Core Dev';
         $group->save();
@@ -52 +64 @@
         $user = new Ticket_1131_User();
         $user->Group = $group;
+        $user->role_id = $this->role_two;
         $user->name = 'jwage';
         $user->save();
         
+        $role->free();
         $group->free();
         $user->free();
     }
 
-    public function testTicket()
+    public function testOriginalTicket()
     {
         $user = Doctrine_Query::create()
@@ -68 +82 @@
         $this->assertFalse($user->get('group_id') instanceof Doctrine_Record);
     }
+    
+    public function testOriginalTicketWithJoins()
+    {
+        $user = Doctrine_Query::create()
+            ->from('Ticket_1131_User u')
+            ->leftJoin('u.Group g')
+            ->where('u.id = ?')->fetchOne(array(1));
+
+        $this->assertEqual($user->Group->id, 1);
+        $this->assertFalse($user->get('group_id') instanceof Doctrine_Record);
+    }
+    
+    public function testOverloading()
+    {
+        $orig = Doctrine_Manager::getInstance()->getAttribute('auto_accessor_override');
+        Doctrine_Manager::getInstance()->setAttribute('auto_accessor_override', true);
+        
+        $user = Doctrine_Query::create()
+            ->from('Ticket_1131_User u')
+            ->where('u.id = ?')->fetchOne(array(1));
+        
+        $this->assertEqual($user->group_id, 1);
+        $this->assertEqual($user->get('group_id'), 1);
+        $this->assertFalse($user->get('group_id') instanceof Doctrine_Record);
+        
+        $this->assertEqual($user->role_id, 2);
+        $this->assertEqual($user->get('role_id'), 2);
+        $this->assertFalse($user->get('role_id') instanceof Doctrine_Record);
+        
+        $this->assertEqual($user->Group->id, 1);
+        $this->assertEqual($user->get('Group')->get('id'), 1);
+        
+        $this->assertEqual($user->Role->id, 2);
+        $this->assertEqual($user->get('Role')->get('id'), 2);
+        
+        Doctrine_Manager::getInstance()->setAttribute('auto_accessor_override', $orig);
+    }
+    
+    public function testOverloadingWithJoins()
+    {
+        $orig = Doctrine_Manager::getInstance()->getAttribute('auto_accessor_override');
+        Doctrine_Manager::getInstance()->setAttribute('auto_accessor_override', true);
+        
+        $user = Doctrine_Query::create()
+            ->from('Ticket_1131_UserWithOverloading u')
+            ->leftJoin('u.Group g')
+            ->leftJoin('u.Role r')
+            ->addWhere('u.id = ?')->fetchOne(array(1));
+        
+        $this->assertEqual($user->group_id, 1);
+        $this->assertEqual($user->get('group_id'), 1);
+        $this->assertFalse($user->get('group_id') instanceof Doctrine_Record);
+        
+        $this->assertEqual($user->role_id, 1);
+        $this->assertEqual($user->get('role_id'), 1);
+        $this->assertFalse($user->get('role_id') instanceof Doctrine_Record);
+        
+        $this->assertEqual($user->Group->id, 1);
+        $this->assertEqual($user->get('Group')->get('id'), 1);
+        
+        $this->assertEqual($user->Role->id, 1);
+        $this->assertEqual($user->get('Role')->get('id'), 1);
+        
+        Doctrine_Manager::getInstance()->setAttribute('auto_accessor_override', $orig);
+    }
 }
 
@@ -75 +154 @@
     {
         $this->hasColumn('group_id', 'integer', 20, array(
+            'notnull' => false, 'default' => null
+        ));
+        $this->hasColumn('role_id', 'integer', 20, array(
             'notnull' => false, 'default' => null
         ));
@@ -86 +168 @@
             'foreign' => 'id'
         ));
-    }
-}
-
+        
+        $this->hasOne('Ticket_1131_Role as Role', array(
+            'local' => 'role_id',
+            'foreign' => 'id'));
+    }
+}
+
+class Ticket_1131_UserWithOverloading extends Ticket_1131_User
+{
+    public function getRole()
+    {
+        return $this->Group->Role;
+    }
+    
+    public function getRoleId()
+    {
+        return $this->Group->role_id;
+    }
+}
 
 class Ticket_1131_Group extends Doctrine_Record
@@ -94 +192 @@
     public function setTableDefinition()
     {
+        $this->hasColumn('role_id', 'integer', 20, array(
+            'notnull' => false, 'default' => null
+        ));
         $this->hasColumn('name', 'string', 255);
     }
@@ -99 +200 @@
     public function setUp()
     {
+        $this->hasOne('Ticket_1131_Role as Role', array(
+            'local' => 'role_id',
+            'foreign' => 'id'));
+        
         $this->hasMany('Ticket_1131_User as Users', array(
             'local' => 'id',
@@ -105 +210 @@
     }
 }
+
+class Ticket_1131_Role extends Doctrine_Record
+{
+    public function setTableDefinition()
+    {
+        $this->hasColumn('name', 'string', 255);
+    }
+
+    public function setUp()
+    {
+        $this->hasMany('Ticket_1131_User as Users', array(
+            'local' => 'id',
+            'foreign' => 'role_id'
+        ));
+        $this->hasMany('Ticket_1131_Group as Groups', array(
+            'local' => 'id',
+            'foreign' => 'role_id'
+        ));
+    }
+}