teresko / palladium

    }

    private function updateCookie(Entity\CookieIdentity $entity)

    {

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

        $active = Entity\Identity::STATUS_ACTIVE;

        $sql = "UPDATE {$table}

                   SET status = :status,

                       hash = :hash,

                       used_on = NOW(),

                       expires_on = FROM_UNIXTIME(:expires)

                 WHERE identity_id = :id

                   AND status = {$active}";

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

        $statement->bindValue(':id', $entity->getId());

        $statement->bindValue(':status', $entity->getStatus());

        $statement->bindValue(':hash', $entity->getHash());

        $statement->bindValue(':expires', $entity->getExpiresOn());

        $statement->execute();

    }

}

    /**

     * @param Entity\Identity $entity

     */

    public function fetch(Entity\Identity $entity)

    {

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

        $sql = "SELECT identity_id                      AS id,

                       user_id                          AS userId,

                       status                           AS status,

                       hash                             AS hash,

                       UNIX_TIMESTAMP(token_expires_on) AS tokenEndOfLife

                  FROM $table

                 WHERE token = :token

                   AND token_action = :action

                   AND token_expires_on > FROM_UNIXTIME(:expires)";

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

        $statement->bindValue(':token', $entity->getToken());

        $statement->bindValue(':action', $entity->getTokenAction());

        $statement->bindValue(':expires', $entity->getTokenEndOfLife());

        $statement->execute();

        $data = $statement->fetch();

        if ($data) {

            $this->applyValues($entity, $data);

        }

    }

}

    /**

     * @param Entity\IdentityCollection $collection

     */

    public function fetch(Entity\IdentityCollection $collection)

    {

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

        $sql = "SELECT identity_id  AS id

                  FROM {$table}

                 WHERE status = :status

                   AND user_id = :user

                   AND type = :type";

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

       $statement->bindValue(':user', $collection->getUserId());

       $statement->bindValue(':status', $collection->getStatus());

       $statement->bindValue(':type', $collection->getType());

       $statement->execute();

       foreach ($statement as $parameters) {

           $collection->addBlueprint($parameters);

       }

    }

}

    /**

     * @param Entity\PasswordIdentity $entity

     */

    public function fetch(Entity\PasswordIdentity $entity)

    {

        $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);

        }

    }

    /**