OCA\Maps\Db\DeviceMapper

Complexity

Total Complexity

4

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	1	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	findByHash()	0	5	1
A	findById()	0	5	1
A	findAll()	0	5	1

<?php
namespace OCA\Maps\Db;

use OCP\AppFramework\Db\Mapper;
use OCP\IDb;

class DeviceMapper extends Mapper {

	public function __construct(IDB $db) {
		parent::__construct($db, 'maps_location_track_users', '\OCA\Maps\Db\Device');
	}

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

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

	/**
	 * @param string $userId
	 * @param int $limit
	 * @param int $offset
	 * @return Device[]
	 */
	public function findAll($userId, $limit=null, $offset=null) {
		$sql = 'SELECT * FROM `*PREFIX*maps_location_track_users`'.
			'WHERE `user_id` = ?';
		return $this->findEntities($sql, [$userId], $limit, $offset);
	}

}