14698093036

Committed 26 Apr 2025 06:23AM UTC coverage: 80.248% (+0.03%) from 80.219%

Build # 14698093036

Build Type

push

github

Committed by

web-flow

Commit Message

feat(database): add `Count` query builder and statement (#1174)

Run Details

58 of 67 new or added lines in 4 files covered. (86.57%)

11843 of 14758 relevant lines covered (80.25%)

106.71 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

92.0

/src/Tempest/Database/src/QueryStatements/CountStatement.php

<?php

namespace Tempest\Database\QueryStatements;

use Tempest\Database\Builder\TableDefinition;
use Tempest\Database\Config\DatabaseDialect;
use Tempest\Database\QueryStatement;
use Tempest\Support\Arr\ImmutableArray;

use function Tempest\Support\arr;

final class CountStatement implements QueryStatement
{
    public bool $distinct = false;

    public function __construct(
        public readonly TableDefinition $table,
        public ?string $column = null,
        public ImmutableArray $where = new ImmutableArray(),
    ) {}

    public function compile(DatabaseDialect $dialect): string
    {
        $query = arr([
            sprintf(
                'SELECT COUNT(%s)',
                $this->getCountArgument(),
            ),
            sprintf('FROM `%s`', $this->table->name),
        ]);

        if ($this->where->isNotEmpty()) {
            $query[] = 'WHERE ' . $this->where
                ->map(fn (WhereStatement $where) => $where->compile($dialect))
                ->implode(PHP_EOL);
        }

        return $query->implode(PHP_EOL);
    }

    public function getCountArgument(): string
    {
        return $this->column === null || $this->column === '*'
            ? '*'
            : sprintf(
                '%s`%s`',
                $this->distinct ? 'DISTINCT ' : '',
                $this->column,
            );
    }

    public function getKey(): string
    {
        return "COUNT({$this->getCountArgument()})";
    }
}

1	<?php
2
3	namespace Tempest\Database\QueryStatements;
4
5	use Tempest\Database\Builder\TableDefinition;
6	use Tempest\Database\Config\DatabaseDialect;
7	use Tempest\Database\QueryStatement;
8	use Tempest\Support\Arr\ImmutableArray;
9
10	use function Tempest\Support\arr;
11
12	final class CountStatement implements QueryStatement
13	{
14	public bool $distinct = false;
15
16	public function __construct(	11✔
17	public readonly TableDefinition $table,
18	public ?string $column = null,
19	public ImmutableArray $where = new ImmutableArray(),
20	) {}	11✔
21
22	public function compile(DatabaseDialect $dialect): string	9✔
23	{
24	$query = arr([	9✔
25	sprintf(	9✔
26	'SELECT COUNT(%s)',	9✔
27	$this->getCountArgument(),	9✔
28	),	9✔
29	sprintf('FROM `%s`', $this->table->name),	9✔
30	]);	9✔
31
32	if ($this->where->isNotEmpty()) {	9✔
33	$query[] = 'WHERE ' . $this->where	2✔
34	->map(fn (WhereStatement $where) => $where->compile($dialect))	2✔
35	->implode(PHP_EOL);	2✔
36	}
37
38	return $query->implode(PHP_EOL);	9✔
39	}
40
41	public function getCountArgument(): string	9✔
42	{
43	return $this->column === null \|\| $this->column === '*'	9✔
44	? '*'	5✔
45	: sprintf(	9✔
46	'%s`%s`',	9✔
47	$this->distinct ? 'DISTINCT ' : '',	9✔
48	$this->column,	9✔
49	);	9✔
50	}
51
NEW 52	public function getKey(): string	×
53	{
NEW 54	return "COUNT({$this->getCountArgument()})";	×
55	}
56	}

tempestphp / tempest-framework / 14698093036

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous