WelcomeTemplate::save() - Code Metrics - Inspection of "113bb8bd1ae298bcc882542aa066edf6bfecd775" - mdaniels5757/waca - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — newinternal (113bb8)

by Michael

created 2020-04-28 14:34 UTC

WelcomeTemplate::save() A

↳ Parent: WelcomeTemplate

Complexity

Conditions	5
Paths	5

Size

Total Lines	43
Code Lines	26

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	30

Importance

Changes

Metric	Value
eloc	26
c	0
b	0
f	0
dl	0
loc	43
ccs	0
cts	35
cp	0
rs	9.1928
cc	5
nc	5
nop	0
crap	30

<?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 PDO;
use Waca\DataObject;
use Waca\Exceptions\OptimisticLockFailedException;
use Waca\PdoDatabase;

/**
 * Welcome template data object
 */
class WelcomeTemplate extends DataObject
{
    /** @var string */
    private $usercode;
    /** @var string */
    private $botcode;
    private $usageCache;
    private $deleted = 0;

    /**
     * Summary of getAll
     *
     * @param PdoDatabase $database
     *
     * @return WelcomeTemplate[]
     */
    public static function getAll(PdoDatabase $database)
    {
        $statement = $database->prepare("SELECT * FROM welcometemplate WHERE deleted = 0;");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

        $statement->execute();

        $result = array();
        /** @var WelcomeTemplate $v */
        foreach ($statement->fetchAll(PDO::FETCH_CLASS, self::class) as $v) {
            $v->setDatabase($database);
            $result[] = $v;
        }

        return $result;
    }


    /**
     * @throws Exception
     */

    public function save()
    {
        if ($this->isNew()) {
            // insert
            $statement = $this->dbObject->prepare(<<<SQL
INSERT INTO welcometemplate (usercode, botcode) VALUES (:usercode, :botcode);
SQL
            );
            $statement->bindValue(":usercode", $this->usercode);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            $statement->bindValue(":botcode", $this->botcode);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

            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 `welcometemplate`
SET usercode = :usercode, botcode = :botcode, updateversion = updateversion + 1
WHERE id = :id AND updateversion = :updateversion
LIMIT 1;
SQL
            );

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

            $statement->bindValue(':usercode', $this->usercode);
            $statement->bindValue(':botcode', $this->botcode);

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

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

            $this->updateversion++;
        }
    }


    /**
     * @return string
     */
    public function getUserCode()
    {
        return $this->usercode;
    }


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


    /**
     * @return string
     */
    public function getBotCode()
    {
        return $this->botcode;
    }


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


    /**
     * @return User[]
     */
    public function getUsersUsingTemplate()
    {
        if ($this->usageCache === null) {
            $statement = $this->dbObject->prepare("SELECT * FROM user WHERE welcome_template = :id;");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

            $statement->execute(array(":id" => $this->id));
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

            $result = array();
            /** @var WelcomeTemplate $v */
            foreach ($statement->fetchAll(PDO::FETCH_CLASS, User::class) as $v) {
                $v->setDatabase($this->dbObject);
                $result[] = $v;
            }

            $this->usageCache = $result;
        }

        return $this->usageCache;
    }


    /**
     * Deletes the object from the database
     */

    public function delete()
    {
        if ($this->id === null) {
            // wtf?
            return;
        }

        $deleteQuery = "UPDATE welcometemplate SET deleted = 1 WHERE id = :id AND updateversion = :updateversion;";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $statement = $this->dbObject->prepare($deleteQuery);

        $statement->bindValue(":id", $this->id);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $statement->bindValue(":updateversion", $this->updateversion);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        $statement->execute();

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


    /**
     * @return bool
     */
    public function isDeleted()
    {
        return ((int)$this->deleted) === 1;
    }

}



mdaniels5757 / waca

Branch — newinternal (113bb8)

WelcomeTemplate::save() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like