node-querybuilder

node-querybuilder copied to clipboard

.count() will always throw an error

1

Whenever I try to run a .count() either with only the table name or the table name and the callback function, I always get the exception "this.resolve is not a...

rsandrea

UserGhost411

NULL does not support

1

.where('attr IS NOT', 'NULL') of .where('attr IS NOT', null) : does not work

lequangkhanh2901

It doesn't have first() method like normal. I can get one row by use limit() method but it til return an array.

khanhle2901

reset query bug fixed

jijojayaprakash

error in batch_update | Cannot read property 'reset_query' of undefined

1

I was using batch_update but facing this error. The query I am getting in next_batch is working fine still I am getting this. **batch_data** [ { column1: 'test', coolumn2: '2.0.2444',...

niranjan02

like() Numeric bug

2

Im using v2.1.1 When using `.like()` and `.or_like()` on numeric, Quote got removed '%123%' became %123% and error of execution `ER_PARSE_ERROR: You have an error in your SQL syntax; check...

selfclose

Add a parenthesis stack for where

2

It would be helpful if we could push and pop where statements. ``` qb.where({foo:'bar'} qb.pushWhere() qb.or_where({v1: 1}) qb.or_where({v2: 2}) qb.popWhere() ``` ```sql where foo='bar' and (v1=1 or v2=2) ```

Flamenco

I'm trying to Select {tableName}.* from {tableName} not working when I join 2 tables becase I just wanna return the values from first table example ` db.select('p.*').from('products p').join('brand b', 'b.id=p.brand_id')...

t0rton

Long running connection getting dropped without proper handling

1

I have an express server, responding to API calls. Before calling `server.listen()` I initialise the Query Builder, and leave it running in the background It all works fine until after...

ghost