var models = require('../../config/sequelize');

models.device.findAll({
    attributes: [
        'type',
        [models.sequelize.fn('count', models.sequelize.col('deviceId')),'count']
    ],
    group: ["device.type"]

    }).then(function (result) {

        result.forEach( function(e){

            console.log( e.count ) ;

        })
     }).catch(function(err) {
         console.log( "test group :"+JSON.stringify(err.message)) ;
}); ;