associations.ejs
1.73 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
With Sequelize you can also specify associations between multiple classes. Doing so will help you to easily
access and set those associated objects. The library therefore provides for each defined class the method
the following methods:
<pre><%- koala(".js", partial("code/associations/associations-1.ejs")) %></pre>
Because Sequelize is doing a lot of magic, you have to call Sequelize#sync after setting the associations!
Doing so will allow you the following:
<pre><%- koala(".js", partial("code/associations/associations-2.ejs")) %></pre>
To remove created associations you can just call the set method without a specific id:
<pre><%- koala(".js", partial("code/associations/associations-3.ejs")) %></pre>
You can also do it vice versa:
<pre><%- koala(".js", partial("code/associations/associations-4.ejs")) %></pre>
For hasOne its basically the same:
<pre><%- koala(".js", partial("code/associations/associations-5.ejs")) %></pre>
In order to specify many-to-many associations you can use the following syntax:
<pre><%- koala(".js", partial("code/associations/associations-6.ejs")) %></pre>
This will create a table, named according to the specified association names (= MembersProjects),
which just stores the id of a project and a member. Don't forget to call the sync method of the sequelize
instance.<br><br>
Since v0.4.1 all association tables and association keys are named as the passed association names:
<pre><%- koala(".js", partial("code/associations/associations-7.ejs")) %></pre>
Sequelize v0.4.2 introduced a new possibility to load the associated objects from the database.
The relevant method is called <i>fetchAssociations</i> and returns a hash:
<pre><%- koala(".js", partial("code/associations/associations-8.ejs")) %></pre>