Build a solid foundation for your AI cooking assistant with a modular Express + TypeScript app. Learn route modules, a clean config, and Prisma models for recipes, ingredients, and reviews. Set up SQLite, add CLI tools for DB management, and create a clean, scalable, production-ready backend.
Overview
Syllabus
- Unit 1: Getting Started with the Cooking App
- Create Your First Express App Using the Factory Pattern
- Instantiate PrismaClient in db.ts
- Connect Express App to Prisma Database
- Verify Prisma Database Connection on Server Startup
- Mount the Routes Router to the Express Application
- Unit 2: Designing Database Models
- Implement Ingredient Model
- Add Recipe Model to Prisma Schema
- Implement Many-to-Many Relationship Between Recipe and Ingredient Models
- Create Review Model and One-to-Many Relationship with Recipes
- Unit 3: Resetting Your Database
- Complete the Reset Database Script
- Add Confirmation Prompt to Reset Database Script
- Fix Deletion Order in Reset Database Script
- Finalize Prisma Database Reset Script with Proper Disconnect
- Implement Robust Error Handling and Resource Cleanup in Reset Script
- Unit 4: Manual Recipe Entry
- Correct Import Path in add_manual_recipe Script
- Prompt and Validate Recipe Name
- Implement promptIngredients Function
- Implement promptSteps Function to Gather Recipe Steps
- Persist Recipes and Ingredients to Database