callStoredProcedure 🆕

Calling a stored procedure with parameters

Signature

MySQL

callStoredProcedure<T>(session: MySQLSession, procedureName: string, variables?: Array<any>): Promise<T>;

MySQLX

callStoredProcedure<T>(session: MySQLXSession, procedureName: string, variables?: Array<any>): Promise<T>;

Example

MySQL

// employeeRouter.{ts|js}
import { employeeController } from './employeeController';

const transacted = true;

await db.usingSession(async (session) => {
  const storeProcedureName = '<sp_name>';
  const parameter1 = '<parameter>';
  const data = await employeeController.callStoredProcedure(session, storeProcedureName, [parameter1]);
  return data;
}, transacted);

MySQLX

// employeeRouter.{ts|js}
import { employeeController } from './employeeController';

const transacted = true;

await db.usingSession(async (session) => {
  const storeProcedureName = '<sp_name>';
  const parameter1 = '<parameter>';
  const data = await employeeController.callStoredProcedure(session, storeProcedureName, [parameter1]);
  return data;
}, transacted);