OCA\Maps\Db\FavoriteMapper

Complexity

Total Complexity

5

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	2
Bugs	0	Features	2

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	find()	0	5	1
A	findByName()	0	7	1
A	findBetween()	0	6	1
A	findAll()	0	4	1

<?php
namespace OCA\Maps\Db;

use OCP\AppFramework\Db\Mapper;
use OCP\IDBConnection;

class FavoriteMapper extends Mapper {

	public function __construct(IDBConnection $db) {
		parent::__construct($db, 'maps_favorites', '\OCA\Maps\Db\Favorite');
	}

	/**
	 * @param int $id
	 * @throws \OCP\AppFramework\Db\DoesNotExistException if not found
	 * @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result
	 * @return Favorite
	 */
	public function find($id) {
		$sql = 'SELECT * FROM `*PREFIX*maps_favorites` '.
			'WHERE `id` = ?';
		return $this->findEntity($sql, [$id]);
	}

	/**
	 * @param string $name
	 * @return Favorite[]
	 */
	public function findByName($name) {
		//TODO add COLLATE SQL_Latin1_General_Cp437_CI_AS_KI_WI
		//TODO and replace ? by %?%
		$sql = 'SELECT * FROM `*PREFIX*maps_favorites` '.
			'WHERE `name` LIKE ?';
		return $this->findEntities($sql, [$name]);
	}

	/**
	 * @param string $userId
	 * @param string $from
	 * @param string $until
	 * @param int $limit
	 * @param int $offset
	 * @return Favorite[]
	 */
	public function findBetween($userId, $from, $until, $limit=null, $offset=null) {
		$sql = 'SELECT * FROM `*PREFIX*maps_favorites` '.
			'WHERE `userId` = ?'.
			'AND `timestamp` BETWEEN ? and ?';
		return $this->findEntities($sql, [$userId, $from, $until], $limit, $offset);
	}

	/**
	 * @param int $limit
	 * @param int $offset
	 * @return Favorite[]
	 */
	public function findAll($limit=null, $offset=null) {
		$sql = 'SELECT * FROM `*PREFIX*maps_favorites`';
		return $this->findEntities($sql, $limit, $offset);
	}
}