Hi there, function nanoTest() { nSQL('users') // "users" is ou

The problem is towards the bottom, this bit of code: <div class="highlight highlig

connection exception about nano-sql HOT 2 CLOSED

wonmank commented on May 18, 2024

connection exception

from nano-sql.

Comments (2)

only-cliches commented on May 18, 2024

The problem is towards the bottom, this bit of code:

// 데이터 조인
nSQL("users")
.query("select",["users2.id", "users.name","users.age","users2.tel","users2.cell"])
.where(["users.id",">",0])
.join({
    type:"inner", // Supported join types are left, inner, right, cross and outer.
    table: "users2",
    where: ["users.id", "=", "users2.id"] // any valid WHERE statement works here
}).exec().then(function(rows) {console.log(rows);

You can't call a query until you connect the database, the best option is just adding an onConnect callback around it.

nSQL().onConnected(() => {
    // 데이터 조인
    nSQL("users")
    .query("select",["users2.id", "users.name","users.age","users2.tel","users2.cell"])
    .where(["users.id",">",0])
    .join({
        type:"inner", // Supported join types are left, inner, right, cross and outer.
        table: "users2",
        where: ["users.id", "=", "users2.id"] // any valid WHERE statement works here
    }).exec().then(function(rows) {console.log(rows);
});