Electron Vue3 Typescript Vite使用typeorm操作SQLite

1，安装typeorm和sqlite3:

        npm install typeorm

        npm install sqlite3

2,  新建一个文件data-source.ts。

import { DataSource } from 'typeorm';
import { User } from '../entity/User';
import * as path from 'path';
import { ItemData } from '../entity/ItemData';


export const AppDataSource = new DataSource({
  type: "sqlite",
  database: "database.sqlite",
  synchronize: true,
  logging: false,
  entities: [User, ItemData],
  migrations: [],
  subscribers: [],
});

AppDataSource.initialize()
    .then(async () => {
        console.log("Data Source has been initialized!")

        // const user = new User();
        // user.firstName = "Timber";
        // user.lastName = "Saw";
        // user.age = "25";
        // await AppDataSource.manager.save(user);
        // console.log("Saved a new user with id: " + user.id);
    })
    .catch((err) => {
        console.error("Error during Data Source initialization", err)
    })

export const getDataSource = (delay = 3000): Promise<DataSource> => {
  if (AppDataSource.isInitialized) return Promise.resolve(AppDataSource);

  return new Promise((resolve, reject) => {
    setTimeout(() => {
      if (AppDataSource.isInitialized) resolve(AppDataSource);
      else reject("Failed to create connection with database");
    }, delay);
  });
};

3,   在main文件夹中index.ts文件中引入并使用，在创建窗口后调用getDataSource()：

import "reflect-metadata";
import {  getDataSource } from '../Config/data-source';


createWindow();
getDataSource();

该文为原创文章，转载请注明原文出处

Author：靓仔建 w: gaolian1025

(希望能帮助到各位，大家的支持是我创作最大动力！现在待业中，希望大家能推荐一下工作。（专注.net C# 6年）)