You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
284 lines
12 KiB
284 lines
12 KiB
"use strict";
|
|
import { assert, driver } from 'mocha-webdriver';
|
|
import { $, gu, test } from 'test/nbrowser/gristUtil-nbrowser';
|
|
|
|
const colHeaderScrollOpts = {block: "start", inline: "end"};
|
|
|
|
describe('ColumnOps.ntest', function() {
|
|
gu.bigScreen();
|
|
const cleanup = test.setupTestSuite(this);
|
|
|
|
before(async function() {
|
|
await gu.supportOldTimeyTestCode();
|
|
await gu.useFixtureDoc(cleanup, "World.grist", true);
|
|
await gu.toggleSidePanel('left', 'close');
|
|
});
|
|
|
|
afterEach(function() {
|
|
return gu.checkForErrors();
|
|
});
|
|
|
|
it("should allow adding and deleting columns", async function() {
|
|
await gu.clickColumnMenuItem('Name', 'Insert column to the right');
|
|
await $('.test-new-columns-menu-add-new').click();
|
|
await gu.waitForServer();
|
|
// Newly created columns labels become editable automatically. The next line checks that the
|
|
// label is editable and then closes the editor.
|
|
await gu.userActionsCollect(true);
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('A')).wait().sendKeys($.ENTER);
|
|
// Verify that no UserActions were actually sent.
|
|
await gu.waitForServer();
|
|
await gu.userActionsVerify([]);
|
|
await gu.userActionsCollect(false);
|
|
await gu.waitAppFocus(true);
|
|
await assert.isPresent(gu.getColumnHeader('A'), true);
|
|
await assert.isPresent(gu.getOpenEditingLabel(gu.getColumnHeader('A')), false);
|
|
|
|
await gu.clickColumnMenuItem('A', 'Delete column');
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('A'), false);
|
|
});
|
|
|
|
it("should allow adding columns with new column menu", async function() {
|
|
await assert.isPresent(gu.getColumnHeader('A'), false);
|
|
await $('.mod-add-column').scrollIntoView(true);
|
|
await $('.mod-add-column').click();
|
|
await gu.actions.selectFloatingOption('Add column');
|
|
await gu.userActionsCollect(true);
|
|
await gu.waitToPass(() => gu.getColumnHeader('A'));
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('A')).wait().sendKeys($.ENTER);
|
|
await gu.waitForServer();
|
|
await gu.userActionsVerify([["AddRecord", "_grist_Views_section_field", null,
|
|
{"colRef":43, "parentId":4, "parentPos":null}]]);
|
|
await gu.userActionsCollect(false);
|
|
await gu.waitAppFocus(true);
|
|
await assert.isPresent(gu.getColumnHeader('A'), true);
|
|
await assert.isPresent(gu.getOpenEditingLabel(gu.getColumnHeader('A')), false);
|
|
assert.deepEqual(await gu.getGridLabels('City'),
|
|
["Name", "Country", "District", "Population", "A"]);
|
|
});
|
|
|
|
it("should allow hiding columns", async function() {
|
|
await assert.isPresent(gu.getColumnHeader('Name'), true);
|
|
await gu.getColumnHeader('Name').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('Name', 'Hide column');
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('Name'), false);
|
|
|
|
await $(".test-undo").click();
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('Name'), true);
|
|
});
|
|
|
|
it("[+] button should allow showing hidden columns", async function() {
|
|
// Hide a column first
|
|
await assert.isPresent(gu.getColumnHeader('Name'), true);
|
|
await gu.getColumnHeader('Name').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('Name', 'Hide column');
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('Name'), false);
|
|
|
|
// Then show it using the Add column menu
|
|
await $('.mod-add-column').scrollIntoView(true);
|
|
await $(".mod-add-column").click();
|
|
await showColumn('Name');
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('Name'), true);
|
|
});
|
|
|
|
it("[+] button show Add column directly if no hidden columns", async function() {
|
|
await $('.mod-add-column').scrollIntoView(true);
|
|
await $(".mod-add-column").click();
|
|
await showColumn("Pop");
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader("Pop. '000"), true);
|
|
|
|
await assert.isPresent(gu.getColumnHeader('B'), false);
|
|
await $('.mod-add-column').scrollIntoView(true);
|
|
await $(".mod-add-column").click();
|
|
await $('.test-new-columns-menu-add-new').click();
|
|
await gu.waitToPass(() => gu.getColumnHeader('B'));
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('B')).wait().sendKeys($.ENTER);
|
|
await gu.waitForServer();
|
|
await gu.waitAppFocus(true);
|
|
await assert.isPresent(gu.getColumnHeader('B'), true);
|
|
});
|
|
|
|
it("should allow renaming columns", async function() {
|
|
await gu.getColumnHeader('Name').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('Name', 'Rename column');
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('Name')).sendKeys('Renamed', $.ENTER);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('Renamed'), true);
|
|
assert.deepEqual(await gu.getGridValues({
|
|
cols: ['Renamed'],
|
|
rowNums: [3, 4, 5],
|
|
}), ['A Coruña (La Coruña)', 'Aachen', 'Aalborg']);
|
|
|
|
// Verify that undo/redo works with renaming
|
|
await gu.undo();
|
|
await assert.isPresent(gu.getColumnHeader('Name'), true);
|
|
assert.deepEqual(await gu.getGridValues({
|
|
cols: ['Name'],
|
|
rowNums: [3, 4, 5],
|
|
}), ['A Coruña (La Coruña)', 'Aachen', 'Aalborg']);
|
|
await gu.redo();
|
|
await assert.isPresent(gu.getColumnHeader('Renamed'), true);
|
|
assert.deepEqual(await gu.getGridValues({
|
|
cols: ['Renamed'],
|
|
rowNums: [3, 4, 5],
|
|
}), ['A Coruña (La Coruña)', 'Aachen', 'Aalborg']);
|
|
|
|
// Refresh the page and check that the rename sticks.
|
|
await driver.navigate().refresh();
|
|
assert.equal(await $('.active_section .test-viewsection-title').wait().text(), 'CITY');
|
|
await gu.waitForServer(5000);
|
|
await gu.clickCellRC(1, 4);
|
|
await assert.isPresent(gu.getColumnHeader('Renamed'), true);
|
|
|
|
// Check that it is renamed in the sidepane
|
|
await gu.openSidePane('field');
|
|
assert.equal(await $(".test-field-label").val(), "Renamed");
|
|
|
|
// Check that both the label and the Id are changed when label and Id are linked
|
|
let deriveIdCheckbox = $(".test-field-derive-id");
|
|
assert.isTrue(await deriveIdCheckbox.is('[class*=-selected]'));
|
|
await deriveIdCheckbox.click();
|
|
await gu.waitForServer();
|
|
assert.isFalse(await deriveIdCheckbox.is('[class*=-selected]'));
|
|
assert(await $(".test-field-col-id").val(), "Renamed");
|
|
|
|
// Check that just the label is changed when label and Id are unlinked
|
|
await gu.getColumnHeader('Renamed').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('Renamed', 'Rename column');
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('Renamed')).wait().sendKeys('foo', $.ENTER);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('foo'), true);
|
|
await assert.isPresent(gu.getOpenEditingLabel(gu.getColumnHeader('foo')), false);
|
|
assert.equal(await $(".test-field-label").val(), "foo");
|
|
assert(await $(".test-field-col-id").val(), "Renamed");
|
|
|
|
// Saving an identical column label should still close the input.
|
|
await gu.getColumnHeader('foo').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('foo', 'Rename column');
|
|
await gu.userActionsCollect(true);
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('foo')).wait().sendKeys('foo', $.ENTER);
|
|
await gu.waitForServer();
|
|
await gu.userActionsVerify([]);
|
|
await gu.userActionsCollect(false);
|
|
await assert.isPresent(gu.getOpenEditingLabel(gu.getColumnHeader('foo')), false);
|
|
await gu.waitAppFocus(true);
|
|
|
|
// Bug T384: Should save the column name after cancelling a rename earlier.
|
|
await gu.getColumnHeader('A').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.clickColumnMenuItem('A', 'Rename column');
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('A')).wait().sendKeys('C', $.ESCAPE);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('A'), true);
|
|
await gu.clickColumnMenuItem('A', 'Rename column');
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('A')).sendKeys('C', $.TAB);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('C'), true);
|
|
});
|
|
|
|
it("should allow renaming columns with a click", async function() {
|
|
// Go to a non-target column first
|
|
await gu.getColumnHeader('Population').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.getColumnHeader('Population').click();
|
|
// Now select the column of interest
|
|
await gu.getColumnHeader('foo').scrollIntoView(colHeaderScrollOpts);
|
|
await gu.getColumnHeader('foo').click();
|
|
// And click one more time to rename
|
|
await gu.getColumnHeader('foo').click();
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('foo')).sendKeys('foot', $.ENTER);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('foo'), false);
|
|
await assert.isPresent(gu.getColumnHeader('foot'), true);
|
|
// Click to rename back again
|
|
await gu.getColumnHeader('foot').click();
|
|
await gu.getOpenEditingLabel(await gu.getColumnHeader('foot')).sendKeys('foo', $.ENTER);
|
|
await gu.waitForServer();
|
|
await assert.isPresent(gu.getColumnHeader('foo'), true);
|
|
await assert.isPresent(gu.getColumnHeader('foot'), false);
|
|
});
|
|
|
|
it("should allow deleting multiple columns", async function() {
|
|
await gu.actions.selectTabView('Country');
|
|
|
|
// delete shortcut should delete all selected columns
|
|
await gu.selectGridArea([1, 0], [1, 1]);
|
|
await gu.sendKeys([$.ALT, '-']);
|
|
await gu.waitForServer();
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Continent", "Region", "SurfaceArea", "IndepYear", "Population", "LifeExpectancy",
|
|
"GNP", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState", "Capital", "Code2"]);
|
|
// Undo to restore changes
|
|
await gu.undo(1, 5000);
|
|
|
|
// delete menu item should delete all selected columns
|
|
await gu.selectGridArea([1, 2], [1, 8]);
|
|
await gu.clickColumnMenuItem('SurfaceArea', 'Delete', true);
|
|
await gu.waitForServer();
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Code", "Name", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState", "Capital", "Code2"]);
|
|
// Undo to restore changes
|
|
await gu.undo(1, 5000);
|
|
|
|
// the delete shortcut should delete all columns in a cell selection as well
|
|
await gu.clickCellRC(2, 5);
|
|
await gu.sendKeys([$.SHIFT, $.RIGHT, $.RIGHT]);
|
|
await gu.sendKeys([$.ALT, '-']);
|
|
await gu.waitForServer();
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Code", "Name", "Continent", "Region", "SurfaceArea", "GNP", "GNPOld", "LocalName",
|
|
"GovernmentForm", "HeadOfState", "Capital", "Code2"]);
|
|
// Undo to restore changes
|
|
await gu.undo(1, 5000);
|
|
|
|
// Nudge first few columns back into view if they've drifted out of it.
|
|
await gu.toggleSidePanel('right', 'close');
|
|
await gu.sendKeys($.LEFT, $.LEFT, $.LEFT);
|
|
|
|
// opening a column menu outside the selection should move the selection
|
|
await gu.clickCellRC(2, 2);
|
|
await gu.sendKeys([$.SHIFT, $.RIGHT]);
|
|
await gu.clickColumnMenuItem('IndepYear', 'Delete', true);
|
|
await gu.waitForServer();
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Code", "Name", "Continent", "Region", "SurfaceArea", "Population",
|
|
"LifeExpectancy", "GNP", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState",
|
|
"Capital", "Code2"]);
|
|
// Undo to restore changes
|
|
await gu.undo();
|
|
});
|
|
|
|
it("should allow hiding multiple columns", async function() {
|
|
await gu.actions.selectTabView('Country');
|
|
await gu.openSidePane('view');
|
|
|
|
// hide menu item should hide all selected columns
|
|
await gu.selectGridArea([1, 2], [1, 8]);
|
|
await gu.clickColumnMenuItem('SurfaceArea', 'Hide 7 columns', true);
|
|
await gu.waitForServer();
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Code", "Name", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState", "Capital", "Code2"]);
|
|
assert.deepEqual(await $('.test-vfc-visible-fields .kf_draggable_content').array().text(),
|
|
["Code", "Name", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState", "Capital", "Code2"]);
|
|
assert.deepEqual(await $('.test-vfc-hidden-fields .kf_draggable_content').array().text(),
|
|
["Name", "Continent", "Region", "SurfaceArea", "IndepYear", "Population",
|
|
"LifeExpectancy", "GNP", "Self"]);
|
|
// Undo to restore changes
|
|
await gu.undo(1, 5000);
|
|
|
|
assert.deepEqual(await gu.getGridLabels('Country'),
|
|
["Code", "Name", "Continent", "Region", "SurfaceArea", "IndepYear", "Population",
|
|
"LifeExpectancy", "GNP", "GNPOld", "LocalName", "GovernmentForm", "HeadOfState",
|
|
"Capital", "Code2"]);
|
|
|
|
});
|
|
});
|
|
|
|
function showColumn(name) {
|
|
return $(`.test-new-columns-menu-hidden-column-inlined:contains(${name})`).click();
|
|
}
|