bramw_baserow/web-frontend/test/unit/database/utils/row.spec.js

import {
  prepareRowForRequest,
  prepareNewOldAndUpdateRequestValues,
  extractRowReadOnlyValues,
} from '@baserow/modules/database/utils/row'
import { TestApp } from '@baserow/test/helpers/testApp'

describe('Row utilities', () => {
  let testApp = null
  let store = null

  beforeAll(() => {
    testApp = new TestApp()
    store = testApp.store
  })

  afterEach((done) => {
    testApp.afterEach().then(done)
  })

  describe('prepareRowForRequest', () => {
    const rowsToTest = [
      // Empty case
      {
        input: {
          row: {},
          fields: [],
        },
        output: {},
      },
      // Basic case of just a simple text field
      {
        input: {
          row: {
            field_1: 'value',
          },
          fields: [
            {
              name: 'field_1',
              id: 1,
              _: {
                type: {
                  type: 'text',
                },
              },
            },
          ],
        },
        output: {
          field_1: 'value',
        },
      },
      // Empty value is being used if no value is provided
      {
        input: {
          row: {
            field_1: 'value',
          },
          fields: [
            {
              name: 'field_1',
              id: 1,
              _: {
                type: {
                  type: 'text',
                },
              },
            },
            {
              name: 'field_2',
              id: 2,
              text_default: 'some default',
              _: {
                type: {
                  type: 'text',
                },
              },
            },
          ],
        },
        output: {
          field_1: 'value',
          field_2: 'some default',
        },
      },
      // Read only field
      {
        input: {
          row: {
            field_1: 'value',
          },
          fields: [
            {
              name: 'field_1',
              id: 1,
              _: {
                type: {
                  type: 'formula',
                },
              },
            },
          ],
        },
        output: {},
      },
      // Missing value
      {
        input: {
          row: {},
          fields: [
            {
              name: 'field_1',
              id: 1,
              text_default: 'some default',
              _: {
                type: {
                  type: 'text',
                },
              },
            },
          ],
        },
        output: {
          field_1: 'some default',
        },
      },
    ]

    test.each(rowsToTest)(
      'Test that %o is correctly prepared for request',
      ({ input, output }) => {
        expect(
          prepareRowForRequest(input.row, input.fields, store.$registry)
        ).toEqual(output)
      },
      200
    )
  })

  test('prepareNewOldAndUpdateRequestValues', () => {
    const row = {
      id: 1,
      field_1: { id: 2, value: 'Option 2', color: 'green' },
      field_2: '2024-01-04T15:15:59.163126Z',
      field_3: 'Text',
    }
    const allFields = [
      {
        id: 1,
        name: 'Single Select',
        type: 'single_select',
        select_options: [
          {
            id: 1,
            value: 'Option 1',
            color: 'blue',
          },
          {
            id: 2,
            value: 'Option 2',
            color: 'green',
          },
        ],
      },
      {
        id: 2,
        name: 'Last modified',
        type: 'last_modified',
        date_include_time: true,
      },
      {
        id: 3,
        name: 'Text',
        type: 'text',
      },
    ]
    const field = allFields[0]
    const value = { id: 1, value: 'Option 1', color: 'blue' }
    const oldValue = { id: 2, value: 'Option 2', color: 'green' }

    const { newRowValues, oldRowValues, updateRequestValues } =
      prepareNewOldAndUpdateRequestValues(
        row,
        allFields,
        field,
        value,
        oldValue,
        store.$registry
      )

    expect(newRowValues.field_2).not.toBe(oldRowValues.field_2)
    expect(newRowValues).toEqual({
      id: row.id,
      field_1: { id: 1, value: 'Option 1', color: 'blue' },
      field_2: newRowValues.field_2,
    })
    expect(oldRowValues).toEqual({
      id: row.id,
      field_1: { id: 2, value: 'Option 2', color: 'green' },
      field_2: '2024-01-04T15:15:59.163126Z',
    })
    expect(updateRequestValues).toEqual({
      field_1: 1,
    })
  })

  test('prepareNewOldAndUpdateRequestValues', () => {
    const row = {
      id: 1,
      field_2: '2024-01-04T15:15:59.163126Z',
      field_3: 'Text',
    }
    const allFields = [
      {
        id: 2,
        name: 'Last modified',
        type: 'last_modified',
        date_include_time: true,
      },
      {
        id: 3,
        name: 'Text',
        type: 'text',
      },
    ]

    const newRow = extractRowReadOnlyValues(row, allFields, store.$registry)

    expect(newRow).toEqual({
      id: 1,
      field_2: '2024-01-04T15:15:59.163126Z',
    })
  })
})