建立关联时,哪些方法/mixins sequelize 添加到模型中?

2023-09-03前端开发问题
11

本文介绍了建立关联时,哪些方法/mixins sequelize 添加到模型中?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

在浏览

要了解此表的含义,请回想在该文档页面的开头,它说在下面的 API 参考中,将关联的名称添加到方法中".最令人困惑的部分是,何时应添加名称的单数版本以及何时应添加复数版本并不清楚.但是,尽管文档没有说明这一点,但我向您保证,您可以使用常识来猜测.如果您认为这两个版本都有意义(例如,对于 add),您会惊讶于实际上两个版本都可用.因此,从上表我们可以得出结论:

  • 添加到 Person 模型实例的方法:

    • addHypothesis()
    • addHypotheses()
    • countHypotheses()
    • createHypothesis()
    • getHypotheses()
    • hasHypothesis()
    • hasHypotheses()
    • removeHypothesis()
    • removeHypotheses()
    • setHypotheses()
  • 添加到假设模型实例的方法:

    • addPerson()
    • addPeople()
    • countPeople()
    • createPerson()
    • getPeople()
    • hasPerson()
    • hasPeople()
    • removePerson()
    • removePeople()
    • setPeople()

另一种毫无疑问地弄清楚这一点的方法是检查 Sequelize 源代码本身,即 这里,我们可以在这里找到:

this.accessors = {得到:得到"+复数,设置:'set' + 复数,addMultiple: 'add' + 复数,添加:'添加'+单数,创建:创建"+单数,删除:删除"+ 单数,removeMultiple: 'remove' + 复数,hasSingle: '有' + 单数,hasAll: '有' + 复数,计数:'计数'+复数};

注意:虽然看起来有悖常理,但实际上上述两种方法 addPerson()addPeople() 都使用相同的参数,可以是单个值或数组.换句话说,源代码中的addaddMultiple方法实际上是相同的,到底.这同样适用于 remove()removeMultiple(),以及 hasSingle()hasAll().

希望您现在可以理解 Sequelize 文档对这些表格的真正含义.

如果您喜欢直接查看源代码,类似于我上面显示的内容,这些是其他类型关联的相关行:

  • 属于:这里

    this.accessors = {得到:得到"+单数,设置:设置"+单数,创建:创建"+ 单数};

  • HasOne:这里

    this.accessors = {得到:得到"+单数,设置:设置"+单数,创建:创建"+ 单数};

  • HasMany:这里

    this.accessors = {得到:得到"+复数,设置:'set' + 复数,addMultiple: 'add' + 复数,添加:'添加'+单数,创建:创建"+单数,删除:删除"+ 单数,removeMultiple: 'remove' + 复数,hasSingle: '有' + 单数,hasAll: '有' + 复数,计数:'计数'+复数};

While going through the sequelize docs, more specifically the documentations about associations, I see that the guide casually shows the reader methods such as setTasks(), addTask(), setProject(), that seem to be automatically created by sequelize for all model instances with respect to the created associations.

I couldn't find detailed information on what methods are available, and whether they are created with the singular version or plural version (since there is both setTasks() and setProject(), for example), and what exactly are the parameters they expect, and such. The docs apparently just casually mention them inside the examples...

So, what methods/mixins sequelize adds to the models when an association is made? And what are the parameters and return values, i.e. what's the documentation for those methods? Or, at least, where can I find them?

解决方案

The documentation about associations you linked, although hosted in an address called docs.sequelize.js, isn't the real sequelize docs (as in fully covered docs with all details that a good documentation usually provides). That is more like a tutorial / guide for starters.

The real sequelize docs are found by clicking on the "Reference" link available in the side menu of the links you mentioned (and it took me quite a while to find that - it doesn't even look like a clickable thing IMO).

The parts you're interested here are these:

  • Sequelize docs for BelongsTo type of associations: here
  • Sequelize docs for BelongsToMany type of associations: here
  • Sequelize docs for HasMany type of associations: here
  • Sequelize docs for HasOne type of associations: here

Understanding the docs

Since the docs linked above can be very confusing, here is an explanation to assist you to understand the docs.

Let's assume, for example, that we have a belongs to many association between Person and Hypothesis. Note that their plural forms, People and Hypotheses, are automatically inferred by Sequelize. This magic is done under the hood by the awesome library called inflection - see How do plurals work in Sequelize? for more details.

// Assuming that the models Person, Hypothesis and Person_Hypothesis are already defined
Person.belongsToMany(Hypothesis, { through: Person_Hypothesis });
Hypothesis.belongsToMany(Person, { through: Person_Hypothesis });

And we want to use the Sequelize docs for BelongsToMany type of associations to learn what methods were automatically added to instances of the Person and Hypothesis models. There, we can find the following table:

To understand what this table means, recall that in the beginning of that page of the docs it says that "In the API reference below, add the name of the association to the method". The most confusing part of this is that it's not so clear when you should add the singular version of the name and when you should add the plural version. But although the docs do not make this clear, I assure you that you can just use common sense to guess. And if you think both versions could make sense (for example, for add), be surprised that actually both versions are available. Therefore, from the table above, we can conclude:

  • Methods added to instances of Person models:

    • addHypothesis()
    • addHypotheses()
    • countHypotheses()
    • createHypothesis()
    • getHypotheses()
    • hasHypothesis()
    • hasHypotheses()
    • removeHypothesis()
    • removeHypotheses()
    • setHypotheses()
  • Methods added to instances of Hypothesis models:

    • addPerson()
    • addPeople()
    • countPeople()
    • createPerson()
    • getPeople()
    • hasPerson()
    • hasPeople()
    • removePerson()
    • removePeople()
    • setPeople()

Another way to figure this out without room for doubt is by checking the Sequelize source code itself, namely here, where we can find:

this.accessors = {
    get: 'get' + plural,
    set: 'set' + plural,
    addMultiple: 'add' + plural,
    add: 'add' + singular,
    create: 'create' + singular,
    remove: 'remove' + singular,
    removeMultiple: 'remove' + plural,
    hasSingle: 'has' + singular,
    hasAll: 'has' + plural,
    count: 'count' + plural
};

Note: although it might seem counter-intuitive, in fact both methods addPerson() and addPeople() mentioned above work with the same parameters, which can be either a single value or an array. In other words, the methods add and addMultiple from the source code are actually the same, in the end. The same applies to remove() and removeMultiple(), and hasSingle() and hasAll().

Hopefully with this you can now understand what the Sequelize docs really mean with those tables.

If you prefer to check the source code directly, analogously to what I showed above, these are the relevant lines for the other kinds of associations:

  • BelongsTo: here

    this.accessors = {
        get: 'get' + singular,
        set: 'set' + singular,
        create: 'create' + singular
    };
    

  • HasOne: here

    this.accessors = {
        get: 'get' + singular,
        set: 'set' + singular,
        create: 'create' + singular
    };
    

  • HasMany: here

    this.accessors = {
        get: 'get' + plural,
        set: 'set' + plural,
        addMultiple: 'add' + plural,
        add: 'add' + singular,
        create: 'create' + singular,
        remove: 'remove' + singular,
        removeMultiple: 'remove' + plural,
        hasSingle: 'has' + singular,
        hasAll: 'has' + plural,
        count: 'count' + plural
    };
    

这篇关于建立关联时,哪些方法/mixins sequelize 添加到模型中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

The End

相关推荐

Fatal error: Call to a member function fetch_assoc() on a no
业务场景:使用update语句去更新数据库字段。 原因:update接收值不正确。原来代码: $query = "UPDATE student SET date = now() WHERE id = $id";$result = $mysqli-query($query2) or die($mysqli-error); // 问题出现了在这句 $data = $result-fetch_ass...
2024-12-13 前端开发问题
136

js删除数组中指定元素的5种方法
在JavaScript中,我们有多种方法可以删除数组中的指定元素。以下给出了5种常见的方法并提供了相应的代码示例: 1.使用splice()方法: let array = [0, 1, 2, 3, 4, 5];let index = array.indexOf(2);if (index -1) { array.splice(index, 1);}// array = [0,...
2024-11-22 前端开发问题
182

layui 实现实时刷新一个外部的div
主页面上显示了一个合计,在删除和增加的时候需要更改这个总套数的值: //html代码div class="layui-inline layui-show-xs-block" style="margin-left: 10px" id="sumDiv"spanSOP合计:/spanspan${totalNum}/spanspan套/span/div 于是在我们删除这个条数据后,...
2024-11-14 前端开发问题
156

layui 单选框、复选框、下拉菜单不显示问题如何解决?
1. 如果是ajax嵌套了 页面, 请确保 只有最外层的页面引入了layui.css 和 layui.js ,内层页面 切记不要再次引入 2. 具体代码如下 layui.use(['form', 'upload'], function(){ var form = layui.form; form.render(); // 加入这一句});...
2024-11-09 前端开发问题
313

layui tree树组件怎么自定义添加图标
经常用到layui的朋友都知道,layui tree默认是不能自定义图标的,那么我们要自定义的话要怎么操作呢? 首先用编辑器软件(修改时候用编辑器记得编码),打开layui.js。搜索: i class="layui-icon layui-icon-file" 改为如下代码: i class="'+ (i.icon || "l...
2024-10-26 前端开发问题
493

layui中表单会自动刷新的问题
layui中表单会自动刷新的问题,因为用到layui的表单,遇到了刷新的问题所以记录一下: script layui.use(['jquery','form','layer'], function(){ var $ = layui.jquery, layer=layui.layer, form = layui.form; form.on('submit(tijiao)', function(data){ a...
2024-10-23 前端开发问题
262