teresko / palladium

    }

    private function createCookie(Entity\CookieIdentity $entity)

    {

        $sql = "INSERT INTO {$this->table}

                       (account_id, parent_id, type, status, identifier, fingerprint, hash, created_on, expires_on)

                VALUES (:account, :parent, :type, :status, :identifier, :fingerprint, :hash, :created, :expires)";

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

        $statement->bindValue(':parent', $entity->getParentId());

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

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

        $statement->bindValue(':created', time());

        $this->bindCommonParameters($statement, $entity);

        $statement->execute();

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

    }

    private function updateCookie(Entity\CookieIdentity $entity)

    }

    private function fetchByToken(Entity\Identity $entity)

    {

        $sql = "SELECT identity_id      AS id,

                       parent_id        AS parentId,

                       account_id       AS accountId,

                       status           AS status,

                       hash             AS hash,

                       token_expires_on AS tokenEndOfLife

                  FROM {$this->table}

                 WHERE token = :token

                   AND token_action = :action

                   AND token_expires_on > :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(PDO::FETCH_ASSOC);

        if ($data) {

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

        }

    }

}

    }

    private function fetchByEmailAddress(Entity\EmailIdentity $entity)

    {

        $sql = "SELECT identity_id      AS id,

                       account_id       AS accountId,

                       hash             AS hash,

                       status           AS status,

                       used_on          AS lastUsed,

                       token            AS token,

                       token_action     AS tokenAction,

                       token_expires_on AS tokenEndOfLife

                  FROM {$this->table}

                 WHERE type = :type

                   AND fingerprint = :fingerprint

                   AND identifier = :email";

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

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

        $statement->bindValue(':email', $entity->getEmailAddress());

        $statement->bindValue(':fingerprint', $entity->getFingerprint());

        $statement->execute();

        $data = $statement->fetch(PDO::FETCH_ASSOC);

        if ($data) {

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

        }

    }

    }

    private function fetchById(Entity\EmailIdentity $entity)

    {

        $sql = "SELECT identity_id      AS id,

                       account_id       AS accountId,

                       hash             AS hash,

                       status           AS status,

                       used_on          AS lastUsed,

                       token            AS token,

                       token_action     AS tokenAction,

                       token_expires_on AS tokenEndOfLife

                  FROM {$this->table}

                 WHERE type = :type

                   AND identity_id = :id";

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

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

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

        $statement->execute();

        $data = $statement->fetch(PDO::FETCH_ASSOC);

        if ($data) {

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

        }

    }

    /**