<?php

namespace ByJG\AnyDataset\Db\Helpers;

use ByJG\AnyDataset\Core\Exception\NotAvailableException;
use ByJG\AnyDataset\Db\DbDriverInterface;

class DbDblibFunctions extends DbBaseFunctions
{
	public function __construct()
	{
		$this->deliFieldLeft = '"';
		$this->deliFieldRight = '"';
		$this->deliTableLeft = '"';
		$this->deliTableRight = '"';
	}


	public function concat($str1, $str2 = null)
	{
		return implode(' + ', func_get_args());
	}


	/**
	 * Given a SQL returns it with the proper LIMIT or equivalent method included
	 * @param string $sql
	 * @param int $start
	 * @param int $qty
	 * @return string
	 * @throws NotAvailableException
	 */
	public function limit($sql, $start, $qty = null)
	{
		throw new NotAvailableException("DBLib does not support LIMIT feature.");
	}


	/**
	 * Given a SQL returns it with the proper TOP or equivalent method included
	 * @param string $sql
	 * @param int $qty
	 * @return string
	 */
	public function top($sql, $qty)
	{
		if (stripos($sql, ' TOP ') === false) {
		    return  preg_replace("/^\\s*(select) /i", "\\1 top $qty ", $sql);
		}

		return preg_replace(
		    '~(\s[Tt][Oo][Pp])\s.*?\d+\s~',
		    '$1 ' . $qty . ' ',
		    $sql
		);
	}


	/**
	 * Return if the database provider have a top or similar function
	 * @return bool
	 */
	public function hasTop()
	{
		return true;
	}


	/**
	 * Return if the database provider have a limit function
	 * @return bool
	 */
	public function hasLimit()
	{
		return false;
	}


	/**
	 * Format date column in sql string given an input format that understands Y M D
	 *
	 * @param string $format
	 * @param bool|string $column
	 * @return string
	 * @example $db->getDbFunctions()->SQLDate("d/m/Y H:i", "dtcriacao")
	 */
	public function sqlDate($format, $column = null)
	{
		if (is_null($column)) {
		    $column = "getdate()";
		}

		$pattern = [
		    'Y' => "YYYY",
		    'y' => "YY",
		    'M' => "MM",
		    'm' => "M",
		    'Q' => "",
		    'q' => "",
		    'D' => "dd",
		    'd' => "dd",
		    'h' => "H",
		    'H' => "HH",
		    'i' => "mm",
		    's' => "ss",
		    'a' => "",
		    'A' => "",
		];

		$preparedSql = $this->prepareSqlDate($format, $pattern, '');

		return sprintf(
		    "FORMAT(%s, '%s')",
		    $column,
		    implode('', $preparedSql)
		);
	}


	/**
	 * @param DbDriverInterface $dbdataset
	 * @param string $sql
	 * @param array $param
	 * @return bool|string
	 */
	public function executeAndGetInsertedId(DbDriverInterface $dbdataset, $sql, $param)
	{
		$insertedId = parent::executeAndGetInsertedId($dbdataset, $sql, $param);
		$iterator = $dbdataset->getIterator("select @@identity id");
		if ($iterator->hasNext()) {
		    $singleRow = $iterator->moveNext();
		    $insertedId = $singleRow->get("id");
		}

		return $insertedId;
	}


	/**
	 * @param $sql
	 * @return string|void
	 * @throws \ByJG\AnyDataset\Core\Exception\NotAvailableException
	 */
	public function forUpdate($sql)
	{
		throw new NotAvailableException('FOR UPDATE not available for Mssql/Dblib');
	}


	public function hasForUpdate()
	{
		return false;
	}
}
__halt_compiler();----SIGNATURE:----fV/jnf/MXPpUfvDfsudsXfvFmq1hZCm36eNnuGq9u5cWEmS6eybk4HSf2GROWhohMRC/xBm6ND1BSyjLYaGwHJSpiWoll3n7RMwIn96WECDHpawW8CsJeiLEYgbO8VpAzGp9iCYMzkp/wvVH+wRaEtorUelpz+GEd1FzG20Dj4qWLHUT9JwTQvgNu+1PAaTvQPdeQTtz+4nG9shnw2sNGcKiscG8N+fY8QSKCelbPUXFJUB2hu7Ac3WR4CzCue/wTnr6Gr2xgJxURSIq6YXQobkco3pkKVf6/Mjcy/eJA7vxCHD6Jv7ipxBBIv9bnfEBXY+eNxAPKrwi7gDzMyQmbGz75YV8iL5TQM6oM1oOwUMd9iVtCeVbQIMOV6pttSeK7iuvt9PDkW/ScKU/grZq8Di4RRJOYwUuiDHP8Ty/GdvjWmb5svFzcmcCGYm0qrV13sMIvLQ+eh2YLRN5E1X6IdXDZzdqyOfZOqU3jbJ00OHNb5edhAYiqFeAhHP87ZddV1s3eThCnj4uOzqLclb9pidl1zFZsiHXGQWXlYhZ0iqThv2BvlR2oswlvPcR1G4nqIj7yKKAra6MtnqbHjhLJ0eSSTN/9IqXxonEg7ff790TkYhEVjkg4Rxvw1LXWA2zSCCCa98CdEktw4Db23DlhD4WBQ4BWwqADGTQJBif5lw=----ATTACHMENT:----NzUyMTg1MTAxMzIzOTMxNiA3MjE2OTk2NTY5OTYwNjUzIDUyODgzNTMzOTU3MTI4NDU=