Collecting workspace information# Restaurant Management API

A robust RESTful API built for restaurant order and table management. This system allows restaurant staff to manage tables, track orders, and process customer interactions efficiently.

🍽️ Features

• Product Management: Create, read, update, and delete menu items
• Table Management: Track available tables and their status
• Session Management: Open and close table sessions for customers
• Order Processing: Create and track orders with detailed information
• Order Summary: Calculate order totals and quantities per table session

🛠️ Technologies

• Node.js: JavaScript runtime
• Express: Web framework
• TypeScript: Type safety and enhanced developer experience
• Knex.js: SQL query builder
• SQLite: Lightweight database
• Zod: Robust schema validation

📋 API Endpoints

Products

• GET /products - List all products (with optional name filter)
• POST /products - Create a new product
• PUT /products/:id - Update an existing product
• DELETE /products/:id - Remove a product

Tables

• GET /tables - List all tables

Table Sessions

• POST /tables-sessions - Open a new table session
• GET /tables-sessions - List all table sessions
• PATCH /tables-sessions/:id - Close a table session

Orders

• POST /orders - Create a new order
• GET /orders/table-session/:table_session_id - Get all orders for a table session
• GET /orders/table-session/:table_session_id/total - Get order summary for a table session

🚀 Getting Started

Prerequisites

• Node.js (v14 or higher)
• npm or yarn

Installation

1. Clone the repository

   git clone https://github.com/batavoo/api-restaurant.git
   cd api-restaurant

2. Install dependencies

   npm install
   # or
   yarn

3. Run migrations to setup the database

   npm run knex migrate:latest

4. Seed the database with initial data

   npm run knex seed:run

5. Start the development server

   npm run dev

💾 Database Schema

The application uses SQLite with the following tables:

• products: Menu items with prices
• tables: Restaurant tables
• tables_sessions: Track when tables are opened and closed
• orders: Store orders with product information, quantity, and pricing

---

Developed by Gustavo Santos Arruda