<?php

namespace dokuwiki\plugin\struct\test;

use dokuwiki\plugin\struct\meta\Search;

/**
 * Tests to the DB for the struct plugin
 *
 * @group plugin_struct
 * @group plugins
 *
 */
class AccessTableDataDBMultiTest extends StructTest
{

    /** @var \helper_plugin_sqlite $sqlite */
    protected $sqlite;

    public function setUp(): void
    {
        parent::setUp();

        /** @var \helper_plugin_struct_db $sqlite */
        $sqlite = plugin_load('helper', 'struct_db');
        $this->sqlite = $sqlite->getDB();

        $this->loadSchemaJSON('testtable', 'testtable2', 100);

        // revision 1
        $this->saveData(
            'testpage',
            'testtable',
            [
                'testMulitColumn2' => ['value1.1', 'value1.2'],
                'testMulitColumn' => ['value2.1', 'value2.2']
            ],
            123
        );

        // revision 2
        $this->saveData(
            'testpage',
            'testtable',
            [
                'testMulitColumn2' => ['value1.1a', 'value1.2a'],
                'testMulitColumn' => ['value2.1a', 'value2.2a']
            ],
            789
        );

        // revision 1 of different page
        $this->saveData(
            'testpage2',
            'testtable',
            [
                'testMulitColumn2' => ['value1.1a'],
                'testMulitColumn' => ['value2.1a']
            ],
            789
        );

        // global data
        $this->saveData(
            '',
            'testtable',
            [
                'testMulitColumn2' => ['value1.1b', 'value1.2b'],
                'testMulitColumn' => ['value2.1b', 'value2.2b']
            ],
            0,
            1
        );
    }

    public function test_getDataFromDB_currentRev()
    {

        // act
        $schemaData = mock\AccessTable::getPageAccess('testtable', 'testpage');
        $actual_data = $schemaData->getDataFromDB();

        $expected_data = [
            [
                'out1' => 'value1.1a' . Search::CONCAT_SEPARATOR . 'value1.2a',
                'out2' => 'value2.1a' . Search::CONCAT_SEPARATOR . 'value2.2a',
                'PID' => 'testpage',
            ],
        ];

        $this->assertEquals($expected_data, $actual_data);
    }

    public function test_getDataFromDB_deleteMultiPage()
    {

        $this->saveData(
            'testpage',
            'testtable',
            [
                'testMulitColumn2' => '',
                'testMulitColumn' => ['value2.1a'],
            ]
        );

        $expected = [
            [
                'out1' => 'value1.1a' . Search::CONCAT_SEPARATOR . 'value1.2a',
                'out2' => 'value2.1a' . Search::CONCAT_SEPARATOR . 'value2.2a',
                'PID' => 'testpage',
            ],
        ];

        $access = mock\AccessTable::getPageAccess('testtable', 'testpage');
        $actual = $access->getDataFromDB();

        $this->assertEquals($expected, $actual);
    }

    public function test_getDataFromDB_deleteMultiGlobal()
    {

        $this->saveData(
            '',
            'testtable',
            [
                'testMulitColumn2' => ['value1.1c', 'value1.2c'],
                'testMulitColumn' => ['']
            ],
            0,
            1
        );

        $expected = [
            [
                'out1' => 'value1.1c' . Search::CONCAT_SEPARATOR . 'value1.2c',
                'out2' => '',
                'RID' => '1',
            ],
        ];

        $access = mock\AccessTable::getGlobalAccess('testtable', 1);
        $actual = $access->getDataFromDB();

        $this->assertEquals($expected, $actual);

    }
}