Unable to pass JSON Array as parameter

[KyleLilly]

Currently it's not possible to pass a JSON array as a query parameter. This is due to the following function in util.js

if (_.isString(value) && value[0] === '[') {
    let arr = JSON.parse(value)
    if (_.isArray(arr)) {
        return arr
    }
}

Per a discussion on the node-postgres issue board brianc/node-postgres#442 - since arrays were around before json the preferred approach is to use JSON.stirngify() if you want to pass an array. This works in sails-postgres but fails in this updated knex based adapter.

[tjwebb]

So first of all, I'm pretty sure we went to Virginia Tech together :)

Secondly, yea that looks like an issue. If you think you have a quick fix, I'd be happy to merge a Pull Request.

[KyleLilly]

Yeah BT Tracker - didn't realize it was you. I'll get a PR together once I get some tests written.

[tjwebb]

Haha awesome, thanks.

On Wed, Dec 16, 2015 at 2:03 PM, Kyle Lilly [email protected]
wrote:

Yeah BT Tracker - didn't realize it was you. I'll get a PR together once I
get some tests written.

—
Reply to this email directly or view it on GitHub
#5 (comment)
.