sequelize for Node.js : ER_NO_SUCH_TABLE

Question

I'm new to sequelize and Node.js.
I coded for test sequelize, but error occured "ER_NO_SUCH_TABLE : Table 'db.node_tests' doesn't exist"
Error is very simple.
However, I want to get data from "node_test" table.
I think sequelize appends 's' character.

There is my source code.

var Sequelize = require('sequelize');

var sequelize = new Sequelize('db', 'user', 'pass');
var nodeTest = sequelize.define('node_test',
        { uid: Sequelize.INTEGER 
         , val: Sequelize.STRING} );

nodeTest.find({where:{uid:'1'}})
    .success(function(tbl){
        console.log(tbl);
    });

I already create table "node_test", and inserted data using mysql client.

Does I misunderstood usage?

Answer 1

I found the answer my own question.

I appended Sequelize method option following. {define:{freezeTableName:true}}

Then sequelize not appends 's' character after table name.

Answer 2

Though the answer works nicely, I nowadays recommend the use of the tableName option when declaring the model:

sequelize.define('node_test', { 
  uid: Sequelize.INTEGER,
  val: Sequelize.STRING
}, {
   tableName: 'node_test'
});

http://docs.sequelizejs.com/manual/tutorial/models-definition.html