Doctrine

<?php

class Doctrine_Ticket_1323_TestCase extends Doctrine_UnitTestCase {
    public function prepareTables() {
        $this->tables[] = "T1323User";
        $this->tables[] = "T1323UserReference";
        parent::prepareTables();
    }

    public function resetData()
    {
      $q = Doctrine_Query::create();
      $q->delete()->from("T1323UserReference")->execute();
      $q = Doctrine_Query::create();
      $q->delete()->from("T1323User")->execute();

      $m = new T1323User();
      $m->name = "Mother";
      $m->save();
      $f = new T1323User();
      $f->name = "Father";
      $f->save();
      $s = new T1323User();
      $s->name = "Son";
      $s->save();
      $d = new T1323User();
      $d->name = "Daughter";
      $d->save();
      $gf = new T1323User();
      $gf->name = "Grandfather";
      $gf->save();
      $gm = new T1323User();
      $gm->name = "Grandmother";
      $gm->save();
      
      $f->Children[] = $s;
      $f->Children[] = $d;
      
      $f->Parents[] = $gf;
      $f->Parents[] = $gm;
      
      $f->save();
      
      $m->Children[] = $s;
      $m->Children[] = $d;
      
      $m->save();
    }

   /**
    * this test will fail
    */       
   public function testWithShow() {
      $this->resetData();
      
      T1323User::showAllRelations();
      $this->runTests();
   }

   /**
    * this test will pass
    */       
   public function testWithoutShow() {
      $this->resetData();
      
      $this->runTests();
   }

    
    public function runTests() {
      // change "Father"'s name...
      $f = Doctrine::getTable("T1323User")->findOneByName("Father");
      $f->name = "Dad";
      $f->save(); 
      
      /*  just playing; makes no difference: 
          remove "Dad"'s relation to "Son"... */
      //$s = Doctrine::getTable("T1323User")->findOneByName("Son");
      //$f->unlink("Children", array($s->id));
      //$f->save();
      
      $relations = Doctrine::getTable("T1323UserReference")->findAll();
      foreach ($relations as $relation) {
        /*  never directly touched any relation; so no user should have 
            himself as parent or child */ 
        $this->assertNotEqual($relation->parent_id, $relation->child_id);
      }
    }
}
  

  
class T1323User extends Doctrine_Record
{
    public function setTableDefinition()
    {
        $this->hasColumn('name', 'string', 30);
    }

    public function setUp()
    {
        $this->hasMany('T1323User as Parents', array('local'    => 'parent_id',
                                                'foreign'  => 'child_id',
                                                'refClass' => 'T1323UserReference'
                                                ));

        $this->hasMany('T1323User as Children', array('local'    => 'child_id',
                                                 'foreign'  => 'parent_id',
                                                 'refClass' => 'T1323UserReference'
                                                 ));

    }
    
    /**
     * just a little function to show all users and their relations
     */         
    public static function showAllRelations() {
        $users = Doctrine::getTable("T1323User")->findAll();
        
        echo "=========================================\n";
        echo "list of all existing users and their relations: \n";
        echo "=========================================\n\n";
        
        foreach ($users as $user) {
            $parents = $user->Parents;
            $children = $user->Children;
            
            echo "user: ";
            echo $user->name;
            echo "\n";
            
            echo "parents:";
            echo "\n";
            foreach ($parents as $parent) {
                echo $parent->name;
                echo "\n";
            }
            echo "\n";
            
            echo "children:";
            echo "\n";
            foreach ($children as $child) {
                echo $child->name;
                echo "\n";
            }
            echo "\n";
            echo "--------------\n";
            echo "\n";
        }
    }
}

class T1323UserReference extends Doctrine_Record
{
    public function setTableDefinition()
    {
        $this->hasColumn('id', 'integer', null, array('primary' => true, 'autoincrement' => true));
        $this->hasColumn('parent_id', 'integer', null);
        $this->hasColumn('child_id', 'integer', null);
    }
}

  
  
?>