Changeset 4570

Timestamp:

06/27/08 17:10:14 (6 months ago)

Author:

gnat

Message:

make this really fail.
Ticket: 1175

Files:

• branches/0.11/tests/Ticket/1175TestCase.php (modified) (1 diff)

branches/0.11/tests/Ticket/1175TestCase.php

@@ -45 +45 @@
         $b->Images[] = $img;
 
+        $img = new gBlogFile();
+        $img->filename = 'blog file 1';
+        $b->Files[] = $img;
+
         $b->save();
 
-        $q = new Doctrine_Query();
-        $u = $q->from('gUser u')->leftJoin('u.Images i')->leftJoin('u.Files f')->where('u.id = ?',array(1))->fetchOne();
-
+        $q = Doctrine_Query::create() 
+                    ->from('gUser u') 
+                    ->leftJoin('u.Images i') 
+                    ->leftJoin('u.Files f') 
+                    ->where('u.id = ?', array(1)); 
+   
+        $this->assertEqual($q->getSql(), 'SELECT g.id AS g__id, g.first_name AS g__first_name, g.last_name AS g__last_name, g2.id AS g2__id, g2.owner_id AS g2__owner_id, g2.filename AS g2__filename, g2.otype AS g2__otype, g3.id AS g3__id, g3.owner_id AS g3__owner_id, g3.filename AS g3__filename, g3.otype AS g3__otype FROM g_user g LEFT JOIN g_image g2 ON g.id = g2.owner_id AND g2.otype = 1 LEFT JOIN g_file g3 ON g.id = g3.owner_id AND g3.otype = 1 WHERE g.id = ?'); 
+     
+        $u = $q->fetchOne(); 
         $this->assertTrue( is_object($u) );
         if(is_object($u))