Sequelize: Destroy/Delete all records in the table

Question

I am using Mocha for Unit tests.

When testing begins, I would like to delete all the previous records in a table.

What I have tried:

db.User.destroy({ force: true }).then(() => {
}).then(() => done());


db.User.destroy(
    {where: undefined},
    {truncate: false}
).then(() => {
    return 
}).then(() => done());


db.User.destroy({}).then(() => {
    return db.User.bulkCreate(users)
}).then(() => done());

I keep getting the following error:

 Error: Missing where or truncate attribute in the options parameter of model.destroy.

How do I delete/destroy all the records in a table?

Answer 1

You can try using

db.User.destroy({
  where: {},
  truncate: true
})

Answer 2

I was able to solve this problem with the code:

table.sync({ force: true });

This is a safer solution than the one proposed in maheshiv's answer.

Answer 3

It works for me: db.User.truncate()