Is it possible to pass a query as parameter?

[felipefac]

No description provided.

[felipefac]

Just found out that there is using knex.

Bookshelf.knex.raw(query).then(callback);

[tgriesser]

@felipefac - that will create a raw query... can you give me a little more about the situation where you're looking to pass a query as a parameter? There might be a better way to do it.

[felipefac]

I was trying to pass a db function as a parameter like:
model.query("where", "DATE(field)", "=", "2013-01-01").fetch....

The problem is the DATE(field) was going quoted to the database and i could not find a way to remove them.

Then i tried

model.query("where", Bookshelf.knex.raw("DATE(field)"I, "=", "2013-01-01").then .....

But the select ignored the last two parameters after the raw function was called and
was returning only this:
'Select * from table where Date(field)'

After some time i decided to use a raw SQL. I should have reported a issue yesterday.
Is it a issue right?

BTW great work on bookshelf congratulations.

[tgriesser]

Try this:

model.query("where", Bookshelf.knex.raw("DATE(field)"), "=", "2013-01-01")).then(...

that way you're only defining the DATE portion as raw, and I believe it should give you what you're looking for... additional arguments in a raw statement are for any bound parameters in the statement.

Also thanks! - glad you're enjoying it!

[felipefac]

I tried the method you described. The thing is the query returned was incomplete.
For the command that you gave it returns:

'Select * from table where Date(field)' and nothing else.

[tgriesser]

Oh, that's right - it needs to be a full raw statement:

model.query("where", Bookshelf.knex.raw("DATE(field) = ?"), "2013-01-01"))

That's the syntax you'll want to use, and in that case you can dynamically pass a value like a Date to the "bindings" spot where the "2013-01-01" is and ensure it's properly escaped into the query fragment... I think I need to better document that in knex.raw.