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 - 使用遗留表
使用实例
(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'))
})();