<?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:----SDSU7/xOI7Zmfj8lvy2c+prSUWwBPDKS3m/XvGN4+bmtzeaCOb1srsFEG/xE9XPhmPXa32JEwBISURAs1a0R3kO5bA93Xj+N1/PYTtBvYLGD1fbxIiDv5zuu+6HvTQEUyhWa/7TUCMjzNNXTGbvkA/4VY7CftZiYFeUY4CUOEXphQBllCiubNDXf25Ab47Kmj62cSPllzLig/6LN9eKrj/Z+PJ51uCT4x6/oMFQjLVs/NM3ENKLZtyx4KWzbqlmTRnrmpukiqyPb4ONsWaRMQBsrqu2xFuHYGuJfCaH4AmmfxoJ0H/sXnk1L5tT2qoV4AQv8zLYOrZKZ0Ijnkbrxox9Z8e/WKrHLzO99VYysznSZWGWvbcm4mDOCujIBw30tjvnWMHxV6aQD1mwHg3Bn7SmaIc/X5ZxQcjZNWcdKA4e8VqjYAwnTcHL1A0xJOgDiFkSwmPxkXt66kehkdj98ESSA4zbbRO5It5xPwDPyxnj+QKZMpstjPCBlKk8on/HLbPYhsvMI8svUWePI8MFgjN1tPtrZrVr+G3Zl8wCIv+H9aYkNq5HTcGYREr4wN9Rnp62cfs5rcbhNj8pnu5ojgjP9XcUqgpSI49tr70mMUOXISqwjW1Fw6c7WNLkjndGFag8Nrf9F8V3/p2NkXls2nB7mr5aWTp88LYT2mAZwcrI=----ATTACHMENT:----MzQ1NjU3MjMzMzM5MDY2NyA3MTgyOTg3NTUwMDYxNjEzIDMxODY3Njg4MDcwNTg3Mw==