FaceMapper::findAll() - Code Metrics - Inspection of "Adding test for tasks and introducing integration..." - matiasdelellis/facerecognition - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#55)

by Branko

created 2018-11-24 20:55 UTC

FaceMapper::findAll() A

↳ Parent: FaceMapper

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

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

<?php
namespace OCA\FaceRecognition\Db;

use OCP\IDBConnection;
use OCP\AppFramework\Db\Mapper;
use OCP\AppFramework\Db\DoesNotExistException;
use OCP\DB\QueryBuilder\IQueryBuilder;

class FaceMapper extends Mapper {

	public function __construct(IDBConnection $db) {
		parent::__construct($db, 'face_recognition', '\OCA\FaceRecognition\Db\Face');
	}

	public function find($id, $userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE id = ? AND uid = ?';
		return $this->findEntity($sql, [$id, $userId]);
	}

	public function findAll($userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? and encoding IS NOT NULL';
		return $this->findEntities($sql, [$userId]);
	}

	public function findAllQueued($userId, $limit = null, $offset = null) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND distance = -1 AND encoding IS NULL';
		return $this->findEntities($sql, [$userId], $limit, $offset);
	}

	public function findAllKnown($userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND distance = 0 AND encoding IS NOT NULL';
		return $this->findEntities($sql, [$userId]);
	}

	public function findAllUnknown($userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND distance > 0 AND encoding IS NOT NULL';
		return $this->findEntities($sql, [$userId]);
	}

	public function findAllEmpty($userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND distance = 0 AND encoding IS NULL';
		return $this->findEntities($sql, [$userId]);
	}

	public function findAllNamed($userId, $query, $limit = null, $offset = null) {
		$sql = 'SELECT id, name, distance FROM *PREFIX*face_recognition WHERE uid = ? AND encoding IS NOT NULL AND LOWER(name) LIKE LOWER(?)';
		return $this->findEntities($sql, [$userId, $query], $limit, $offset);
	}

	public function findRandom($userId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND distance = 1 AND encoding IS NOT NULL ORDER BY RAND() LIMIT 8';
		return $this->findEntities($sql, [$userId]);
	}

	public function getGroups($userId) {
		$sql = 'SELECT name FROM *PREFIX*face_recognition WHERE uid = ? AND encoding IS NOT NULL GROUP BY name ORDER BY COUNT(name) DESC';
		return $this->findEntities($sql, [$userId]);
	}

	public function findNewFile($userId, $fileId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND file = ? AND distance = -1 AND encoding IS NULL';
		return $this->findEntities($sql, [$userId, $fileId]);
	}

	public function findFile($userId, $fileId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE uid = ? AND file = ?';
		return $this->findEntities($sql, [$userId, $fileId]);
	}

	public function fileExists($fileId) {
		$sql = 'SELECT * FROM *PREFIX*face_recognition WHERE file = ?';
		try {
			$faces = $this->findEntities($sql, [$fileId]);
			return ($faces != NULL);
		} catch (Exception $e) {

			return false;
		}
		return true;
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
	}

	public function countUserQueue($userId) {
		$sql = 'SELECT count(*) AS ct FROM *PREFIX*face_recognition WHERE uid = ? AND distance = -1 AND encoding IS NULL';
		$query = \OCP\DB::prepare($sql);
		$query = /** @scrutinizer ignore-deprecated */ \OCP\DB::prepare($sql);
		$result = $query->execute([$userId]);
		if ($row = $result->fetchRow()) {
			return $row['ct'];
		}
		return 0;
	}

	public function countQueue() {
		$sql = 'SELECT count(*) AS ct FROM *PREFIX*face_recognition WHERE distance = -1 AND encoding IS NULL';
		$query = \OCP\DB::prepare($sql);
		$query = /** @scrutinizer ignore-deprecated */ \OCP\DB::prepare($sql);
		$result = $query->execute();
		if ($row = $result->fetchRow()) {
			return $row['ct'];
		}
		return 0;
	}

}

matiasdelellis / facerecognition

Pull Request — master (#55)

FaceMapper::findAll() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like