From da6d31366f809720d0cd411ddc02249c518ce9f5 Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Wed, 3 Nov 2010 22:54:01 +0000 Subject: Parameters to where_raw method are now optional --- test/test_queries.php | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'test') diff --git a/test/test_queries.php b/test/test_queries.php index c02e3d1..879a086 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -100,6 +100,10 @@ $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_raw('`name` = "Fred"')->find_many(); + $expected = "SELECT * FROM `widget` WHERE `name` = \"Fred\""; + Tester::check_equal("Raw WHERE clause with no parameters", $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); -- cgit v1.2.3