Prisma Client Rust
GitHubGitHub (opens in a new tab)
  • Introduction
  • Getting Started
    • Installation
    • Setup
    • Structure
  • Reading Data
    • Find Queries
    • Fetching Relations
    • Pagination
    • Ordering
    • Counting Records
    • Select & Include
    • Order By
  • Writing Data
    • Create Queries
    • Update Queries
    • Delete Queries
    • Upserting
  • Extra
    • Raw Queries
    • Batching Queries
    • Transactions
    • Composite Types
    • Partial Types
    • Mocking Queries
    • Error Handling
    • Migrations
    • rspc Integration
    • Query Traits
  • 0.6.0 Migration
  • Introduction
  • Getting Started
    • Installation
    • Setup
    • Structure
  • Reading Data
    • Find Queries
    • Fetching Relations
    • Pagination
    • Ordering
    • Counting Records
    • Select & Include
    • Order By
  • Writing Data
    • Create Queries
    • Update Queries
    • Delete Queries
    • Upserting
  • Extra
    • Raw Queries
    • Batching Queries
    • Transactions
    • Composite Types
    • Partial Types
    • Mocking Queries
    • Error Handling
    • Migrations
    • rspc Integration
    • Query Traits
  • 0.6.0 Migration
Question? Give us feedback → (opens in a new tab)Edit this page
Reading Data
Counting Records

Count

count returns the number of records that fit a set of filters.

The examples use the following schema:

model Post {
    id        String   @id @default(cuid())
    title     String
    content   String
}
use prisma::comment;
 
// Passing no filters will count all records
let all_count: usize = client
    .comment()
    .count(vec![])
    .exec()
    .await?;
 
// Number of records whose title starts with "Post"
let filtered_count: usize = client
    .comment()
    .count(vec![comment::title::starts_with("Post".to_string())])
    .exec()
    .await?;
OrderingSelect & Include

Apache 2.0 2023 © Brendonovich