Edward Baer
07/22/2021, 11:15 PMconst mysql = require('mysql-await');
// Drop, and re-create Sequence Stored Procedure
const dropSomeProcedure = 'DROP PROCEDURE IF EXISTS someProcedure';
const createSomeProcedure = `
CREATE PROCEDURE someProcedure (
...
)
BEGIN
....
END
`;
const connectionParams = {
host: config.dbHost,
port: config.dbPort,
user: config.dbUsername,
password: config.dbPassword,
database: config.dbDatabase
};
const dbConn = mysql.createConnection(connectionParams);
await dbConn.awaitQuery(dropSomeProcedure );
await dbConn.awaitQuery(createSomeProcedure);
dbConn.end();