diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-10-27 15:49:50 +0100 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-10-27 15:49:50 +0100 |
commit | 5b8fff99a50c42194df445d82c665f0123caf10e (patch) | |
tree | 107f052164c758afe9fd397e6d176398be62ded1 /tests/unit/db | |
parent | f11e4cff46ad6b41f53c2354ca189186b1dd421e (diff) |
make cleanup faster
Diffstat (limited to 'tests/unit/db')
-rw-r--r-- | tests/unit/db/ItemMapperTest.php | 4 | ||||
-rw-r--r-- | tests/unit/db/postgres/ItemMapperTest.php | 4 |
2 files changed, 4 insertions, 4 deletions
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]; |