From 27a98ddf6f3a5dbc8972ce4c5aacffeed50edd9e Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Thu, 20 Jan 2011 19:09:20 +0100
Subject: [PATCH] Add script for later migration of share data.

---
 .../upgrades/convert_sql_shares_to_sqlng.php       | 31 ++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100755 kronolith/scripts/upgrades/convert_sql_shares_to_sqlng.php

diff --git a/kronolith/scripts/upgrades/convert_sql_shares_to_sqlng.php b/kronolith/scripts/upgrades/convert_sql_shares_to_sqlng.php
new file mode 100755
index 000000000..fcfb0dcd6
--- /dev/null
+++ b/kronolith/scripts/upgrades/convert_sql_shares_to_sqlng.php
@@ -0,0 +1,31 @@
+#!/usr/bin/env php
+<?php
+/**
+ * This script migrates Kronolith's share data from the SQL Horde_Share
+ * driver to the next-generation SQL Horde_Share driver.
+ *
+ * It is supposed to run at any time after migrating Kronolith to the latest DB
+ * schema version. The schema migration already migrates the data once, but
+ * this script can be used to migrate the data again, e.g. if starting to use
+ * the NG driver at a later time.
+ */
+
+/* Set up the CLI environment */
+require_once dirname(__FILE__) . '/../../lib/Application.php';
+Horde_Registry::appInit('kronolith', array('authentication' => 'none', 'cli' => true));
+
+require_once dirname(__FILE__) . '/../../migration/15_kronolith_upgrade_sqlng.php';
+
+$db = $injector->getInstance('Horde_Db_Adapter');
+$migration = new KronolithUpgradeSqlng($db);
+$cli = new Horde_Cli();
+
+$delete = $cli->prompt('Delete existing shares from the NEW backend before migrating the OLD backend? This should be done to avoid duplicate entries or primary key collisions in the storage backend from earlier migrations.', array('y' => 'Yes', 'n' => 'No'), 'n');
+
+if ($delete == 'y' || $delete == 'Y') {
+    $db->delete('DELETE FROM kronolith_sharesng');
+    $db->delete('DELETE FROM kronolith_sharesng_users');
+    $db->delete('DELETE FROM kronolith_sharesng_groups');
+}
+
+$migration->dataUp();
-- 
2.11.0