sequelize.define error: has no method 'define' in nodejs

Question

This is my managedb.js which manages all the database models:

var Sequelize = require('sequelize-postgres').sequelize
var postgres  = require('sequelize-postgres').postgres

 var db = new Sequelize('testdb', 'postgres', 'postgres', {
  dialect: 'postgres'
})


var models = [
'user'
];

models.forEach(function(model) {
module.exports[model] = db.import(__dirname + '/' + model);
});



exports.db = db;

This is my user.js

var sequelize = require("sequelize");
var seq = require("./managedb");
var db = seq.db;

var Project = db.define('Project', {
  title: sequelize.STRING,
  description: sequelize.TEXT
});

In my app.js

var seq = require('./models/managedb');
seq.db.sync();

Error I get is this:

var Project = sequelize.define('Project', {
                        ^
TypeError: Object function (database, username, password, options) {
    var urlParts
    options = options || {}

    if (arguments.length === 1 || (arguments.length === 2 && typeof username === 'object')) {
      options = username || {}
      urlParts = url.parse(arguments[0])
      database = urlParts.path.replace(/^\//,  '')
      dialect = urlParts.protocol
      options.dialect = urlParts.protocol.replace(/:$/, '')
      options.host = urlParts.hostname

      if (urlParts.port) {
        options.port = urlParts.port
      }

      if (urlParts.auth) {
        username = urlParts.auth.split(':')[0]
        password = urlParts.auth.split(':')[1]
      }
    }

    this.options = Utils._.extend({
      dialect: 'mysql',
      host: 'localhost',
      port: 3306,
      protocol: 'tcp',
      define: {},
      query: {},
      sync: {},
      logging: console.log,
      omitNull: false,
      queue: true,
      native: false,
      replication: false,
      pool: {},
      quoteIdentifiers: true
    }, options || {})

    if (this.options.logging === true) {
      console.log('DEPRECATION WARNING: The logging-option should be either a function or false. Default: console.log')
      this.options.logging = console.log
    }

    this.config = {
      database: database,
      username: username,
      password: (( (["", null, false].indexOf(password) > -1) || (typeof password == 'undefined')) ? null : password),
      host    : this.options.host,
      port    : this.options.port,
      pool    : this.options.pool,
      protocol: this.options.protocol,
      queue   : this.options.queue,
      native  : this.options.native,
      replication: this.options.replication,
      maxConcurrentQueries: this.options.maxConcurrentQueries
    }

    var ConnectorManager = require("./dialects/" + this.options.dialect + "/connector-manager")

    this.daoFactoryManager = new DAOFactoryManager(this)
    this.connectorManager  = new ConnectorManager(this, this.config)

    this.importCache = {}
  } has no method 'define'

Jean-Philippe Leclerc · Accepted Answer · 2013-06-07 19:53:46Z

7

This is because you have to instantiate Sequelize.

var Sequelize = require("sequelize");

var sequelize = new Sequelize('database', 'username');

var Project = sequelize.define('Project', {
  title: sequelize.STRING,
  description: sequelize.TEXT
});

answered Jun 7, 2013 at 19:53

Jean-Philippe Leclerc

6,8055 gold badges45 silver badges66 bronze badges

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

6 Comments

Hick Over a year ago

Do I've to instantiate sequelize in every model then? I can just import it from the manage db, right?

Jean-Philippe Leclerc Over a year ago

Yes, generally you should use the same instance for your models. Edit: You can module.exports your instance and use it to define your models in other files.

Hick Over a year ago

The error still persists. I edited the question to show the change in code. Did I export/import it wrong?

Hick Over a year ago

The error that I'm currently getting it this: TypeError: Cannot call method 'define' of undefined

Jean-Philippe Leclerc Over a year ago

Does it works if you use module.exports.db = db instead of exports.db = db?

|

Collectives™ on Stack Overflow

sequelize.define error: has no method 'define' in nodejs

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related