Add new migrations to dav app

sharidas · sharidas · commit eb689434ef71 · 2019-08-23T13:23:30.000+05:30
New migrations have been added to the dav app to
acheive the following:
1. Delete the existing entries in properties table
   which have null fileid entries
2. Restrict null value entry for fileid in properties table.

Signed-off-by: Sujith H &lt;sharidasan@owncloud.com&gt;
diff --git a/apps/dav/appinfo/Migrations/Version20190822150226.php b/apps/dav/appinfo/Migrations/Version20190822150226.php
@@ -0,0 +1,38 @@
+<?php
+/**
+ * @author Sujith Haridasan <sharidasan@owncloud.com>
+ *
+ * @copyright Copyright (c) 2019, ownCloud GmbH
+ * @license AGPL-3.0
+ *
+ * This code is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License, version 3,
+ * as published by the Free Software Foundation.
+ *
+ * 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, version 3,
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>
+ *
+ */
+
+namespace OCA\dav\Migrations;
+
+use OCP\IDBConnection;
+use OCP\Migration\ISqlMigration;
+
+/**
+ * Remove null fileid's from the properties table.
+ */
+class Version20190822150226 implements ISqlMigration {
+
+	public function sql(IDBConnection $connection) {
+		$qb = $connection->getQueryBuilder();
+		$qb->delete('properties')
+			->where($qb->expr()->isNull('fileid'));
+		$qb->execute();
+	}
+}
diff --git a/apps/dav/appinfo/Migrations/Version20190823065724.php b/apps/dav/appinfo/Migrations/Version20190823065724.php
@@ -0,0 +1,40 @@
+<?php
+/**
+ * @author Sujith Haridasan <sharidasan@owncloud.com>
+ *
+ * @copyright Copyright (c) 2019, ownCloud GmbH
+ * @license AGPL-3.0
+ *
+ * This code is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License, version 3,
+ * as published by the Free Software Foundation.
+ *
+ * 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, version 3,
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>
+ *
+ */
+
+namespace OCA\dav\Migrations;
+
+use Doctrine\DBAL\Schema\Schema;
+use OCP\Migration\ISchemaMigration;
+
+/**
+ * Add NULL constraint to fileid column for properties table.
+ */
+class Version20190823065724 implements ISchemaMigration {
+
+	public function changeSchema(Schema $schema, array $options) {
+		$prefix = $options['tablePrefix'];
+
+		$table = $schema->getTable("${prefix}properties");
+		$table->changeColumn('fileid', [
+			'notnull' => true,
+		]);
+	}
+}
diff --git a/apps/dav/appinfo/info.xml b/apps/dav/appinfo/info.xml
@@ -5,7 +5,7 @@
 	<description>ownCloud WebDAV endpoint</description>
 	<licence>AGPL</licence>
 	<author>owncloud.org</author>
-	<version>0.4.0</version>
+	<version>0.5.0</version>
 	<default_enable/>
 	<use-migrations>true</use-migrations>
 	<types>
