How to make more complex queries?

[thokari]

Hi, I want to completely change the structure of my database (mongodb), so the four methods provided by the API will not suffice. How do I use the mongodb API from within migrations?
I am currently stuck with this:

exports.up = (db, callback) ->
    db.connection._db.collection('users').find().toArray((err, arr) ->
        console.log err
        console.log arr
        callback()
     )

Which yields:

{ [MongoError: Connection Closed By Application] name: 'MongoError' }
null

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[wzrdtales]

This is currently not possible, requests are encapsulated by the _run method which fistly builds the connection. I have planned anyway to make a bit of rework on some drivers, including this one.

So as we're on this topic I can ask this question, I've forgot to ask so often.
@toymachiner62 Could you tell me why exactly you establish the connection not when loading the driver and instead open a new connection for every _run call?
Does this have a specific reason that you choosed this design?

[toymachiner62]

If i remember correctly I was having a helluva time with the connection stuff b/c it's different than most other sql connections. I can't remember the specifics off the top of my head though..

Either that or I was being dense at the time...

[wzrdtales]

@toymachiner62 Ok thanks for your response :)
Then I will check out the details about the connection and see what happens if there is a persistent connection.

@thokari I will schedule this at a later time, I will invest more time in May again and hope to finish the v0.10.x. Either I will schedule this for the v0.10.x release or going to put into the next release, depends on how fast next month everything moves forward.