Custom json response in sequelize.js

Question

I using sequelize for getting json from mysql db. So I have two models Menu and Product further associations like:

Menu.js

  classMethods: {
    associate: function(models) {
      Menu.hasMany(models.Product, {foreignKey: 'menu_id'})
    }
  }

Product.js

  classMethods: {
    associate: function(models) {
      Product.belongsTo(models.Menu, {foreignKey: 'menu_id'})
    }
  },
  // IF I ADD BELOW CODE I HAVE ERROR: Possibly unhandled ReferenceError: menu is not defined
  instanceMethods: {
     toJSON: function () {
       var values = this.get();
       if (this.Menu) {
         values.icon = menu.icon;
       }

       return values;
     }
   }

and

 Product.findAll({
      where: { /* id: */ },
      include: [
          { model: Menu }
      ]
  }).success(function(match) {
    res.json(match);
 });

Then I get:

{
  "id": 3,
  "menu_id": 1,
  "product_title": "whatever",
  "price": 22,
  "createdAt": "0000-00-00 00:00:00",
  "updatedAt": "0000-00-00 00:00:00",
  "Menu": {
    "id": 1,
    "menu_title": "whatever",
    "icon": "someurlforicon",
    "createdAt": "2014-12-29T00:00:00.000Z",
    "updatedAt": "2014-12-29T00:00:00.000Z"
  }
}

Is possible to just extend products array with icon from menu model ? LIKE:

{
  "id": 3,
  "menu_id": 1,
  "product_title": "whatever",
  "price": 22,
  "icon": "someurlforicon",
  "createdAt": "0000-00-00 00:00:00",
  "updatedAt": "0000-00-00 00:00:00",
}

Thanks for any help!

Jan Aagaard Meier · Accepted Answer · 2015-01-06 11:48:07Z

7

You could add a custom toJSON method to the Product model:

instanceMethods: {
  toJSON: function () {
    var values = this.get();

    if (this.Menu) {
      values.icon = this.Menu.icon;
    }

    return values;
  }
}

edited Jan 6, 2015 at 11:48

answered Jan 6, 2015 at 7:45

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Makromat Over a year ago

Hello Jan Thanks for answer! I trying to add your solution but I have error : Possibly unhandled ReferenceError: menu is not defined

Jan Aagaard Meier Over a year ago

Sorry, I was a bit too quick - of course you have to actually access this.Menu after checking if it is defined

Makromat Over a year ago

Thank you!!! Even next thing Can I remove menu child array somehow? Just have icon inside product array ?

Jan Aagaard Meier Over a year ago

delete values.Menu - This is just a plain javascript object we are working with :) developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

Dave Stein Over a year ago

This is outdated as of V4. You need to do Product.prototype.toJSON = function() {} docs.sequelizejs.com/manual/tutorial/upgrade-to-v4.html

Arthur Zhang · Accepted Answer · 2015-01-06 01:38:49Z

-1

The product and The menu is a many-to-one associations. So Product.find() can't return the product array. Because the product corresponding to a menu.

answered Jan 6, 2015 at 1:38

Arthur Zhang

1,5773 gold badges11 silver badges12 bronze badges

Collectives™ on Stack Overflow

Custom json response in sequelize.js

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related