Web Front-end
JS Tutorial
The difference between model and association in include when Sequelize connects and queries
The difference between model and association in include when Sequelize connects and queries
Preface
Everyone knows that when using Sequelize to perform connection queries between relational models (tables), we will use model/as to specify the connection query model that already has an existing relationship, or through association to directly specify the connection query model relationship. So, in what scenarios should each be used?
1. Example preparation
Model definition
First, define the two models User and Company:
'use strict'
const Sequelize = require('sequelize');
// 创建 sequelize 实例
const sequelize = new Sequelize('db1', 'root', '111111', {logging: console.log});
// 定义User模型
var User = sequelize.define('user', {
id:{type: Sequelize.BIGINT(11), autoIncrement:true, primaryKey : true, unique : true},
name: { type: Sequelize.STRING, comment:'姓名' },
sex: { type: Sequelize.INTEGER, allowNull: false, defaultValue: 0, comment:'性别' },
companyId: { type: Sequelize.BIGINT(11), field: 'company_id', allowNull: false, comment:'所属公司' },
isManager: { type: Sequelize.BOOLEAN, field: 'is_manager', allowNull: false, defaultValue: false, comment:'是否管理员'}
},
{ charset: 'utf8',
collate: 'utf8_general_ci'});
// 定义Company模型
var Company = sequelize.define('company', {
id:{ type:Sequelize.BIGINT(11), autoIncrement:true, primaryKey : true, unique : true},
name: { type: Sequelize.STRING, comment:'公司名称' }
},
{ charset: 'utf8',
collate: 'utf8_general_ci'});
// 定义User-Company关联关系
User.belongsTo(Company, {foreignKey:'companyId'});
// sequelize.sync({force:true}).then(() => {
// process.exit();
// });
As shown above, we defined two models, User and Company, and specified a 1:1 relationship between User and Company through belongsTo.
Insert data
Next, insert some test data based on the just-defined relationship model:
Company.create({name:'某公司'}).then((result) => {
return Promise.all([
User.create({name:'何民三', sex:1, companyId:result.id, isManager: true}),
User.create({name:'张老二', sex:1, companyId:result.id})
])
}).then((result) => {
console.log('done');
}).catch((err) => {
console.error(err);
}); 2. Use model /as
When performing connection query, if the association between models has been defined. You can specify the model to be connected to the query through the 'model' attribute in the include query option, and you can also specify an alias through the 'as' attribute.
For example, query a user from the User model and query the company information of the user:
var include = [{
model: Company,
as: 'company'
}];
User.findOne({include:include}).then((result) => {
console.log(result.name + ' 是 '+result.company.name+' 的员工');
}).catch((err) => {
console.error(err);
});The query results are as follows:
何民三 是 某公司 的员工
3. When using association
to connect the query, if there is no connection relationship defined in advance between the two models to be connected to the query, or To use a connection relationship outside the definition. At this time, model relationships can be defined or redefined through association.
For example, query any company in the Company model and query the administrator of the company:
var include = [{
association: Company.hasOne(User, {foreignKey:'companyId', as:'manager'}),
where: {isManager:true}
}]
Company.findOne({include:include}).then((result) => {
console.log(result.name +' 的管理员是 ' +result.manager.name);
}).catch((err) => {
console.error(err);
});Due to the relationship between Company-User The model relationship is not defined in advance, so you need to specify the association relationship to be used when connecting the query in the include option.
The query results are as follows:
某公司 的管理员是 何民三
In addition to being used to specify model relationships that have not been defined before, association can also be used to re-define models. relation. For example, suppose we define a 1:N relationship between Company-User through hasMany in advance. This relationship applies to all employees under the query company. In the above example, we need to check the company's administrator through a 1:1 relationship. Therefore, we can redefine the model relationship through association.
For more related articles on the difference between model and association in include during Sequelize connection query, please pay attention to the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1677
14
1429
52
1333
25
1278
29
1257
24
Python vs. JavaScript: The Learning Curve and Ease of Use
Apr 16, 2025 am 12:12 AM
Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.
JavaScript and the Web: Core Functionality and Use Cases
Apr 18, 2025 am 12:19 AM
The main uses of JavaScript in web development include client interaction, form verification and asynchronous communication. 1) Dynamic content update and user interaction through DOM operations; 2) Client verification is carried out before the user submits data to improve the user experience; 3) Refreshless communication with the server is achieved through AJAX technology.
JavaScript in Action: Real-World Examples and Projects
Apr 19, 2025 am 12:13 AM
JavaScript's application in the real world includes front-end and back-end development. 1) Display front-end applications by building a TODO list application, involving DOM operations and event processing. 2) Build RESTfulAPI through Node.js and Express to demonstrate back-end applications.
Understanding the JavaScript Engine: Implementation Details
Apr 17, 2025 am 12:05 AM
Understanding how JavaScript engine works internally is important to developers because it helps write more efficient code and understand performance bottlenecks and optimization strategies. 1) The engine's workflow includes three stages: parsing, compiling and execution; 2) During the execution process, the engine will perform dynamic optimization, such as inline cache and hidden classes; 3) Best practices include avoiding global variables, optimizing loops, using const and lets, and avoiding excessive use of closures.
Python vs. JavaScript: Development Environments and Tools
Apr 26, 2025 am 12:09 AM
Both Python and JavaScript's choices in development environments are important. 1) Python's development environment includes PyCharm, JupyterNotebook and Anaconda, which are suitable for data science and rapid prototyping. 2) The development environment of JavaScript includes Node.js, VSCode and Webpack, which are suitable for front-end and back-end development. Choosing the right tools according to project needs can improve development efficiency and project success rate.
The Role of C/C in JavaScript Interpreters and Compilers
Apr 20, 2025 am 12:01 AM
C and C play a vital role in the JavaScript engine, mainly used to implement interpreters and JIT compilers. 1) C is used to parse JavaScript source code and generate an abstract syntax tree. 2) C is responsible for generating and executing bytecode. 3) C implements the JIT compiler, optimizes and compiles hot-spot code at runtime, and significantly improves the execution efficiency of JavaScript.
Python vs. JavaScript: Use Cases and Applications Compared
Apr 21, 2025 am 12:01 AM
Python is more suitable for data science and automation, while JavaScript is more suitable for front-end and full-stack development. 1. Python performs well in data science and machine learning, using libraries such as NumPy and Pandas for data processing and modeling. 2. Python is concise and efficient in automation and scripting. 3. JavaScript is indispensable in front-end development and is used to build dynamic web pages and single-page applications. 4. JavaScript plays a role in back-end development through Node.js and supports full-stack development.
From Websites to Apps: The Diverse Applications of JavaScript
Apr 22, 2025 am 12:02 AM
JavaScript is widely used in websites, mobile applications, desktop applications and server-side programming. 1) In website development, JavaScript operates DOM together with HTML and CSS to achieve dynamic effects and supports frameworks such as jQuery and React. 2) Through ReactNative and Ionic, JavaScript is used to develop cross-platform mobile applications. 3) The Electron framework enables JavaScript to build desktop applications. 4) Node.js allows JavaScript to run on the server side and supports high concurrent requests.
