Tx_AoeDbsequenzer_Xclass_DatabaseConnection

Complexity

Total Complexity

14

Size/Duplication

Total Lines	120
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	DatabaseConnection::enable()	0	4	1
A	DatabaseConnection::disable()	0	4	1
A	DatabaseConnection::INSERTquery()	0	7	2
A	DatabaseConnection::INSERTmultipleRows()	0	9	3
A	DatabaseConnection::UPDATEquery()	0	7	3
A	DatabaseConnection::exec_DELETEquery()	0	5	1
A	DatabaseConnection::sql_pconnect()	0	6	1

<?php
namespace Aoe\AoeDbSequenzer\Xclass;

/***************************************************************
 *  Copyright notice
 *
 *  (c) 2017 AOE GmbH (dev@aoe.com)
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

use Aoe\AoeDbSequenzer\Sequenzer;
use Aoe\AoeDbSequenzer\Service\Typo3Service;

/**
 * @package Aoe\AoeDbSequenzer\Xclass
 */
class DatabaseConnection extends \TYPO3\CMS\Core\Database\DatabaseConnection
{
    /**
     * @var boolean
     */
    private $isEnabled = true;

    /**
     * @var Typo3Service
     */
    private $typo3Service;

    /**
     * Enables the sequencer.
     *
     * @return void
     */
    public function enable()
    {
        $this->isEnabled = true;
    }

    /**
     * Disables the sequencer.
     *
     * @return void
     */
    public function disable()
    {
        $this->isEnabled = false;
    }

    /**
     * Creates and executes an INSERT SQL-statement for $table from the array with field/value pairs $fields_values.
     * Using this function specifically allows us to handle BLOB and CLOB fields depending on DB
     *
     * @param    string $table Table name
     * @param    array $fields_values Field values as key=>value pairs. Values will be escaped internally. Typically you would fill an array like "$insertFields" with 'fieldname'=>'value' and pass it to this function as argument.
     * @param    string /array $no_quote_fields See fullQuoteArray()
     * @return    string|NULL Full SQL query for INSERT, NULL if $fields_values is empty
     */
    function INSERTquery($table, $fields_values, $no_quote_fields = false)

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

    {
        if ($this->isEnabled) {
            $fields_values = $this->getTypo3Service()->modifyInsertFields($table, $fields_values);
        }
        return parent::INSERTquery($table, $fields_values, $no_quote_fields);
    }

    /**
     * Creates an INSERT SQL-statement for $table with multiple rows.
     *
     * @param    string $table Table name
     * @param    array $fields Field names
     * @param    array $rows Table rows. Each row should be an array with field values mapping to $fields
     * @param    bool|array|string $no_quote_fields See fullQuoteArray()
     * @return    string              Full SQL query for INSERT (unless $rows does not contain any elements in which case it will be false)
     */
    public function INSERTmultipleRows($table, array $fields, array $rows, $no_quote_fields = false)
    {
        if ($this->isEnabled) {
            foreach ($rows as &$row) {
                $row = $this->getTypo3Service()->modifyInsertFields($table, $row);
            }
        }
        return parent::INSERTmultipleRows($table, $fields, $rows, $no_quote_fields);
    }

    /**
     * Creates an UPDATE SQL-statement for $table where $where-clause (typ. 'uid=...') from the array with field/value pairs $fields_values.
     *
     * @param    string $table See exec_UPDATEquery()
     * @param    string $where See exec_UPDATEquery()
     * @param    array $fields_values See exec_UPDATEquery()
     * @param    boolean $no_quote_fields See fullQuoteArray()
     * @return    string        Full SQL query for UPDATE (unless $fields_values does not contain any elements in which case it will be false)
     */
    public function UPDATEquery($table, $where, $fields_values, $no_quote_fields = false)
    {
        if ($this->getTypo3Service()->needsSequenzer($table) && isset($fields_values['uid'])) {
            throw new \InvalidArgumentException('no uid allowed in update statement!', 1512378277);
        }
        return parent::UPDATEquery($table, $where, $fields_values, $no_quote_fields);
    }

    /**
     * Creates and executes a DELETE SQL-statement for $table where $where-clause
     *
     * @param    string $table Database tablename
     * @param    string $where WHERE clause, eg. "uid=1". NOTICE: You must escape values in this argument with $this->fullQuoteStr() yourself!
     * @return boolean|\mysqli_result|object MySQLi result object / DBAL object
     */
    public function exec_DELETEquery($table, $where)
    {
        //TODO: log deletes
        return parent::exec_DELETEquery($table, $where);
    }

    /**
     * Open a (persistent) connection to a MySQL server
     *
     * @param string $host Deprecated since 6.1, will be removed in two versions. Database host IP/domain[:port]
     * @param string $username Deprecated since 6.1, will be removed in two versions. Username to connect with.
     * @param string $password Deprecated since 6.1, will be removed in two versions. Password to connect with.
     * @return \mysqli|NULL    Returns current database handle
     */
    function sql_pconnect($host = null, $username = null, $password = null)

The parameter $host is not used and could be removed.

The parameter $username is not used and could be removed.

The parameter $password is not used and could be removed.

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

    {
        parent::sql_pconnect();
        $this->getTypo3Service()->setDbLink($this->getDatabaseHandle());
        return $this->getDatabaseHandle();
    }

    /**
     * create instance of Typo3Service by lazy-loading
     *
     * Why we do this?
     * Because some unittests backup the variable $GLOBALS (and so, also the variable $GLOBALS['TYPO3_DB']), which means, that this
     * object/class will be serialized/unserialized, so the instance of Typo3Service will be null after unserialization!
     *
     * @return Typo3Service
     */
    protected function getTypo3Service()
    {
        if (false === isset($this->typo3Service)) {
            $this->typo3Service = new Typo3Service(new Sequenzer());
        }
        return $this->typo3Service;
    }
}