Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

2.9 KB
Raw Blame
import { err } from 'neverthrow';
import { describe, expect, it } from 'vitest';
import {
  databaseCsvMessage,
  encodeDatabaseCsv,
  exportedValue,
  parseDatabaseCsv,
} from './csv';

describe('database CSV files', () => {
  it('preserves quoted values, mentions, leading zeroes and wide integer identifiers', () => {
    expect(
      parseDatabaseCsv(
        'Name,Notes,Id\r\n"Doe, Jo","Say hi to @bob\nHe said ""hi""",00123\r\nOther,,9007199254740993'
      )._unsafeUnwrap()
    ).toEqual({
      columns: ['Name', 'Notes', 'Id'],
      rows: [
        ['Doe, Jo', 'Say hi to @bob\nHe said "hi"', '00123'],
        ['Other', '', '9007199254740993'],
      ],
    });
  });
  it('keeps duplicate and blank header values in distinct columns', () => {
    expect(
      parseDatabaseCsv('Name,name,,Name 2\na,b,c,d')._unsafeUnwrap().columns
    ).toEqual(['Name', 'name 2', 'Column 3', 'Name 2 2']);
  });
  it('rejects extra cells and broken quotes instead of dropping data', () => {
    expect(parseDatabaseCsv('Name\na,b')).toEqual(
      err({ kind: 'long-row', row: 2 })
    );
    const broken = parseDatabaseCsv('Name\n"oops')._unsafeUnwrapErr();
    expect(broken).toMatchObject({ kind: 'malformed', row: 2 });
    expect(databaseCsvMessage(broken)).toMatch(/^CSV row 2: .*unterminated/i);
  });
  it('pads missing cells and allows a header-only empty table', () => {
    expect(parseDatabaseCsv('Name,Notes\na')._unsafeUnwrap().rows).toEqual([
      ['a', ''],
    ]);
    expect(parseDatabaseCsv('Name,Notes\n')._unsafeUnwrap().rows).toEqual([]);
  });
  it('refuses a CSV without a header', () => {
    expect(parseDatabaseCsv(',\na,b')).toEqual(err({ kind: 'no-header' }));
    expect(databaseCsvMessage({ kind: 'no-header' })).toBe(
      'The CSV needs a header row.'
    );
  });
  it('quotes CSV and prevents text from becoming a spreadsheet formula', () => {
    expect(
      encodeDatabaseCsv(
        ['Name', 'Amount'],
        [
          ['=SUM(A1)', -12],
          ['Doe, Jo', null],
        ]
      )
    ).toBe('Name,Amount\n"\'=SUM(A1)",-12\n"Doe, Jo",');
  });

  it('exports a date range as the interval a range cell imports from', () => {
    expect(
      exportedValue(
        {
          id: 'trip',
          name: 'Trip',
          dataType: 'DATE_RANGE',
          isMultiSelect: false,
          options: [],
          writable: true,
        },
        '2026-03-01T00:00:00.000Z/2026-03-05T00:00:00.000Z'
      )
    ).toBe('2026-03-01T00:00:00.000Z/2026-03-05T00:00:00.000Z');
  });

  it('names the import limits the service holds a CSV to', () => {
    expect(databaseCsvMessage({ kind: 'too-large' })).toBe(
      'Choose a CSV smaller than 16 MB.'
    );
    expect(databaseCsvMessage({ kind: 'too-many-rows' })).toBe(
      'A CSV can contain up to 10,000 rows.'
    );
    expect(databaseCsvMessage({ kind: 'too-many-columns' })).toBe(
      'A CSV can contain up to 100 columns.'
    );
  });
});