Doctrine

Timestamp:

11/29/07 10:09:54 (2 years ago)

Author:

tamcy

Message:

#438: Updated test case syntax

Files:

• trunk/tests/Ticket/438TestCase.php (modified) (5 diffs)

trunk/tests/Ticket/438TestCase.php

@@ -78 +78 @@
       $this->newStudentCourse($student1, $course2);
 
-      // 1. Fetch relationship on demand
+
+      // 1. Fetch relationship on demand (multiple queries)
       $q = new Doctrine_Query();
       $q->from('T438_StudentCourse sc')
@@ -94 +95 @@
       $q->select('sc.*, s.*, c.*')
         ->from('T438_StudentCourse sc, sc.Student s, sc.Course c')
-        ->where('sc.student_id = ? AND sc.course_id = ?',array('07090002', 'MATH001'));
+        ->where('sc.student_id = ? AND sc.course_id = ?',array('07090002', 'MATH001'))
+        ->execute();
 
-      $record = $q->execute()->getFirst();
+      $record = $q->getFirst();
       $this->assertEqual($record->student_id, '07090002');
       $this->assertEqual($record->course_id,  'MATH001');
@@ -118 +120 @@
   public function setUp()
   {
-    $this->hasMany('T438_Course as StudyCourses', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_student_id', 'foreign' => 'sc_course_id'));
+    $this->hasMany('T438_Course as StudyCourses', array('refClass' => 'T438_StudentCourse', 'local' => 'student_id', 'foreign' => 'course_id'));
   }
 }
@@ -135 +137 @@
   public function setUp()
   {
-    $this->hasMany('T438_Student as Students', array('refClass' => 'T438_StudentCourse', 'local' => 'sc_course_id', 'foreign' => 'sc_student_id'));
+    $this->hasMany('T438_Student as Students', array('refClass' => 'T438_StudentCourse', 'local' => 'course_id', 'foreign' => 'student_id'));
   }
 }
-
-
 
 class T438_StudentCourse extends Doctrine_Record
@@ -149 +149 @@
     $this->hasColumn('sc_student_id as student_id', 'varchar', 30, array (  'primary' => true,));
     $this->hasColumn('sc_course_id as course_id', 'varchar', 20, array (  'primary' => true,));
-    $this->hasColumn('sc_remark as remark', 'varchar', 500, array ());
+    $this->hasColumn('sc_remark  as remark', 'varchar', 500, array ());
   }
   
   public function setUp()
   {
-    $this->ownsOne('T438_Student as Student', array('local' => 'sc_student_id', 'foreign' => 's_id'));
-    $this->ownsOne('T438_Course as Course', array('local' => 'sc_course_id', 'foreign' => 'c_id'));
+    $this->hasOne('T438_Student as Student', array('local' => 'student_id', 'foreign' => 'id'));
+    $this->hasOne('T438_Course as Course', array('local' => 'course_id', 'foreign' => 'id'));
   }
 }