<?php

namespace ByJG\AnyDataset\Db;

interface DbFunctionsInterface
{
	/**
	 * Given two or more string the system will return the string containing de proper SQL commands
	 * to concatenate these string;
	 *
	 * use:
	 *      for ($i = 0, $numArgs = func_num_args(); $i < $numArgs ; $i++)
	 * to get all parameters received.
	 *
	 * @param string $str1
	 * @param string|null $str2
	 * @return string
	 */
	public function concat($str1, $str2 = null);


	/**
	 * Given a SQL returns it with the proper LIMIT or equivalent method included
	 * @param string $sql
	 * @param int $start
	 * @param int $qty
	 * @return string
	 */
	public function limit($sql, $start, $qty);


	/**
	 * 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);


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


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


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


	/**
	 * Format a string date to a string database readable format.
	 *
	 * @param string $date
	 * @param string $dateFormat
	 * @return string
	 */
	public function toDate($date, $dateFormat);


	/**
	 * Format a string database readable format to a string date in a free format.
	 *
	 * @param string $date
	 * @param string $dateFormat
	 * @return string
	 */
	public function fromDate($date, $dateFormat);


	/**
	 * @param DbDriverInterface $dbdataset
	 * @param string $sql
	 * @param array $param
	 * @return int
	 */
	public function executeAndGetInsertedId(DbDriverInterface $dbdataset, $sql, $param);


	/**
	 * @param string|array $field
	 * @return mixed
	 */
	public function delimiterField($field);


	/**
	 * @param string|array $table
	 * @return mixed
	 */
	public function delimiterTable($table);


	public function forUpdate($sql);


	public function hasForUpdate();
}
__halt_compiler();----SIGNATURE:----DDc2EJMlxTGBe8dT6LDW4CfmCYrK7F1igBPjbvTBbHU4TY7sS+SwDiOhBJvHrME+FwTJz4bXJs8/xGC/IA/i3I5ejBRpDfaGDRJG/hjZkETSEtrgQQmVjez3FJFCXS3QsrN6wWUG4xwP6kzIk6HsIrn8RvjV0gfE33hGX+5pgpeggAWX5SEsgMRr8OSjsoww5aQuGS25xFnONrr326HbkHI5zou/OTigjOcBX2Cp1bCZGys3kW70K1hFL9mnTQnt33ZNCsjSpd/9fqp8DLo+d2boSNkC/LozT4rcObHFT0FSZ4kWPVEInzt6woggt6u/zEK+yWLxAmQsC7d6Z/UiIau4F8QSpi6ypYJuL55Z4rRMRSBRLsRkJZN0yCSJ2wodNoNJO0P2x0p5Hyfha0h9AQFIe8Shw5MXtUD2Sk8+DzV9ElIY6EbV5EQQuRy+Lxucn/zKcGqcJKJBJq8jJFuiM2qY/2PCRkohL8a1O49kKmc5VDv/1FsMka+Q/fC6qJ1Fr/svLUtxCJuM8suMlDMENKKiYcUZQvlWF+IotUZ+4BQqrwC2IAYOu3E9zExCmRb6sVyNTSTmc1wEx9zasv9/kw3u4QCQaNOTW5v/0SnsIjFayMHPnTQj3GdWxYVWwrZIYHxaUOF3csqbLM3gb7uZ1DAWSrNVkOmQ3JA1GJhWGVc=----ATTACHMENT:----NTk3MjM5OTMxMzQ0ODEzNiA5MTk3OTkyMDEyNjU2MjgxIDIxOTk2NjA1NTY1NTUyNzc=