danielgp\common_lib\MySQLiByDanielGPtypes

Complexity

Total Complexity

7

Size/Duplication

Total Lines	77
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	listOfMySQLqueryLanguageType()	0	9	2
A	getMySQLqueryType()	0	17	2
A	listOfMySQLqueryStatementType()	0	8	1
A	readTypeFromJsonFile()	0	10	2

<?php

/**
 *
 * The MIT License (MIT)
 *
 * Copyright (c) 2015 Daniel Popiniuc
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 *
 */

namespace danielgp\common_lib;

/**
 * Handles the size of field limits
 *
 * @author Daniel Popiniuc
 */
trait MySQLiByDanielGPtypes
{

    /**
     * Returns the Query language type by scanning the 1st keyword from a given query
     *
     * @param string $sQuery
     */
    protected function getMySQLqueryType($sQuery)
    {
        $queryPieces    = explode(' ', $sQuery);
        $statementTypes = $this->listOfMySQLqueryStatementType($queryPieces[0]);
        if (in_array($queryPieces[0], $statementTypes['keys'])) {
            $type    = $statementTypes['value']['Type'];
            $ar1     = ['1st Keyword Within Query' => $queryPieces[0]];
            $lnT     = $this->listOfMySQLqueryLanguageType($type);
            $aReturn = array_merge($ar1, $lnT, $statementTypes['value']);
            ksort($aReturn);
            return $aReturn;
        }
        return [
            'detected1stKeywordWithinQuery' => $queryPieces[0],
            'unknown'                       => ['standsFor' => 'unknown', 'description' => 'unknown'],
            'Type'                          => 'unknown',
            'Description'                   => 'unknown',
        ];
    }

    /**
     * Just to keep a list of type of language as array
     *
     * @return array
     */
    private function listOfMySQLqueryLanguageType($qType)
    {
        $keyForReturn = 'Type ' . $qType . ' stands for';
        $vMap         = ['DCL', 'DDL', 'DML', 'DQL', 'DTL'];
        if (in_array($qType, $vMap)) {
            $valForReturn = $this->readTypeFromJsonFile('MySQLiLanguageTypes')[$qType];
            return [$keyForReturn => $valForReturn[0] . ' (' . $valForReturn[1] . ')'];
        }
        return [$keyForReturn => 'unknown'];
    }

    /**
     * Just to keep a list of statement types as array
     *
     * @param string $firstKwordWQuery
     * @return array
     */
    private function listOfMySQLqueryStatementType($firstKwordWQuery)
    {
        $statmentsArray = $this->readTypeFromJsonFile('MySQLiStatementTypes');
        return [
            'keys'  => array_keys($statmentsArray),
            'value' => [
                'Description' => $statmentsArray[$firstKwordWQuery][1],
                'Type'        => $statmentsArray[$firstKwordWQuery][0],
            ],
        ];
    }

    /**
     *
     * @param string $fileBaseName
     * @return array
     */
    private function readTypeFromJsonFile($fileBaseName)
    {
        $fName = __DIR__ . DIRECTORY_SEPARATOR . 'json' . DIRECTORY_SEPARATOR . $fileBaseName . '.min.json';
        $fJson = fopen($fName, 'r');
        if ($fJson === false) {
            throw new \Exception('Unable to read file ' . $fName);
        }
        $jSonContent = fread($fJson, filesize($fName));
        fclose($fJson);
        return json_decode($jSonContent, true);
    }
}