PostgresqlFunctionRepository::__construct() - Code Metrics - Inspection of "remove unnecessary collection definition" - michael-rubel/laravel-sql-function-repository - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( e293a6...eec931 )

by Michael

created 2022-05-26 13:08 UTC

PostgresqlFunctionRepository::__construct() A

↳ Parent: PostgresqlFunctionRepository

Complexity

Conditions	3
Paths	4

Size

Total Lines	10
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	3

Importance

Changes	1
Bugs	0	Features	0

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

<?php

declare(strict_types=1);

namespace MichaelRubel\SqlFunctionRepository\Repositories;

use Illuminate\Support\Facades\DB;
use MichaelRubel\SqlFunctionRepository\SqlFunctionRepository;

class PostgresqlFunctionRepository implements SqlFunctionRepository
{
    /**
     * @param string|null $connection
     * @param string|null $select
     */
    public function __construct(
        public ?string $connection = null,
        public ?string $select = null,
    ) {
        if (is_null($this->connection)) {
            $this->connection = config('sql-function-repository.connection', DB::getDefaultConnection());
        }

        if (is_null($this->select)) {
            $this->select = config('sql-function-repository.select', 'select * from ');
        }
    }

    /**
     * Execute the database function.
     *
     * @param string $name
     * @param array  $parameters
     *
     * @return array
     */
    public function runDatabaseFunction(string $name, array $parameters = []): array
    {
        return DB::connection($this->connection)->select(
            $this->buildSqlFunction($name, $parameters),
            $parameters
        );
    }

    /**
     * @param string $name
     * @param array  $parameters
     *
     * @return string
     */
    protected function buildSqlFunction(string $name, array $parameters): string
    {
        return $this->select . $name . str(implode('?, ', $parameters))
                ->replaceLast(', ', '')
                ->start('(')
                ->finish(')');
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace MichaelRubel\SqlFunctionRepository\Repositories;
6
7		use Illuminate\Support\Facades\DB;
8		use MichaelRubel\SqlFunctionRepository\SqlFunctionRepository;
9
10		class PostgresqlFunctionRepository implements SqlFunctionRepository
11		{
12		/**
13		* @param string\|null $connection
14		* @param string\|null $select
15		*/
16	1	public function __construct(
17		public ?string $connection = null,
18		public ?string $select = null,
19		) {
20	1	if (is_null($this->connection)) {
21	1	$this->connection = config('sql-function-repository.connection', DB::getDefaultConnection());
22		}
23
24	1	if (is_null($this->select)) {
25	1	$this->select = config('sql-function-repository.select', 'select * from ');
26		}
27		}
28
29		/**
30		* Execute the database function.
31		*
32		* @param string $name
33		* @param array $parameters
34		*
35		* @return array
36		*/
37		public function runDatabaseFunction(string $name, array $parameters = []): array
38		{
39		return DB::connection($this->connection)->select(
40		$this->buildSqlFunction($name, $parameters),
41		$parameters
42		);
43		}
44
45		/**
46		* @param string $name
47		* @param array $parameters
48		*
49		* @return string
50		*/
51		protected function buildSqlFunction(string $name, array $parameters): string
52		{
53		return $this->select . $name . str(implode('?, ', $parameters))
54		->replaceLast(', ', '')
55		->start('(')
56		->finish(')');
57		}
58		}
59

michael-rubel / laravel-sql-function-repository

Push — main ( e293a6...eec931 )

PostgresqlFunctionRepository::__construct() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like