UserPreference::setUser() - Code Metrics - Inspection of "Domains: add preference for default domain" - enwikipedia-acc/waca - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — multiproject/prefs ( 965e5d )

by Simon

created 2022-08-19 17:09 UTC

UserPreference::setUser() A

↳ Parent: UserPreference

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	1
dl	0
loc	3
rs	10
c	1
b	0
f	0
cc	1
nc	1
nop	1

<?php
/******************************************************************************
 * Wikipedia Account Creation Assistance tool                                 *
 *                                                                            *
 * All code in this file is released into the public domain by the ACC        *
 * Development Team. Please see team.json for a list of contributors.         *
 ******************************************************************************/

namespace Waca\DataObjects;

use Exception;
use Waca\DataObject;
use Waca\Exceptions\OptimisticLockFailedException;
use Waca\PdoDatabase;

class UserPreference extends DataObject
{

    /** @var int */
    private $user;

    /** @var ?int */
    private $domain;

    /** @var string */
    private $preference;

    /** @var ?mixed */
    private $value;

    public static function getLocalPreference(PdoDatabase $database, int $user, string $preference, int $domain) {
        $statement = $database->prepare('SELECT * FROM userpreference WHERE preference = :preference AND USER = :user AND domain = :domain');
        $statement->execute([
            ':user' => $user,
            ':preference' => $preference,
            ':domain' => $domain
        ]);

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

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

        return $resultObject;
    }

    public static function getGlobalPreference(PdoDatabase $database, int $user, string $preference) {
        $statement = $database->prepare('SELECT * FROM userpreference WHERE preference = :preference AND USER = :user AND domain IS NULL');
        $statement->execute([
            ':user' => $user,
            ':preference' => $preference
        ]);

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

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

        return $resultObject;
    }

    /**
     * @inheritDoc
     * @throws Exception
     */
    public function save()
    {
        if($this->isNew()) {
            // insert
            $statement = $this->dbObject->prepare(<<<SQL
                INSERT INTO `userpreference` (
                    user, domain, preference, value
                ) VALUES (
                    :user, :domain, :preference, :value
                );
SQL
            );
            $statement->bindValue(":user", $this->user);
            $statement->bindValue(":domain", $this->domain);
            $statement->bindValue(":preference", $this->preference);
            $statement->bindValue(":value", $this->value);

            if ($statement->execute()) {
                $this->id = (int)$this->dbObject->lastInsertId();
            }
            else {
                throw new Exception($statement->errorInfo());
                throw new Exception(/** @scrutinizer ignore-type */ $statement->errorInfo());
            }
        }else{
            // update
            $statement = $this->dbObject->prepare(<<<SQL
                UPDATE `userpreference` SET 
                    value = :value,
                    updateversion = updateversion + 1
                WHERE id = :id AND updateversion = :updateversion;
SQL
            );
            $statement->bindValue(":value", $this->value);

            $statement->bindValue(':id', $this->id);
            $statement->bindValue(':updateversion', $this->updateversion);

            if (!$statement->execute()) {
                throw new Exception($statement->errorInfo());
            }

            if ($statement->rowCount() !== 1) {
                throw new OptimisticLockFailedException();
            }

            $this->updateversion++;
        }
    }

    /**
     * @return int
     */
    public function getUser(): int
    {
        return $this->user;
    }

    /**
     * @param int $user
     */
    public function setUser(int $user): void
    {
        $this->user = $user;
    }

    /**
     * @return ?int
     */
    public function getDomain(): ?int
    {
        return $this->domain;
    }

    /**
     * @param ?int $domain
     */
    public function setDomain(?int $domain): void
    {
        $this->domain = $domain;
    }

    /**
     * @return string
     */
    public function getPreference(): string
    {
        return $this->preference;
    }

    /**
     * @param string $preference
     */
    public function setPreference(string $preference): void
    {
        $this->preference = $preference;
    }

    /**
     * @return mixed|null
     */
    public function getValue()
    {
        return $this->value;
    }

    /**
     * @param mixed|null $value
     */
    public function setValue($value): void
    {
        $this->value = $value;
    }
}


enwikipedia-acc / waca

Push — multiproject/prefs ( 965e5d )

UserPreference::setUser() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like