function begintransaction(): promise<mysqltransaction>;
const cloud = require("@alipay/faas-server-sdk");
exports.main = async (event, context) => {
const mysql = cloud.mysql();
const transaction = await mysql.begintransaction();
try {
await transaction.insert(
'some-table',
{ user_id: '001', name: 'someone' },
);
await transaction.update(
'some-table',
{ id: '999', name: 'updated name' },
);
await transaction.commit();
return { message: '事务执行成功' };
} catch(e) {
console.log(e);
await transaction.rollback();
return { message: '事务执行失败,回滚' };
}
};