How can i create web services using MySql Stored procedures in strongloop

Question

I'm new to concept of strong loop & want to create web services using MySql stored procedures instead of table schema, but i'm not getting any related samples or step by step documentation for how & where to define input & output parameters, How to define getters & setters, How can i Use stored procedure(i do in java). so can anybuddy help me for that. I'm trying following code in "Mode.js". where do i need to make changes

     module.exports = function(StaticData) {


    StaticDataremoteMethod(
   var ds = server.dataSources.MySQL;
var sql = 'SELECT * FROM static_data';
ds.connector.execute(sql, function(err, data)
  {
    if(err) return err;
    console.log(err);
    });,
    {
        accepts: [
        {arg: 'id', type: 'number', required: true}
      ],
       http: {path: '/:id/StaticDataremoteMethod', verb: 'get'}
    }
  );

};

for same I'm getting following exception on command prompt

C:\Users\anupd\Desktop\ToursDemo>slc arc Swagger: skipping unknown type "subscription". Swagger: skipping unknown type "subscription". Loading workspace C:\Users\anupd\Desktop\ToursDemo StrongLoop Arc is running here: http://localhost:65058/#/ C:\Users\anupd\Desktop\ToursDemo\common\models\static-data.js:5 var ds = server.dataSources.MySQL; ^^^

SyntaxError: Unexpected token var at exports.runInThisContext (vm.js:53:16) at Module._compile (module.js:374:25) at Object.Module._extensions..js (module.js:417:10) at Module.load (module.js:344:32) at Function.Module._load (module.js:301:12) at Module.require (module.js:354:17) at require (internal/module.js:12:17) at C:\Users\anupd\Desktop\ToursDemo\node_modules\loopback-boot\lib\executor. js:226:20 at Array.forEach (native) at defineModels (C:\Users\anupd\Desktop\ToursDemo\node_modules\loopback-boot \lib\executor.js:207:23)

Thanks in advance

Answer 1

Refer this link.

dataSource.connector.execute(sql, params, cb); or dataSource.connector.query(sql, params, cb);

https://docs.strongloop.com/display/public/LB/Database+connectors https://docs.strongloop.com/display/public/LB/Executing+native+SQL

  method()
{

var server = require('../server');
var ds = server.dataSources.MySQL;
var sql = 'select * from Appuser';
ds.connector.execute(sql, function(err, data)
  {
    if(err) return err;
    console.log(err);
    console.log("data",data);
  });
}