123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- <?php
- declare(strict_types=1);
- namespace OC\Core\Migrations;
- use Closure;
- use OCP\DB\ISchemaWrapper;
- use OCP\DB\Types;
- use OCP\IDBConnection;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version24000Date20211230140012 extends SimpleMigrationStep {
- public function __construct(
- protected IDBConnection $connection,
- ) {
- }
- public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper {
-
- $schema = $schemaClosure();
- $table = $schema->getTable('jobs');
- if (!$table->hasColumn('argument_hash')) {
- $table->addColumn('argument_hash', Types::STRING, [
- 'notnull' => false,
- 'length' => 32,
- ]);
- $table->addIndex(['class', 'argument_hash'], 'job_argument_hash');
- return $schema;
- }
- return null;
- }
- public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
- $update = $this->connection->getQueryBuilder();
- $update->update('jobs')
- ->set('argument_hash', $update->func()->md5('argument'));
- $update->executeStatement();
- }
- }
|