ByJG\AnyDataset\Database\DBSqliteFunctions

Complexity

Total Complexity

11

Size/Duplication

Total Lines	109
Duplicated Lines	17.43 %

Coupling/Cohesion

Components	0
Dependencies	5

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	concat()	0	4	1
A	limit()	8	8	2
A	top()	0	4	1
A	hasTop()	0	4	1
A	hasLimit()	0	4	1
A	sqlDate()	0	4	1
A	toDate()	0	4	1
A	fromDate()	0	4	1
A	executeAndGetInsertedId()	11	11	2

<?php

namespace ByJG\AnyDataset\Database;

use ByJG\AnyDataset\Exception\NotImplementedException;
use ByJG\AnyDataset\Repository\DBDataset;

class DBSqliteFunctions extends DBBaseFunctions
{

    function concat($s1, $s2 = null)

It is generally recommended to explicitly declare the visibility for methods.

    {
        return implode(func_get_args(), ' || ');
    }

    /**
     * Given a SQL returns it with the proper LIMIT or equivalent method included
     * @param string $sql
     * @param int $start
     * @param int $qty
     * @return string
     */
    function limit($sql, $start, $qty)

It is generally recommended to explicitly declare the visibility for methods.

This method seems to be duplicated in your project.

    {
        if (strpos($sql, ' LIMIT ') === false) {
            return $sql . " LIMIT $start, $qty ";
        }

        return $sql;
    }

    /**
     * Given a SQL returns it with the proper TOP or equivalent method included
     * @param string $sql
     * @param int $qty
     * @return string
     */
    function top($sql, $qty)

It is generally recommended to explicitly declare the visibility for methods.

    {
        return $this->limit($sql, 0, $qty);
    }

    /**
     * Return if the database provider have a top or similar function
     * @return bool
     */
    function hasTop()

It is generally recommended to explicitly declare the visibility for methods.

    {
        return true;
    }

    /**
     * Return if the database provider have a limit function
     * @return bool
     */
    function hasLimit()

It is generally recommended to explicitly declare the visibility for methods.

    {
        return true;
    }

    /**
     * Format date column in sql string given an input format that understands Y M D
     * @param string $fmt
     * @param string|bool $col
     * @return string
     * @throws NotImplementedException
     * @example $db->getDbFunctions()->SQLDate("d/m/Y H:i", "dtcriacao")
     */
    function sqlDate($fmt, $col = false)

It is generally recommended to explicitly declare the visibility for methods.

    {
        throw new NotImplementedException('Not implemented');
    }

    /**
     * Format a string date to a string database readable format.
     *
     * @param string $date
     * @param string $dateFormat
     * @return string
     */
    function toDate($date, $dateFormat)

It is generally recommended to explicitly declare the visibility for methods.

    {
        return parent::toDate($date, $dateFormat);
    }

    /**
     * Format a string database readable format to a string date in a free format.
     *
     * @param string $date
     * @param string $dateFormat
     * @return string
     */
    function fromDate($date, $dateFormat)

It is generally recommended to explicitly declare the visibility for methods.

    {
        return parent::fromDate($date, $dateFormat);
    }

    /**
     *
     * @param DBDataset $dbdataset
     * @param string $sql
     * @param array $param
     * @return int
     */
    function executeAndGetInsertedId($dbdataset, $sql, $param)

It is generally recommended to explicitly declare the visibility for methods.

This method seems to be duplicated in your project.

    {
        $id = parent::executeAndGetInsertedId($dbdataset, $sql, $param);
        $it = $dbdataset->getIterator("SELECT last_insert_rowid() id");
        if ($it->hasNext()) {
            $sr = $it->moveNext();
            $id = $sr->getField("id");
        }

        return $id;
    }
}