CLI action step を使って MySQL に対してクエリや検証を実行できます。
Example code
const dbName = "XXXXX";const userName = "XXXXX";const password = "XXXXX";const host = "XXXXX";const port = XXXXX;
const sequelize = new Sequelize(dbName, userName, password, { dialect: "mysql", host, port});
return sequelize .query("SELECT name FROM myTable where id = 1;", { plain: true, raw: true, type: Sequelize.QueryTypes.SELECT }) .then(myTableRows => { const result = myTableRows && JSON.stringify(myTableRows); console.log("Query result", result); if (!myTableRows || myTableRows.name !== expectedValue) { return Promise.reject(new Error("Failed to find raw")); } });Parameters - この例で使用するパッケージと JS
1.name: Sequelize, type: Package, value: sequelize@latest
2.name: mysql2, type: Package, value: mysql2@latest
3.name: expectedValue, type: JavaScript, value: "fdssdf dfdf"
see screenshot:
