Deleting Data

You may delete existing data through various repository methods.

In this section, it assumes you're familiar with the usage of repository. If not, please read through the Repository: Getting Started page first.

Deleting Data

To delete a record, you may use the destroy method and pass the primary key for the record to be deleted.

// Existing records.[  { id: 1, name: 'John Doe', age: 40 },  { id: 2, name: 'Jane Doe', age: 30 },  { id: 3, name: 'Johnny Doe', age: 20 }]// Delete the record with id of 2.useRepo(User).destroy(2)// The result.[  { id: 1, name: 'John Doe', age: 40 },  { id: 3, name: 'Johnny Doe', age: 20 }]

In addition, the destroy method will accept an array of primary keys to delete multiple records.

useRepo(User).destroy([1, 2])

The destroy method will return deleted models. When you pass a single primary key, it will return a single model, and if you pass multiple primary keys, it will return a collection of models.

const user = await useRepo(User).destroy(2)// User { id: 2, name: 'Jane Doe', age: 30 }const user = await useRepo(User).destroy([1, 2])/*  [    User { id: 1, name: 'John Doe', age: 40 },    User { id: 2, name: 'Jane Doe', age: 30 }  ]*/

If you wish to delete the entire records, you may use the flush method.

useRepo(User).flush()

Deleting Data By Query

You can also run a delete statement on a set of records. In this example, we will delete all flights that are marked as inactive.

useRepo(User).where('active', false).delete()