Arcanedev\LaravelMetrics\Expressions\TrendDateFormat\PostgresExpression

Complexity

Total Complexity

9

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	getValue()	0	24	6
A	interval()	0	14	3

<?php

declare(strict_types=1);

namespace Arcanedev\LaravelMetrics\Expressions\TrendDateFormat;

use Arcanedev\LaravelMetrics\Exceptions\InvalidTrendUnitException;
use Arcanedev\LaravelMetrics\Metrics\Trend;

/**
 * Class     PostgresExpression
 *
 * @author   ARCANEDEV <arcanedev.maroc@gmail.com>
 */
class PostgresExpression extends Expression
{
    /* -----------------------------------------------------------------
     |  Main Methods
     | -----------------------------------------------------------------
     */

    /**
     * Get the value of the expression.
     *
     * @return string
     */
    public function getValue(): string
    {
        $interval = $this->interval();

        switch ($this->unit) {
            case Trend::BY_MONTHS:
                return "to_char({$this->wrap($this->value)}{$interval}, 'YYYY-MM')";

            case Trend::BY_WEEKS:
                return "to_char({$this->wrap($this->value)}{$interval}, 'IYYY-IW')";

            case Trend::BY_DAYS:
                return "to_char({$this->wrap($this->value)}{$interval}, 'YYYY-MM-DD')";

            case Trend::BY_HOURS:
                return "to_char({$this->wrap($this->value)}{$interval}, 'YYYY-MM-DD HH24:00')";

            case Trend::BY_MINUTES:
                return "to_char({$this->wrap($this->value)}{$interval}, 'YYYY-MM-DD HH24:mi:00')";

            default:
                throw InvalidTrendUnitException::make($this->unit);
        }
    }

    /* -----------------------------------------------------------------
     |  Other Methods
     | -----------------------------------------------------------------
     */

    /**
     * Get the interval.
     *
     * @return string
     */
    private function interval(): string
    {
        $offset = $this->offset();

        if ($offset > 0) {
            return ' + interval \''.$offset.' hour\'';
        }

        if ($offset === 0) {
            return '';
        }

        return ' - interval \''.($offset * -1).' HOUR\'';
    }
}