ORM concept (Sequelize, Prisma overview) in Node.js - Mini Project: Build & Apply

Basic ORM Concept with Sequelize in Node.js

📖 Scenario: You are building a simple Node.js app to manage a list of books in a library. Instead of writing raw database queries, you will use an ORM (Object-Relational Mapping) tool called Sequelize to interact with the database easily.This project will help you understand how to set up data models and perform basic operations using Sequelize, a popular ORM for Node.js.

🎯 Goal: Create a Sequelize model for books, configure a connection, and write code to add and list books using ORM methods.

📋 What You'll Learn

Create a Sequelize model called Book with fields title (string) and author (string).

Set up a Sequelize connection to an SQLite database.

Write code to add a new book record using the Book.create() method.

Write code to retrieve all books using the Book.findAll() method.

💡 Why This Matters

🌍 Real World

ORMs like Sequelize are used in many Node.js applications to simplify database interactions by mapping database tables to JavaScript objects.

💼 Career

Understanding ORM concepts is essential for backend developers working with databases, improving productivity and code maintainability.

1

DATA SETUP: Import Sequelize and create a Sequelize instance

Write code to import Sequelize from the sequelize package and create a new Sequelize instance called sequelize that connects to an SQLite database named library.db.

Node.js

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

// Your code here

Need a hint?

Use new Sequelize({ dialect: 'sqlite', storage: 'library.db' }) to create the connection.

2

CONFIGURATION: Define the Book model with title and author fields

Using the sequelize instance, define a model called Book with two string fields: title and author. Assign this model to a constant named Book.

Node.js

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

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'library.db'
});

// Define the Book model below
// Your code here

Need a hint?

Use sequelize.define('Book', { title: { type: Sequelize.STRING }, author: { type: Sequelize.STRING } }).

3

CORE LOGIC: Add a new book record using Book.create()

Write code to add a new book with title set to 'The Great Gatsby' and author set to 'F. Scott Fitzgerald' using the Book.create() method. Assign the result to a constant named newBook.

Node.js

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

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'library.db'
});

const Book = sequelize.define('Book', {
  title: {
    type: Sequelize.STRING
  },
  author: {
    type: Sequelize.STRING
  }
});

// Add a new book record below
// Your code here

Need a hint?

Use Book.create({ title: 'The Great Gatsby', author: 'F. Scott Fitzgerald' }) and assign it to newBook.

4

COMPLETION: Retrieve all books using Book.findAll()

Write code to retrieve all book records using Book.findAll() and assign the result to a constant named allBooks.

Node.js

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

const sequelize = new Sequelize({
  dialect: 'sqlite',
  storage: 'library.db'
});

const Book = sequelize.define('Book', {
  title: {
    type: Sequelize.STRING
  },
  author: {
    type: Sequelize.STRING
  }
});

const newBook = Book.create({
  title: 'The Great Gatsby',
  author: 'F. Scott Fitzgerald'
});

// Retrieve all books below
// Your code here

Need a hint?

Use Book.findAll() and assign it to allBooks.