vipnytt\RobotsTxtParser\SQL\TableConstructor

Complexity

Total Complexity

7

Size/Duplication

Total Lines	64
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	create()	0	14	4
A	exists()	0	9	2

<?php
namespace vipnytt\RobotsTxtParser\SQL;

use PDO;
use vipnytt\RobotsTxtParser\Exceptions\SQLException;

/**
 * Class TableConstructor
 *
 * @package vipnytt\RobotsTxtParser\SQL
 */
class TableConstructor
{
    /**
     * Database connection
     * @var PDO
     */
    private $pdo;

    /**
     * Table name
     * @var string
     */
    private $table;

    /**
     * TableConstructor constructor.
     *
     * @param PDO $pdo
     * @param string $tableName
     */
    public function __construct(PDO $pdo, $tableName)
    {
        $this->pdo = $pdo;
        $this->table = $tableName;
    }

    /**
     * Create table
     *
     * @param string $sql
     * @param string $readme
     * @return bool
     * @throws SQLException
     */
    public function create($sql, $readme)
    {
        if ($this->exists()) {
            return true;
        }
        try {
            $this->pdo->query($sql);
        } catch (\PDOException $exception) {

Consider adding a comment why this CATCH block is empty.

        }
        if ($this->exists()) {
            return true;
        }
        throw new SQLException('Automatic setup failed, please create table `' . $this->table . '` manually. Setup instructions: ' . $readme);
    }

    /**
     * Check if the table exists
     *
     * @return bool
     */
    public function exists()
    {
        try {
            $result = $this->pdo->query("SELECT 1 FROM " . $this->table . " LIMIT 1;");
        } catch (\PDOException $e) {
            return false;
        }
        return $result !== false;
    }
}