Helix\DB\SQL\AggregateTrait

Complexity

Total Complexity

10

Size/Duplication

Total Lines	88
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

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

<?php

namespace Helix\DB\SQL;

/**
 * Produces aggregate expressions for the instance.
 */
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 Text
     */
    public function groupConcat (string $delimiter = ',') {
        $delimiter = $this->db->quote($delimiter);
        if ($this->db->isSQLite()) {
            return Text::factory($this->db, "GROUP_CONCAT({$this},{$delimiter})");
        }
        return Text::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})");
    }
}