Voice-to-text dictation app with local (Nvidia Parakeet/Whisper) and cloud models (BYOK). Privacy-first and available cross-platform.
JavaScript aianthropiccross-platformgeminigroqlinuxmacosnvidiaopen-sourceopenaiparakeetspeech-to-texttranscribewhisperwindows
import { sql } from 'drizzle-orm';
import { createMemoryChatRepository } from './testDb';
describe('LocalChatRepository', () => {
let now: number;
beforeEach(() => {
now = 1_000;
// Each call advances the clock so ordering never depends on two writes landing in one ms.
jest.spyOn(Date, 'now').mockImplementation(() => (now += 10));
});
afterEach(() => {
jest.restoreAllMocks();
});
it('lists conversations newest first with the last message as preview', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
const b = repo.createConversation('B');
repo.appendMessage({ conversationId: a.id, role: 'user', text: 'hello there' });
const list = repo.listConversations();
expect(list.map((conversation) => conversation.id)).toEqual([a.id, b.id]);
expect(list[0].preview).toBe('hello there');
expect(list[1].preview).toBe('');
});
it('shows a markdown answer as plain text in the preview', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
repo.appendMessage({
conversationId: a.id,
role: 'assistant',
text: '## Summary\n**Decision:** moved to `March`.\n- See [the note](https://x.y)',
});
expect(repo.listConversations()[0].preview).toBe(
'Summary Decision: moved to March. See the note',
);
});
it('shows a table answer without its pipes and keeps text that only looks like markdown', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
const b = repo.createConversation('B');
repo.appendMessage({
conversationId: a.id,
role: 'assistant',
text: '| Plan | Price |\n|---|---|\n| Pro | 8 |\n> Billed ~~monthly~~ yearly\n1. Done',
});
repo.appendMessage({
conversationId: b.id,
role: 'assistant',
text: 'Edit __init__.py, 5 * 3 = 15, see https://x.y/a__b~~c and my_var',
});
const previews = repo.listConversations().map((conversation) => conversation.preview);
expect(previews).toEqual([
'Edit __init__.py, 5 * 3 = 15, see https://x.y/a__b~~c and my_var',
'Plan Price Pro 8 Billed monthly yearly Done',
]);
});
it('drops single-marker emphasis but keeps underscores and asterisks inside words', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
repo.appendMessage({
conversationId: a.id,
role: 'assistant',
text: 'The plan is *final* and _signed_, see snake_case and 2*3*4.',
});
expect(repo.listConversations()[0].preview).toBe(
'The plan is final and signed, see snake_case and 2*3*4.',
);
});
it('keeps messages in the order they were saved when the clock moves back', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
repo.appendMessage({ conversationId: a.id, role: 'user', text: 'question' });
now -= 60_000;
repo.appendMessage({ conversationId: a.id, role: 'assistant', text: 'answer' });
expect(repo.getMessages(a.id).map((message) => message.text)).toEqual(['question', 'answer']);
expect(repo.listConversations()[0].preview).toBe('answer');
});
it('cuts the preview to 120 characters and honors the limit', () => {
const { repo } = createMemoryChatRepository();
const a = repo.createConversation('A');
repo.createConversation('B');
repo.appendMessage({ conversationId: a.id, role: 'user', text: 'x'.repeat(300) });
const list = repo.listConversations(1);
expect(list).toHaveLength(1);
expect(list[0].preview).toHaveLength(120);
});
it('round-trips steps and sources', () => {
const { repo } = createMemoryChatRepository();
const conversation = repo.createConversation('Pricing');
const steps = [
{
id: 'search' as const,
status: 'done' as const,
label: 'Searched your notes',
detail: '2 notes match',
},
];
const sources = [{ noteId: 7, title: 'Pricing call' }];
const saved = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'Here you go',
steps,
sources,
});
expect(saved.steps).toEqual(steps);
expect(saved.sources).toEqual(sources);
expect(repo.getMessages(conversation.id)).toEqual([saved]);
});
it('bumps the conversation updatedAt when a message is appended', () => {
const { repo } = createMemoryChatRepository();
const conversation = repo.createConversation('A');
const message = repo.appendMessage({
conversationId: conversation.id,
role: 'user',
text: 'hi',
});
expect(repo.getConversation(conversation.id)?.updatedAt).toBe(message.createdAt);
});
it('reads malformed steps_json as an empty list', () => {
const { repo, db } = createMemoryChatRepository();
const conversation = repo.createConversation('A');
const message = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'hi',
steps: [{ id: 'read', status: 'done', label: 'Read a note' }],
});
db.run(
sql`UPDATE chat_messages SET steps_json = '{', sources_json = NULL WHERE id = ${message.id}`,
);
const [reloaded] = repo.getMessages(conversation.id);
expect(reloaded.steps).toEqual([]);
expect(reloaded.sources).toEqual([]);
});
it('flags an answer whose sources_json is corrupt or NULL', () => {
const { repo, db } = createMemoryChatRepository();
const conversation = repo.createConversation('A');
const question = repo.appendMessage({
conversationId: conversation.id,
role: 'user',
text: 'q',
});
const corrupt = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'a',
});
const missing = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'b',
});
const intact = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'c',
});
db.run(sql`UPDATE chat_messages SET sources_json = '{' WHERE id = ${corrupt.id}`);
db.run(
sql`UPDATE chat_messages SET sources_json = NULL WHERE id IN (${missing.id}, ${question.id})`,
);
const flags = repo
.getMessages(conversation.id)
.map((message) => [message.text, message.sourcesUnreadable === true]);
expect(flags).toEqual([
['q', false],
['a', true],
['b', true],
['c', false],
]);
expect(intact.sourcesUnreadable).toBeUndefined();
});
it('deleteConversation removes its messages', () => {
const { repo } = createMemoryChatRepository();
const doomed = repo.createConversation('Doomed');
const kept = repo.createConversation('Kept');
repo.appendMessage({ conversationId: doomed.id, role: 'user', text: 'bye' });
repo.appendMessage({ conversationId: kept.id, role: 'user', text: 'stay' });
repo.deleteConversation(doomed.id);
expect(repo.getMessages(doomed.id)).toEqual([]);
expect(repo.getConversation(doomed.id)).toBeNull();
expect(repo.getMessages(kept.id)).toHaveLength(1);
});
it('deleteMessage removes one message and returns the rest oldest first', () => {
const { repo } = createMemoryChatRepository();
const conversation = repo.createConversation('A');
const first = repo.appendMessage({
conversationId: conversation.id,
role: 'user',
text: 'one',
});
const second = repo.appendMessage({
conversationId: conversation.id,
role: 'assistant',
text: 'two',
});
const third = repo.appendMessage({
conversationId: conversation.id,
role: 'user',
text: 'three',
});
repo.deleteMessage(second.id);
expect(repo.getMessages(conversation.id).map((message) => message.id)).toEqual([
first.id,
third.id,
]);
});
it('clearAll empties both tables', () => {
const { repo } = createMemoryChatRepository();
const conversation = repo.createConversation('A');
repo.appendMessage({ conversationId: conversation.id, role: 'user', text: 'hi' });
repo.clearAll();
expect(repo.listConversations()).toEqual([]);
expect(repo.getMessages(conversation.id)).toEqual([]);
});
});