<?php
/**
 * @author Daniel J. Summers <daniel@bitbadger.solutions>
 * @license MIT
 */

declare(strict_types=1);

use BitBadger\PDODocument\{Configuration, DocumentException, DocumentIndex, Mode};
use BitBadger\PDODocument\Query\Definition;

pest()->group('unit');

describe('::ensureTable()', function () {
    afterEach(function () { Configuration::overrideMode(null); });
    test('generates correct SQL [PostgreSQL]', function () {
        Configuration::overrideMode(Mode::PgSQL);
        expect(Definition::ensureTable('documents'))
            ->toBe('CREATE TABLE IF NOT EXISTS documents (data JSONB NOT NULL)');
    })->group('postgresql');
    test('generates correct SQL [SQLite]', function () {
        Configuration::overrideMode(Mode::SQLite);
        expect(Definition::ensureTable('dox'))->toBe('CREATE TABLE IF NOT EXISTS dox (data TEXT NOT NULL)');
    })->group('sqlite');
    test('throws an exception if mode is not set', function () {
        expect(fn () => Definition::ensureTable(''))->toThrow(DocumentException::class);
    });
});

describe('::ensureIndexOn()', function () {
    test('generates correct SQL for unqualified table, single ascending field', function () {
        expect(Definition::ensureIndexOn('test', 'fields', ['details']))
            ->toBe("CREATE INDEX IF NOT EXISTS idx_test_fields ON test ((data->>'details'))");
    });
    test('generates correct SQL for qualified table, multiple fields', function () {
        expect(Definition::ensureIndexOn('sch.testing', 'json', ['group', 'sub_group DESC']))
            ->toBe('CREATE INDEX IF NOT EXISTS idx_testing_json ON sch.testing '
                . "((data->>'group'), (data->>'sub_group') DESC)");
    });
});

describe('::ensureKey()', function () {
    test('generates correct SQL', function () {
        expect(Definition::ensureKey('tbl'))
            ->toBe("CREATE UNIQUE INDEX IF NOT EXISTS idx_tbl_key ON tbl ((data->>'id'))");
    });
});

describe('::ensureDocumentIndexOn()', function () {
    afterEach(function () { Configuration::overrideMode(null); });
    test('generates correct SQL for qualified table, full index [PostgreSQL]', function () {
        Configuration::overrideMode(Mode::PgSQL);
        expect(Definition::ensureDocumentIndexOn('my.tbl', DocumentIndex::Full))
            ->toBe("CREATE INDEX IF NOT EXISTS idx_tbl_document ON my.tbl USING GIN (data)");
    })->group('postgresql');
    test('generates correct SQL for unqualified table, optimized index [PostgreSQL]', function () {
        Configuration::overrideMode(Mode::PgSQL);
        expect(Definition::ensureDocumentIndexOn('it', DocumentIndex::Optimized))
            ->toBe("CREATE INDEX IF NOT EXISTS idx_it_document ON it USING GIN (data jsonb_path_ops)");
    })->group('postgresql');
    test('throws an exception [SQLite]', function () {
        Configuration::overrideMode(Mode::SQLite);
        expect(fn () => Definition::ensureDocumentIndexOn('', DocumentIndex::Full))->toThrow(DocumentException::class);
    })->group('sqlite');
});