import {Page} from '@playwright/test';

import {TestParametrizationConfig} from '../../../types/config';

import QLPage from '../../../page-objects/ql/QLPage';
import datalensTest from '../../../utils/playwright/globalTestDefinition';
import {openTestPage} from '../../../utils';

import {WizardVisualizationId} from '../../../page-objects/common/Visualization';

const sqlScriptWithIntervalParam = `select {{target_date_from}} as date_from, {{target_date_to}} as date_to`;

datalensTest.describe('QL interval parameter recognition check with operation', () => {
    datalensTest(
        'Checking that the user can set date-interval parameter default value and it applies correctly',
        async ({page, config}: {page: Page; config: TestParametrizationConfig}) => {
            const qlPage = new QLPage({page});

            await openTestPage(page, config.ql.urls.NewQLChartWithConnection);

            await qlPage.setVisualization(WizardVisualizationId.FlatTable);

            await qlPage.setScript(sqlScriptWithIntervalParam);

            await qlPage.openParamsTab();

            await qlPage.addParam();

            await qlPage.selectParamType('date-interval');

            await qlPage.setParamName('target_date');

            await qlPage.openParamDialog();

            await qlPage.selectRangeDate(['05.10.1995', '18.02.2018']);

            await qlPage.applyParamDialog();

            await qlPage.runScript();

            const viewTableTexts = await qlPage.chartkit.getRowsTexts();
            const previewTableTexts = await qlPage.previewTable.getRowsTexts();

            expect(String(viewTableTexts[0][0])).toEqual('05.10.1995');
            expect(String(viewTableTexts[0][1])).toEqual('18.02.2018');
            expect(String(previewTableTexts[0][0])).toEqual('1995-10-05');
            expect(String(previewTableTexts[0][1])).toEqual('2018-02-18');
        },
    );
});