CODEWITHSUNDEEP
javascriptnode.jselectronknex.jsnode-sqlite3
Pooya Behravesh
Pooya Behravesh

Reputation: 194

sqlite3 update query refreshes electron renderer process

I realized that when i use update query with knex (with sqlite3) in electron js, after query done, the renderer process refreshes automatically! for example:

index.html: 

ipc.send('UpdateTheRow', {'Id': 1, 'Title': 'foo', 'Date': '01-01-2020'});

main.js

    ipcMain.on('UpdateTheRow', (event, newData)=>{
        knex('Products').where({id: newData.Id}).update({
            title: newData.Title,
            enter_date: newData.Date
        }).then(function (res) {
            console.log(res);
        });
    });

after running update request, console prints the Response , But the renderer refreshes!

in other words when we do something like this:

reaplce console.log in Main.js with:

indexPage.webContents.send("EditedTheRow", res);

and in index.html: 

ipc.on('EditedTheRow', (event, response) => {
   alert('Updated');
}

the query works nice but we dont get any alert in Renderer!

Upvotes: 0

Views: 1097

Answers (1)

Pooya Behravesh
Pooya Behravesh

Reputation: 194

Answer:

The main problem in my case was interference of several frame works!
I am using sqlite3, so the database saved as a file in my 'root' project folder.
Along these i am using a "Hot Reload" tool that notices file changes.
And every time i use a query like Update, Insert and Delete that changes database records, my DB file changes and Hot-reload refreshes the Renderer process!

Upvotes: 7

Related Questions