edyan / neuralyzer

src/Helper/DB/SQLServer.php

<?php

declare(strict_types=1);

/**
 * neuralyzer : Data Anonymization Library and CLI Tool
 *
 * PHP Version 7.2
 *
 * @author Emmanuel Dyan
 *
 * @copyright 2020 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
     */
    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') {

The function Doctrine\DBAL\Connection::getHost() has been deprecated.

It seems like $this->conn->getHost() can also be of type null; however, parameter $hostname of gethostbyname() does only seem to accept string, maybe add an additional type check?

            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}");

The function Doctrine\DBAL\Connection::query() has been deprecated: Use {@link executeQuery()} instead.

            }

            $this->conn->query($sql);

The function Doctrine\DBAL\Connection::query() has been deprecated: Use {@link executeQuery()} instead.

        }

        return $sql;
    }
}