hasMany countAccessor

[czkody]

Hello,
is possible to add countAccessor to Many association?

Model

var db = config.db;
var Category = db.define('category', {
    //properties
    id : Number,
    name : String
},{
    //options
}); 
Category.hasMany("successors", {distance : Number}, Category, {reverse: 'predecessors', mergeTable: 'category_tree', mergeId: 'predecessor_id', mergeAssocId: 'successor_id'});

Controller

var Category = require('../models/Category');
exports.countSuccessors = function(req, res, next) {
    category_id = Number(req.params['category']);
    Category(category_id).countSuccessors({distance:1}, function (err, count) {     
        res.json(count);
    });

}

[dresende]

Yes, absolutely. But you might need to use the git version for a while when I implement it.

[dresende]

Wait.. (so many stuff I sometimes forget about features). Try this:

Controller

var Category = require('../models/Category');
exports.countSuccessors = function(req, res, next) {
    category_id = Number(req.params['category']);
    Category(category_id).getSuccessors({ distance: 1 }).count(function (err, count) {      
        res.json(count);
    });
}

Explanation: calling the hasMany.getAccessor without callback makes it return a ChainFind instance. Look here:

https://github.com/dresende/node-orm2/blob/master/lib/ChainFind.js#L31

[czkody]

Hi,
I have just tried , but your code produced this query:

SELECT COUNT(*) AS `c` FROM `category` WHERE (`distance` = 1)

Have last versions of orm and sql-query.

[dresende]

I have to look at this closer, it seems the chain is not taking care of the join option..

[dresende]

I think I solved it, please try the latest git.

[czkody]

Hi,
Yes, you made it. Works fine. Thank you so much.