MySQL::loadData() - Code Metrics - Inspection of "Bump version v3.1.0" - edyan/neuralyzer - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 16eb74...e2e5d8 )

by Emmanuel

created 2018-06-10 16:34 UTC

MySQL::loadData() A

↳ Parent: MySQL

Complexity

Conditions	2
Paths	2

Size

Total Lines	16
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	16
ccs	8
cts	8
cp	1
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	7
nc	2
nop	4
crap	2

<?php
/**
 * neuralyzer : Data Anonymization Library and CLI Tool
 *
 * PHP Version 7.1
 *
 * @author Emmanuel Dyan
 * @copyright 2018 Emmanuel Dyan
 *
 * @package edyan/neuralyzer
 *
 * @license GNU General Public License v2.0
 *
 * @link https://github.com/edyan/neuralyzer
 */

namespace Edyan\Neuralyzer\Helper\DB;

/**
 * Various methods related to MySQL
 */
class MySQL extends AbstractDBHelper
{
    /**
     * Send options to be able to load dataset
     * @return array
     */
    public static function getDriverOptions(): array
    {
        return [
            \PDO::MYSQL_ATTR_LOCAL_INFILE => true
        ];
    }


    /**
     * Load Data from a CSV
     * @param  string  $table
     * @param  string  $filename
     * @param  array   $fields
     * @param  string  $mode  Not in used here
     * @return string
     */
    public function loadData(
        string $table,
        string $filename,
        array $fields,
        string $mode
    ): string {
        $sql ="LOAD DATA LOCAL INFILE '{$filename}'
     REPLACE INTO TABLE {$table}
     FIELDS TERMINATED BY '|' ENCLOSED BY '\"' LINES TERMINATED BY '" . PHP_EOL . "'
     (`" . implode("`, `", $fields) . "`)";
        // Run the query if asked
        if ($this->pretend === false) {
            $this->conn->query($sql);
        }

        return $sql;
    }
}


1		<?php
2		/**
3		* neuralyzer : Data Anonymization Library and CLI Tool
4		*
5		* PHP Version 7.1
6		*
7		* @author Emmanuel Dyan
8		* @copyright 2018 Emmanuel Dyan
9		*
10		* @package edyan/neuralyzer
11		*
12		* @license GNU General Public License v2.0
13		*
14		* @link https://github.com/edyan/neuralyzer
15		*/
16
17		namespace Edyan\Neuralyzer\Helper\DB;
18
19		/**
20		* Various methods related to MySQL
21		*/
22		class MySQL extends AbstractDBHelper
23		{
24		/**
25		* Send options to be able to load dataset
26		* @return array
27		*/
28	46	public static function getDriverOptions(): array
29		{
30		return [
31	46	\PDO::MYSQL_ATTR_LOCAL_INFILE => true
32		];
33		}
34
35
36		/**
37		* Load Data from a CSV
38		* @param string $table
39		* @param string $filename
40		* @param array $fields
41		* @param string $mode Not in used here
42		* @return string
43		*/
44	7	public function loadData(
45		string $table,
46		string $filename,
47		array $fields,
48		string $mode
49		): string {
50	7	$sql ="LOAD DATA LOCAL INFILE '{$filename}'
51	7	REPLACE INTO TABLE {$table}
52	7	FIELDS TERMINATED BY '\|' ENCLOSED BY '\"' LINES TERMINATED BY '" . PHP_EOL . "'
53	7	(`" . implode("`, `", $fields) . "`)";
54		// Run the query if asked
55	7	if ($this->pretend === false) {
56	6	$this->conn->query($sql);
57		}
58
59	6	return $sql;
60		}
61		}
62

edyan / neuralyzer

Push — master ( 16eb74...e2e5d8 )

MySQL::loadData() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like