QUICKSTART.md

Quick Start Guide

✅ Backend is Ready!

Your complete Express.js backend with PostgreSQL is now running on http://localhost:4000

🚀 What's Been Done

1. ✅ Database Setup

   • Created 7 tables with proper relationships
   • Added indexes for performance
   • Seeded with sample data

2. ✅ API Endpoints Working

   • Parties API: /api/parties
   • Mirchi Types API: /api/mirchi-types
   • Lots API: /api/lots
   • Transactions API: /api/transactions

3. ✅ Sample Data Loaded

   • 5 Parties (Ramesh Traders, Suresh & Co, etc.)
   • 5 Mirchi Types (Teja, Byadgi, Guntur Sannam, etc.)
   • 3 Active Lots with stock
   • 1 Sample Transaction

🔧 Available Commands

cd backend

# Start server (currently running)
npm start

# Development mode with auto-reload
npm run dev

# Database management
npm run migrate  # Create tables
npm run seed     # Add sample data
npm run reset    # Drop all tables (⚠️ use with caution)

📡 Test the API

Health Check:

curl http://localhost:4000/health

Get All Parties:

curl http://localhost:4000/api/parties

Get All Mirchi Types:

curl http://localhost:4000/api/mirchi-types

Get All Transactions:

curl http://localhost:4000/api/transactions

🔗 Connect Frontend

Update your frontend's db.ts file:

• The API_BASE is already set to http://localhost:4000/api
• All endpoints are ready to use
• No changes needed in frontend code!

📊 Database Schema

Tables:

1. parties - Customer/supplier management
2. mirchi_types - Chili pepper varieties
3. lots - Inventory with stock tracking
4. transactions - Purchase/sales bills
5. transaction_items - Line items
6. expenses - Transaction expenses
7. payments - Payment records

🎯 Next Steps

1. Keep the backend server running
2. Start your frontend: cd frontend && npm run dev
3. Test the complete application!

💡 Features

• ✅ Full CRUD operations for all entities
• ✅ Automatic stock management (lots)
• ✅ Party balance tracking
• ✅ Payment tracking with multiple modes
• ✅ Support for returns (purchase/sales)
• ✅ Transaction filtering by party, type, etc.
• ✅ Proper error handling and validation

🐛 Troubleshooting

Server not starting?

• Check if port 4000 is available
• Verify PostgreSQL connection in .env

Database errors?

• Run npm run reset then npm run migrate and npm run seed

API not responding?

• Check server logs in terminal
• Verify server is running on port 4000