SQLServer::getEnclosureForCSV() - Code Metrics - Inspection of "Bad return in getDriverOptions" - edyan/neuralyzer - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( fb988b...6625be )

by Emmanuel

created 2018-11-29 19:09 UTC

SQLServer::getEnclosureForCSV() A

↳ Parent: SQLServer

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;

use Edyan\Neuralyzer\Exception\NeuralyzerException;

/**
 * Various methods related to SQLServer
 */
class SQLServer extends AbstractDBHelper
{
    /**
     * Set the right enclosure
     *
     * @return string
     */
    public function getEnclosureForCSV(): string
    {
        return chr(0);
    }

    /**
     * {@inheritdoc}
     */
    public function loadData(string $table, string $fname, array $fields, string $mode): string
    {
        if (substr(gethostbyname($this->conn->getHost()), 0, 3) !== '127') {
            throw new NeuralyzerException('SQL Server must be on the same host than PHP');
        }

        $sql ="BULK INSERT {$table} FROM '{$fname}' WITH (
            FIELDTERMINATOR = '|', DATAFILETYPE = 'widechar', ROWTERMINATOR = '" . PHP_EOL . "'
        )";

        if ($this->pretend === false) {
            if ($mode === 'update') {
                $this->conn->query("TRUNCATE TABLE {$table}");
            }

            $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		use Edyan\Neuralyzer\Exception\NeuralyzerException;
20
21		/**
22		* Various methods related to SQLServer
23		*/
24		class SQLServer extends AbstractDBHelper
25		{
26		/**
27		* Set the right enclosure
28		*
29		* @return string
30		*/
31	1	public function getEnclosureForCSV(): string
32		{
33	1	return chr(0);
34		}
35
36		/**
37		* {@inheritdoc}
38		*/
39	2	public function loadData(string $table, string $fname, array $fields, string $mode): string
40		{
41	2	if (substr(gethostbyname($this->conn->getHost()), 0, 3) !== '127') {
42	1	throw new NeuralyzerException('SQL Server must be on the same host than PHP');
43		}
44
45	1	$sql ="BULK INSERT {$table} FROM '{$fname}' WITH (
46	1	FIELDTERMINATOR = '\|', DATAFILETYPE = 'widechar', ROWTERMINATOR = '" . PHP_EOL . "'
47		)";
48
49	1	if ($this->pretend === false) {
50		if ($mode === 'update') {
51		$this->conn->query("TRUNCATE TABLE {$table}");
52		}
53
54		$this->conn->query($sql);
55		}
56
57	1	return $sql;
58		}
59		}
60

edyan / neuralyzer

Push — master ( fb988b...6625be )

SQLServer::getEnclosureForCSV() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like