From 5b8fff99a50c42194df445d82c665f0123caf10e Mon Sep 17 00:00:00 2001
From: Bernhard Posselt <dev@bernhard-posselt.com>
Date: Mon, 27 Oct 2014 15:49:50 +0100
Subject: make cleanup faster

---
 tests/unit/db/ItemMapperTest.php          | 4 ++--
 tests/unit/db/postgres/ItemMapperTest.php | 4 ++--
 2 files changed, 4 insertions(+), 4 deletions(-)

(limited to 'tests/unit')

diff --git a/tests/unit/db/ItemMapperTest.php b/tests/unit/db/ItemMapperTest.php
index 2f6b68c1c..46a129ecf 100644
--- a/tests/unit/db/ItemMapperTest.php
+++ b/tests/unit/db/ItemMapperTest.php
@@ -366,7 +366,7 @@ class ItemMapperTest extends  \Test\AppFramework\Db\MapperTestUtility {
             'FROM `*PREFIX*news_items` `items` ' .
             'JOIN `*PREFIX*news_feeds` `feeds` ' .
                 'ON `feeds`.`id` = `items`.`feed_id` ' .
-            'WHERE NOT ((`items`.`status` & ?) > 0) ' .
+            'AND NOT ((`items`.`status` & ?) > 0) ' .
             'GROUP BY `items`.`feed_id`, `feeds`.`articles_per_update` ' .
             'HAVING COUNT(*) > ?';
 
@@ -390,7 +390,7 @@ class ItemMapperTest extends  \Test\AppFramework\Db\MapperTestUtility {
             'FROM `*PREFIX*news_items` `items` ' .
             'JOIN `*PREFIX*news_feeds` `feeds` ' .
                 'ON `feeds`.`id` = `items`.`feed_id` ' .
-            'WHERE NOT ((`items`.`status` & ?) > 0) ' .
+                'AND NOT ((`items`.`status` & ?) > 0) ' .
             'GROUP BY `items`.`feed_id`, `feeds`.`articles_per_update` ' .
             'HAVING COUNT(*) > ?';
         $params1 = [$status, $threshold];
diff --git a/tests/unit/db/postgres/ItemMapperTest.php b/tests/unit/db/postgres/ItemMapperTest.php
index 473641522..22c6bb78c 100644
--- a/tests/unit/db/postgres/ItemMapperTest.php
+++ b/tests/unit/db/postgres/ItemMapperTest.php
@@ -69,7 +69,7 @@ class ItemMapperTest extends  \Test\AppFramework\Db\MapperTestUtility {
             'FROM `*PREFIX*news_items` `items` ' .
             'JOIN `*PREFIX*news_feeds` `feeds` ' .
                 'ON `feeds`.`id` = `items`.`feed_id` ' .
-            'WHERE NOT ((`items`.`status` & ?) > 0) ' .
+            'AND NOT ((`items`.`status` & ?) > 0) ' .
             'GROUP BY `items`.`feed_id`, `feeds`.`articles_per_update` ' .
             'HAVING COUNT(*) > ?';
 
@@ -93,7 +93,7 @@ class ItemMapperTest extends  \Test\AppFramework\Db\MapperTestUtility {
             'FROM `*PREFIX*news_items` `items` ' .
             'JOIN `*PREFIX*news_feeds` `feeds` ' .
                 'ON `feeds`.`id` = `items`.`feed_id` ' .
-            'WHERE NOT ((`items`.`status` & ?) > 0) ' .
+                'AND NOT ((`items`.`status` & ?) > 0) ' .
             'GROUP BY `items`.`feed_id`, `feeds`.`articles_per_update` ' .
             'HAVING COUNT(*) > ?';
         $params1 = [$status, $threshold];
-- 
cgit v1.2.3