Skip to content

Bring projects, wikis, and teams together with AI. AppFlowy is the AI collaborative workspace where you achieve more without losing control of your data. The leading open source Notion alternative.

19.9 KB
Raw Blame
import 'package:appflowy/generated/locale_keys.g.dart';
import 'package:appflowy/plugins/database/grid/presentation/grid_page.dart';
import 'package:appflowy/plugins/database/widgets/field/type_option_editor/select/select_option.dart';
import 'package:appflowy/shared/icon_emoji_picker/recent_icons.dart';
import 'package:appflowy/util/field_type_extension.dart';
import 'package:appflowy_backend/protobuf/flowy-database2/protobuf.dart';
import 'package:appflowy_backend/protobuf/flowy-folder/protobuf.dart';
import 'package:easy_localization/easy_localization.dart';
import 'package:flutter/material.dart';
import 'package:flutter_test/flutter_test.dart';
import 'package:integration_test/integration_test.dart';

import '../../shared/database_test_op.dart';
import '../../shared/util.dart';

void main() {
  setUpAll(() {
    IntegrationTestWidgetsFlutterBinding.ensureInitialized();
    RecentIcons.enable = false;
  });

  tearDownAll(() {
    RecentIcons.enable = true;
  });

  group('grid edit field test:', () {
    testWidgets('rename existing field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      // Invoke the field editor
      await tester.tapGridFieldWithName('Name');

      await tester.renameField('hello world');
      await tester.dismissFieldEditor();

      await tester.tapGridFieldWithName('hello world');
      await tester.pumpAndSettle();
    });

    testWidgets('edit field icon', (tester) async {
      const icon = 'artificial_intelligence/ai-upscale-spark';
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      tester.assertFieldSvg('Name', FieldType.RichText);

      // choose specific icon
      await tester.tapGridFieldWithName('Name');
      await tester.changeFieldIcon(icon);
      await tester.dismissFieldEditor();

      tester.assertFieldCustomSvg('Name', icon);

      // remove icon
      await tester.tapGridFieldWithName('Name');
      await tester.changeFieldIcon('');
      await tester.dismissFieldEditor();

      tester.assertFieldSvg('Name', FieldType.RichText);

      await tester.pumpAndSettle();
    });

    testWidgets('update field type of existing field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      // Invoke the field editor
      await tester.changeFieldTypeOfFieldWithName('Type', FieldType.Checkbox);

      await tester.assertFieldTypeWithFieldName(
        'Type',
        FieldType.Checkbox,
      );
      await tester.pumpAndSettle();
    });

    testWidgets('create a field and rename it', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      // create a new grid
      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      // create a field
      await tester.createField(FieldType.Checklist);
      tester.findFieldWithName(FieldType.Checklist.i18n);

      // editing field type during field creation should change title
      await tester.createField(FieldType.MultiSelect);
      tester.findFieldWithName(FieldType.MultiSelect.i18n);

      // not if the user changes the title manually though
      const name = "New field";
      await tester.createField(FieldType.DateTime);
      await tester.tapGridFieldWithName(FieldType.DateTime.i18n);
      await tester.renameField(name);
      await tester.tapEditFieldButton();
      await tester.tapSwitchFieldTypeButton();
      await tester.selectFieldType(FieldType.URL);
      tester.findFieldWithName(name);
    });

    testWidgets('delete field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      // create a field
      await tester.createField(FieldType.Checkbox, name: 'New field 1');

      // Delete the field
      await tester.tapGridFieldWithName('New field 1');
      await tester.tapDeletePropertyButton();

      // confirm delete
      await tester.tapButtonWithName(LocaleKeys.space_delete.tr());

      tester.noFieldWithName('New field 1');
      await tester.pumpAndSettle();
    });

    testWidgets('duplicate field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      // create a field
      await tester.createField(FieldType.RichText, name: 'New field 1');

      // duplicate the field
      await tester.tapGridFieldWithName('New field 1');
      await tester.tapDuplicatePropertyButton();

      tester.findFieldWithName('New field 1 (copy)');
      await tester.pumpAndSettle();
    });

    testWidgets('insert field on either side of a field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      await tester.scrollToRight(find.byType(GridPage));

      // insert new field to the right
      await tester.tapGridFieldWithName('Type');
      await tester.tapInsertFieldButton(left: false, name: 'Right');
      await tester.dismissFieldEditor();
      tester.findFieldWithName('Right');

      // insert new field to the left
      await tester.tapGridFieldWithName('Type');
      await tester.tapInsertFieldButton(left: true, name: "Left");
      await tester.dismissFieldEditor();
      tester.findFieldWithName('Left');

      await tester.pumpAndSettle();
    });

    testWidgets('clear cells under field', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      await tester.scrollToRight(find.byType(GridPage));

      // edit the data
      await tester.editCell(
        rowIndex: 0,
        fieldType: FieldType.RichText,
        input: 'Hello',
      );
      await tester.editCell(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        input: 'World',
      );

      expect(find.text('Hello'), findsOneWidget);
      expect(find.text('World'), findsOneWidget);

      // clear the cells
      await tester.tapGridFieldWithName('Name');
      await tester.tapClearCellsButton();
      await tester.tapButtonWithName(LocaleKeys.button_confirm.tr());

      expect(find.text('Hello'), findsNothing);
      expect(find.text('World'), findsNothing);
    });

    testWidgets('create list of fields', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      for (final fieldType in [
        FieldType.Checklist,
        FieldType.DateTime,
        FieldType.Number,
        FieldType.URL,
        FieldType.MultiSelect,
        FieldType.LastEditedTime,
        FieldType.CreatedTime,
        FieldType.Checkbox,
      ]) {
        await tester.createField(fieldType);

        // After update the field type, the cells should be updated
        tester.findCellByFieldType(fieldType);
        await tester.pumpAndSettle();
      }
    });

    testWidgets('field types with empty type option editor', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      for (final fieldType in [
        FieldType.RichText,
        FieldType.Checkbox,
        FieldType.Checklist,
        FieldType.URL,
      ]) {
        await tester.createField(fieldType);

        // open the field editor
        await tester.tapGridFieldWithName(fieldType.i18n);
        await tester.tapEditFieldButton();

        // check type option editor is empty
        tester.expectEmptyTypeOptionEditor();
        await tester.dismissFieldEditor();
      }
    });

    testWidgets('number field type option', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);
      await tester.scrollToRight(find.byType(GridPage));

      // create a number field
      await tester.createField(FieldType.Number);

      // enter some data into the first number cell
      await tester.editCell(
        rowIndex: 0,
        fieldType: FieldType.Number,
        input: '123',
      );
      // edit the next cell to force the previous cell at row 0 to lose focus
      await tester.editCell(
        rowIndex: 1,
        fieldType: FieldType.Number,
        input: '0.2',
      );
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.Number,
        content: '123',
      );

      // open editor and change number format
      await tester.tapGridFieldWithName(FieldType.Number.i18n);
      await tester.tapEditFieldButton();
      await tester.changeNumberFieldFormat();
      await tester.dismissFieldEditor();

      // assert number format has been changed
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.Number,
        content: '\$123',
      );
    });

    testWidgets('add option', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(
        layout: ViewLayoutPB.Grid,
      );

      // invoke the field editor
      await tester.tapGridFieldWithName('Type');
      await tester.tapEditFieldButton();

      // tap 'add option' button
      await tester.tapAddSelectOptionButton();
      const text = 'Hello AppFlowy';
      final inputField = find.descendant(
        of: find.byType(CreateOptionTextField),
        matching: find.byType(TextField),
      );
      await tester.enterText(inputField, text);
      await tester.testTextInput.receiveAction(TextInputAction.done);
      await tester.pumpAndSettle(const Duration(milliseconds: 500));

      // check the result
      tester.expectToSeeText(text);
    });

    testWidgets('date time field type options', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);
      await tester.scrollToRight(find.byType(GridPage));

      // create a date field
      await tester.createField(FieldType.DateTime);

      // edit the first date cell
      await tester.tapCellInGrid(rowIndex: 0, fieldType: FieldType.DateTime);
      await tester.toggleIncludeTime();
      final now = DateTime.now();
      await tester.selectDay(content: now.day);

      await tester.dismissCellEditor();

      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.DateTime,
        content: DateFormat('MMM dd, y HH:mm').format(now),
      );

      // open editor and change date & time format
      await tester.tapGridFieldWithName(FieldType.DateTime.i18n);
      await tester.tapEditFieldButton();
      await tester.changeDateFormat();
      await tester.changeTimeFormat();
      await tester.dismissFieldEditor();

      // assert date format has been changed
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.DateTime,
        content: DateFormat('dd/MM/y hh:mm a').format(now),
      );
    });

    testWidgets('text in viewport while typing', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);

      await tester.changeCalculateAtIndex(0, CalculationType.Count);

      // add very large text with 200 lines
      final largeText = List.generate(
        200,
        (index) => 'Line ${index + 1}',
      ).join('\n');

      await tester.editCell(
        rowIndex: 2,
        fieldType: FieldType.RichText,
        input: largeText,
      );

      // checks if last line is in view port
      tester.expectToSeeText('Line 200');
    });

    // Disable this test because it fails on CI randomly
    // testWidgets('last modified and created at field type options',
    //     (tester) async {
    //   await tester.initializeAppFlowy();
    //   await tester.tapGoButton();

    //   await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);
    //   final created = DateTime.now();

    //   // create a created at field
    //   await tester.tapNewPropertyButton();
    //   await tester.renameField(FieldType.CreatedTime.i18n);
    //   await tester.tapSwitchFieldTypeButton();
    //   await tester.selectFieldType(FieldType.CreatedTime);
    //   await tester.dismissFieldEditor();

    //   // create a last modified field
    //   await tester.tapNewPropertyButton();
    //   await tester.renameField(FieldType.LastEditedTime.i18n);
    //   await tester.tapSwitchFieldTypeButton();

    //   // get time just before modifying
    //   final modified = DateTime.now();

    //   // create a last modified field (cont'd)
    //   await tester.selectFieldType(FieldType.LastEditedTime);
    //   await tester.dismissFieldEditor();

    //   tester.assertCellContent(
    //     rowIndex: 0,
    //     fieldType: FieldType.CreatedTime,
    //     content: DateFormat('MMM dd, y HH:mm').format(created),
    //   );
    //   tester.assertCellContent(
    //     rowIndex: 0,
    //     fieldType: FieldType.LastEditedTime,
    //     content: DateFormat('MMM dd, y HH:mm').format(modified),
    //   );

    //   // open field editor and change date & time format
    //   await tester.tapGridFieldWithName(FieldType.LastEditedTime.i18n);
    //   await tester.tapEditFieldButton();
    //   await tester.changeDateFormat();
    //   await tester.changeTimeFormat();
    //   await tester.dismissFieldEditor();

    //   // open field editor and change date & time format
    //   await tester.tapGridFieldWithName(FieldType.CreatedTime.i18n);
    //   await tester.tapEditFieldButton();
    //   await tester.changeDateFormat();
    //   await tester.changeTimeFormat();
    //   await tester.dismissFieldEditor();

    //   // assert format has been changed
    //   tester.assertCellContent(
    //     rowIndex: 0,
    //     fieldType: FieldType.CreatedTime,
    //     content: DateFormat('dd/MM/y hh:mm a').format(created),
    //   );
    //   tester.assertCellContent(
    //     rowIndex: 0,
    //     fieldType: FieldType.LastEditedTime,
    //     content: DateFormat('dd/MM/y hh:mm a').format(modified),
    //   );
    // });

    testWidgets('select option transform', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(
        layout: ViewLayoutPB.Grid,
      );

      // invoke the field editor of existing Single-Select field Type
      await tester.tapGridFieldWithName('Type');
      await tester.tapEditFieldButton();

      // add some select options
      await tester.tapAddSelectOptionButton();
      for (final optionName in ['A', 'B', 'C']) {
        final inputField = find.descendant(
          of: find.byType(CreateOptionTextField),
          matching: find.byType(TextField),
        );
        await tester.enterText(inputField, optionName);
        await tester.testTextInput.receiveAction(TextInputAction.done);
      }
      await tester.dismissFieldEditor();

      // select A in first row's cell under the Type field
      await tester.tapCellInGrid(
        rowIndex: 0,
        fieldType: FieldType.SingleSelect,
      );
      await tester.selectOption(name: 'A');
      await tester.dismissCellEditor();
      tester.findSelectOptionWithNameInGrid(name: 'A', rowIndex: 0);

      await tester.changeFieldTypeOfFieldWithName('Type', FieldType.RichText);
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.RichText,
        content: "A",
        cellIndex: 1,
      );

      // add some random text in the second row
      await tester.editCell(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        input: "random",
        cellIndex: 1,
      );
      tester.assertCellContent(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        content: "random",
        cellIndex: 1,
      );

      await tester.changeFieldTypeOfFieldWithName(
        'Type',
        FieldType.SingleSelect,
      );
      tester.findSelectOptionWithNameInGrid(name: 'A', rowIndex: 0);
      tester.assertNumberOfSelectedOptionsInGrid(
        rowIndex: 1,
        matcher: findsNothing,
      );

      // create a new field for testing
      await tester.createField(FieldType.RichText, name: 'Test');

      // edit the first 2 rows
      await tester.editCell(
        rowIndex: 0,
        fieldType: FieldType.RichText,
        input: "E,F",
        cellIndex: 1,
      );
      await tester.editCell(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        input: "G",
        cellIndex: 1,
      );

      await tester.changeFieldTypeOfFieldWithName(
        'Test',
        FieldType.MultiSelect,
      );
      tester.assertMultiSelectOption(contents: ['E', 'F'], rowIndex: 0);
      tester.assertMultiSelectOption(contents: ['G'], rowIndex: 1);

      await tester.tapCellInGrid(
        rowIndex: 2,
        fieldType: FieldType.MultiSelect,
      );
      await tester.selectOption(name: 'G');
      await tester.createOption(name: 'H');
      await tester.dismissCellEditor();
      tester.findSelectOptionWithNameInGrid(name: 'A', rowIndex: 0);
      tester.assertMultiSelectOption(contents: ['G', 'H'], rowIndex: 2);

      await tester.changeFieldTypeOfFieldWithName(
        'Test',
        FieldType.RichText,
      );
      tester.assertCellContent(
        rowIndex: 2,
        fieldType: FieldType.RichText,
        content: "G,H",
        cellIndex: 1,
      );
      await tester.changeFieldTypeOfFieldWithName(
        'Test',
        FieldType.MultiSelect,
      );

      tester.assertMultiSelectOption(contents: ['E', 'F'], rowIndex: 0);
      tester.assertMultiSelectOption(contents: ['G'], rowIndex: 1);
      tester.assertMultiSelectOption(contents: ['G', 'H'], rowIndex: 2);
    });

    testWidgets('date time transform', (tester) async {
      await tester.initializeAppFlowy();
      await tester.tapAnonymousSignInButton();

      await tester.createNewPageWithNameUnderParent(layout: ViewLayoutPB.Grid);
      await tester.scrollToRight(find.byType(GridPage));

      // create a date field
      await tester.createField(FieldType.DateTime);

      // edit the first date cell
      await tester.tapCellInGrid(rowIndex: 0, fieldType: FieldType.DateTime);
      final now = DateTime.now();
      await tester.toggleIncludeTime();
      await tester.selectDay(content: now.day);

      await tester.dismissCellEditor();

      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.DateTime,
        content: DateFormat('MMM dd, y HH:mm').format(now),
      );

      await tester.changeFieldTypeOfFieldWithName(
        'Date',
        FieldType.RichText,
      );
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.RichText,
        content: DateFormat('MMM dd, y HH:mm').format(now),
        cellIndex: 1,
      );

      await tester.editCell(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        input: "Oct 5, 2024",
        cellIndex: 1,
      );
      tester.assertCellContent(
        rowIndex: 1,
        fieldType: FieldType.RichText,
        content: "Oct 5, 2024",
        cellIndex: 1,
      );

      await tester.changeFieldTypeOfFieldWithName(
        'Date',
        FieldType.DateTime,
      );
      tester.assertCellContent(
        rowIndex: 0,
        fieldType: FieldType.DateTime,
        content: DateFormat('MMM dd, y').format(now),
      );
      tester.assertCellContent(
        rowIndex: 1,
        fieldType: FieldType.DateTime,
        content: "Oct 05, 2024",
      );
    });
  });
}