AntiSpoofCache::getByUsername() - Code Metrics - Inspection of "Upgrade bootstrap-sortable, fix CI, and a bit more..." - enwikipedia-acc/waca - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#526)

by Michael

created 2020-04-22 01:06 UTC

AntiSpoofCache::getByUsername() A

↳ Parent: AntiSpoofCache

Complexity

Conditions	2
Paths	2

Size

Total Lines	21
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	13
c	1
b	0
f	0
nc	2
nop	2
dl	0
loc	21
ccs	0
cts	17
cp	0
crap	6
rs	9.8333

<?php

/**
 * AntiSpoofCache data object
 */
class AntiSpoofCache extends DataObject
{
	protected $username;
	protected $data;
	protected $timestamp;

	public static function getByUsername($username, PdoDatabase $database)
	{
		$statement = $database->prepare(<<<SQL
SELECT *
FROM antispoofcache
WHERE username = :id AND timestamp > date_sub(now(), interval 3 hour)
LIMIT 1
SQL
		);
		$statement->bindValue(":id", $username);

		$statement->execute();

		$resultObject = $statement->fetchObject(get_called_class());

		if ($resultObject != false) {
			$resultObject->isNew = false;
			$resultObject->setDatabase($database);
		}

		return $resultObject;
	}

	public function getUsername()
	{
		return $this->username;
	}

	public function setUsername($username)
	{
		$this->username = $username;
	}

	public function getData()
	{
		return $this->data;
	}

	/**
	 * @param string $data
	 */
	public function setData($data)
	{
		$this->data = $data;
	}

	public function getTimestamp()
	{
		return $this->timestamp;
	}

	public function save()
	{
		if ($this->isNew) {
			// insert
			// clear old data first
			$this->dbObject->exec("delete from antispoofcache where timestamp < date_sub(now(), interval 3 hour);");

			$statement = $this->dbObject->prepare("INSERT INTO antispoofcache (username, data) VALUES (:username, :data);");
			$statement->bindValue(":username", $this->username);
			$statement->bindValue(":data", $this->data);

			if ($statement->execute()) {
				$this->isNew = false;
				$this->id = $this->dbObject->lastInsertId();
$answer = 42;

$correct = false;

$correct = (bool) $answer;
			}
			else {
				throw new Exception($statement->errorInfo());
				throw new Exception(/** @scrutinizer ignore-type */ $statement->errorInfo());
			}
		}
	}
}


enwikipedia-acc / waca

Pull Request — master (#526)

AntiSpoofCache::getByUsername() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like