Mouf\Database\QueryWriter\Utils\DbHelper

Complexity

Total Complexity

5

Size/Duplication

Total Lines	36
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getAll()	0	16	2
A	getFromLimitString()	0	16	3

<?php

namespace Mouf\Database\QueryWriter\Utils;

use Mouf\MoufManager;

class DbHelper
{
    public static function getAll($sql, $offset, $limit)
    {
        $dbalConnection = MoufManager::getMoufManager()->get('dbalConnection');
        /* @var $dbalConnection \Doctrine\DBAL\Connection */
        $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($from = null, $limit = null)
    {
        if ($limit !== null) {
            $limitInt = (int) $limit;
            $queryStr = ' LIMIT '.$limitInt;

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

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