Xiao-koa-mysql NPM

xiao-koa-mysql

XiaoKoa快速开发系列之操作MySQL插件

安装

npm i xiao-koa-mysql

使用

index.ts

import { Application, xiaoKoaApp } from "xiao-koa";
import xiaoKoaMysql from "xiao-koa-mysql";

@Application
export default class TestApplication {
  main(app: xiaoKoaApp) {
    app.mount(xiaoKoaMysql);

    app.run(__dirname, 1234);
  }
}

application.yml

...

mysql:
  connectionLimit: 10
  host: localhost
  user: root
  password: 123456
  database: test

mapping.ts

import { Mapping, Sql } from "xiao-koa-mysql";

@Mapping()
export class TestMapping {
  @Sql(`select * from user where id = #{id}`)
  findAll(id: number): any {}
}