NirjharLo\Cgss\Models\Insight

Complexity

Total Complexity

6

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	2
A	insert()	0	8	1
A	all()	0	4	1
A	count()	0	4	1
A	updateRemark()	0	8	1

<?php
namespace NirjharLo\Cgss\Models;

use wpdb;

The type wpdb was not found. Maybe you did not declare it correctly or list all dependencies?

/**
 * Simple model for cgss_insight table.
 */
class Insight
{
    /** @var wpdb */
    protected $db;

    /** @var string */
    protected $table;

    public function __construct(?wpdb $db = null)
    {
        global $wpdb;
        $this->db = $db ?: $wpdb;
        $this->table = $this->db->prefix . 'cgss_insight';
    }

    /**
     * Get all rows from the insight table.
     */
    public function all(): array
    {
        $sql = "SELECT * FROM {$this->table}";
        return $this->db->get_results($sql, ARRAY_A);

The constant NirjharLo\Cgss\Models\ARRAY_A was not found. Maybe you did not declare it correctly or list all dependencies?

    }

    /**
     * Count rows in the insight table.
     */
    public function count(): int
    {
        $sql = "SELECT COUNT(*) FROM {$this->table}";
        return (int) $this->db->get_var($sql);
    }

    /**
     * Insert an insight row.
     */
    public function insert(string $item, string $remark, int $id): bool
    {
        $result = $this->db->insert(
            $this->table,
            ['ID' => $id, 'item' => $item, 'remark' => $remark],
            ['%d', '%s', '%s']
        );
        return $result !== false;
    }

    /**
     * Update remark value by row id.
     */
    public function updateRemark(int $id, string $remark): int
    {
        return $this->db->update(
            $this->table,
            ['remark' => $remark],
            ['ID' => $id],
            ['%s'],
            ['%d']
        );
    }
}