mysql存储过程queue_mysql – 在Sequelize中调用输入/输出类型存储过程

我在

MySQL中创建了一个存储过程,它期望一些输入并返回一些输出.

要在MySQL中调用存储过程,我正在运行

CALL createCoupon(1236,321, @message);

SELECT @message AS message

并在消息对象中获取输出.

现在我需要在sequelize中称之为SP的情况.我正在研究sailsjs项目并使用sequelize模块进行排队.

我在config / db_config中创建了数据库连接,我的连接字符串是：

var sequelize = new Sequelize(db.name, db.user, db.pass, {

host: db.host,

dialect: "mysql", // or 'sqlite', 'postgres', 'mariadb'

port: 3306, // or 5432 (for postgres)

maxConcurrentQueries: 100,

pool: {

maxConnections: 50,

maxIdleTime: 2000

},

queue: true

})

我在控制器中称它为：

var Sequelize = require('sequelize');

var sequelize = require('../../config/db_config').dbase;

function setCoupon(couponCode, userId, setCouponResponse) {

var createCouponSQL = "some raw query";

sequelize.query(createCouponSQL, null, {

raw: true

}).success(function(createCoupon) {

sails.log.info(createCoupon);

setCouponResponse(null, createCoupon);

}).error(function(err) {

sails.log.error(err);

setCouponResponse(err, null);

});

}

module.exports = {

'createCoupon': function(req, callback) {

setCoupon(req.param('coupon_code'), req.session.userSession, function(err, setCouponResponse){

})

}

}

现在我需要在续集中调用SP,所以我只是尝试：

var createCouponSQL = "CALL createCoupon(1236,321, @message);";

createCouponSQL += "SELECT @message AS message";

sequelize.query(createCouponSQL, null, {

raw: true

}).success(function(createCoupon) {

sails.log.info(createCoupon);

setCouponResponse(null, createCoupon);

}).error(function(err) {

sails.log.error(err);

setCouponResponse(err, null);

});

但sequlize触发错误：

Executing (default): CALL createCoupon(1236,321, @message);SELECT @message AS m

essage

error: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the m

anual that corresponds to your MySQL server version for the right syntax to use

near 'SELECT @message AS message' at line 1

at Query.Sequence._packetToError (C:\Users\asd\Desktop\CardCash P2\Website\

node_modules\mysql\lib\protocol\sequences\Sequence.js:30:14)

我已经完成了一些R& D但是却找不到任何适当的东西来调用一个存储过程,它将我的响应发送回@message并且我需要执行另一个select语句来获得结果.

请指导我如何使用我连接数据库的方式正确地完成此操作.

谢谢.