# N:M Relationships

## Objectives

* Create a join table and utilize it in a many-to-many relationship
* Use Sequelize's helper methods to add relationships between two different models.

## To Join the Many

When creating a many to many relationship, we need to have some way of creating that relationship. With a 1:M relationship, the id of the one is attached to the many (`pets.userId` in the 1:M relationship in our `userapp`). What do we do when there is no 1? When everything is many, we have to have some place to put the corrosponding ids.

Enter join tables! These tables have a one to many relationship with each of the relevant tables.

![An er diagram featuring a many to many relationship with students and classes and a join table called enrollments](https://fmhelp.filemaker.com/help/18/fmp/en/FMP_Help/images/relational.07.06.1.png)

Often, the naming convention is to have the join table have the names of both tables. For examples if you have products and orders, the join table will often be called `products_orders`.

## Sequelize models

We will be expanding our data model in `userapp` to include toys for our pets.

> **Very Important** Name - your models `singular`, but your join model will be plural.

```
sequelize model:create --name toy --attributes type:string,color:string

sequelize model:create --name petsToys --attributes petId:integer,toyId:integer
```

## Update your Associations

In order to associate pets to toys in a many to many fashion, you will need to update the associations on the pets and toys.

### pet.js

```javascript
 pet.associate = function(models) {
   // associations can be defined here
   models.pet.belongsTo(models.user);
   models.pet.belongsToMany(models.toy, {through: "petsToys"})
 };
```

### toys.js

```javascript
toys.associate = function(models) {
   models.toy.belongsToMany(models.pet, {through: "petsToys"})
 };
```

## Examples

### Add a unique toy to a pet.

In order to add a unique toy to a pet, we must first try to find or create a pet, in order to make sure it is in fact unique.

Secondly, we must attach a toy to the pet, using some built in helpers.

Some ORM has capabilities to do a bulk create on an object associations, but that kind of logic is not built in Sequelize.

```javascript
// First, get a reference to a pet.
db.pet.findOrCreate({
  where: {
    name: "Silly May",
    species: "Mini Aussie"
  }
}).then(function([pet, created]) {
  // Second, get a reference to a toy.
  db.toy.findOrCreate({
    where: {type: "stinky bear", color: "brown"}
  }).then(function([toy, created]) {
    // Finally, use the "addModel" method to attach one model to another model.
    pet.addToy(toy).then(function(relationInfo) {
      console.log(toy.type, "added to", pet.name);
    });
  });
});
```

Take some time to use these helper functions to add more toys and more pets!

### Get all pets that use a toy

Sequelize generates helper functions that allow you to get related items. For instance, if you wanted to find all pets that used a given toy:

```javascript
db.toy.findOne({
  where: {type: "ball"}
}).then(function(toy) {
  toy.getPets().then(function(pets) {
    console.log(pets.length, 'pet(s) love the', toy.color, toy.type)
  });
});
```

You can use the `addModel()` helper function to add a pet association on a toy if there are no pet associations yet.

```javascript
db.toy.findOrCreate({
  where: {type: "ball", color: "green"}
}).then(function([toy, created]) {
  toy.getPets().then(function(pets) {
    // Check if their are any pets associated with this toy
    if (pets.length > 0) {
      pets.forEach(function(pet) {
        console.log(pet.name, 'loves their', toy.color, toy.type);
      });
    } else {
      // findOrCreate a Pet and add it to the toy
      db.pet.findOrCreate({
        where: {
          name: "Ruby Tuesday",
          species: "Toy Aussie"
        }
      }).then(function([pet, created]) {
        toy.addPet(pet).then(function(relationInfo){
          console.log(pet.name, 'has faved the', toy.color, toy.type, 'toy')
        })
      });
    } // end of if statement
  });
});
```

Because this is a Many to Many association, all the logic from before can be turned around to search for all the toys of a particular pet!

```javascript
db.pet.findOne({
  where: {name: "Ruby Tuesday"}
}).then(function(pet) {
  pet.getToys().then(function(toys) {
    toys.forEach(function(toy) {
      console.log(pet.name, 'loves their', toy.color, toy.type);
    });
  });
});
```

> NOTE: In the above code, if Ruby Tuesday doesn't have any toys, that `forEach` function will crash the nodemon server! Make sure you have error handling so your whole app doesn't shut down because one pet isn't materialistic!

### Get all the data!

Since we have a 1:M relationship between users and pets as well as a N:M relationship between pets and toys, we can get all our info through the Pet model. One of the easier ways of doing this is through the `include` keyword:

```javascript
db.pet.findOne({
  where: {
    name: "Silly May"
  },
  include: [db.user, db.toy]
}).then(function(pet) {
  pet.toys.forEach(function(toy) {
    console.log(pet.user.firstName + '\'s pet', pet.name, 'loves their', toy.color, toy.type)
  })
})
```

Or we can use a mix of `include` and helper functions to get all the toys of all the pets of a certain user!

```javascript
db.user.findByPk(1, { include: [db.pet] })
.then(function(user) {
  user.pets.forEach(function(pet) {
    pet.getToys().then(function(toys) {
      toys.forEach(function(toy) {
        console.log(user.firstName + '\'s pet', pet.name, 'loves their', toy.color, toy.type)
      })
    })
  })
})
```

As you can see, there are MANY (to) MANY ways to get associated data when it is needed. It's also easy to see how easy it can be to get lost in nesting hell. One way to help keep things clean is to comment the end of each section. If we take the last block of code as an example:

```javascript
db.user.findByPk(1, { include: [db.pet] })
.then(function(user) {
  user.pets.forEach(function(pet) {
    pet.getToys().then(function(toys) {
      toys.forEach(function(toy) {
        console.log(user.firstName + '\'s pet', pet.name, 'loves their', toy.color, toy.type)
      }) // toys.forEach end
    }) // getToys end
  }) // pets.forEach end
}) // user.findByPk end
```