forked from tmotagam/sqlite-electron
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.js
More file actions
103 lines (90 loc) · 2.16 KB
/
index.js
File metadata and controls
103 lines (90 loc) · 2.16 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
const { app, BrowserWindow, ipcMain } = require("electron");
const { join } = require("path");
const { setdbPath, executeQuery, executeMany, executeScript, fetchOne, fetchMany, fetchAll, load_extension, backup } = require("sqlite-electron");
function createWindow() {
const win = new BrowserWindow({
width: 800,
height: 600,
webPreferences: {
preload: join(__dirname, "preload.js"),
},
});
win.loadFile("index.html");
}
app.enableSandbox();
app.whenReady().then(() => {
createWindow();
app.on("activate", () => {
if (BrowserWindow.getAllWindows().length === 0) {
createWindow();
}
});
});
app.on("window-all-closed", () => {
if (process.platform !== "darwin") {
app.quit();
}
});
ipcMain.handle("potd", async (event, dbPath, isuri) => {
try {
return await setdbPath(dbPath, isuri)
} catch (error) {
return error
}
});
ipcMain.handle("executeQuery", async (event, query, value) => {
try {
return await executeQuery(query, value);
} catch (error) {
return error;
}
});
ipcMain.handle("fetchone", async (event, query, value) => {
try {
return await fetchOne(query, value);
} catch (error) {
return error;
}
});
ipcMain.handle("fetchmany", async (event, query, size, value) => {
try {
return await fetchMany(query, size, value);
} catch (error) {
return error;
}
});
ipcMain.handle("fetchall", async (event, query, value) => {
try {
return await fetchAll(query, value);
} catch (error) {
return error;
}
});
ipcMain.handle("executeMany", async (event, query, values) => {
try {
return await executeMany(query, values);
} catch (error) {
return error;
}
});
ipcMain.handle("executeScript", async (event, scriptpath) => {
try {
return await executeScript(scriptpath);
} catch (error) {
return error;
}
});
ipcMain.handle("load_extension", async (event, path) => {
try {
return await load_extension(path);
} catch (error) {
return error;
}
});
ipcMain.handle("backup", async (event, target, pages, name, sleep) => {
try {
return await backup(target, Number(pages), name, Number(sleep));
} catch (error) {
return error;
}
});