Hello, I have an issue with an electron app using sqlite:
Followed the docs (Using Local Databases in Mobile and Desktop apps) and can find the correct action on flow:
What do you want to do?
Iām having also issue with sqlite in capacitor mobile app. After adding sqlite and creating a table in database, all other plugins vanished from package.json except sqlite plugin.
Have you added capacitor to your page as framework? Then the capacitor actions will be available.
@George I was about to say that, after manually adding capacitor framework (which it's a bug reported time ago), shows the actions on the flow, but query is empty so facing another issue
Query might be empty if the database is empty. It is easy to mixup the oaths to the SQLite database and have it create a new one each time
I'm confused..
On the tutorial the data is added using the editor and displayed correctly.
That doesn't work anymore?
Recreated step by step so thought it should lead to the same result
Anyway, made a new one:
<script is="dmx-flow" id="flow3" type="text/dmx-flow" dmx-on:done="flow1.run()">{
Capacitor.sqlite.insert: {
name: "insert",
connection: "newdb",
sql: {
type: "insert",
values: [
{table: "table1", column: "value", type: "text", value: "1"}
],
table: "table1",
returning: "id",
query: "insert into `table1` (`value`) values (?)",
params: []
}
}
}</script>
And:
Uncaught (in promise) Error: RunSQL: run: table table1 has no column named value
at Ue.runSQL (p-6e83e397.entry.js:7:124956)
at async dr._run (p-6e83e397.entry.js:13:159127)
at async dr.run (p-6e83e397.entry.js:13:141707)
at async CapacitorSQLiteWeb.run (plugin.js:1145:35)
Ok, checked json and seems field was not saved when creating table on editor:
dmx.databases['newdb'] = {
"version": 4,
"upgrade": [
{
"toVersion": 1,
"statements": [
"create table `table1` (`id` integer not null primary key autoincrement)"
]
So will inspect it a little more
Thanks @George