VIPnytt / RobotsTxtParser

     *

     * @return bool

     */

    private function increment()

    {

        $query = $this->pdo->prepare(<<<SQL

INSERT INTO robotstxt__delay0 (base, userAgent, delayUntil, lastDelay)

VALUES (:base, :userAgent, (UNIX_TIMESTAMP(CURTIME(6)) + :delay) * 1000000, :delay * 1000000)

ON DUPLICATE KEY UPDATE

  delayUntil = GREATEST((UNIX_TIMESTAMP(CURTIME(6)) + :delay) * 1000000, delayUntil + (:delay * 1000000)),

  lastDelay = :delay * 1000000;

SQL

        );

        $query->bindValue('base', $this->base, \PDO::PARAM_STR);

        $query->bindValue('userAgent', $this->userAgent, \PDO::PARAM_STR);

        $query->bindValue('delay', $this->delay, \PDO::PARAM_INT);

        return $query->execute();

    }

    /**

     * Debug - Get raw data

     *

     * @return array

     */

    public function debug()

    {

        $query = $this->pdo->prepare(<<<SQL

SELECT *

FROM robotstxt__delay0

WHERE base = :base AND userAgent = :userAgent;

SQL

        );

        $query->bindValue('base', $this->base, \PDO::PARAM_STR);

        $query->bindValue('userAgent', $this->userAgent, \PDO::PARAM_STR);

        $query->execute();

        return $query->rowCount() > 0 ? $query->fetch(\PDO::FETCH_ASSOC) : [];

    }

}