Horat1us\Yii\Helpers\QueryHelper

Complexity

Total Complexity

5

Size/Duplication

Total Lines	52
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	sqlCall()	0	10	1
A	coalesce()	0	4	1
A	caseWhen()	0	16	3

<?php

namespace Horat1us\Yii\Helpers;

use yii\db\Expression;

/**
 * Class QueryHelper
 * @package Horat1us\Yii\Helpers
 */
class QueryHelper
{
    /**
     * @param string $sqlMethod
     * @param mixed[] $params
     * @return Expression
     */
    public static function sqlCall(string $sqlMethod, ...$params): Expression
    {
        $expressions = implode(', ', array_map(function ($expression) {
            return "({$expression})";
        }, (array)$params));

        $command = "{$sqlMethod}({$expressions})";

        return new Expression($command);
    }

    /**
     * Only for PostgreSQL
     *
     * @param array ...$params
     * @return Expression
     */
    public static function coalesce(...$params): Expression
    {
        return static::sqlCall('COALESCE', ...$params);
    }

    /**
     * @param array $cases
     * @param string|null $value
     * @param string|null $else
     * @return string
     */
    public static function caseWhen(array $cases, string $value = '', string $else = null): string
    {
        $command = "CASE {$value}";

        foreach ($cases as $condition => $statement) {
            $command .= " WHEN {$condition} THEN {$statement}";
        }

        if ($else) {

The expression $else of type null|string is loosely compared to true; this is ambiguous if the string can be empty. You might want to explicitly use !== null instead.

            $command .= " ELSE {$else}";
        }

        $command .= " END";

        return new Expression($command);
    }
}