A local-first personal finance app
import { beforeEach, describe, expect, it, vi } from 'vitest';
import * as asyncStorage from '#platform/server/asyncStorage';
import * as aql from '#server/aql';
import * as db from '#server/db';
import { handlers } from '#server/main';
import { runHandler } from '#server/mutators';
import { Action } from '#server/rules/action';
import {
ensureFormulaPreferencesLoaded,
resetFormulaPreferencesCache,
} from './bootstrap';
import { loadUserPreferencesForFormulas } from './customFunctionsPreferences';
function executeFormula(formula: string) {
const action = new Action('set', 'notes', null, { formula });
const transaction = { notes: '' };
action.exec(transaction);
return transaction.notes;
}
describe('formula preference bootstrap', () => {
beforeEach(async () => {
// oxlint-disable-next-line typescript/no-explicit-any
await (global as any).emptyDatabase()();
vi.clearAllMocks();
resetFormulaPreferencesCache();
});
it('reloads cached user preferences after reset', async () => {
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5, 2)')).toBe('1,234.50');
await db.update('preferences', {
id: 'numberFormat',
value: 'dot-comma',
});
resetFormulaPreferencesCache();
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5, 2)')).toBe('1.234,50');
});
it('infers number separators from locale formatting', async () => {
const preferences = await loadUserPreferencesForFormulas({
selectedLocale: 'de-DE',
});
expect(preferences.numberFormat).toBe('dot-comma');
expect(preferences.decimalPlaces).toBe(2);
expect(preferences.thousandsSeparator).toBe('.');
expect(preferences.decimalSeparator).toBe(',');
});
it('loads hidden fraction preference for formula number formatting', async () => {
await db.update('preferences', {
id: 'hideFraction',
value: 'true',
});
const preferences = await loadUserPreferencesForFormulas();
expect(preferences.decimalPlaces).toBe(0);
});
it('loads formula preferences with one preferences query', async () => {
const aqlQuerySpy = vi.spyOn(aql, 'aqlQuery');
await loadUserPreferencesForFormulas();
expect(aqlQuerySpy).toHaveBeenCalledTimes(1);
});
it('reloads cached user preferences after relevant synced preferences change', async () => {
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5)')).toBe('1,234.50');
await runHandler(handlers['preferences/save'], {
id: 'numberFormat',
value: 'dot-comma',
});
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5)')).toBe('1.234,50');
});
it('reloads cached user preferences after hide fraction changes', async () => {
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5)')).toBe('1,234.50');
await runHandler(handlers['preferences/save'], {
id: 'hideFraction',
value: 'true',
});
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5)')).toBe('1,235');
});
it('keeps cached user preferences after unrelated synced preferences change', async () => {
await ensureFormulaPreferencesLoaded();
await db.update('preferences', {
id: 'numberFormat',
value: 'dot-comma',
});
await runHandler(handlers['preferences/save'], {
id: 'dateFormat',
value: 'dd/MM/yyyy',
});
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5, 2)')).toBe('1,234.50');
});
it('reloads cached user preferences after language changes', async () => {
await ensureFormulaPreferencesLoaded();
expect(executeFormula('=FORMATNUMBER(1234.5, 2)')).toBe('1,234.50');
await runHandler(handlers['save-global-prefs'], {
language: 'de-DE',
});
vi.mocked(asyncStorage.getItem).mockResolvedValue('de-DE');
await ensureFormulaPreferencesLoaded();
expect(vi.mocked(asyncStorage.setItem)).toHaveBeenCalledWith(
'language',
'de-DE',
);
expect(executeFormula('=FORMATNUMBER(1234.5, 2)')).toBe('1.234,50');
});
});