current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

The Sequelize example suggests doing this just before server.listen() in app.js which seems too limiting.

How would you script more complex syncs or migrations?

share|improve this question

1 Answer 1

up vote 0 down vote

Synchronization new project with DB is one-time process before starting the project. DB or synchronized with the application or not, so do not input your synchronization code in Express. Create standalone separate sync.js file with all your models and sync code and run it before you run your Express app.

var Sequelize = require('sequelize');
var sequelize = new Sequelize(... {
  // dbs settings    
});

var User = sequelize.define('User', {
   name: Sequelize.STRING
});

var Post = sequelize.define('Post', {
    title: Sequelize.STRING,
    body: Sequelize.STRING
});

Post.belongsTo(User);
User.hasMany(Post);


User.sync({force: true}).success(function() {
    Post.sync({force: true}).success(function() {
        console.log('Everything was synchronized');
    });
});

And after that run you Express app

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.