docs.sequelizejs.comSequelize | Feature-rich ORM for modern TypeScript & JavaScript

Sequelize | Feature-rich ORM for modern TypeScript & JavaScript Sequelize v6 - stable v7 - alpha v6 - stable v5 v4 v3 v2 v1 API References Sequelize 7 Sequelize 6 Sequelize 5 Sequelize 4 Sequelize 3 Sequelize 2 Slack GitHub Security Search Sequelize Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more. Getting Started API Reference Upgrade to v6 Support us Install dependencies npm install sequelize sqlite3 # or yarn add sequelize sqlite3 Getting Started Define models import { Sequelize , DataTypes } from ’sequelize’ ; const sequelize = new Sequelize ( ’sqlite::memory:’ ) ; const User = sequelize . define ( ’User’ , { username : DataTypes . STRING , birthday : DataTypes . DATE , } ) ; Defining Models Persist and query const jane = await User . create ( { username : ’janedoe’ , birthday : new Date ( 1980 , 6 , 20 ) , } ) ; const users = await User . findAll ( ) ; Querying Models Data Modeling Define your models with ease and make optional use of automatic database synchronization. const Wishlist = sequelize . define ( "Wishlist" , { title : DataTypes . STRING , } ) ; const Wish = sequelize . define ( "Wish" , { title : DataTypes . STRING , quantity : DataTypes . NUMBER , } ) ; // Automatically create all tables await sequelize . sync ( ) ; Associations Define associations between models and let Sequelize handle the heavy lifting. Wish . belongsTo ( Wishlist ) ; Wishlist . hasMany ( Wish ) ; const wishlist = await Wishlist . findOne ( ) ; const wishes = await wishlist . getWishes ( ) ; const wish = await wishlist . createWish ( { title : ’Toys’ , quantity : 3 , } ) ; await wishlist . removeWish ( wish ) ; Soft deletion Mark data as deleted instead of removing it once and for all from the database. const User = sequelize . define ( "User" , { username : DataTypes . STRING } , { paranoid : true } , } ) ; const user = await User . findOne ( ) ; await user . destroy ( ) ; await User . findAll ( ) ; // non-deleted only await User . findAll ( { paranoid : false } ) ; // all Ready to get started with Sequelize? Transactions , migrations , strong typing , JSON querying , lifecycle events (hooks) , and more. Learn more about the many features Sequelize has to offer! Getting Started Docs Guides Version Policy Security Changelog Legal Community Stack Overflow Slack Twitter GitHub Support OpenCollective Copyright © 2024 Sequelize Contributors. Built with Docusaurus and powered by Netlify...