PostgreSQL::getEnclosureForCSV() - Code Metrics - Inspection of "Compressed phar" - edyan/neuralyzer - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( e18e45...a1f222 )

by Emmanuel

created 2018-10-30 22:43 UTC

PostgreSQL::getEnclosureForCSV() A

↳ Parent: PostgreSQL

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

Metric	Value
dl	0
loc	3
ccs	2
cts	2
cp	1
rs	10
c	0
b	0
f	0
cc	1
eloc	1
nc	1
nop	0
crap	1

<?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	1	public function getEnclosureForCSV(): string
29		{
30	1	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	1	public function loadData(
43		string $table,
44		string $filename,
45		array $fields,
46		string $mode
47		): string {
48	1	$fields = implode(', ', $fields);
49
50	1	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);
56		}
57
58	1	$sql = "COPY {$table} ($fields) FROM '{$filename}' ";
59	1	$sql.= '... Managed by pgsqlCopyFromFile';
60
61	1	return $sql;
62		}
63		}
64

edyan / neuralyzer

Push — master ( e18e45...a1f222 )

PostgreSQL::getEnclosureForCSV() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like