Sequelize ORM Spiekbrief

Sequelize is een promise-gebaseerde Node.js ORM voor Postgres, MySQL, MariaDB, SQLite en SQL Server.

Verbinding & Modeldefinitie

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

const sequelize = new Sequelize('postgres://user:pass@localhost:5432/mydb');

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  email: {
    type: DataTypes.STRING,
    unique: true,
    validate: { isEmail: true }
  }
});

// Databaseschema synchroniseren
await sequelize.sync();

---

CRUD-bewerkingen

// Aanmaken (Create)
const user = await User.create({ name: 'Alice', email: '[email protected]' });

// Lezen (Read)
const users = await User.findAll({
  where: { name: 'Alice' },
  order: [['createdAt', 'DESC']],
  limit: 10
});

// Bijwerken (Update)
await User.update({ name: 'Bob' }, { where: { id: 1 } });

// Verwijderen (Delete)
await User.destroy({ where: { id: 1 } });

---

Modelassociaties

User.hasMany(Post);
Post.belongsTo(User);

// Eager loading met include
const userWithPosts = await User.findOne({
  where: { id: 1 },
  include: [Post]
});

---

Referenties

• Officiële Sequelize Documentatie