r4373 - branches/0.11/tests/Query

0 views
Skip to first unread message

no-r...@phpdoctrine.org

unread,
May 17, 2008, 8:04:51 AM5/17/08
to doctri...@googlegroups.com
Author: romanb
Date: 2008-05-17 13:04:51 +0100 (Sat, 17 May 2008)
New Revision: 4373

Modified:
branches/0.11/tests/Query/DriverTestCase.php
Log:
Formatting.

Modified: branches/0.11/tests/Query/DriverTestCase.php
===================================================================
--- branches/0.11/tests/Query/DriverTestCase.php 2008-05-17 12:01:48 UTC (rev 4372)
+++ branches/0.11/tests/Query/DriverTestCase.php 2008-05-17 12:04:51 UTC (rev 4373)
@@ -113,20 +113,20 @@
. "e.password AS e__password, e.type AS e__type, e.created AS e__created, "
. "e.updated AS e__updated, e.email_id AS e__email_id, p.id AS p__id, "
. "p.phonenumber AS p__phonenumber, p.entity_id AS p__entity_id "
- . "FROM entity e "
- . "INNER JOIN phonenumber p ON e.id = p.entity_id "
- . "WHERE e.id IN ("
- . "SELECT b.id FROM ("
- . "SELECT a.*, ROWNUM AS doctrine_rownum "
- . "FROM ("
- . "SELECT DISTINCT e2.id "
- . "FROM entity e2 "
- . "INNER JOIN phonenumber p2 ON e2.id = p2.entity_id "
- . "WHERE (e2.type = 0)"
- . ") a"
- . " ) b "
- . "WHERE doctrine_rownum BETWEEN 3 AND 7"
- . ") AND (e.type = 0)";
+ . "FROM entity e "
+ . "INNER JOIN phonenumber p ON e.id = p.entity_id "
+ . "WHERE e.id IN ("
+ . "SELECT b.id FROM ("
+ . "SELECT a.*, ROWNUM AS doctrine_rownum "
+ . "FROM ("
+ . "SELECT DISTINCT e2.id "
+ . "FROM entity e2 "
+ . "INNER JOIN phonenumber p2 ON e2.id = p2.entity_id "
+ . "WHERE (e2.type = 0)"
+ . ") a"
+ . " ) b "
+ . "WHERE doctrine_rownum BETWEEN 3 AND 7"
+ . ") AND (e.type = 0)";

$this->assertEqual($q->getSql(), $correctSql);
}

Reply all
Reply to author
Forward
0 new messages