Database synchronization

When starting a new project you won't have a database structure and using Sequelize you won't need to. Just specify your model structures and let the library do the rest. Currently supported is the creation and deletion of tables:

  1. // Create the tables:
  2. Project.sync()
  3. Task.sync()
  5. // Force the creation!
  6. Project.sync({force: true}) // this will drop the table first and re-create it afterwards
  8. // drop the tables:
  9. Project.drop()
  10. Task.drop()
  12. // event handling:
  13. Project.[sync|drop]().then(() => {
  14.   // ok ... everything is nice!
  15. }).catch(error => {
  16.   // oooh, did you enter wrong database credentials?
  17. })

Because synchronizing and dropping all of your tables might be a lot of lines to write, you can also let Sequelize do the work for you:

  1. // Sync all models that aren't already in the database
  2. sequelize.sync()
  4. // Force sync all models
  5. sequelize.sync({force: true})
  7. // Drop all tables
  8. sequelize.drop()
  10. // emit handling:
  11. sequelize.[sync|drop]().then(() => {
  12.   // woot woot
  13. }).catch(error => {
  14.   // whooops
  15. })

Because .sync({ force: true }) is destructive operation, you can use match option as an additional safety check.match option tells sequelize to match a regex against the database name before syncing - a safety check for caseswhere force: true is used in tests but not live code.

  1. // This will run .sync() only if database name ends with '_test'
  2. sequelize.sync({ force: true, match: /_test$/ });