diff options
author | Kunio Murasawa <[email protected]> | 2012-06-02 01:17:52 +0900 |
---|---|---|
committer | Simon Holywell <[email protected]> | 2012-11-08 13:39:40 +0000 |
commit | 84bd58f902d93970a6626c2e3d360eed09a4b174 (patch) | |
tree | a5b3e84e06af72047f6999ba8f00b2cebf5685fa /test/test_queries.php | |
parent | 6ad8dc19fee4a323e2c5e92371a46be1a1b7c847 (diff) |
Escape sprintf % chars in queries
Thanks m92o
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 0faa592..e5681db 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -120,6 +120,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('STRFTIME("%Y", "now") = ?', array(2012))->find_many(); + $expected = "SELECT * FROM `widget` WHERE STRFTIME(\"%Y\", \"now\") = '2012'"; + Tester::check_equal("Raw WHERE clause with '%'", $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); |