diff options
| author | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-09-13 12:46:29 +0200 |
|---|---|---|
| committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-09-13 12:46:29 +0200 |
| commit | e06aaac5120f95212598b54cd1fb6e2513e77b86 (patch) | |
| tree | fb156d6c90c63fb14363c8f19f2ba4dd8ad3e1a9 /tests | |
| parent | 021b68025223f2f3fdc8a7f588ae2e87128cbbc0 (diff) | |
fix starred count for deleted folders, reload path when deleting
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/unit/db/ItemMapperTest.php | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/tests/unit/db/ItemMapperTest.php b/tests/unit/db/ItemMapperTest.php index 2fadd50cf..9765893d4 100644 --- a/tests/unit/db/ItemMapperTest.php +++ b/tests/unit/db/ItemMapperTest.php @@ -103,12 +103,17 @@ class ItemMapperTest extends \Test\AppFramework\Db\MapperTestUtility { $row = array( array('size' => 9) ); - $sql = 'SELECT COUNT(*) AS size FROM `*PREFIX*news_feeds` `feeds` ' . - 'JOIN `*PREFIX*news_items` `items` ' . - 'ON `items`.`feed_id` = `feeds`.`id` ' . + $sql = 'SELECT COUNT(*) AS size FROM `*PREFIX*news_items` `items` '. + 'JOIN `*PREFIX*news_feeds` `feeds` ' . + 'ON `feeds`.`id` = `items`.`feed_id` '. + 'AND `feeds`.`deleted_at` = 0 ' . 'AND `feeds`.`user_id` = ? ' . - 'WHERE ((`items`.`status` & ' . StatusFlag::STARRED . ') = ' - . StatusFlag::STARRED . ')'; + 'AND ((`items`.`status` & ' . StatusFlag::STARRED . ') = ' . + StatusFlag::STARRED . ')' . + 'LEFT OUTER JOIN `*PREFIX*news_folders` `folders` ' . + 'ON `folders`.`id` = `feeds`.`folder_id` ' . + 'WHERE `feeds`.`folder_id` = 0 ' . + 'OR `folders`.`deleted_at` = 0'; $this->setMapperResult($sql, array($userId), $row); |