const mongoose = require('mongoose');
const bcrypt = require('bcrypt-nodejs');
const Schema = mongoose.Schema;

const UserSchema = new Schema({

    username: String,
    password:  String,
    email:  String,

});

module.exports = mongoose.model('users', UserSchema, 'users');

const mongoose = require('mongoose');
var mongoosePaginate = require('mongoose-paginate');
const Schema = mongoose.Schema;

const ProductSchema = new Schema({
    userid: {type:String, required: true},
    product_name: {type:String, required: true}
});
ProductSchema.plugin(mongoosePaginate);
module.exports = mongoose.model('products', ProductSchema, 'products');

exports.selectUsersProductsCount = function (req, res, next) {

  Product.aggregate([
    {"$group" : {_id:{userid:"$userid" }, count:{$sum:1} }   }
],
function(err, result) {
    if(err){ res.status(400).json({ success: false, message:'Error processing request '+ err }); }
        res.status(201).json({
          success: true,
          data: result
    });
    console.log(result);
})

}

[ { _id: { userid: '5ab655bbb94733156c438112' }, count: 3 },
  { _id: { userid: '5ab425c6f5bff145304092f7' }, count: 1 } ]

[ { _id: { userid: '5ab655bbb94733156c438112', username: 'Jon Alon' }, count: 3 },
  { _id: { userid: '5ab425c6f5bff145304092f7', username: 'Jonson Con' }, count: 1 } ]