Simplify the virtual favorite inbox

* Remove the heavy-weight virtual flagged mailbox
* Implement a favorites inbox as a simple filtered view
* Refactor the sync logic so it work with filtered mailboxes

Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>

1 files changed, 29 insertions, 0 deletions

diff --git a/lib/Migration/Version1030Date20200228105714.php b/lib/Migration/Version1030Date20200228105714.php
new file mode 100644
index 000000000..0b68533d9
--- /dev/null
+++ b/lib/Migration/Version1030Date20200228105714.php
@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+namespace OCA\Mail\Migration;
+
+use Closure;
+use OCP\IDBConnection;
+use OCP\Migration\IOutput;
+use OCP\Migration\SimpleMigrationStep;
+
+class Version1030Date20200228105714 extends SimpleMigrationStep {
+
+	/** @var IDBConnection */
+	protected $connection;
+
+	public function __construct(IDBConnection $connection) {
+		$this->connection = $connection;
+	}
+
+	public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
+		// Force a re-sync, so the old favorites inbox vanishes
+		$update = $this->connection->getQueryBuilder();
+		$update->update('mail_accounts')
+			->set('last_mailbox_sync', $update->createNamedParameter(0));
+		$update->execute();
+	}
+
+}