diff options
author | Jamie Matthews <[email protected]> | 2010-10-25 18:28:03 +0100 |
---|---|---|
committer | Jamie Matthews <[email protected]> | 2010-10-25 18:28:03 +0100 |
commit | b513f1e3ea3f6edb9d781dcd32ceb1d1497c60bf (patch) | |
tree | 9653e875b0267712257dc061c30e0b285b0cd400 /test/test_queries.php | |
parent | 12d257077bca18b30f759da20161c929675bd04a (diff) |
Initial work on joins. Basic test, join and _add_join methods
Diffstat (limited to 'test/test_queries.php')
-rw-r--r-- | test/test_queries.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/test/test_queries.php b/test/test_queries.php index c2247bf..ea7ae44 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -120,6 +120,10 @@ $expected = "SELECT COUNT(*) AS `count` FROM `widget`"; Tester::check_equal("Literal expression in result columns", $expected); + ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many(); + $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`"; + Tester::check_equal("Simple join", $expected); + $widget = ORM::for_table('widget')->create(); $widget->name = "Fred"; $widget->age = 10; |