select from MySql db from sails in native query

Question

i want to get result: group + count of messages which belong to the current group for example:

webdevelopment - 34 messages

How can I achieve the same result without performing _.each

how i can to get the result one Query I used MySql, my code something like this

 Group.find().exec(function (err, groups) {
        if (err)
            return next(err);
        _.each(groups, function (grouper) {
            Messages.count({
                groupId : grouper.groupId,
            }).exec(function (err, found) {
                console.log(grouper.groupName + ' - ' + found + ' messages.');

            });
        });
    });

my module somethink like this

module messages

module.exports = {
  attributes: {
    id:{
         type: 'integer',
         primaryKey: true,
         autoIncrement: true
      },
    groupId:{
        type:'int'
    }
  }
};

module Group

module.exports = {
  attributes: {
  id:{
     type: 'integer',
     primaryKey: true,
     autoIncrement: true
  },
  groupName:{
    type:'string'
  }

  }
};

myusuf · Accepted Answer · 2014-12-20 10:25:33Z

2

You need to write the SQL query that gives the desired result. Lets say the query is:

var myQuery = "Select ... from ...";

Now you can execute the query using query method of the Model like so:

Group.query(myQuery, function(err, res) {
  /* use res.rows to get the result */
});

It does not matter which model you use when using query method.

answered Dec 20, 2014 at 10:25

myusuf

12.3k12 gold badges39 silver badges50 bronze badges

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

Comments

TheLebDev · Accepted Answer · 2019-08-02 08:32:10Z

1

As of Sails v1, Model.query has been deprecated, instead use sails.sendNativeQuery(queryString, paramArray)

answered Aug 2, 2019 at 8:32

TheLebDev

5511 gold badge8 silver badges19 bronze badges

Collectives™ on Stack Overflow

select from MySql db from sails in native query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related