Palladium\Mapper\PasswordIdentity

Complexity

Total Complexity

7

Size/Duplication

Total Lines	130
Duplicated Lines	60 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	exists()	0	22	1
B	fetch()	30	30	2
A	store()	0	9	2
A	createIdentity()	23	23	1
B	updateIdentity()	25	25	1

<?php

namespace Palladium\Mapper;

/**
 * SQL logic for authentication attemps using username/password
 */

use Palladium\Component\SqlMapper;
use Palladium\Entity\Authentication as Entity;

class PasswordIdentity extends SqlMapper
{

    /**
     * @param Entity\PasswordIdentity $entity
     */
    public function exists(Entity\PasswordIdentity $entity)
    {
        $table = $this->config['accounts']['identities'];

        $sql = "SELECT 1
                  FROM {$table}
                 WHERE type = :type
                   AND fingerprint = :fingerprint
                   AND identifier = :identifier
                   AND (expires_on IS NULL OR expires_on > NOW())";

        $statement = $this->connection->prepare($sql);

        $statement->bindValue(':type', Entity\Identity::TYPE_PASSWORD);
        $statement->bindValue(':fingerprint', $entity->getFingerprint());
        $statement->bindValue(':identifier', $entity->getIdentifier());

        $statement->execute();
        $data = $statement->fetch();

        return empty($data) === false;
    }


    /**
     * @param Entity\PasswordIdentity $entity
     */
    public function fetch(Entity\PasswordIdentity $entity)

This method seems to be duplicated in your project.

    {
        $table = $this->config['accounts']['identities'];

        $sql = "SELECT identity_id                      AS id,
                       user_id                          AS userId,
                       hash                             AS hash,
                       status                           AS status,
                       token                            AS token,
                       token_action                     AS tokenAction,
                       UNIX_TIMESTAMP(token_expires_on) AS tokenEndOfLife
                  FROM $table
                 WHERE type = :type
                   AND fingerprint = :fingerprint
                   AND identifier = :identifier";

        $statement = $this->connection->prepare($sql);

        $statement->bindValue(':type', $entity->getType());
        $statement->bindValue(':identifier', $entity->getIdentifier());
        $statement->bindValue(':fingerprint', $entity->getFingerprint());

        $statement->execute();

        $data = $statement->fetch();

        if ($data) {
            $this->applyValues($entity, $data);
        }
    }


    /**
     * @param Entity\PasswordIdentity $entity
     */
    public function store(Entity\PasswordIdentity $entity)
    {
        if ($entity->getId() === null) {
            $this->createIdentity($entity);
            return;
        }

        $this->updateIdentity($entity);
    }


    private function createIdentity(Entity\PasswordIdentity $entity)

This method seems to be duplicated in your project.

    {
        $table = $this->config['accounts']['identities'];

        $sql = "INSERT INTO {$table}
                       (type, status, identifier, fingerprint, hash, token, token_action, token_expires_on )
                VALUES (:type, :status, :identifier, :fingerprint, :hash, :token, :action, FROM_UNIXTIME(:token_eol))";

        $statement = $this->connection->prepare($sql);

        $statement->bindValue(':type', Entity\Identity::TYPE_PASSWORD);
        $statement->bindValue(':status', Entity\Identity::STATUS_NEW);
        $statement->bindValue(':identifier', $entity->getIdentifier());
        $statement->bindValue(':fingerprint', $entity->getFingerprint());
        $statement->bindValue(':hash', $entity->getHash());
        $statement->bindValue(':token', $entity->getToken());
        $statement->bindValue(':action', $entity->getTokenAction());
        $statement->bindValue(':token_eol', $entity->getTokenEndOfLife());

        $statement->execute();

        $entity->setId($this->connection->lastInsertId());
    }


    private function updateIdentity(Entity\PasswordIdentity $entity)

This method seems to be duplicated in your project.

    {
        $table = $this->config['accounts']['identities'];

        $sql = "UPDATE {$table}
                   SET hash = :hash,
                       status = :status,
                       expires_on = FROM_UNIXTIME(:expires),
                       token = :token,
                       token_action = :action,
                       token_expires_on = FROM_UNIXTIME(:token_eol)
                 WHERE identity_id = :id";

         $statement = $this->connection->prepare($sql);

         $statement->bindValue(':id', $entity->getId());
         $statement->bindValue(':hash', $entity->getHash());
         $statement->bindValue(':status', $entity->getStatus());
         $statement->bindValue(':expires', $entity->getExpiresOn());
         $statement->bindValue(':token', $entity->getToken());
         $statement->bindValue(':action', $entity->getTokenAction());
         $statement->bindValue(':token_eol', $entity->getTokenEndOfLife());

         $statement->execute();
    }
}