OCA\Maps\Db\LocationMapper

Complexity

Total Complexity

4

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

0%

Importance

Changes

0

4 Methods

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

<?php
namespace OCA\Maps\Db;

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

class LocationMapper extends Mapper {

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

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

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

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