cnpm i sqlite3 --build-from-source

//數(shù)據(jù)庫連接
 
const sqlite3 = require('sqlite3')
const NODE_ENV = process.env.NODE_ENV
const path = require('path')
const { app } = require('electron')
let DB_PATH = path.join(app.getAppPath(), '/config/text.db');
 
console.log('連接數(shù)據(jù)庫路徑：',app.getAppPath());
console.log('連接數(shù)據(jù)庫路徑：',DB_PATH);
 
// 判斷是否是正式環(huán)境
if (app.isPackaged) {
    // 正式環(huán)境
    DB_PATH = path.join(path.dirname(app.getPath('exe')), '/config/text.db');
}
 
//連接數(shù)據(jù)庫
function connectDatabase() {
    return new sqlite3.Database(DB_PATH, (err) => {
        if (err) {
            console.error('連接數(shù)據(jù)庫錯(cuò)誤：' + err.message);
        }
        console.log('連接數(shù)據(jù)庫成功')
    });
}
const db = connectDatabase();
 
//創(chuàng)建數(shù)據(jù)庫,如果用戶本地沒有數(shù)據(jù)庫的話就創(chuàng)建否則跳過
function createDataTable() {
    //創(chuàng)建用戶表
    db.serialize(function () {
        db.run('create table if not exists user (id INTEGER PRIMARY KEY AUTOINCREMENT, name text, email text, phone text);');
    });
    // db.close();
} 
exports.connectDatabase = connectDatabase;
exports.createDataTable = createDataTable;
exports.db = db;

const { createDataTable } = require("./db/sqlite3db.js")

createDataTable();

const {
	app,
	net,
	ipcMain,
	BrowserWindow
} = require('electron')
const path = require("path");
const fs = require('fs');
const { checkUpdate } = require("./updater.js")

const { createDataTable } = require("./db/sqlite3db.js")

const createWindow = () => {
	const mainWindow = new BrowserWindow({
		frame: false, //false表示去掉頂部導(dǎo)航去掉關(guān)閉按鈕最大化最小化按鈕
		width: 1366,
		height: 768,
		maxWidth: 1920,
		minWidth: 1280,
		minHeight: 600,
		backgroundColor: '#333',
		transparent: false, //是否透明
		webPreferences: {
			// 允許使用webview
			webviewTag: true,
			// false關(guān)閉CORS,支持跨域請求
			webSecurity: false,
			// 開啟渲染進(jìn)程使用node,為了解決require 識別問題
			nodeIntegration: true,
			// 是否在獨(dú)立 JavaScript 環(huán)境中運(yùn)行 Electron API和指定的preload 腳本.Electron 12 版本之后它將被默認(rèn)true
			contextIsolation: false,
			// 允許使用remote
			enableRemoteModule: true,
			// 子進(jìn)程路徑
			preload: path.join(__dirname, "./preload.js"),
		}
	})

	console.log("=====", path.join(__dirname, "./preload.js"));
	// 判斷是否是正式環(huán)境
	if (app.isPackaged) {
		// mainWindow.loadFile(`file://${path.join(__dirname, '../dist/index.html')}`); // 正式環(huán)境下加載html文件
		mainWindow.loadFile('dist/index.html')
		// mainWindow.webContents.openDevTools()
	} else {
		mainWindow.loadURL('http://127.0.0.1:3000/'); // dev環(huán)境下加載vite服務(wù)頁面
		mainWindow.webContents.openDevTools()
	}

	createDataTable();
}
app.whenReady().then(() => {
	createWindow()
	app.on('activate', () => {
		if (BrowserWindow.getAllWindows().length === 0) createWindow()
	})
})
app.on('window-all-closed', () => {
	if (process.platform !== 'darwin') {
		app.quit();
		mainWindow.close();
	}
})