Crud::extractModel() - Code Metrics - Inspection of "adicionar o toObject" - brunobmorais/php-database - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — main ( ff7bb8...23065b )

by BRUNO
created 2024-10-20 19:07 UTC
Crud::extractModel() A

↳ Parent: Project
Complexity

Conditions	2
Paths	2
Size

Total Lines	11
Code Lines	6
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	2
eloc	6
nc	2
nop	1
dl	0
loc	11
rs	10
c	0
b	0
f	0
<?php

namespace BMorais\Database;

/**
 * CLASS ABSTRACT CRUD
 * Basic class to make connection between the database and the application
 *
 * @author Bruno Morais <[email protected]>
 * @copyright MIT, bmorais.com
 * @package bmorais\database
 * @subpackage class
 * @access private
 */

abstract class Crud
{
    use DatalayerTrait;

    /**
     * @param string $fields
     * @param string $add
     * @param array|null $values
     * @param bool $returnModel
     * @param bool $debug
     * @return array|false|void
     */
    public function select(string $fields = '*', string $add = '', array $values = null, bool $returnModel = false, bool $debug = false)
    {
        if (strlen($add) > 0) {
            $add = ' ' . $add;
        }

        $sql = "SELECT {$fields} FROM {$this->getTableName()}";

        if (!empty($this->getTableAlias()))
            $sql .= " AS {$this->getTableAlias()}";

        $sql .= "{$add}";

        if ($debug) {
            echo $sql;

            return;
        }
        $this->executeSQL($sql, $values);
        if ($returnModel) {
            return $this->fetchArrayClass();
        } else {
            return $this->fetchArrayObj();
        }
    }

    /**
     * @param string $fields
     * @param array|null $values
     * @param bool $debug
     * @return bool|void
     */
    public function insert(string $fields, array $values = null, bool $debug = false)
    {
        $numparams = '';
        foreach ($values as $item) {
            $numparams .= ',?';
        }
        $numparams = substr($numparams, 1);
        $sql = "INSERT INTO {$this->getTableName()} ({$fields}) VALUES ({$numparams})";
        if ($debug) {
            echo $sql.'<pre>'.print_r($values).'</pre>';
            echo $sql.'<pre>'./** @scrutinizer ignore-type */ print_r($values).'</pre>';
            return;
        }
        $result = $this->executeSQL($sql, $values);
        return !empty($result);

    }

    /**
     * @param object $object
     * @return bool|null
     */
    public function insertObject(object $object)
    {
        $args = [];
        $params = [];
        foreach ($object as $chave => $valor) {
            if ($valor != null) {
                $args[] = $chave;
                $params[] = $valor;
            }
        }
        $args = implode(',', $args);

        return $this->insert($args, $params);
    }

    /**
     * @param array $params
     * @return bool
     */
    public function insertArray(array $params): bool
    {
        if (!empty($params)) {
            $query = "INSERT INTO {$this->getTableName()}";
            $values = [];
            $dataColumns = array_keys($params);
            if (isset($dataColumns[0])) {
                $query .= ' (`' . implode('`, `', $dataColumns) . '`) ';
            }
            $query .= ' VALUES (';

            foreach ($dataColumns as $index => $column) {
                $values[] = $params[$column];
                $query .= '?, ';
            }

            $query = rtrim($query, ', ');
            $query .= ')';

            $result = $this->executeSQL($query, $values);
            if (empty($result)) {
                return false;
            }

            return true;
        } else {
            return false;
        }
    }

    /**
     * @param string $fields
     * @param array|null $values
     * @param string|null $where
     * @param bool $debug
     * @return bool|void
     */
    public function update(string $fields, array $values = null, string $where = null, bool $debug = false)
    {
        $fields_T = '';
        $atributos = explode(',', $fields);

        foreach ($atributos as $item) {
            $fields_T .= ", {$item} = ?";
        }
        $fields_T = substr($fields_T, 2);
        $sql = "UPDATE {$this->getTableName()} SET {$fields_T}";
        if (isset($where)) {
            $sql .= " WHERE $where";
        }
        if ($debug) {
            echo $sql.'<pre>'.print_r($values).'</pre>';
            echo $sql.'<pre>'./** @scrutinizer ignore-type */ print_r($values).'</pre>';
            return;
        }
        $result = $this->executeSQL($sql, $values);
        return !empty($result);
    }


    /**
     * @param object $object
     * @param string $where
     * @return bool|null
     */
    public function updateObject(object $object, string $where): ?bool
    {
        $args = [];
        $params = [];
        foreach ($object as $chave => $valor) {
            if ($valor != null) {
                $args[] = $chave;
                $params[] = $valor;
            }
        }
        $args = implode(',', $args);

        return $this->update($args, $params, $where);
    }

    /**
     * @param array $params
     * @param string $where
     * @return bool
     */

    public function updateArray(array $params, string $where): bool
    {
        if (!empty($params)) {
            $query = "UPDATE {$this->getTableName()} SET";
            $values = [];

            foreach ($params as $index => $column) {
                $query .= " {$index} = ?, ";
                $values[] = $params[$index];
            }
            $query = rtrim($query, ', ');

            if (!empty($where)) {
                $query .= " WHERE {$where}";
            }

            $result = $this->executeSQL($query, $values);
            if (empty($result)) {
                return false;
            }

            return true;
        } else {
            return false;
        }
    }

    /**
     * @param array|null $values
     * @param string|null $where
     * @param bool $debug
     * @return bool|void
     */

    public function delete(array $values = null, string $where = null, bool $debug = false)
    {
        $sql = "DELETE FROM {$this->getTableName()}";
        if (!empty($where)) {
            $sql .= " WHERE $where";
        }
        if ($debug) {
            echo $sql.'<pre>'.print_r($values).'</pre>';
            echo $sql.'<pre>'./** @scrutinizer ignore-type */ print_r($values).'</pre>';
            return;
        }
        $result = $this->executeSQL($sql, $values);
        return !empty($result);

    }

    /**
     * @return false|string
     */
    public function lastInsertId(): ?string
    {
        return $this->lastId();
    }

    /**
     * @return string|null
     */
    public function getLogSQL(): ?string
    {
        return $this->logSQL ?? "";
    }

}

brunobmorais / php-database

Push — main ( ff7bb8...23065b )

Crud::extractModel() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
