Vijayakanth Manoharan
1015e24e69
- Wrap getDashboardSnapshot in try/catch; return JSON 500 instead of crashing - Add prisma/seed.ts with realistic Feb + Mar 2026 data: biweekly $2,850 pay schedule, $2,430 rent, expenses across all 8 categories - Update Dockerfile and backup route for host Ollama runtime Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
88 lines
5.2 KiB
TypeScript
88 lines
5.2 KiB
TypeScript
import { PrismaClient } from '@prisma/client'
|
||
|
||
const prisma = new PrismaClient()
|
||
|
||
async function main() {
|
||
// Clear all data
|
||
await prisma.monthlyInsight.deleteMany()
|
||
await prisma.expense.deleteMany()
|
||
await prisma.paycheck.deleteMany()
|
||
await prisma.paySchedule.deleteMany()
|
||
|
||
// ── Pay schedule ────────────────────────────────────────────────
|
||
// Biweekly $2,850. Anchor on 2026-03-14 (last received paycheck).
|
||
// This projects 2026-03-28 as the upcoming payday this weekend.
|
||
await prisma.paySchedule.create({
|
||
data: {
|
||
amountCents: 285000,
|
||
anchorDate: '2026-03-14',
|
||
active: true,
|
||
},
|
||
})
|
||
|
||
// ── February 2026 paychecks ──────────────────────────────────────
|
||
// Biweekly back from 2026-03-14: Feb 14, Feb 28 (same cycle −2 periods, −1 period)
|
||
await prisma.paycheck.createMany({
|
||
data: [
|
||
{ payDate: '2026-02-14', amountCents: 285000 },
|
||
{ payDate: '2026-02-28', amountCents: 285000 },
|
||
],
|
||
})
|
||
|
||
// ── March 2026 paychecks ─────────────────────────────────────────
|
||
// March 14 received; March 28 is upcoming → covered by projected schedule
|
||
await prisma.paycheck.create({
|
||
data: { payDate: '2026-03-14', amountCents: 285000 },
|
||
})
|
||
|
||
// ── February 2026 expenses ───────────────────────────────────────
|
||
await prisma.expense.createMany({
|
||
data: [
|
||
{ date: '2026-02-02', title: 'Rent', amountCents: 243000, category: 'RENT' },
|
||
{ date: '2026-02-04', title: 'Grocery Run', amountCents: 11500, category: 'FOOD' },
|
||
{ date: '2026-02-07', title: 'Coffee & Snacks', amountCents: 3200, category: 'FOOD' },
|
||
{ date: '2026-02-09', title: 'Electric Bill', amountCents: 9200, category: 'BILLS' },
|
||
{ date: '2026-02-09', title: 'Internet', amountCents: 6500, category: 'BILLS' },
|
||
{ date: '2026-02-11', title: 'Gas Station', amountCents: 5500, category: 'TRANSPORT' },
|
||
{ date: '2026-02-13', title: 'Pharmacy', amountCents: 4200, category: 'HEALTH' },
|
||
{ date: '2026-02-15', title: 'Movie Tickets', amountCents: 2800, category: 'ENTERTAINMENT' },
|
||
{ date: '2026-02-17', title: 'Grocery Run', amountCents: 9800, category: 'FOOD' },
|
||
{ date: '2026-02-19', title: 'Gym Membership', amountCents: 5000, category: 'HEALTH' },
|
||
{ date: '2026-02-21', title: 'Dinner Out', amountCents: 6800, category: 'FOOD' },
|
||
{ date: '2026-02-22', title: 'New Jeans', amountCents: 12000, category: 'SHOPPING' },
|
||
{ date: '2026-02-24', title: 'Rideshare', amountCents: 2200, category: 'TRANSPORT' },
|
||
{ date: '2026-02-26', title: 'Phone Bill', amountCents: 6500, category: 'BILLS' },
|
||
{ date: '2026-02-28', title: 'Misc Supplies', amountCents: 1800, category: 'MISC' },
|
||
],
|
||
})
|
||
|
||
// ── March 2026 expenses (through March 23 — month is ongoing) ───
|
||
await prisma.expense.createMany({
|
||
data: [
|
||
{ date: '2026-03-02', title: 'Rent', amountCents: 243000, category: 'RENT' },
|
||
{ date: '2026-03-04', title: 'Grocery Run', amountCents: 10800, category: 'FOOD' },
|
||
{ date: '2026-03-06', title: 'Coffee & Snacks', amountCents: 2900, category: 'FOOD' },
|
||
{ date: '2026-03-08', title: 'Gas Station', amountCents: 6000, category: 'TRANSPORT' },
|
||
{ date: '2026-03-09', title: 'Electric Bill', amountCents: 8800, category: 'BILLS' },
|
||
{ date: '2026-03-11', title: 'Streaming Services', amountCents: 5500, category: 'BILLS' },
|
||
{ date: '2026-03-12', title: 'Lunch Out', amountCents: 4500, category: 'FOOD' },
|
||
{ date: '2026-03-14', title: 'Pharmacy', amountCents: 3500, category: 'HEALTH' },
|
||
{ date: '2026-03-16', title: 'Grocery Run', amountCents: 9500, category: 'FOOD' },
|
||
{ date: '2026-03-17', title: 'Cinema', amountCents: 3200, category: 'ENTERTAINMENT' },
|
||
{ date: '2026-03-19', title: 'Clothing Online', amountCents: 7500, category: 'SHOPPING' },
|
||
{ date: '2026-03-20', title: 'Phone Bill', amountCents: 6500, category: 'BILLS' },
|
||
{ date: '2026-03-21', title: 'Rideshare', amountCents: 1800, category: 'TRANSPORT' },
|
||
{ date: '2026-03-23', title: 'Dinner Out', amountCents: 5500, category: 'FOOD' },
|
||
],
|
||
})
|
||
|
||
console.log('✓ Cleared old data')
|
||
console.log('✓ Pay schedule: biweekly $2,850 (anchor 2026-03-14, next: 2026-03-28)')
|
||
console.log('✓ Paychecks: Feb 14, Feb 28, Mar 14 → Mar 28 projected')
|
||
console.log('✓ Expenses: Feb 2026 (15 items) + Mar 2026 (14 items, through Mar 23)')
|
||
}
|
||
|
||
main()
|
||
.catch(console.error)
|
||
.finally(() => prisma.$disconnect())
|