mongoose adapter: cannot specify sort direction

[TinNT]

MongooseAdapter.prototype.all = function all(model, filter, callback) {
   ...
    if (filter.order) {
        query.asc(filter.order); //direction is hardcoded
    }
    ...
};

is there an easy way to patch this issue and define findOne method?

Thanks

[1602]

Yep, just need to extend order feature to work with direction option.

Thanks,
Anatoliy

On 28.02.2012, at 10:25, TinNTreply@reply.github.com wrote:

MongooseAdapter.prototype.all = function all(model, filter, callback) {
  ...
   if (filter.order) {
       query.asc(filter.order); //direction is hardcoded
   }
   ...
};

is there an easy way to patch this issue and define findOne method?

Thanks

---

Reply to this email directly or view it on GitHub:
#38

[1602]

Maybe this is undocumented mongoose feature, but for my test it works as expected when I specify sort direction:

User.all({order: 'email DESC'}, console.log);

Let me know if you have any problems with mongoose adapter. I've only fixed redis adapter to hook this feature, all others working just fine.

[TinNT]

Thanks for your reply, I tried to install latest release of mongoose and jugglingdb, but it didn't help, the issue is still there, here is the details

➜  node_modules  npm install mongoose
mongoose@2.5.9 ./mongoose 
├── hooks@0.1.9
└── mongodb@0.9.7-3-5
➜  node_modules  npm install jugglingdb
jugglingdb@0.1.1 ./jugglingdb 
└── hashish@0.0.4


------------

User.all({order: 'email DESC'}, function(err, users){
   users.forEach(function(user){
     console.log(user.email);
   })
});

john@hcompany.com
tom@hcompany.com
admin@hcompany.com
tin@hcompany.com
mike@hcompany.com
susan@hcompany.com
test@hcompany.com

note: order by email DESC did not work
---------------

User.all({order: 'email'}, function(err, users){
   users.forEach(function(user){
     console.log(user.email);
   })
});

admin@hcompany.com
john@hcompany.com
mike@hcompany.com
susan@hcompany.com
test@hcompany.com
tin@hcompany.com
tom@hcompany.com

Thanks again.

[1602]

Both features implemented now: findOne, DESC, ASC sortings for mongoose

[TinNT]

Awesome!!!

Thank you.

[giano]

thanks!