node-querybuilder

node-querybuilder copied to clipboard

Using NOW() in custom where?

3

I need to select data where ``last_update` >= now() - INTERVAL 1 MINUTE` Example of what I'm currently trying to use: ```javascript qb.select('*').where('last_update >= NOW() - INTERVAL 1 MINUTE', null,...

mswdev

Trying to run this query including case when clause this.db.select("ar.id as resolution_id, ar.resolution_no, ar.resolution_heading, ar.resolution_text, ar.resolution_proposer, ar.resolution_seconder, " + "case when (art.proxy_vote_allowed=1 and ar.proxy_allowed_to_vote=1) then 1 " + "when (art.proxy_vote_allowed=1...

cyberrspiritt

insert_ignore and dupe

1

Using the query builder following the documentation leads to an error: the argument list is not used as in the example (https://www.npmjs.com/package/node-querybuilder#insert_ignoretable-dataon_dupe-callback): `.insert_ignore(table, data[,on_dupe][, callback])` Looks like the third parameter...

aseprano

Simple Question

3

Hi, @kylefarris I am sorry, that I write you here, because I haven't found you in facebook/telegram. As I understood, this npm package aim and purpose is not to be...

KHYehor

calling where_in with an empty array returns all rows

4

``` qb.where_in('id',[]) qb.get(...) ``` This results in `all rows returned`, instead of `no rows returned`.

Flamenco

why need the line pool.get_connection ?

1

can remove pool.get_connection() ? I want it to have a line number equal to the line number of single connection can do that ?

matamune94

How to create Nested Or/And clauses?

1

How to generate the query clause with nested and/or, example: ```sql Select departmentName, departmentSales From Department Where EmployeeCount > 1000 AND ( DepartmentRevenue > 100000 OR DepartmentCost > 10000 )...

gitcloned

How would I define an insert_batch with the table, data, on_dupe, and a callback? Each time I try to do this, it doesn't seem it can support all those parameters...

mswdev

Example in DELETE docs does not close connection on error

9

See comment in snippet. ```js pool.get_connection(qb => { qb.get('comments', {id: id}, (err, res) => { // CONNECTION SHOULD BE CLOSED BEFORE RETURNING if (err) return console.error(err); const article_id = res.article_id;...

Flamenco

[2.0.0-beta.1] cb is not defined error when insert_batch with empty array

4

driver: mysql ```js const members = [] // some function that may return an empty array qb.insert_batch('group_user', members, (err, res) => {}) ``` Expected behavior would be to simply invoke...

Flamenco