From 69bf5735df7360264ad1763fc5bc303411bd8f6c Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Thu, 7 Oct 2010 01:31:05 +0100 Subject: Simplify where_raw method. This method can now be used in method chains. --- test/test_queries.php | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'test') diff --git a/test/test_queries.php b/test/test_queries.php index aadfe46..013b897 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -86,6 +86,11 @@ $expected = 'SELECT * FROM `widget` WHERE `name` = "Fred" AND (`age` = "5" OR `age` = "10")'; Tester::check_equal("Raw WHERE clause", $expected); + ORM::for_table('widget')->where('age', 18)->where_raw('(`name` = ? OR `name` = ?)', array('Fred', 'Bob'))->where('size', 'large')->find_many(); + $expected = 'SELECT * FROM `widget` WHERE `age` = "18" AND (`name` = "Fred" OR `name` = "Bob") AND `size` = "large"'; + Tester::check_equal("Raw WHERE clause in method chain", $expected); + + ORM::for_table('widget')->raw_query('SELECT `w`.* FROM `widget` w WHERE `name` = ? AND `age` = ?', array('Fred', 5))->find_many(); $expected = 'SELECT `w`.* FROM `widget` w WHERE `name` = "Fred" AND `age` = "5"'; Tester::check_equal("Raw query", $expected); -- cgit v1.2.3