csv-database

import csvdb, { CsvDatabase } from 'csv-database'; import path from 'path'; import fs from 'fs/promises'; interface User { id: number; name: string; mail: string; } async function main() { const filename = path.join(__dirname, 'users.csv'); // Ensure the file exists (or is created) and cleanup for demo try { await fs.unlink(filename); } catch (e) { /* ignore */ } const db: CsvDatabase<User> = await csvdb<User>(filename, ['id', 'name', 'mail']); console.log('Database initialized.'); // Add data await db.add([{ id: 1, name: 'johndoe', mail: 'john@example.com' }]); await db.add({ id: 2, name: 'janedoe', mail: 'jane@example.com' }); console.log('Added two users.'); // Get all data const allUsers = await db.get(); console.log('All users:', allUsers); // Get data with predicate const john = await db.get({ name: 'johndoe' }); console.log('John Doe:', john); // Edit data await db.edit({ name: 'johndoe' }, { mail: 'john.doe@newmail.com' }); const updatedJohn = await db.get({ id: 1 }); console.log('Updated John:', updatedJohn); // Delete data await db.delete({ id: 2 }); const remainingUsers = await db.get(); console.log('Remaining users after delete:', remainingUsers); // Clean up the created file await fs.unlink(filename); console.log('Cleaned up users.csv'); } main().catch(console.error);