cool-admin框架后端使用-node版本，使用事务装饰器来创建和事务回滚

梦想与想象-广州大智汇

已于 2022-12-11 23:59:38 修改

阅读量768

点赞数

分类专栏： node # cool-admin 文章标签： node cool-admin typescript typeorm

于 2022-09-14 00:20:34 首次发布

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/u014617119/article/details/126843663

版权

node 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

cool-admin

8 篇文章 1 订阅

订阅专栏

这里以cool-admin官方封装到依赖@CoolTransaction来实现
演示为重写控制器update这个CRUD

创建实体类DzhSgChatAcountEntity，路径：src/modules/sg/entity/chata_account.ts

在这里插入图片描述

import { EntityModel } from '@midwayjs/orm';
import { BaseEntity } from '@cool-midway/core';
import { Column } from 'typeorm';

/**
 * 描述
 */
@EntityModel('dzh_sg_chat_acount')
export class DzhSgChatAcountEntity extends BaseEntity {

  @Column({ comment: '会员' })
  uid: number;

  @Column({ comment: '唯一值' })
  unique: string

  @Column({ comment: '备注', type:'text', nullable: true,})
  remark: string

  @Column({ comment: '状态 0:禁用 1:正常', default: 1, type: 'tinyint'})
  status: number
}

创建第二个实体类DzhSgDomainEntity，路径：src/modules/sg/entity/domain.ts

在这里插入图片描述

import { EntityModel } from '@midwayjs/orm';
import { BaseEntity } from '@cool-midway/core';
import { Column } from 'typeorm';

/**
 * 描述
 */
@EntityModel('dzh_sg_domain')
export class DzhSgDomainEntity extends BaseEntity {
    @Column({ comment: '会员' })
    uid: number;

    @Column({ comment: '域名', type: 'text' })
    domain: string

    @Column({ comment: '备注', type:'text', nullable: true })
    remark: string

    @Column({ comment: '状态 0:禁用 1:正常', default: 1, type: 'tinyint' })
    status: number
}

控制器DzhSgChatAcountController，路径：src/modules/sg/controller/admin/chat_account.ts

在这里插入图片描述

service: DzhSgChatAccountService,这里一定要写，不然服务类重写update无效

import { Provide } from '@midwayjs/decorator';
import { CoolController, BaseController } from '@cool-midway/core';
import { DzhSgChatAcountEntity } from '../../entity/chata_account';

import { DzhSgChatAccountService } from '../../service/admin/chat_account';

/**
 * 描述
 */
@Provide()
@CoolController({
  api: ['add', 'delete', 'update', 'info', 'list', 'page'],
  entity: DzhSgChatAcountEntity,
  service: DzhSgChatAccountService,//这里一定要写，不然服务类重写update无效

})
export class DzhSgChatAcountController extends BaseController {}

服务类DzhSgChatAccountService，路径：src/modules/sg/service/admin/chat_account.ts

在这里插入图片描述

import { Inject, Provide } from '@midwayjs/decorator';
import {
  BaseService,
  CoolCommException,
  CoolTransaction,
} from '@cool-midway/core';
import { InjectEntityModel } from '@midwayjs/orm';
import { QueryRunner, Repository } from 'typeorm';
import { DzhSgChatAcountEntity } from '../../entity/chata_account';
import { DzhSgDomainEntity } from '../../entity/domain';

/**
 * 描述
 */
@Provide()
export class DzhSgChatAccountService extends BaseService {

  /**
   * 更新
   */
  @CoolTransaction({ isolation: 'SERIALIZABLE' })
  async update(param, queryRunner?: QueryRunner) {
  
    const dzhSgDomain= new DzhSgDomainEntity();
    dzhSgDomain.uid = "我是uid"；
    dzhSgDomain.domain = '我是domain';
    await queryRunner.manager.insert<DzhSgDomainEntity>(
      DzhSgDomainEntity,
      dzhSgDomain
    );
    //这里因为接收到的param不是实体类类型，而save方法入参要求实体类类型，所以这里转换一下
    const dzhSgChatAcount = new DzhSgChatAcountEntity()
    let obj = Object.assign(dzhSgChatAcount, param);
    await queryRunner.manager.save<DzhSgChatAcountEntity>(obj);
    
    return param.id;
  }
}