sqlite-electron/sqlite-electron.ts at master · spacehub-mn/sqlite-electron · GitHub

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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
import { execFile } from 'child_process';
import { dirname, join } from 'path';
import 'electron';

const electronNodeDetection = (): string => {
    if (typeof process !== 'undefined' && typeof process.versions === 'object' && !!process.versions.electron) {
        if (process.defaultApp) {
            return join(dirname(require.main.filename), module.exports.dbPath);
        } else {
            return join(dirname(process.execPath), module.exports.dbPath);
        }
    } else {
        return join(dirname(require.main.filename), module.exports.dbPath);
    }
}

const executeQuery = (Query: string, fetch?: string, values?: (string | number | null | Buffer)[]): Promise<boolean | []> => {
    return new Promise<boolean | []>((resolve, reject) => {
        try {

            const fullpath = electronNodeDetection();

            let sqlitePath = ''

            if (process.platform === 'win32') {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}.exe`)
            }else {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}`)
            }
            const sqlite = execFile(sqlitePath);

            let string = '';

            sqlite.stdin.write(JSON.stringify(['executeQuery', fullpath, Query, fetch, values]));
            sqlite.stdin.end();

            sqlite.stdout.on('data', (data) => {
                string += data.toString();
            });

            sqlite.stdout.on('end', () => {
                sqlite.kill();
                resolve(JSON.parse(string));
            });
        } catch (error) {
            reject(error);
        }
    });
}

const executeMany = (Query: string, v: (string | number | null | Buffer)[]): Promise<boolean> => {
    return new Promise<boolean>((resolve, reject) => {
        try {

            const fullpath = electronNodeDetection()

            let sqlitePath = ''

            if (process.platform === 'win32') {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}.exe`)
            }else {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}`)
            }
            const sqlite = execFile(sqlitePath);

            let string = '';

            sqlite.stdout.on('data', (data) => {
                string += data.toString()
            })

            sqlite.stdout.on('end', () => {
                sqlite.kill()
                resolve(JSON.parse(string))
            })

            sqlite.stdin.write(JSON.stringify(['executeMany', fullpath, Query, v]))
            sqlite.stdin.end()
        } catch (error) {
            reject(error)
        }
    });
}

const executeScript = (scriptName: string): Promise<Boolean> => {
    return new Promise<Boolean>((resolve, reject) => {
        try {

            const fullpath = electronNodeDetection()

            let sqlitePath = ''

            if (process.platform === 'win32') {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}.exe`)
            }else {
                sqlitePath = join(__dirname, `sqlite-${process.platform}-${process.arch}`)
            }
            const sqlite = execFile(sqlitePath);

            let string = '';

            sqlite.stdout.on('data', (data) => {
                string += data.toString()
            })

            sqlite.stdout.on('end', () => {
                sqlite.kill()
                resolve(JSON.parse(string))
            })

            sqlite.stdin.write(JSON.stringify(['executeScript', fullpath, scriptName]))
            sqlite.stdin.end()
        } catch (error) {
            reject(error)
        }
    });
}

module.exports.dbPath = ''
module.exports.executeQuery = executeQuery
module.exports.executeMany = executeMany
module.exports.executeScript = executeScript