From 88de94d5109888ab453e85cf7b23b3941a94d2c9 Mon Sep 17 00:00:00 2001 From: bluehaze Date: Mon, 1 Jul 2013 14:33:34 +0200 Subject: Modified testReadAll, testReadFolder and testReadAll SQL quieries --- tests/unit/db/ItemMapperTest.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'tests') 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 (' . -- cgit v1.2.3