15536904331

Committed 09 Jun 2025 02:25PM UTC coverage: 70.243%. First build

Build # 15536904331

Build Type

push

github

Committed by

homersimpsons

Commit Message

:construction_worker: Upgrade CI dependencies and activation

Run Details

1100 of 1566 relevant lines covered (70.24%)

4.89 hits per line

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

0.0

/src/Mouf/Database/QueryWriter/Utils/DbHelper.php

<?php

namespace Mouf\Database\QueryWriter\Utils;

use Doctrine\DBAL\Connection;
use Mouf\MoufManager;

class DbHelper
{
    public static function getAll(string $sql, ?int $offset, ?int $limit)
    {
        /** @var Connection $dbalConnection */
        $dbalConnection = MoufManager::getMoufManager()->get('dbalConnection');
        $sql .= self::getFromLimitString($offset, $limit);
        $statement = $dbalConnection->executeQuery($sql);
        $results = $statement->fetchAll();

        $array = [];

        foreach ($results as $result) {
            $array[] = $result;
        }

        return $array;
    }

    public static function getFromLimitString(?int $from = null, ?int $limit = null): string
    {
        if ($limit !== null) {
            $queryStr = ' LIMIT '.$limit;

            if ($from !== null) {
                $queryStr .= ' OFFSET '.$from;
            }

            return $queryStr;
        } else {
            return '';
        }
    }
}

1	<?php
2
3	namespace Mouf\Database\QueryWriter\Utils;
4
5	use Doctrine\DBAL\Connection;
6	use Mouf\MoufManager;
7
8	class DbHelper
9	{
10	public static function getAll(string $sql, ?int $offset, ?int $limit)
11	{
12	/** @var Connection $dbalConnection */
13	$dbalConnection = MoufManager::getMoufManager()->get('dbalConnection');	×
14	$sql .= self::getFromLimitString($offset, $limit);	×
15	$statement = $dbalConnection->executeQuery($sql);	×
16	$results = $statement->fetchAll();	×
17
18	$array = [];	×
19
20	foreach ($results as $result) {	×
21	$array[] = $result;	×
22	}
23
24	return $array;	×
25	}
26
27	public static function getFromLimitString(?int $from = null, ?int $limit = null): string
28	{
29	if ($limit !== null) {	×
30	$queryStr = ' LIMIT '.$limit;	×
31
32	if ($from !== null) {	×
33	$queryStr .= ' OFFSET '.$from;	×
34	}
35
36	return $queryStr;	×
37	} else {
38	return '';	×
39	}
40	}
41	}

thecodingmachine / magic-query / 15536904331

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