From 7a0648757ae57898af29d8cff403086432fa2ba5 Mon Sep 17 00:00:00 2001 From: Vitor Mattos Date: Mon, 25 Jul 2022 11:30:20 -0300 Subject: Delete comments that expired now Signed-off-by: Vitor Mattos --- lib/private/Comments/Manager.php | 2 +- tests/lib/Comments/ManagerTest.php | 5 ++++- 2 files changed, 5 insertions(+), 2 deletions(-) diff --git a/lib/private/Comments/Manager.php b/lib/private/Comments/Manager.php index b82df1bccc8..53603e51e56 100644 --- a/lib/private/Comments/Manager.php +++ b/lib/private/Comments/Manager.php @@ -1652,7 +1652,7 @@ class Manager implements ICommentsManager { public function deleteCommentsExpiredAtObject(string $objectType, string $objectId = ''): bool { $qb = $this->dbConn->getQueryBuilder(); $qb->delete('comments') - ->where($qb->expr()->lt('expire_date', + ->where($qb->expr()->lte('expire_date', $qb->createNamedParameter($this->timeFactory->getDateTime(), IQueryBuilder::PARAM_DATE))) ->andWhere($qb->expr()->eq('object_type', $qb->createNamedParameter($objectType))); diff --git a/tests/lib/Comments/ManagerTest.php b/tests/lib/Comments/ManagerTest.php index ae91efb8498..1af460e6f1b 100644 --- a/tests/lib/Comments/ManagerTest.php +++ b/tests/lib/Comments/ManagerTest.php @@ -753,6 +753,9 @@ class ManagerTest extends TestCase { $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file1', new \DateTime('-2 hours')); $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file2', new \DateTime('-2 hours')); $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime('-2 hours')); + $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime()); + $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime()); + $ids[] = $this->addDatabaseEntry(0, 0, null, null, 'file3', new \DateTime()); $manager = new Manager( $this->connection, @@ -777,7 +780,7 @@ class ManagerTest extends TestCase { } } $this->assertSame($exists, 0); - $this->assertSame($deleted, 3); + $this->assertSame($deleted, 6); // actor info is gone from DB, but when database interaction is alright, // we still expect to get true back -- cgit v1.2.3