refer to the figure above, existing
//
permission:{
id:DataTypes.INTEGER,
type:DataTypes.STRING
}
///
Operate:{
id:DataTypes.INTEGER,
name:DataTypes.STRING
url:DataTypes.STRING
} how to write associate? for permission Can you dynamically associate different tables according to type?
and permission:Operate is one-to-one, but sometimes polymorphic. I think it would be better to build a correlation table. How do I build the table at 1:1?
sequelizejs establish a relationship through BelongsTo, BelongsToMany, HasMany, HasOne , and the associated query include is fine.
http://docs.sequelizejs.com/c.
Previous: Electron package exe wrong report that the version cannot be found
Next: Laravel-permission executes migrate report database creation error
as shown in the figure, every time I create data, it returns at a strange time adding this has no effect timezone: +08:00 ...
var data = [{ id:1 } ,{ id:2 } ,{ id:3 }] is similar to this structure. An element object in data corresponds to a record in a database table. then Sequelize how to do it all at once? ...
as shown in the figure, Table 1 is associated with Table 2. How to click submit and save the two tables together ...
2 tables select tb1.name as name, tb1.id as id, (select count (1) from tb2 where tb1.type = tb2.type) as count from tb1 how to implement the sequelize method, and how to get such a result is using include, and how to write where. ...
the environmental background of the problems and what methods you have tried now the project is a node service. For the two nodes, postgresql does read-write separation, and the master node does write operations. Due to the large amount of data, you n...
chat program, the user can grab the vest. If two users grab the vest at the same time, both users will grab the vest. How can the first user block the table when operating the table? how should I use transactions with logic like the following? rob_...
there is a table in the database. I read this table first. If there is anything that meets the conditions, I will directly return. If not, update a piece of data. Now, if two requests come in, neither of them will read the qualified data. The expected r...
problem description: there are two tables with one to many. The json data received from the front end already contains the records of the main table and the child table. How can create be recorded as the best solution? 2. Table structure such as: [...
model.Form.belongsToMany(model.Issue, { through: model.FormIssue,foreignKey: formId ,as: formIssue }); model.Issue.belongsToMany(model.Form, { through: model.FormIssue,foreignKey: issueId ,as: issueForm }); model.FormIssue: const FormIssue =...
the model, created by sequelize-cli modifies the foreign key associate hasMany and other relationships, how to Synchronize this foreign key relationship to the database? ...
class Models { async setModels(app){ const sequelize = require( sequelize ) const files = await this.readModels() global.Models = {} global.Models._Op = sequelize.Op app.context.Models = {} app.co...
background: const EventUser = sequelize.define( userEvents , { payStatus: Sequelize.STRING }) User.belongsToMany(Event, { through: EventUser}) Event.belongsToMany(User, { through: EventUser}) use: const event = await EventModel.getEvent...
sequelize query findone can return the first matched data then I want to get the last matched data. Is there a convenient way to or findAll to get all the data and then get the last ?...