PostgreSQL::getEnclosureForCSV() - Code Metrics - Inspection of "Added helpers to load data instead of having every..." - edyan/neuralyzer - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( bbf0da...682cd1 )

by Emmanuel

created 2018-05-13 21:44 UTC

PostgreSQL::getEnclosureForCSV() A

↳ Parent: PostgreSQL

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	4
rs	10
c	0
b	0
f	0
cc	1
eloc	2
nc	1
nop	0

<?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 PostgreSQL
 */
class PostgreSQL extends AbstractDBHelper
{
    /**
     * Set the right enclosure
     * @return string
     */
    public function getEnclosureForCSV(): string
    {
        return chr(0);
    }


    /**
     * 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 {
        $fields = implode(', ', $fields);

        if ($this->pretend === false) {
            if ($mode === 'update') {
                $this->conn->query("TRUNCATE {$table}");
            }
            $pdo = $this->conn->getWrappedConnection();
            $pdo->pgsqlCopyFromFile($table, $filename, '|', '\\\\N', $fields);

        }

        $sql = "COPY {$table} ($fields) FROM '{$filename}' ";
        $sql.= '... Managed by pgsqlCopyFromFile';

        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 PostgreSQL
21			*/
22			class PostgreSQL extends AbstractDBHelper
23			{
24			/**
25			* Set the right enclosure
26			* @return string
27			*/
28			public function getEnclosureForCSV(): string
29			{
30			return chr(0);
31			}
32
33
34			/**
35			* Load Data from a CSV
36			* @param string $table
37			* @param string $filename
38			* @param array $fields
39			* @param string $mode Not in used here
40			* @return string
41			*/
42			public function loadData(
43			string $table,
44			string $filename,
45			array $fields,
46			string $mode
47			): string {
48			$fields = implode(', ', $fields);
49
50			if ($this->pretend === false) {
51			if ($mode === 'update') {
52			$this->conn->query("TRUNCATE {$table}");
53			}
54			$pdo = $this->conn->getWrappedConnection();
55			$pdo->pgsqlCopyFromFile($table, $filename, '\|', '\\\\N', $fields);
			0 ignored issues – show Bug introduced 2018-05-13 21:46 UTC by Report Bug Copy Issue Report The method `pgsqlCopyFromFile()` does not seem to exist on `object<Doctrine\DBAL\Driver\Connection>`. This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces. This is most likely a typographical error or the method has been renamed. Loading history...
56			}
57
58			$sql = "COPY {$table} ($fields) FROM '{$filename}' ";
59			$sql.= '... Managed by pgsqlCopyFromFile';
60
61			return $sql;
62			}
63			}
64

edyan / neuralyzer

Push — master ( bbf0da...682cd1 )

PostgreSQL::getEnclosureForCSV() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like