sails js getting data from database without schema definition in model

Question

I am new to SailsJs. I have a MySQL database with 123 tables with lots of fields. Now i want to use that database in my sails application. When i need to get data from any table i need to declare fields name, type etc in model like below

module.exports = {
   tableName: 'Mytable',
   adapter: 'someMysqlServer',
   migrate: 'safe',
  autoCreatedAt: false,
autoUpdatedAt: false,
  attributes: {
    id: {
      type: 'number',
      required:true
    },   
    name: {
      type: 'string',
      required: true
    }

  }
};

Now I don't want to declare all the fields in model as i have so many tables/fields. So how can i select/insert/update data without this.

mo.dhouibi · Accepted Answer · 2015-11-30 12:09:16Z

1

var connection = mysql.createConnection({
host: sails.config.connections.yourDbConnetion.host,
user: sails.config.connections.yourDbConnetion.user,
password: sails.config.connections.yourDbConnetion.password,
database: sails.config.connections.yourDbConnetion.database
});

YourFunction: function (req,res) {
connection.query('YOUR SQL QUERY ', function (err, result) {
if (err)
return res.send(err);
.........

});
}

answered Nov 30, 2015 at 12:09

mo.dhouibi

5951 gold badge4 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sails js getting data from database without schema definition in model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related