Sequelize Docs 中文文档 v4

Sequelize Docs 中文文档 v4

写在前面

Sequelize 是一个基于 promise 的 Node.js ORM, 目前支持 Postgres, MySQL, SQLite 和 Microsoft SQL Server. 它具有强大的事务支持, 关联关系, 读取和复制等功能.

• Getting started - 入门
• Model definition - 模型定义
• Model usage - 模型使用
• Querying - 查询
• Instances - 实例
• Associations - 关联
• Transactions - 事务
• Scopes - 作用域
• Hooks - 钩子
• Raw queries - 原始查询
• Migrations - 迁移
• Upgrade to V4 - 升级到 V4
• Working with legacy tables - 使用遗留表

使用实例

Basic usage - 基本用法

(async function () {

    const Sequelize = require('sequelize');

    const sequelize = new Sequelize('http_runner', 'root', '123456', {

        host: '127.0.0.1',

        port: 3306,

        dialect: 'mysql',

        timezone: '+08:00'

    })

    sequelize.authenticate().then(() => {

        console.log('连接成功')

    }).catch(err => {

        console.log('连接失败')

    });

    const User = sequelize.define('user', {

        username: Sequelize.STRING,

        birthday: Sequelize.DATE

    });

    await User.create({

        username: 'janedoe',

        birthday: new Date(1980, 6, 20)

    })

    let user = await User.findAll()

    console.log(user.get('firstName'))

})();