A local-first personal finance app
import type * as db from '#server/db';
/** Collect formula strings from serialized or live rule actions. */
export function collectFormulasFromActions(
actions: Array<{ options?: { formula?: string } }>,
): string[] {
const out: string[] = [];
for (const action of actions) {
const f = action.options?.formula;
if (typeof f === 'string') {
out.push(f);
}
}
return out;
}
/** Decode escape sequences inside a double-quoted formula string literal. */
export function decodeBalanceOfQuotedLiteral(inner: string): string {
return inner.replace(/\\"/g, '"').replace(/\\\\/g, '\\');
}
/**
* Distinct decoded string literals from BALANCE_OF("…") calls in a formula.
*/
export function extractBalanceOfLiterals(formula: string): string[] {
const seen = new Set<string>();
const out: string[] = [];
const re = /BALANCE_OF\s*\(\s*"((?:[^"\\]|\\.)*)"\s*\)/gi;
let m: RegExpExecArray | null;
while ((m = re.exec(formula)) !== null) {
const decoded = decodeBalanceOfQuotedLiteral(m[1]);
if (!seen.has(decoded)) {
seen.add(decoded);
out.push(decoded);
}
}
return out;
}
/**
* Resolve account id: map key (id) first, else first exact name match.
*/
export function resolveAccountIdForBalanceOf(
literal: string,
accountsMap: Map<string, db.DbAccount>,
): string | null {
if (accountsMap.has(literal)) {
return literal;
}
for (const acc of accountsMap.values()) {
if (acc.name === literal) {
return acc.id;
}
}
return null;
}