DB::insertHashes() - Code Metrics - Inspection of "Fix/query builder (#10)" - omatech/enigma - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 698fd2...95f32c )

by Christian

created 2020-04-13 21:27 UTC

DB::insertHashes() A

↳ Parent: DB

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	2

Importance

Changes

Metric	Value
cc	2
eloc	5
c	0
b	0
f	0
nc	2
nop	3
dl	0
loc	8
ccs	5
cts	5
cp	1
crap	2
rs	10

<?php

namespace Omatech\Enigma\Database\Eloquent;

use Illuminate\Support\Facades\DB as Query;

final class DB extends DBAbstract
{
    private $table;

    /**
     * DB constructor.
     * @param string $table
     */
    public function __construct(string $table)
    {
        $this->table = $table.'_index';
    }

    /**
     * @param int $modelId
     * @param string $column
     * @param array $hashes
     * @return void
     */
    public function insertHashes(int $modelId, string $column, array $hashes): void
    {
        foreach (array_chunk($hashes, 100) as $chunks) {
            $insert = array_map(function ($hash) use ($modelId, $column) {
                return "('$modelId', '$column', '$hash')";
            }, $chunks);

            Query::statement("INSERT INTO $this->table (model_id, name, hash) VALUES ".implode(',', $insert));
        }
    }

    /**
     * @param int $modelId
     * @param string $column
     * @return void
     */
    public function deleteHashes(int $modelId, string $column): void
    {
        Query::statement("DELETE FROM $this->table WHERE model_id = $modelId AND name = '$column'");
    }

    /**
     * @param string $column
     * @param string $hash
     * @return array
     */
    public function findByHash(string $column, string $hash): array
    {
        $query = Query::select(
            "SELECT model_id FROM $this->table
            WHERE name = '$column' AND
                  hash = '$hash' AND
                  model_id IS NOT NULL"
        );

        return array_map(static function ($row) {
            return $row->model_id;
        }, $query ?? []);
    }
}


1		<?php
2
3		namespace Omatech\Enigma\Database\Eloquent;
4
5		use Illuminate\Support\Facades\DB as Query;
6
7		final class DB extends DBAbstract
8		{
9		private $table;
10
11		/**
12		* DB constructor.
13		* @param string $table
14		*/
15	44	public function __construct(string $table)
16		{
17	44	$this->table = $table.'_index';
18	44	}
19
20		/**
21		* @param int $modelId
22		* @param string $column
23		* @param array $hashes
24		* @return void
25		*/
26	44	public function insertHashes(int $modelId, string $column, array $hashes): void
27		{
28	44	foreach (array_chunk($hashes, 100) as $chunks) {
29		$insert = array_map(function ($hash) use ($modelId, $column) {
30	44	return "('$modelId', '$column', '$hash')";
31	44	}, $chunks);
32
33	44	Query::statement("INSERT INTO $this->table (model_id, name, hash) VALUES ".implode(',', $insert));
34		}
35	44	}
36
37		/**
38		* @param int $modelId
39		* @param string $column
40		* @return void
41		*/
42	44	public function deleteHashes(int $modelId, string $column): void
43		{
44	44	Query::statement("DELETE FROM $this->table WHERE model_id = $modelId AND name = '$column'");
45	44	}
46
47		/**
48		* @param string $column
49		* @param string $hash
50		* @return array
51		*/
52	24	public function findByHash(string $column, string $hash): array
53		{
54	24	$query = Query::select(
55	24	"SELECT model_id FROM $this->table
56	24	WHERE name = '$column' AND
57	24	hash = '$hash' AND
58		model_id IS NOT NULL"
59		);
60
61		return array_map(static function ($row) {
62	20	return $row->model_id;
63	24	}, $query ?? []);
64		}
65		}
66

omatech / enigma

GitHub Access Token became invalid

Push — master ( 698fd2...95f32c )

DB::insertHashes() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like