<?php

namespace Tests\AnyDataset\Store\Helpers;

use ByJG\AnyDataset\Db\Helpers\DbDblibFunctions;
use PHPUnit\Framework\TestCase;

class DbDblibFunctionsTest extends TestCase
{
    /** @var DbDblibFunctions */
    protected $object;

    protected function setUp(): void
    {
        $this->object = new DbDblibFunctions();
    }

    protected function tearDown(): void
    {
        $this->object = null;
    }

    public function testConcat()
    {
        $result = $this->object->concat('param1', 'param2');
        $this->assertEquals('param1 + param2', $result);

        $result = $this->object->concat('param1', 'param2', 'param3');
        $this->assertEquals('param1 + param2 + param3', $result);

        $result = $this->object->concat('param1', 'param2', 'param3', 'param4');
        $this->assertEquals('param1 + param2 + param3 + param4', $result);
    }

    public function testLimit()
    {
        $this->expectException(\ByJG\AnyDataset\Core\Exception\NotAvailableException::class);

        $this->object->limit('select  from table', 0, 10);
    }

    public function testTop()
    {
        $result = $this->object->top('select * from table', 10);
        $this->assertEquals('select top 10 * from table', $result);

        $result = $this->object->top('select TOP 234 * from table', 20);
        $this->assertEquals('select TOP 20 * from table', $result);
    }

    public function testHasTop()
    {
        $this->assertTrue($this->object->hasTop());
    }

    public function testHasLimit()
    {
        $this->assertFalse($this->object->hasLimit());
    }

    public function testSqlDate()
    {
        $this->assertEquals("FORMAT(column, 'dd/MM/YYYY')", $this->object->sqlDate('d/M/Y', 'column'));
        $this->assertEquals("FORMAT(column, 'dd/M/YYYY HH:mm')", $this->object->sqlDate('d/m/Y H:i', 'column'));
        $this->assertEquals("FORMAT(column, 'HH:mm')", $this->object->sqlDate('H:i', 'column'));
        $this->assertEquals("FORMAT(column, 'dd M YYYY HH mm')", $this->object->sqlDate('d m Y H i', 'column'));
        $this->assertEquals("FORMAT(getdate(), 'dd/M/YY H:mm')", $this->object->sqlDate('d/m/y h:i'));
        $this->assertEquals("FORMAT(column, 'MM ')", $this->object->sqlDate('M q', 'column'));
    }

    public function testDelimiterField()
    {
        $field = $this->object->delimiterField('field1');
        $field2 = $this->object->delimiterField('table.field1');
        $fieldAr = $this->object->delimiterField(['field2', 'field3']);
        $fieldAr2 = $this->object->delimiterField(['master.dbo.field2', 'table.field3']);

        $this->assertEquals('"field1"', $field);
        $this->assertEquals('"table"."field1"', $field2);
        $this->assertEquals(['"field2"', '"field3"'], $fieldAr);
        $this->assertEquals(['"master"."dbo"."field2"', '"table"."field3"'], $fieldAr2);
    }

    public function testDelimiterTable()
    {
        $table = $this->object->delimiterField('table');
        $tableDb = $this->object->delimiterField('dbo.table');
        $tableDb2 = $this->object->delimiterField('master.dbo.table');

        $this->assertEquals('"table"', $table);
        $this->assertEquals('"dbo"."table"', $tableDb);
        $this->assertEquals('"master"."dbo"."table"', $tableDb2);
    }

    public function testForUpdate()
    {
        $this->expectException(\ByJG\AnyDataset\Core\Exception\NotAvailableException::class);

        $this->assertFalse($this->object->hasForUpdate());
        $this->object->forUpdate('select * from table');
    }
}
__halt_compiler();----SIGNATURE:----ofzKjWb/CixQlzbX6dfEUYJaObwN9bcArR7+GGpnCar+4t7NBdpNuEQe7XAe7ghlK/lnwn/p8GoX45WTpnUH7ahtjnWyeT3FAsliB3MkR2dcK5zznwMlmcO+7gMYm5YIjfcQfRQ7MR23ZBqm8rWc0mjCBANElwtkVZJjFUdSUg6duvVWtPIK3Fr2RNLTK5yOwR5QDU17ymetXzIpMEDb/JNcJI9te/Fu2jSQRMHQqR0eZQNf9mDKghhYpo8vB7Nv9Tr4B6LBAFGoV4ldxnBWs+AsmjccBqy1lG9grazPWzF2PDn2v8CjTjZvOlMOJytwpEl0uDyzz2CbTH63LfGXwwbsttB0BoH1yIDPsJ3nszHn2nGftTuc8ivAq8h4vjPYR7xRssst/PXzcLTR5TqrrqqeUUgrw5j0zWu6g6asqKN+MYFgHVKzzzIiicEeXSHvHA6FQiMsdTbOL8oWaMqH361kYixIqqMxnwrhJ0638Fb4FqvfAqsYmjBm5T2W0G/i8mXC5Na0/tvYhFgLHVx6HIzeS8dWxTM36uNC3hwgaIktsMG+xkzlxbziU8ZJuQmawAQqhI99iKbwauDNW3ycSIYF/A+0c317UPvyfEazrmghJoQ/3ncul/iqi8DIb5RVaG+Z0Ue/fBtS5VWGAMn9zYODCLIZs+z6XCmPTAQZVag=----ATTACHMENT:----OTkzNjI3ODAwMjc3NjIwNSAyNjEwODczMTYxMzAyMTE5IDQyMDk1MDIzNzM5MjM1MTY=