From f9af1ffce3b01e6e87ded22cc5903c0bf253fbc1 Mon Sep 17 00:00:00 2001 From: Sander Marechal Date: Wed, 2 Mar 2011 15:57:19 +0100 Subject: Allow raw queries without parameters This is useful for e.g. MySQL `LOCK TABLE` or SQLite `VACUUM` commands which usually do not require parameters. --- test/test_queries.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'test') diff --git a/test/test_queries.php b/test/test_queries.php index 329ebc9..7b058b5 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -124,9 +124,13 @@ $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')->find_many(); + $expected = "SELECT `w`.* FROM `widget` w"; + Tester::check_equal("Raw query", $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); + Tester::check_equal("Raw query with parameters", $expected); ORM::for_table('widget')->select('name')->find_many(); $expected = "SELECT `name` FROM `widget`"; -- cgit v1.2.3