From 011b55119b56023224781be01d27043c5a1454ab Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Mon, 25 Oct 2010 20:21:52 +0100 Subject: Add table_alias method to provide ability to alias the main table in SELECT queries --- test/test_queries.php | 3 +++ 1 file changed, 3 insertions(+) (limited to 'test') diff --git a/test/test_queries.php b/test/test_queries.php index d72c101..807eed6 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -147,6 +147,9 @@ $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` JOIN `widget_nozzle` ON `widget_nozzle`.`widget_id` = `widget`.`id`"; Tester::check_equal("Multiple join sources", $expected); + ORM::for_table('widget')->table_alias('w')->find_many(); + $expected = "SELECT * FROM `widget` `w`"; + ORM::for_table('widget')->join('widget_handle', array('wh.widget_id', '=', 'widget.id'), 'wh')->find_many(); $expected = "SELECT * FROM `widget` JOIN `widget_handle` `wh` ON `wh`.`widget_id` = `widget`.`id`"; Tester::check_equal("Join with alias", $expected); -- cgit v1.2.3