From b1bb899867b787f024c94ae26907b857e203d59c Mon Sep 17 00:00:00 2001
From: Thomas Tanghus <thomas@tanghus.net>
Date: Mon, 20 May 2013 10:16:07 +0200
Subject: [PATCH] Add rename() method to OC_VCategories.

---
 lib/vcategories.php       | 32 ++++++++++++++++++++++++++++++++
 tests/lib/vcategories.php | 10 ++++++++++
 2 files changed, 42 insertions(+)

diff --git a/lib/vcategories.php b/lib/vcategories.php
index 5975e688b75..74864704e30 100644
--- a/lib/vcategories.php
+++ b/lib/vcategories.php
@@ -324,6 +324,38 @@ class OC_VCategories {
 		return $id;
 	}
 
+	/**
+	* @brief Rename category.
+	* @param string $from The name of the existing category
+	* @param string $to The new name of the category.
+	* @returns bool
+	*/
+	public function rename($from, $to) {
+		$id = $this->array_searchi($from, $this->categories);
+		if($id === false) {
+			OCP\Util::writeLog('core', __METHOD__.', category: ' . $from. ' does not exist', OCP\Util::DEBUG);
+			return false;
+		}
+
+		$sql = 'UPDATE `' . self::CATEGORY_TABLE . '` SET `category` = ? '
+			. 'WHERE `uid` = ? AND `type` = ? AND `id` = ?';
+		try {
+			$stmt = OCP\DB::prepare($sql);
+			$result = $stmt->execute(array($to, $this->user, $this->type, $id));
+			if (OC_DB::isError($result)) {
+				echo 'DB error: ' . $result . "\n";
+				OC_Log::write('core', __METHOD__. 'DB error: ' . OC_DB::getErrorMessage($result), OC_Log::ERROR);
+				return false;
+			}
+		} catch(Exception $e) {
+			OCP\Util::writeLog('core', __METHOD__.', exception: '.$e->getMessage(),
+				OCP\Util::ERROR);
+			return false;
+		}
+		$this->categories[$id] = $to;
+		return true;
+	}
+
 	/**
 	* @brief Add a new category.
 	* @param $names A string with a name or an array of strings containing
diff --git a/tests/lib/vcategories.php b/tests/lib/vcategories.php
index e79dd49870c..a8af6ae9f7a 100644
--- a/tests/lib/vcategories.php
+++ b/tests/lib/vcategories.php
@@ -81,6 +81,16 @@ class Test_VCategories extends PHPUnit_Framework_TestCase {
 
 	}
 
+	public function testrenameCategory() {
+		$defcategories = array('Friends', 'Family', 'Wrok', 'Other');
+		$catmgr = new OC_VCategories($this->objectType, $this->user, $defcategories);
+
+		$this->assertTrue($catmgr->rename('Wrok', 'Work'));
+		$this->assertTrue($catmgr->hasCategory('Work'));
+		$this->assertFalse($catmgr->hasCategory('Wrok'));
+
+	}
+
 	public function testAddToCategory() {
 		$objids = array(1, 2, 3, 4, 5, 6, 7, 8, 9);
 
-- 
2.39.5