// Simple verification script for the database
import {
queryTransactions,
getSpendingByCategory,
getSpendingByDepartment,
compareToBudget,
getTopVendors
} from '../dist/services/database.js';
async function verifySetup() {
console.log('=== Verifying Financial MCP Setup ===\n');
try {
// Test 1: Query all transactions to verify loading
console.log('1. Checking Data Loading...');
const allTransactions = await queryTransactions({});
console.log(` Found ${allTransactions.length} transactions`);
if (allTransactions.length === 0) {
console.error(' ❌ ERROR: No transactions found! Check data/transactions.csv');
process.exit(1);
}
console.log(' ✅ Data Loaded successfully');
// Test 2: Category Analysis
console.log('\n2. Testing Analytics (Category Spending)...');
const categorySpending = await getSpendingByCategory();
if (categorySpending.length > 0) {
console.log(` ✅ Analytics working: Found ${categorySpending.length} categories`);
} else {
console.warn(' ⚠️ Warning: No category data found');
}
console.log('\n=== ✅ Setup Verified Successfully ===');
console.log('You are ready to deploy!');
} catch (error) {
console.error('\n❌ Verification Failed:', error);
process.exit(1);
}
}
verifySetup().catch(console.error);
