Comments (9)
fritx
commented on August 25, 2024
@ElectroDr3am hey, are you sure you were using function (err) {} instead of err => {}?
Or have you tried:
stmt = db.prepare('INSERT INTO foo VALUES (?)')
stmt.run(params, err => {
console.log(err, stmt.lastID)
})I've just tried cross-sqlcipher in both node and electron, Mac.
(It would take me some time to test it in Windows.)
Ref:
from cross-sqlcipher.
Zvorykin
commented on August 25, 2024
I'm using Electron and Vue.js and create connection in main process like
that
(for test i've changed to `node-sqlite`)
sqlite3 = require('sqlite3')
// else
// sqlite3 = require('cross-sqlcipher')
let db = new sqlite3.Database('db.db')
global.DB = db
then get it from render
let remote = window.require('electron').remote
DB = remote.getGlobal('DB')
Vue.prototype.$db = DB
and using in vue js component
methods: {
createTicket:function () {
this.$db.run(`INSERT INTO foo...`,
{
//params
}, function (err) {
console.log(this.lastID, this)
// that's the point
})
.get('SELECT last_insert_rowid() as id', (err, row) => {
console.log(row.id)
})
}
}
The point I've specified `this` is some global variable, I think it is the
whole App variable.
Maybe you can provide example of better use of node-sqlite?
Thanks.
2017-10-04 7:25 GMT+03:00 Fritz Lin <[email protected]>:
… @ElectroDr3am <https://github.com/electrodr3am> hey, are you sure you
were using function (err) {} instead of err => {}?
Or have you tried:
stmt = db.prepare(sql); stmt.run(params, err => { stmt.lastID })
I've just tried cross-sqlcipher in both node and electron, Mac.
(It would take me some time to test it in Windows.)
Ref:
- TryGhost/node-sqlite3#100
<TryGhost/node-sqlite3#100>
- TryGhost/node-sqlite3#622 (comment)
<TryGhost/node-sqlite3#622 (comment)>
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#4 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AbiXsK0p2pnoPwkNNIgEXxosRGpcxeHOks5sowi6gaJpZM4Pm7kh>
.
from cross-sqlcipher.
fritx
commented on August 25, 2024
Oh you are using electron's remote and Vue stuff, I'm not quite sure.
I suggest you use stmt.lastID syntax. You can try it instead.
See TryGhost/node-sqlite3#622 (comment)
from cross-sqlcipher.
Zvorykin
commented on August 25, 2024
Nope, I've tryied your advice, but same result. Nevermind, I'm working of
small enought project so I can simply query SELECT last_insert_rowid()
as idafter
every INSERT if I need it. Thanks for reply!
2017-10-04 11:18 GMT+03:00 Fritz Lin <[email protected]>:
… Oh you are using electron's remote and Vue stuff, I'm not quite sure.
I suggest you to use stmt.lastID syntax. You can try it instead.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#4 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AbiXsLuv0AcrpXQqjQGIszRbz53gW4Sjks5soz9NgaJpZM4Pm7kh>
.
from cross-sqlcipher.
fritx
commented on August 25, 2024
@ElectroDr3am hah.. anyway I have another advice...
Personally I think the logic business (db query) should be placed in the main process,
and you turn off the webPreferences.nodeIntegration in renderer processes.
You can send ipc messages between them, and don't have to use remote.getGlobal,
it could be the ideal model of an electron app?
from cross-sqlcipher.
Zvorykin
commented on August 25, 2024
Thanks for advice, I'll consider refactoring my app using that idea.
I think it's worth it and may be usefull to avoid such troubles like I've
got.
2017-10-05 17:27 GMT+03:00 Fritz Lin <[email protected]>:
… @ElectroDr3am <https://github.com/electrodr3am> hah.. anyway I have
another advice...
Personally I think the logic business (db query) should be placed in the
main process,
and you turn off the webPreference.nodeIntegration in renderer processes.
You can send ipc messages between them, and don't have to use
remote.getGlobal,
it could be the ideal model of an electron app?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#4 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AbiXsIsfnD9_2BymkH-qNvBuF3lNabfPks5spOdegaJpZM4Pm7kh>
.
from cross-sqlcipher.
Zvorykin
commented on August 25, 2024
By the way I've tested using sqlite from main process and it works
correctly as described in docs.
from cross-sqlcipher.
fritx
commented on August 25, 2024
@ElectroDr3am does it work for you? with cross-sqlcipher
from cross-sqlcipher.
Zvorykin
commented on August 25, 2024
@fritx Sorry for offtop but does cross-sqlcipher support Promicess? Maybe you can you provide some example? Thanks
from cross-sqlcipher.
Related Issues (5)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cross-sqlcipher.