diff options
author | Benjamin Brahmer <info@b-brahmer.de> | 2022-03-20 10:56:49 +0100 |
---|---|---|
committer | Benjamin Brahmer <info@b-brahmer.de> | 2022-05-02 09:56:12 +0200 |
commit | 5af0cb6e225468599da10e1c6fa7cd870f9c56ec (patch) | |
tree | 0ce80d9245b127b0146a37908ea2a6c7e79ab138 /lib/Db | |
parent | da5e749ecce2a90bc6df8aa52e9e1d7e76ac9efe (diff) |
update last_modified when marking an item as read
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
this way it works
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
add changelog entry
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
Partly fix test
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
test passing
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
Diffstat (limited to 'lib/Db')
-rw-r--r-- | lib/Db/FeedMapperV2.php | 6 | ||||
-rw-r--r-- | lib/Db/FolderMapperV2.php | 5 |
2 files changed, 8 insertions, 3 deletions
diff --git a/lib/Db/FeedMapperV2.php b/lib/Db/FeedMapperV2.php index bab170f79..c80bf118b 100644 --- a/lib/Db/FeedMapperV2.php +++ b/lib/Db/FeedMapperV2.php @@ -186,14 +186,16 @@ class FeedMapperV2 extends NewsMapperV2 }, $this->db->executeQuery($idBuilder->getSQL(), $idBuilder->getParameters())->fetchAll() ); - + $time = new Time(); $builder = $this->db->getQueryBuilder(); $builder->update(ItemMapperV2::TABLE_NAME) ->set('unread', $builder->createParameter('unread')) + ->set('last_modified', $builder->createParameter('last_modified')) ->andWhere('id IN (:idList)') ->andWhere('unread != :unread') ->setParameter('unread', false, IQueryBuilder::PARAM_BOOL) - ->setParameter('idList', $idList, IQueryBuilder::PARAM_INT_ARRAY); + ->setParameter('idList', $idList, IQueryBuilder::PARAM_INT_ARRAY) + ->setParameter('last_modified', $time->getMicroTime(), IQueryBuilder::PARAM_STR); return $this->db->executeStatement( $builder->getSQL(), diff --git a/lib/Db/FolderMapperV2.php b/lib/Db/FolderMapperV2.php index ea2edee91..9afda11c4 100644 --- a/lib/Db/FolderMapperV2.php +++ b/lib/Db/FolderMapperV2.php @@ -128,13 +128,16 @@ class FolderMapperV2 extends NewsMapperV2 return intval($value['id']); }, $this->db->executeQuery($idBuilder->getSQL(), $idBuilder->getParameters())->fetchAll()); + $time = new Time(); $builder = $this->db->getQueryBuilder(); $builder->update(ItemMapperV2::TABLE_NAME) ->set('unread', $builder->createParameter('unread')) + ->set('last_modified', $builder->createParameter('last_modified')) ->andWhere('id IN (:idList)') ->andWhere('unread != :unread') ->setParameter('unread', false, IQueryBuilder::PARAM_BOOL) - ->setParameter('idList', $idList, IQueryBuilder::PARAM_INT_ARRAY); + ->setParameter('idList', $idList, IQueryBuilder::PARAM_INT_ARRAY) + ->setParameter('last_modified', $time->getMicroTime(), IQueryBuilder::PARAM_STR); return $this->db->executeStatement( $builder->getSQL(), |