CRUD operations with Sequelize in Express - Mini Project: Build & Apply

CRUD operations with Sequelize

📖 Scenario: You are building a simple Express API to manage a list of books in a library. Each book has a title and an author. You will use Sequelize to interact with a database and perform CRUD operations.

🎯 Goal: Create an Express app with Sequelize that can create, read, update, and delete books from the database.

📋 What You'll Learn

Create a Sequelize model for Book with title and author fields

Set up an Express app with Sequelize connection

Implement CRUD routes: POST /books, GET /books, PUT /books/:id, DELETE /books/:id

Use async/await and proper Sequelize methods for database operations

💡 Why This Matters

🌍 Real World

APIs like this are common in web apps to manage data records such as books, users, or products.

💼 Career

Understanding Sequelize CRUD operations is essential for backend developers working with Node.js and relational databases.

1

Set up Sequelize and define the Book model

Create a Sequelize instance called sequelize connected to an SQLite database in memory. Then define a model called Book with fields title and author, both of type Sequelize.STRING.

Express

const { Sequelize, DataTypes } = require('sequelize');

// Your code here

Need a hint?

Use new Sequelize('sqlite::memory:') to create the connection. Use sequelize.define to create the model with title and author as string fields.

2

Set up Express app and sync database

Create an Express app called app. Add a line to sync the Sequelize models with the database using sequelize.sync().

Express

const express = require('express');
const app = express();

// Your code here

Need a hint?

Import Express, create app with express(), and call sequelize.sync() to create tables. Use app.use(express.json()) to parse JSON bodies.

3

Create CRUD routes for books

Add four routes to app: POST /books to create a book using Book.create(), GET /books to get all books using Book.findAll(), PUT /books/:id to update a book by id using Book.update(), and DELETE /books/:id to delete a book by id using Book.destroy(). Use async functions and await for Sequelize calls.

Express

// Your code here

Need a hint?

Use app.post, app.get, app.put, and app.delete with async functions. Use Sequelize methods create, findAll, update, and destroy with await.

4

Start the Express server

Add code to start the Express server on port 3000 using app.listen(3000). Add a callback that logs 'Server is running on port 3000'.

Express

// Your code here

Need a hint?

Use app.listen(3000, () => { console.log('Server is running on port 3000') }) to start the server.