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
1660
14
1417
52
1311
25
1261
29
1234
24
Demystifying JavaScript: What It Does and Why It Matters
Apr 09, 2025 am 12:07 AM
JavaScript is the cornerstone of modern web development, and its main functions include event-driven programming, dynamic content generation and asynchronous programming. 1) Event-driven programming allows web pages to change dynamically according to user operations. 2) Dynamic content generation allows page content to be adjusted according to conditions. 3) Asynchronous programming ensures that the user interface is not blocked. JavaScript is widely used in web interaction, single-page application and server-side development, greatly improving the flexibility of user experience and cross-platform development.
The Evolution of JavaScript: Current Trends and Future Prospects
Apr 10, 2025 am 09:33 AM
The latest trends in JavaScript include the rise of TypeScript, the popularity of modern frameworks and libraries, and the application of WebAssembly. Future prospects cover more powerful type systems, the development of server-side JavaScript, the expansion of artificial intelligence and machine learning, and the potential of IoT and edge computing.
JavaScript Engines: Comparing Implementations
Apr 13, 2025 am 12:05 AM
Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.
JavaScript: Exploring the Versatility of a Web Language
Apr 11, 2025 am 12:01 AM
JavaScript is the core language of modern web development and is widely used for its diversity and flexibility. 1) Front-end development: build dynamic web pages and single-page applications through DOM operations and modern frameworks (such as React, Vue.js, Angular). 2) Server-side development: Node.js uses a non-blocking I/O model to handle high concurrency and real-time applications. 3) Mobile and desktop application development: cross-platform development is realized through ReactNative and Electron to improve development efficiency.
How to Build a Multi-Tenant SaaS Application with Next.js (Frontend Integration)
Apr 11, 2025 am 08:22 AM
This article demonstrates frontend integration with a backend secured by Permit, building a functional EdTech SaaS application using Next.js. The frontend fetches user permissions to control UI visibility and ensures API requests adhere to role-base
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.
From C/C to JavaScript: How It All Works
Apr 14, 2025 am 12:05 AM
The shift from C/C to JavaScript requires adapting to dynamic typing, garbage collection and asynchronous programming. 1) C/C is a statically typed language that requires manual memory management, while JavaScript is dynamically typed and garbage collection is automatically processed. 2) C/C needs to be compiled into machine code, while JavaScript is an interpreted language. 3) JavaScript introduces concepts such as closures, prototype chains and Promise, which enhances flexibility and asynchronous programming capabilities.
Building a Multi-Tenant SaaS Application with Next.js (Backend Integration)
Apr 11, 2025 am 08:23 AM
I built a functional multi-tenant SaaS application (an EdTech app) with your everyday tech tool and you can do the same. First, what’s a multi-tenant SaaS application? Multi-tenant SaaS applications let you serve multiple customers from a sing
