Count entities matching the conjunction of field equality operands. This does not perform authorization since count does not load full entities. Note that this should be used with the same caution as loadManyByFieldEqualityConjunctionAsync regarding indexing since counts can be expensive on large datasets without appropriate indexes.
count of entities matching the filters
Count entities matching a SQL fragment. This does not perform authorization since count does not load full entity rows. Note that this should be used with the same caution as loadManyBySQL regarding indexing since counts can be expensive on large datasets without appropriate indexes.
count of entities matching the query
Get cursor for a given entity that matches what loadPageAsync would produce. Useful for constructing pagination cursors for entities returned from other loader methods that can then be passed to loadPageAsync for pagination. Most commonly used for testing pagination behavior.
The entity to get the pagination cursor for.
The pagination cursor for the given entity.
Load the first entity matching the conjunction of field equality operands and query modifiers.
This is a convenience method for loadManyByFieldEqualityConjunctionAsync. However, the orderBy query modifier is required to ensure consistent results if more than one entity matches the filters.
the first entity matching the filters, or null if none match
Load entities matching the conjunction of field equality operands and query modifiers.
Typically this is used for complex queries that cannot be expressed through simpler convenience methods such as loadManyByFieldEqualingAsync.
entities matching the filters
Load entities using a SQL query builder. When executed, all queries will enforce authorization and throw if not authorized.
const entities = await ExampleEntity.loader(vc)
.loadManyBySQL(sql`age >= ${18} AND status = ${'active'}`)
.orderBy('createdAt', 'DESC')
.limit(10)
.executeAsync();
const { between, inArray } = SQLExpression;
const filtered = await ExampleEntity.loader(vc)
.loadManyBySQL(
sql`${between('age', 18, 65)} AND ${inArray('role', ['admin', 'moderator'])}`
)
.executeAsync();
Load a page of entities with Relay-style cursor pagination.
Pagination arguments with pagination and either first/after or last/before
a page of entities matching the pagination arguments
Enforcing knex entity loader for non-data-loader-based load methods. All loads through this loader will throw if the load is not successful.