Excel File Database Setup

[riddhisahni]

Excel File Database Setup & Upload Integration

Branch: 06/excel-file-database-setup

Overview

As part of this sprint, we will update the PostgreSQL database to support three new Excel files provided by Food for Free staff. This work ensures that the database schema aligns with the latest reporting formats and that uploaded files correctly persist data to the database.

Files

All Inventory Transactions by Date-2026-01-07.xlsx
Product Package Destination-2026-01-07.xlsx
Packages by Item-2026-01-07.xlsx

Tasks

1. Database Schema

• Add three new Prisma models in food-for-free/prisma/schema.prisma.
• Each model must include all columns present in its corresponding Excel file.
• Use appropriate data types to reflect the Excel data accurately.

prisma commands:

npx prisma format
npx prisma migrate dev --name add_excel_file_models
npx prisma generate
npx prisma studio

2. Data Ingestion (Sample Data Only)

• Extract and upload a small subset of rows from each Excel file for testing purposes.
• Full data ingestion is out of scope for this sprint; the focus is on validating schema correctness and upload functionality.

3. File Upload Integration

• Use the existing upload button component to create three separate upload buttons, one for each Excel file.
• Place the upload buttons on the Sticker Sheet tab.
• Ensure that uploading a file results in data being parsed and inserted into the correct PostgreSQL table.

4. Verification

• Verify that uploaded data is correctly persisted in the database.
• Confirm data visibility via Neon:
  • https://console.neon.tech/app/projects/cool-dream-25122434/branches/br-twilight-moon-a4xro28f/tables?database=neondb
• Use the Neon login credentials available in Notion.

Deliverables

• Three Prisma models reflecting the schemas of the provided Excel files.
• Functional upload flows for each file type.
• Successful data persistence verified in PostgreSQL (via Neon).
• Upload buttons accessible from the Sticker Sheet tab.