javascript - How to sort data in multiple groups using Sequelize? -

javascript - How to sort data in multiple groups using Sequelize? -

i'm having problem want maintain much logic , computation on database server , know if possible table sorted in sub groups based on attribute illustration :

{ "category1" : [{object1},{object2}...], "category2" : [{object1},{object2}...], "category3" : [{object1},{object2}...] }

where category particular field table.

currently i'm using instead :

models.product.findall({ include: [ {model: models.productprice, as: 'prices', required: true, where: {price_active: true}}, {model: models.productcategory, as: 'category'}, {model: models.productstore, as: 'store'} ] }).then(function (products) { var productsbycategory = {}; for(var =0; i< products.length; i++){ if(productsbycategory[products[i].category.category_name]){ productsbycategory[products[i].category.category_name].push(products[i]); } else{ productsbycategory[products[i].category.category_name] = new array(products[i]); } } res.render('index', {title: 'some title', products: productsbycategory}); }); });

but i'm aware blocks thread time gets mapped. practice?

thanks alot

javascript mysql node.js sequelize.js