summaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authorJamie Matthews <[email protected]>2010-11-03 22:54:01 +0000
committerJamie Matthews <[email protected]>2010-11-03 22:54:01 +0000
commitda6d31366f809720d0cd411ddc02249c518ce9f5 (patch)
treecd00fc19ce5444e26555669b833cc8b78f1cbcce /test
parente4d6bad6924fa50b8295da971293671ec3122a51 (diff)
Parameters to where_raw method are now optional
Diffstat (limited to 'test')
-rw-r--r--test/test_queries.php4
1 files changed, 4 insertions, 0 deletions
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);