<?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(string $str1, ?string $str2 = null): string;

    /**
     * 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(string $sql, int $start, int $qty = 50): string;

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

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

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

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

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

    /**
     * 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(string $date, string $dateFormat): string;

    /**
     * @param DbDriverInterface $dbdataset
     * @param string $sql
     * @param array|null $param
     * @return mixed
     */
    public function executeAndGetInsertedId(DbDriverInterface $dbdataset, string $sql, ?array $param = null): mixed;

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

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

    public function forUpdate(string $sql): string;

    public function hasForUpdate(): bool;

    public function getTableMetadata(DbDriverInterface $dbdataset, string $tableName): array;

    public function getIsolationLevelCommand(?IsolationLevelEnum $isolationLevel = null): string;

    public function getJoinTablesUpdate(array $tables): array;
}__halt_compiler();----SIGNATURE:----bFxhM8kmfF0wPziHcen6+HWCMuf9nqs2+F+I52I7IohHavxt0/ZlSn67S+GmpZALqQYsTnUa7xLB0usdkoBU6Ohi94GxWsQWpBuyT2uMfFaQ/E6KPYGkdj7HfMeOFUR2GjziOQvLo53QzjUECeSVRkM9gIN7wi8MPLgwq1SMjoaCMA0npa6rEe/f+/jlOxEwKkOLNmFkplvXTYfIEa9nCfItLZooVj8Ox3Ml4qFkVIma56a2n8PAPB3oN1c31OVJDyuUfFu9LOARlCxiFyA8VCAkDbrR89Kca39KnlvQBhJLnuc5gXuZCO3ycqAobwWScmlJL8xJqSMDjt9E2OoIDWF1QWXX1Rk3nvSZG8Whe84wfHFZqDmH62K+yVxll+3u1Ozpt0TOtCX+ln8saq3HER8E7t9ku/cXX5RIoyK01wfY7WgjpwMh5/kHn8twXUMnlYV7KX24pqpim9DRmussahT0So0/Iwig63HDEWh0WCgmX9jNImYrlpKJXdYF8vuy6mHI3UZD99te5yPvkLi39vEykGBjbW0SwU0ElZnyAk5QVElV1a1sEt8Rw9yCd9c4SWyL7UFbRz0ILy0JbwM4bThkGW3TYwhUPCnye37Fet2TNr/w/pOv+bs7GOoT/ae8PEmIdTojyCg/kqnWzZNGS6mXwCkZEEJe9VRQgogj760=----ATTACHMENT:----OTA3MjI3OTM0ODkxNTM0MSAzMDA2ODIzODY4ODE5MTA0IDIzNzA1NzE1MTk4NjAxNQ==