javascript - 使用 knex js 时如何返回值？

Question

我有一个函数试图让它使用 return 从数据库返回一个 knex 结果，但它似乎不起作用？我正在使用 knex 库而不是 ajax。

代码

//function

function runKnex(){
        //Run Queries and send Content
        var result = knex.select().table('User')
         return result.then(function(rows){
            return rows;
        })
}

//calling function

mainWindow.webContents.on('did-finish-load',()=>{
        const knexres = runKnex();
        console.log(knexres);
});

结果

  _bitField: 0,
  _fulfillmentHandler0: undefined,
  _rejectionHandler0: undefined,
  _promise0: undefined,
  _receiver0: undefined
} 

为什么不是数组？我如何让它返回一个数组？

NB when you console.log(rows) you get:

[
  { UserId: 1, FirstName: 'Tarik', LastName: 'Guney', Age: 30 },
  { UserId: 2, FirstName: 'Sumeyye', LastName: 'Guney', Age: 29 }
]

Answer 1

// 1. with async await
function runKnex(){
        //Run Queries and send Content
        var result = knex.select().table('User')
         return result.then(function(rows){
            return rows;
        })
}

//calling function
mainWindow.webContents.on('did-finish-load',async ()=>{
        const knexres = await runKnex();
        console.log(knexres);
});

// 2. 

function runKnex(){
        //Run Queries and send Content
        
       return  knex.select().table('User').then()
       
}

//calling function
mainWindow.webContents.on('did-finish-load', ()=>{
      runKnex().then(knexres=>{
      
         console.log(knexres);
      
      });
});