From 7f5ef4dcf751bcd5f17dddf140d349d645b24cba Mon Sep 17 00:00:00 2001 From: Christopher Ng Date: Thu, 13 Oct 2022 00:19:00 +0000 Subject: Delete theming background preferences Signed-off-by: Christopher Ng --- core/Migrations/Version25000Date20221007010957.php | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'core') diff --git a/core/Migrations/Version25000Date20221007010957.php b/core/Migrations/Version25000Date20221007010957.php index ac33b608ace..5e4a9854382 100644 --- a/core/Migrations/Version25000Date20221007010957.php +++ b/core/Migrations/Version25000Date20221007010957.php @@ -52,13 +52,19 @@ class Version25000Date20221007010957 extends SimpleMigrationStep { public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options): void { $qb = $this->connection->getQueryBuilder(); + $orExpr = $qb->expr()->orX( + $qb->expr()->eq('configkey', $qb->createNamedParameter('background')), + $qb->expr()->eq('configkey', $qb->createNamedParameter('backgroundVersion')), + ); + + $qb->delete('preferences') + ->where($qb->expr()->eq('appid', $qb->createNamedParameter('theming'))) + ->andWhere($orExpr); + $qb->update('preferences') ->set('appid', $qb->createNamedParameter('theming')) ->where($qb->expr()->eq('appid', $qb->createNamedParameter('dashboard'))) - ->andWhere($qb->expr()->orX( - $qb->expr()->eq('configkey', $qb->createNamedParameter('background')), - $qb->expr()->eq('configkey', $qb->createNamedParameter('backgroundVersion')) - )); + ->andWhere($orExpr); $qb->executeStatement(); } -- cgit v1.2.3