Skip to main content

Bulk Operations

Caution

To avoid performance issues, bulk operations are not allowed on relations.

createMany()

Creates multiple entries.

Syntax: createMany(parameters) => { count: number }

Parameters

ParameterTypeDescription
dataArray of objectsArray of input data

Example

await strapi.db.query('api::blog.article').createMany({
data: [
{
title: 'ABCD',
},
{
title: 'EFGH',
},
],
});

// { count: 2 }

updateMany()

Updates multiple entries matching the parameters.

Syntax: updateMany(parameters) => { count: number }

Parameters

ParameterTypeDescription
whereWhereParameterFilters to use
dataObjectInput data

Example

await strapi.db.query('api::shop.article').updateMany({
where: {
price: 20,
},
data: {
price: 18,
},
});

// { count: 42 }

deleteMany()

Deletes multiple entries matching the parameters.

Syntax: deleteMany(parameters) => { count: number }

Parameters

ParameterTypeDescription
whereWhereParameterFilters to use

Example

await strapi.db.query('api::blog.article').deleteMany({
where: {
title: {
$startsWith: 'v3',
},
},
});

// { count: 42 }

Aggregations

count()

Counts entries matching the parameters.

Syntax: count(parameters) => number

Parameters

ParameterTypeDescription
whereWhereParameterFilters to use
const count = await strapi.db.query('api::blog.article').count({
where: {
title: {
$startsWith: 'v3',
},
},
});

// 12