1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 |
- <?php
- declare(strict_types=1);
- namespace OC\Core\Migrations;
- use Closure;
- use OCP\IDBConnection;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version25000Date20221007010957 extends SimpleMigrationStep {
- public function __construct(
- protected IDBConnection $connection,
- ) {
- }
-
- public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options): void {
- $cleanUpQuery = $this->connection->getQueryBuilder();
- $cleanUpQuery->delete('preferences')
- ->where($cleanUpQuery->expr()->eq('appid', $cleanUpQuery->createNamedParameter('theming')))
- ->andWhere($cleanUpQuery->expr()->orX(
- $cleanUpQuery->expr()->eq('configkey', $cleanUpQuery->createNamedParameter('background')),
- $cleanUpQuery->expr()->eq('configkey', $cleanUpQuery->createNamedParameter('backgroundVersion')),
- ));
- $cleanUpQuery->executeStatement();
- $updateQuery = $this->connection->getQueryBuilder();
- $updateQuery->update('preferences')
- ->set('appid', $updateQuery->createNamedParameter('theming'))
- ->where($updateQuery->expr()->eq('appid', $updateQuery->createNamedParameter('dashboard')))
- ->andWhere($updateQuery->expr()->orX(
- $updateQuery->expr()->eq('configkey', $updateQuery->createNamedParameter('background')),
- $updateQuery->expr()->eq('configkey', $updateQuery->createNamedParameter('backgroundVersion')),
- ));
- $updateQuery->executeStatement();
- }
- }
|