123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- <?php
- declare(strict_types=1);
- namespace OCA\FederatedFileSharing\Migration;
- use Closure;
- use Doctrine\DBAL\Types\Type;
- use OCP\DB\ISchemaWrapper;
- use OCP\DB\Types;
- use OCP\IDBConnection;
- use OCP\Migration\IOutput;
- use OCP\Migration\SimpleMigrationStep;
- class Version1011Date20201120125158 extends SimpleMigrationStep {
-
- private $connection;
- public function __construct(IDBConnection $connection) {
- $this->connection = $connection;
- }
- public function changeSchema(IOutput $output, Closure $schemaClosure, array $options) {
-
- $schema = $schemaClosure();
- if ($schema->hasTable('federated_reshares')) {
- $table = $schema->getTable('federated_reshares');
- $remoteIdColumn = $table->getColumn('remote_id');
- if ($remoteIdColumn && $remoteIdColumn->getType()->getName() !== Types::STRING) {
- $remoteIdColumn->setNotnull(false);
- $remoteIdColumn->setType(Type::getType(Types::STRING));
- $remoteIdColumn->setOptions(['length' => 255]);
- $remoteIdColumn->setDefault('');
- return $schema;
- }
- }
- return null;
- }
- public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
- $qb = $this->connection->getQueryBuilder();
- $qb->update('federated_reshares')
- ->set('remote_id', $qb->createNamedParameter(''))
- ->where($qb->expr()->eq('remote_id', $qb->createNamedParameter('-1')));
- $qb->execute();
- }
- }
|