MySQLi::getTables() - Code Metrics - bytic/database - Measure and Improve Code Quality continuously with Scrutinizer

MySQLi::getTables() A
last analyzed 2023-01-30 21:10 UTC

↳ Parent: MySQLi
Complexity

Conditions	4
Paths	2
Size

Total Lines	14
Code Lines	7
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	0
CRAP Score	20
Importance

Changes	2
Bugs	0	Features	0
Metric	Value
cc	4
eloc	7
c	2
b	0
f	0
nc	2
nop	0
dl	0
loc	14
ccs	0
cts	4
cp	0
crap	20
rs	10
<?php

namespace Nip\Database\Adapters;

/**
 * Class MySQLi
 * @package Nip\Database\Adapters
 */
class MySQLi extends AbstractAdapter implements AdapterInterface
{
    protected $connection;

    /**
     * Connects to MySQL server
     *
     * @param string|boolean $host
     * @param string|boolean $user
     * @param string|boolean $password
     * @param string|boolean $database
     * @param bool $newLink
     *
     * @return resource
     */
    public function connect($host = false, $user = false, $password = false, $database = false, $newLink = false)
    {
        $this->connection = mysqli_connect($host, $user, $password, $newLink);
        $this->connection = /** @scrutinizer ignore-call */ mysqli_connect($host, $user, $password, $newLink);

        if ($this->connection) {
            if ($this->selectDatabase($database)) {
                return $this->connection;

            } else {
                $message = 'Cannot select database '.$database;
            }
        } else {
            $message = mysqli_error($this->connection);
            $message = mysqli_error(/** @scrutinizer ignore-type */ $this->connection);
        }

        if (!$this->connection) {
            trigger_error($message, E_USER_WARNING);
            trigger_error(/** @scrutinizer ignore-type */ $message, E_USER_WARNING);
        }
    }

    /**
     * @param $database
     * @return bool
     */
    public function selectDatabase($database)
    {
        return mysqli_select_db($this->connection, $database);
    }

    /**
     * @param $sql
     * @return bool|\mysqli_result
     */
    public function query($sql)
    {
        try {
            return mysqli_query($this->connection, $sql);
        } catch (\Exception $e) {
            throw new \Exception($e->getMessage().' for query '.$sql, $e->getCode(), $e);
        }
    }

    /**
     * @return int|string
     */
    public function lastInsertID()
    {
        return mysqli_insert_id($this->connection);
    }

    /**
     * @return int
     */
    public function affectedRows()
    {
        return mysqli_affected_rows($this->connection);

    }

    /**
     * @return string
     */
    public function info()
    {
        return mysqli_info($this->connection);
    }

    /**
     * @param $result
     * @return null|object
     */
    public function fetchObject($result)
    {
        return mysqli_fetch_object($result);
    }

    /**
     * @param $result
     * @param $row
     * @param $field
     * @return mixed
     */
    public function result($result, $row, $field)
    {
        return mysqli_result($result, $row, $field);
        return /** @scrutinizer ignore-call */ mysqli_result($result, $row, $field);
    }

    /**
     * @param $result
     */
    public function freeResults($result)
    {
        return mysqli_free_result($result);
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
if ($a->getObject()) {
    }

    /**
     * @param $table
     * @return array|false
     */
    public function describeTable($table)
    {
        if (!($this->connection instanceof \mysqli)) {
            return false;
        }

        $return = ['fields' => [], 'indexes' => []];

        $result = $this->execute('DESCRIBE '.$table);
        if (is_bool($result)) {
            return false;
        }
        if (mysqli_num_rows($result)) {
            while ($row = $this->fetchAssoc($result)) {
                $return['fields'][$row['Field']] = [
                    'field' => $row['Field'],
                    'type' => $row['Type'],
                    'nullable' => strtoupper($row['Null']) == 'YES',
                    'primary' => (
                        isset($return['indexes']['PRIMARY']['fields'][0])
                        && $return['indexes']['PRIMARY']['fields'][0] == $row['Field']
                    ),
                    'default' => $row['Default'],
                    'auto_increment' => ($row['Extra'] === 'auto_increment'),
                ];
            }
        }

        $result = $this->execute('SHOW INDEX IN '.$table);
        if (is_bool($result)) {
            return false;
        }
        if (mysqli_num_rows($result)) {
            while ($row = $this->fetchAssoc($result)) {
                if (!isset($return['indexes'][$row['Key_name']])) {
                    $return['indexes'][$row['Key_name']] = [];
                }
                $return['indexes'][$row['Key_name']]['fields'][] = $row['Column_name'];
                $return['indexes'][$row['Key_name']]['unique'] = $row['Non_unique'] == '0';
                $return['indexes'][$row['Key_name']]['fulltext'] = $row['Index_type'] == 'FULLTEXT';
                $return['indexes'][$row['Key_name']]['type'] = $row['Index_type'];
            }
        }

        return $return;
    }

    /**
     * @param $result
     * @return array|null
     */
    public function fetchAssoc($result)
    {
        return mysqli_fetch_assoc($result);
    }

    /**
     * @return array
     */
    public function getTables()
    {
        $return = [];

        $result = $this->execute("SHOW FULL TABLES");
        if ($this->numRows($result)) {
            while ($row = $this->fetchArray($result)) {
                $return[$row[0]] = [
                    "type" => $row[1] == "BASE TABLE" ? "table" : "view",
                ];
            }
        }

        return $return;
    }

    /**
     * @param $result
     * @return int
     */
    public function numRows($result)
    {
        return mysqli_num_rows($result);

    }

    /**
     * @param $result
     * @return array|null
     */
    public function fetchArray($result)
    {
        return mysqli_fetch_array($result);
    }

    /**
     * @param $value
     * @return int|string
     */
    public function quote($value)
    {
        $value = $this->cleanData($value);

        return is_numeric($value) ? $value : "'$value'";
    }

    /**
     * @param $data
     * @return string
     */
    public function cleanData($data)
    {
        return mysqli_real_escape_string($this->connection, $data);
    }

    /**
     * @return string
     */
    public function error()
    {
        return mysqli_error($this->connection);
    }

    public function disconnect()
    {
        mysqli_close($this->connection);
    }
}

bytic / database

MySQLi::getTables() A last analyzed 2023-01-30 21:10 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

MySQLi::getTables() A
last analyzed 2023-01-30 21:10 UTC
