diff options
author | tag <[email protected]> | 2012-11-21 17:24:55 -0500 |
---|---|---|
committer | Simon Holywell <[email protected]> | 2012-11-26 13:36:22 +0000 |
commit | e2cb2242caf642c6440b6a1d0fc89b3826e85955 (patch) | |
tree | cb8ad4a3136ce68161a91b589a8d782607e04bca /test/test_queries.php | |
parent | 87b05b7da4290ab15c667a32982e1c6327eed582 (diff) |
Fixed query logging for delete_many; added unit test for delete_many
Diffstat (limited to 'test/test_queries.php')
-rwxr-xr-x[-rw-r--r--] | test/test_queries.php | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/test/test_queries.php b/test/test_queries.php index bcd4c7e..984b407 100644..100755 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -291,20 +291,24 @@ $expected = "DELETE FROM `widget` WHERE `id` = '1'"; Tester::check_equal("Delete data", $expected); + $widget = ORM::for_table('widget')->where_equal('age', 10)->delete_many(); + $expected = "DELETE FROM `widget` WHERE `age` = '10'"; + Tester::check_equal("Delete many", $expected); + // Regression tests $widget = ORM::for_table('widget')->select('widget.*')->find_one(); $expected = "SELECT `widget`.* FROM `widget` LIMIT 1"; Tester::check_equal("Issue #12 - incorrect quoting of column wildcard", $expected); - + $widget = ORM::for_table('widget')->where_raw('username LIKE "ben%"')->find_many(); $expected = 'SELECT * FROM `widget` WHERE username LIKE "ben%"'; Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "%"', $expected); - + $widget = ORM::for_table('widget')->where_raw('comments LIKE "has been released?%"')->find_many(); $expected = 'SELECT * FROM `widget` WHERE comments LIKE "has been released?%"'; Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "?"', $expected); - + // Tests that alter Idiorm's config are done last ORM::configure('id_column', 'primary_key'); |