Helix\DB\Fluent\Value\AggregateTrait

Complexity

Total Complexity

10

Size/Duplication

Total Lines	98
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	1

9 Methods

Rating	Name	Duplication	Size	Complexity
A	avgDistinct()	0	3	1
A	min()	0	3	1
A	sumDistinct()	0	3	1
A	countDistinct()	0	3	1
A	avg()	0	3	1
A	sum()	0	3	1
A	max()	0	3	1
A	count()	0	3	1
A	groupConcat()	0	7	2

<?php

namespace Helix\DB\Fluent\Value;

use Helix\DB\Fluent\AbstractTrait;
use Helix\DB\Fluent\Num;
use Helix\DB\Fluent\Str;

/**
 * Aggregation functions.
 */
trait AggregateTrait
{

    use AbstractTrait;

    /**
     * `AVG($this)`
     *
     * @return Num
     */
    public function avg()
    {
        return Num::factory($this->db, "AVG({$this})");
    }

    /**
     * `AVG(DISTINCT $this)`
     *
     * @return Num
     */
    public function avgDistinct()
    {
        return Num::factory($this->db, "AVG(DISTINCT {$this})");
    }

    /**
     * `COUNT($this)`
     *
     * @return Num
     */
    public function count()
    {
        return Num::factory($this->db, "COUNT({$this})");
    }

    /**
     * `COUNT(DISTINCT $this)`
     *
     * @return Num
     */
    public function countDistinct()
    {
        return Num::factory($this->db, "COUNT(DISTINCT {$this})");
    }

    /**
     * `GROUP_CONCAT($this)` using a delimiter.
     *
     * @param string $delimiter
     * @return Str
     */
    public function groupConcat(string $delimiter = ',')
    {
        $delimiter = $this->db->quote($delimiter);
        if ($this->db->isSQLite()) {
            return Str::factory($this->db, "GROUP_CONCAT({$this},{$delimiter})");
        }
        return Str::factory($this->db, "GROUP_CONCAT({$this} SEPARATOR {$delimiter})");
    }

    /**
     * `MAX($this)`
     *
     * @return Num
     */
    public function max()
    {
        return Num::factory($this->db, "MAX({$this})");
    }

    /**
     * `MIN($this)`
     *
     * @return Num
     */
    public function min()
    {
        return Num::factory($this->db, "MIN({$this})");
    }

    /**
     * `SUM($this)`
     *
     * @return Num
     */
    public function sum()
    {
        return Num::factory($this->db, "SUM({$this})");
    }

    /**
     * `SUM(DISTINCT $this)`
     *
     * @return Num
     */
    public function sumDistinct()
    {
        return Num::factory($this->db, "SUM(DISTINCT {$this})");
    }
}