使用Loopback4调用MYSQL存储过程的正确方法

npm install --save @loopback/mysql
npm install --save mysql

import {juggler} from '@loopback/repository';

export const db: juggler.DataSource = new juggler.DataSource({
  name: 'db',
  connector: 'mysql',
  host: 'localhost',
  port: 3306,
  user: 'username',
  password: 'password',
  database: 'database_name',
});

lb4 model

import {get, param, post, requestBody} from '@loopback/rest';
import {repository} from '@loopback/repository';
import {db} from '../datasources';
import {MyModelRepository} from '../repositories';

export class MyController {
  constructor(
    @repository(MyModelRepository) private myModelRepo: MyModelRepository,
  ) {}

  @post('/my-controller')
  async callStoredProcedure(@requestBody() data: any): Promise<any> {
    const result = await this.myModelRepo.execute('CALL my_stored_procedure(?, ?)', [data.param1, data.param2]);
    return result;
  }
}