diff options
author | Maxence Lange <maxence@artificial-owl.com> | 2019-01-02 17:43:41 -0100 |
---|---|---|
committer | Maxence Lange <maxence@artificial-owl.com> | 2019-02-05 15:10:24 -0100 |
commit | a5427a35a9eb6464dcdcf4c8d4a1c58642b7817e (patch) | |
tree | e1ab0449ad088b1d44f27f8733df336bf293d7b3 | |
parent | 41edd3eee4b25bd4cf7c6d44194fce3882d495cc (diff) |
add table 'server_tags', and field 'tags' in table 'server_notes'
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
-rw-r--r-- | lib/Db/CoreRequestBuilder.php | 3 | ||||
-rw-r--r-- | lib/Migration/Version0002Date20190201000001.php | 109 |
2 files changed, 111 insertions, 1 deletions
diff --git a/lib/Db/CoreRequestBuilder.php b/lib/Db/CoreRequestBuilder.php index d9ae63f1..cf26aee4 100644 --- a/lib/Db/CoreRequestBuilder.php +++ b/lib/Db/CoreRequestBuilder.php @@ -58,12 +58,13 @@ class CoreRequestBuilder { const TABLE_SERVER_ACTORS = 'social_server_actors'; const TABLE_SERVER_NOTES = 'social_server_notes'; + const TABLE_SERVER_TAGS = 'social_server_tags'; const TABLE_SERVER_FOLLOWS = 'social_server_follows'; const TABLE_CACHE_ACTORS = 'social_cache_actors'; const TABLE_CACHE_DOCUMENTS = 'social_cache_documents'; - + /** @var IDBConnection */ protected $dbConnection; diff --git a/lib/Migration/Version0002Date20190201000001.php b/lib/Migration/Version0002Date20190201000001.php new file mode 100644 index 00000000..aecbd526 --- /dev/null +++ b/lib/Migration/Version0002Date20190201000001.php @@ -0,0 +1,109 @@ +<?php +declare(strict_types=1); + + +/** + * Nextcloud - Social Support + * + * This file is licensed under the Affero General Public License version 3 or + * later. See the COPYING file. + * + * @author Maxence Lange <maxence@artificial-owl.com> + * @copyright 2018, Maxence Lange <maxence@artificial-owl.com> + * @license GNU AGPL version 3 or any later version + * + * This program is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License as + * published by the Free Software Foundation, either version 3 of the + * License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Affero General Public License for more details. + * + * You should have received a copy of the GNU Affero General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + * + */ + + +namespace OCA\Social\Migration; + + +use Closure; +use Doctrine\DBAL\DBALException; +use Doctrine\DBAL\Schema\SchemaException; +use Doctrine\DBAL\Types\Type; +use OCA\Social\Db\CoreRequestBuilder; +use OCP\DB\ISchemaWrapper; +use OCP\IDBConnection; +use OCP\Migration\IOutput; +use OCP\Migration\SimpleMigrationStep; + + +/** + * Class Version0002Date20190201000001 + * + * @package OCA\Social\Migration + */ +class Version0002Date20190201000001 extends SimpleMigrationStep { + + + /** @var IDBConnection */ + private $connection; + + + /** + * @param IDBConnection $connection + */ + public function __construct(IDBConnection $connection) { + $this->connection = $connection; + } + + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + * + * @return ISchemaWrapper + * @throws SchemaException + * @throws DBALException + */ + public function changeSchema(IOutput $output, Closure $schemaClosure, array $options + ): ISchemaWrapper { + /** @var ISchemaWrapper $schema */ + $schema = $schemaClosure(); + + if (!$schema->hasTable(CoreRequestBuilder::TABLE_SERVER_TAGS)) { + $table = $schema->createTable(CoreRequestBuilder::TABLE_SERVER_TAGS); + $table->addColumn('tag', 'string', ['notnull' => false, 'length' => 63]); + $table->addColumn( + 'trend', 'string', ['notnull' => false, 'length' => 500] + ); + $table->setPrimaryKey(['tag']); + } + + + $table = $schema->getTable(CoreRequestBuilder::TABLE_SERVER_NOTES); + if (!$table->hasColumn('tags')) { + $table->addColumn( + 'tags', Type::STRING, ['notnull' => false, 'default' => '[]', 'length' => 1000] + ); + } + + return $schema; + } + + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + */ + public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options) { + } + +} + |