OCA\Files_PaperHive\PaperHiveMetadata

Complexity

Total Complexity

6

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	insertBookID()	0	14	3
A	getBookID()	0	11	2
A	deleteBookID()	0	5	1

<?php
/**
 * @author Piotr Mrowczynski <piotr.mrowczynski@yahoo.com>
 *
 * @copyright Copyright (c) 2018, Piotr Mrowczynski.
 * @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/>
 *
 */

/**
 * This class handles hooks.
 */
namespace OCA\Files_PaperHive;

use OC\DatabaseException;

class PaperHiveMetadata {

	/**
	 * @param $fileId
	 * @param $docId
	 * @return bool
	 * @throws \OC\DatabaseException
	 */
	public function insertBookID($fileId, $docId) {
		try {
			$query = \OC_DB::prepare("INSERT INTO `*PREFIX*paperhive` (`fileid`,`bookid`) VALUES (?,?)");
			$result = $query->execute([$fileId, $docId]);
		} catch (DatabaseException $e) {

The class OC\DatabaseException does not exist. Did you forget a USE statement, or did you not list all dependencies?

			$result = false;
		}

		if (!$result) {
			\OCP\Util::writeLog('files_paperhive', 'paperhive database couldn\'t be updated for the files owner', \OCP\Util::ERROR);
			return false;
		}
		return true;
	}

	/**
	 * @param $fileId
	 * @return bool
	 * @throws DatabaseException
	 */
	public function getBookID($fileId) {
		$query = \OC_DB::prepare('SELECT `bookid`'
			. ' FROM `*PREFIX*paperhive` WHERE `fileid`=? LIMIT 1');
		$result = $query->execute([$fileId]);

		while ($row = $result->fetchRow()) {
			return $row['bookid'];
		}

		return false;
	}

	/**
	 * @param $fileId
	 * @return bool
	 * @throws DatabaseException
	 */
	public function deleteBookID($fileId) {
		$query = \OC_DB::prepare('DELETE FROM `*PREFIX*paperhive` WHERE `fileid`=?');
		$query->execute([$fileId]);
		return true;
	}
}