DatabaseLogger::up() - Code Metrics - Inspection of "update" - Jagepard/Rudra-Framework - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#75)

by Korotkov

created 2024-03-19 15:38 UTC

DatabaseLogger::up() A

↳ Parent: DatabaseLogger

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	3
nc	1
nop	0
dl	0
loc	13
rs	10
c	1
b	0
f	0

<?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);
    }
}

1			<?php
2
3			namespace App\Ship\Utils;
4
5			use Rudra\Container\Facades\Rudra;
6
7			class DatabaseLogger
8			{
9			protected \PDO $dsn;
10			protected string $table;
11
12			public function __construct()
13			{
14			$this->dsn = Rudra::get("DSN");
15			}
16
17			protected function up(): void
18			{
19			$query = $this->dsn->prepare("
20			CREATE TABLE {$this->table} (
21			`id` INT NOT NULL AUTO_INCREMENT ,
22			`name` VARCHAR(255) NOT NULL ,
23			`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
24			`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
25			PRIMARY KEY (`id`)
26			) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci
27			");
28
29			$query->execute();
30			}
31
32			protected function isTable()
33			{
34			$query = $this->dsn->query("
35			SHOW TABLES LIKE '{$this->table}';
36			");
37
38			return $query->fetchColumn();
39			}
40
41			protected function writeLog(string $name): void
42			{
43			$query = $this->dsn->prepare("
44			INSERT INTO {$this->table} (`name`)
45			VALUES (:name)"
46			);
47
48			$query->execute([':name' => $name]);
49			}
50
51			protected function checkLog(string $name)
52			{
53			$stmt = $this->dsn->prepare("
54			SELECT * FROM {$this->table}
55			WHERE name = :name
56			");
57
58			$stmt->execute([
59			':name' => $name,
60			]);
61
62			return $stmt->fetch(\PDO::FETCH_ASSOC);
63			}
64			}

Jagepard / Rudra-Framework

Pull Request — master (#75)

DatabaseLogger::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like