Node—— typeorm 数据库操作、简单封装

创建typeorm项目

1. Db.ts

import {createConnection} from "typeorm"

export class Db {
    static connDb

    static async init() {
        Db.connDb = await createConnection()
    }

    static dbRepositories(entity) {
        const repository = this.connDb.getRepository(entity)
        return {
            find: (obj: any = "") => {
                return repository.find(obj)
            },
            delete: (obj: any = "") => {
                return repository.delete(obj)
            },
            findOne: (obj: any = "") => {
                return repository.findOne(obj)
            },
            save: (obj: any = "") => {
                return repository.save(obj)
            },
            remove: (obj: any = "") => {
                return repository.remove(obj)
            }
        }
    }

    static dbManager() {
        return this.connDb.manager
    }
}

2. Sql.ts 对应实体类

import {Db} from "../utils/Db";
import {WscUser} from "../entity/WscUser";
export class Sql {
    public wscUserDb = Db.dbRepositories(WscUser)
}

创建test.ts文件

import {Db} from "./src/mapping/Db";
import {Sql} from "./src/mapping/Sql";

/*初始化数据库连接*/
Db.init().then(async ()=>{
    let sql = new Sql()
    /*查询所有用户数据*/
    let user = await sql.wscUserDb.find()
    console.log(user)
})

运行 ts-node test.ts

在类里继承使用