Method find_notes_in_page

examples/graphql_example/service/src/query.rs:16–29

If ok, returns (note models, num pages).

(
        db: &DbConn,
        page: u64,
        notes_per_page: u64,
    )

    /// If ok, returns (note models, num pages).
    pub async fn find_notes_in_page(
        db: &DbConn,
        page: u64,
        notes_per_page: u64,
    ) -> Result<(Vec<note::Model>, u64), DbErr> {
        // Setup paginator
        let paginator = Note::find()
            .order_by_asc(note::Column::Id)
            .paginate(db, notes_per_page);
        let num_pages = paginator.num_pages().await?;

        // Fetch paginated notes
        paginator.fetch_page(page - 1).await.map(|p| (p, num_pages))
    }
}