14372198759

Committed 27 Jan 2025 09:09PM UTC coverage: 99.02%. Remained the same

Build # 14372198759

Build Type

push

github

Committed by

natanfelles

Commit Message

Merge branch 'development'

Run Details

2426 of 2450 relevant lines covered (99.02%)

10.85 hits per line

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

0.0

/src/Manipulation/Traits/Explain.php

<?php declare(strict_types=1);
/*
 * This file is part of Aplus Framework Database Library.
 *
 * (c) Natan Felles <natanfelles@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace Framework\Database\Manipulation\Traits;

use Framework\Database\Result\Explain as Result;
use InvalidArgumentException;

/**
 * Trait Explain.
 *
 * @see https://mariadb.com/kb/en/explain/
 *
 * @package database
 *
 * @since 4
 */
trait Explain
{
    /**
     * @see https://mariadb.com/kb/en/explain/#explain-extended
     */
    public const string EXP_EXTENDED = 'EXTENDED';
    /**
     * https://mariadb.com/kb/en/partition-pruning-and-selection/.
     */
    public const string EXP_PARTITIONS = 'PARTITIONS';
    /**
     * @see https://mariadb.com/kb/en/explain-format-json/
     */
    public const string EXP_FORMAT_JSON = 'FORMAT=JSON';

    /**
     * EXPLAIN provides information about statements.
     *
     * @param string|null $option
     *
     * @see https://mariadb.com/kb/en/explain/
     *
     * @return array<int,Result>
     */
    public function explain(?string $option = null) : array
    {
        if ($option !== null) {
            $opt = \strtoupper($option);
            if (!\in_array($opt, [
                static::EXP_EXTENDED,
                static::EXP_FORMAT_JSON,
                static::EXP_PARTITIONS,
            ], true)) {
                throw new InvalidArgumentException('Invalid EXPLAIN option: ' . $option);
            }
            $option = ' ' . $opt;
        }
        $sql = 'EXPLAIN' . $option . \PHP_EOL . $this->sql();
        $results = [];
        foreach ($this->database->query($sql)->fetchAll() as $row) {
            $results[] = new Result($row); // @phpstan-ignore-line
        }
        return $results;
    }
}

1	<?php declare(strict_types=1);
2	/*
3	* This file is part of Aplus Framework Database Library.
4	*
5	* (c) Natan Felles <natanfelles@gmail.com>
6	*
7	* For the full copyright and license information, please view the LICENSE
8	* file that was distributed with this source code.
9	*/
10	namespace Framework\Database\Manipulation\Traits;
11
12	use Framework\Database\Result\Explain as Result;
13	use InvalidArgumentException;
14
15	/**
16	* Trait Explain.
17	*
18	* @see https://mariadb.com/kb/en/explain/
19	*
20	* @package database
21	*
22	* @since 4
23	*/
24	trait Explain
25	{
26	/**
27	* @see https://mariadb.com/kb/en/explain/#explain-extended
28	*/
29	public const string EXP_EXTENDED = 'EXTENDED';
30	/**
31	* https://mariadb.com/kb/en/partition-pruning-and-selection/.
32	*/
33	public const string EXP_PARTITIONS = 'PARTITIONS';
34	/**
35	* @see https://mariadb.com/kb/en/explain-format-json/
36	*/
37	public const string EXP_FORMAT_JSON = 'FORMAT=JSON';
38
39	/**
40	* EXPLAIN provides information about statements.
41	*
42	* @param string\|null $option
43	*
44	* @see https://mariadb.com/kb/en/explain/
45	*
46	* @return array<int,Result>
47	*/
48	public function explain(?string $option = null) : array
49	{
50	if ($option !== null) {	×
51	$opt = \strtoupper($option);	×
52	if (!\in_array($opt, [	×
53	static::EXP_EXTENDED,	×
54	static::EXP_FORMAT_JSON,	×
55	static::EXP_PARTITIONS,	×
56	], true)) {	×
57	throw new InvalidArgumentException('Invalid EXPLAIN option: ' . $option);	×
58	}
59	$option = ' ' . $opt;	×
60	}
61	$sql = 'EXPLAIN' . $option . \PHP_EOL . $this->sql();	×
62	$results = [];	×
63	foreach ($this->database->query($sql)->fetchAll() as $row) {	×
64	$results[] = new Result($row); // @phpstan-ignore-line	×
65	}
66	return $results;	×
67	}
68	}

aplus-framework / database / 14372198759

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