OCA\Music\Db\PlaylistMapper

Complexity

Total Complexity

5

Size/Duplication

Total Lines	50
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	makeSelectQuery()	0	5	1
A	findAll()	0	5	1
A	find()	0	5	1
A	findListsContainingTrack()	0	7	1

<?php

/**
 * ownCloud - Music app
 *
 * This file is licensed under the Affero General Public License version 3 or
 * later. See the COPYING file.
 *
 * @author Morris Jobke <hey@morrisjobke.de>
 * @author Volkan Gezer <volkangezer@gmail.com>
 * @copyright Morris Jobke 2014
 * @copyright Volkan Gezer 2014
 */

namespace OCA\Music\Db;

use OCP\AppFramework\Db\Entity;
use OCP\IDBConnection;

class PlaylistMapper extends BaseMapper {

	public function __construct(IDBConnection $db){
		parent::__construct($db, 'music_playlists', '\OCA\Music\Db\Playlist');
	}

	/**
	 * @param string $condition
	 */
	private function makeSelectQuery($condition=null){
		return 'SELECT `name`, `id`, `track_ids` ' .
			'FROM `*PREFIX*music_playlists` ' .
			'WHERE `user_id` = ? ' . $condition;
	}

	/**
	 * @param string $userId
	 * @param integer $limit
	 * @param integer $offset
	 * @return Playlist[]
	 */
	public function findAll($userId, $limit=null, $offset=null){
		$sql = $this->makeSelectQuery();
		$params = array($userId);
		return $this->findEntities($sql, $params, $limit, $offset);
	}

	/**
	 * @param integer $id
	 * @param string $userId
	 * @return Playlist
	 */
	public function find($id, $userId){
		$sql = $this->makeSelectQuery('AND `id` = ?');
		$params = array($userId, $id);
		return $this->findEntity($sql, $params);
	}

	/**
	 * @param int $trackId
	 * @return Playlist[]
	 */
	 public function findListsContainingTrack($trackId) {
		$sql = 'SELECT * ' .
			'FROM `*PREFIX*music_playlists` ' .
			'WHERE `track_ids` LIKE ?';
		$params = array('%|' . $trackId . '|%');
		return $this->findEntities($sql, $params);
	}
}