App\Ship\Utils\DatabaseLogger

Complexity

Total Complexity

5

Size/Duplication

Total Lines	56
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	13	1
A	isTable()	0	7	1
A	checkLog()	0	12	1
A	__construct()	0	3	1
A	writeLog()	0	8	1

<?php

namespace App\Ship\Utils;

use Rudra\Container\Facades\Rudra;

class DatabaseLogger
{
    protected \PDO $dsn;
    protected string $table;

    public function __construct()
    {
        $this->dsn = Rudra::get("DSN");
    }

    protected function up(): void
    {
        $query = $this->dsn->prepare("
            CREATE TABLE {$this->table} (
            `id` INT NOT NULL AUTO_INCREMENT ,
            `name` VARCHAR(255) NOT NULL , 
            `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
            `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                PRIMARY KEY (`id`)
            ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci
        ");

        $query->execute();
    }

    protected function isTable()
    {
        $query = $this->dsn->query("
            SHOW TABLES LIKE '{$this->table}';
        ");

        return $query->fetchColumn();
    }

    protected function writeLog(string $name): void
    {
        $query = $this->dsn->prepare("
            INSERT INTO {$this->table} (`name`)
            VALUES (:name)"
        );

        $query->execute([':name' => $name]);
    }

    protected function checkLog(string $name)
    {
        $stmt = $this->dsn->prepare("
            SELECT * FROM {$this->table}
            WHERE name = :name
        ");

        $stmt->execute([
            ':name' => $name,
        ]);

        return $stmt->fetch(\PDO::FETCH_ASSOC);
    }
}