Hi, I have a problem with"node-querybuilder ", ie, select is not a function, bello

Hey <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url=

qb.select is not a function about node-querybuilder HOT 1 CLOSED

kylefarris commented on June 20, 2024

qb.select is not a function

from node-querybuilder.

Comments (1)

kylefarris commented on June 20, 2024

Hey @shajeermhmmd,

You've setup the QueryBuilder instance to create a pool of connections (preferred way) but you're attempting to use the library as if you set it up for a single connection. You need to get a connection from the pool first (see: https://github.com/kylefarris/node-querybuilder#get_connection)

You code should be as follows:

var pool= require('node-querybuilder').QueryBuilder({
    connectionLimit : 100,
    host : 'localhost',
    user : 'root',
    password : '',
    database : 'address_book',
    debug : false,
    pool_size: 50
}, 'mysql', 'pool');

pool.get_connection(function(qb) {
    qb.select('*').get('users', function(err,response) {
        qb.release(); // <-- make sure to do this when you're done with each series of queries
        if (err) return console.error("Uh oh! Couldn't get results: " + err.msg);
        console.log("Query Ran: " + qb.last_query());
        return response;
    });
});

Also, if you're going to be selecting all fields, there's no need to write .select('*'); you can simply omit it like this: qb.get('users', ... and it will work as expected.

from node-querybuilder.

Recommend Projects