Waterline and mysql without sails

I am creating a node app and want to use waterline and mysql without sails. I cannot get the adapter to work. The exact error I am getting with the code below:

C:\node\mlb\node_modules\waterline\lib\waterline\core\index.js:70 var schemaAttributes = this.waterline.schema[this.identity].attributes; TypeError: Cannot read property 'undefined' of undefined

Here is my code:

var Waterline = require('waterline');
var mysql = require('sails-mysql');

mysql.config = {
  host: 'localhost',
  database: 'mlb',
  port: '3306',
  username: 'admin',
  password: 'xxxxxxxx'
}

var Batter = Waterline.Collection.extend({
  adapter: 'mysql',
  attributes: {
    name: {
    type: 'string',
    required: true
   }
 }
});

new Batter({ tableName: 'batters', adapters: { mysql: mysql }}, function (err, Model) {
    Model.findAll().exec(function(err, batters) {
    // Now we have an array of users
    });
});

      

+3


source to share





All Articles