vipnytt\RobotsTxtParser\Client\SQL\Cache\CacheMaintenanceSQL

Complexity

Total Complexity

4

Size/Duplication

Total Lines	50
Duplicated Lines	14 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	clean()	0	10	1
A	setup()	7	7	2

<?php
namespace vipnytt\RobotsTxtParser\Client\SQL\Cache;

use PDO;
use vipnytt\RobotsTxtParser\Client\SQL\SQLInterface;
use vipnytt\RobotsTxtParser\Client\SQL\SQLTrait;
use vipnytt\RobotsTxtParser\Exceptions\SQLException;
use vipnytt\RobotsTxtParser\RobotsTxtInterface;

/**
 * Class CacheMaintenanceSQL
 *
 * @package vipnytt\RobotsTxtParser\Client\SQL\Cache
 */
class CacheMaintenanceSQL implements RobotsTxtInterface, SQLInterface
{
    use SQLTrait;

    /**
     * @var PDO
     */
    private $pdo;

    /**
     * Maintenance constructor.
     *
     * @param PDO $pdo
     */
    public function __construct(PDO $pdo)
    {
        $this->pdo = $this->pdoInitialize($pdo);
    }

    /**
     * Clean the cache table
     *
     * @param int $delay - in seconds
     * @return bool
     */
    public function clean($delay = self::CACHE_TIME)
    {
        $query = $this->pdo->prepare(<<<SQL
DELETE FROM robotstxt__cache0
WHERE worker = 0 AND nextUpdate < (UNIX_TIMESTAMP() - :delay);
SQL
        );
        $query->bindParam(':delay', $delay, PDO::PARAM_INT);
        return $query->execute();
    }

    /**
     * Create SQL table
     *
     * @return bool
     * @throws SQLException
     */
    public function setup()

This method seems to be duplicated in your project.

    {
        if (!$this->createTable($this->pdo, self::TABLE_CACHE, file_get_contents(__DIR__ . '/cache.sql'))) {
            throw new SQLException('Unable to create table! Please read instructions at ' . self::README_SQL_CACHE);
        }
        return true;
    }
}