LocationMapper::findBetween() - Code Metrics - owncloud/maps - Measure and Improve Code Quality continuously with Scrutinizer

LocationMapper::findBetween() A
last analyzed 2018-09-10 12:52 UTC

↳ Parent: LocationMapper

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	6
ccs	0
cts	6
cp	0
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	5
crap	2

<?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);
	}
}


1			<?php
2			namespace OCA\Maps\Db;
3
4			use OCP\AppFramework\Db\Mapper;
5			use OCP\IDb;
6
7			class LocationMapper extends Mapper {
8
9			public function __construct(IDB $db) {
10			parent::__construct($db, 'maps_locations', '\OCA\Maps\Db\Location');
11			}
12
13			/**
14			* @param int $id
15			* @throws \OCP\AppFramework\Db\DoesNotExistException if not found
16			* @throws \OCP\AppFramework\Db\MultipleObjectsReturnedException if more than one result
17			* @return Location
18			*/
19			public function find($id) {
20			$sql = 'SELECT * FROM `PREFIXmaps_locations` '.
21			'WHERE `id` = ?';
22			return $this->findEntity($sql, [$id]);
23			}
24
25			/**
26			* @param string $deviceHash
27			* @param string $from
28			* @param string $until
29			* @param int $limit
30			* @param int $offset
31			* @return Location[]
32			*/
33			public function findBetween($deviceHash, $from, $until, $limit=null, $offset=null) {
34			$sql = 'SELECT * FROM `PREFIXmaps_locations` '.
35			'WHERE `device_hash` = ?'.
36			'AND `timestamp` BETWEEN ? and ?';
37			return $this->findEntities($sql, [$deviceHash, $from, $until], $limit, $offset);
38			}
39
40			/**
41			* @param int $limit
42			* @param int $offset
43			* @return Location[]
44			*/
45			public function findAll($limit=null, $offset=null) {
46			$sql = 'SELECT * FROM `PREFIXmaps_locations`';
47			return $this->findEntities($sql, $limit, $offset);
48			}
49			}
50

owncloud / maps

LocationMapper::findBetween() A last analyzed 2018-09-10 12:52 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

LocationMapper::findBetween() A
last analyzed 2018-09-10 12:52 UTC