diff options
author | tag <[email protected]> | 2012-11-21 17:24:55 -0500 |
---|---|---|
committer | tag <[email protected]> | 2012-11-21 17:24:55 -0500 |
commit | a8bc45ce8c549f27d8178fc6a6b288dc20c16d11 (patch) | |
tree | 093cece0785236b898e2b0e61d4293ed24ec4a2c /test/test_queries.php | |
parent | 5091b82652ccb974c79d1ba903fad2c681cee458 (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'); |