电子等待sqlite3响应

Question

我在我的main.js中有一个sqlite3数据库请求，该请求是通过按钮单击renderer.js触发的。

该请求到达我的main.js。但是，我无法等待数据库的结果。该问题已经发生在main.js中，因此我甚至在传递给Renderer.js之前就卡住了。

我希望有人能告诉我我缺少什么。

这是我的代码：

Renderer.js

$(document).on('click','#mybtn',function(e){

    let query = "SELECT id, name FROM table1"

    // send (here is the issue)
    window.api.send("db-query", query)

    // (next step: receive, might be wrong but not yet my problem)
    window.api.receive(channel="receive-db-data", (data) => {
      console.log(data);
    });

});

main.js

ipcMain.on(channel='db-query', async (e, query) => {
  console.log('query received: ' + query);
  
  let data = await db_request(query).then(
      function(value) {
         console.log('value: ' + value);
         return value;
      },
      function(error) {
         console.log('error fetching data from db on query:' + query);
      }
  )
  console.log("response ready: " + data); //returns undefined if 'return value' is used (otherwise nothing)

  // to send back to renderer.js later
  e.sender.send("db-data", data)

})


let db_request = async (query) => {

  let data = []

  var sqlite3 = require('sqlite3').verbose();
  var dbPath = require('path').resolve(__dirname, '../../Fin.db')
  var db = new sqlite3.Database(dbPath)

  db.serialize(function(){
    db.each(query, function(err, row) {
      console.log(row)
      data.push({"id": row.id, "name": row.name})
    });
  });
  db.close();

  console.log('db_request:' + data)

  return data
}

，这就是我的终端的样子：

query received: SELECT id, type, name FROM table1
db_request:
value: 
response ready: undefined
{ id: 1, name: 'a' }
{ id: 2, name: 'b' }
{ id: 3, name: 'c' }

Answer 1

您必须将db_request结果转换为承诺，当将所有行推到data时，将解决承诺。当您使用等待关键字时，无需使用。然后链条处理承诺。

main.js看起来像这样：

const sqlite3 = require('sqlite3').verbose();
const dbPath = require('path').resolve(__dirname, '../../Fin.db')

ipcMain.on(channel='db-query', async (e, query) => {
  console.log('query received: ' + query)

  try {
    const data = await db_request(query); // remove .then
    console.log('value: ' + data)
    // to send back to renderer.js later
    e.sender.send("db-data", data)
  } catch (error) {
    console.log('error fetching data from db on query:' + query);
    e.sender.send("db-data", []) // send empty data or error ???
  }
})


let db_request = (query) => {
  const db = new sqlite3.Database(dbPath)

  return new Promise((resolve, reject) => { // return a promise
    // I think you dont need serialize for this case
    const data = []
    db.each(query, (err, row) => {
      console.log(err, row)
      if (!err) {
        data.push({"id": row.id, "name": row.name})
      }
    }, (error) => {
      if (error) {
        reject(error)
      } else {
        resolve(data)
      }
    });
  })
}