diff options
author | bluehaze <francesco.sportolari@gmail.com> | 2013-07-01 14:33:34 +0200 |
---|---|---|
committer | bluehaze <francesco.sportolari@gmail.com> | 2013-07-01 14:33:34 +0200 |
commit | 88de94d5109888ab453e85cf7b23b3941a94d2c9 (patch) | |
tree | e6bde3a58898efe648498e0af19b1b0a5f00f4eb /tests/unit/db/ItemMapperTest.php | |
parent | 8366f4c4550fd00d869a4836379c2776544e564f (diff) |
Modified testReadAll, testReadFolder and testReadAll SQL quieries
Diffstat (limited to 'tests/unit/db/ItemMapperTest.php')
-rw-r--r-- | tests/unit/db/ItemMapperTest.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/tests/unit/db/ItemMapperTest.php b/tests/unit/db/ItemMapperTest.php index c88f27403..bf4d1fa60 100644 --- a/tests/unit/db/ItemMapperTest.php +++ b/tests/unit/db/ItemMapperTest.php @@ -135,7 +135,7 @@ class ItemMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility { public function testReadAll(){ $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` IN (' . 'SELECT `id` FROM `*PREFIX*news_feeds` ' . 'WHERE `user_id` = ? ' . @@ -150,7 +150,7 @@ class ItemMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility { public function testReadFolder(){ $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` IN (' . 'SELECT `id` FROM `*PREFIX*news_feeds` ' . 'WHERE `folder_id` = ? ' . @@ -166,7 +166,7 @@ class ItemMapperTest extends \OCA\AppFramework\Utility\MapperTestUtility { public function testReadFeed(){ $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` = ? ' . 'AND `id` <= ? ' . 'AND EXISTS (' . |