Trait diesel::associations::GroupedBy
source · pub trait GroupedBy<'a, Parent>: IntoIterator + Sized {
// Required method
fn grouped_by(self, parents: &'a [Parent]) -> Vec<Vec<Self::Item>>;
}Expand description
The grouped_by function groups records by their parent.
grouped_by is called on a Vec<Child> with a &[Parent].
The return value will be Vec<Vec<Child>> indexed to match their parent.
Or to put it another way, the returned data can be passed to zip,
and it will be combined with its parent.
This function does not generate a GROUP BY SQL statement,
as it operates on data structures already loaded from the database
Child refers to the “many” part of a “one to many” relationship. It “belongs to” its parent Parent refers to the “one” part of a “one to many” relationship and can “have many” children. The child always has a foreign key, which refers to its parent’s primary key. In the following relationship, User has many Posts, so User is the parent and Posts are children.
Example
let users = users::table.load::<User>(connection)?;
let posts = Post::belonging_to(&users)
.load::<Post>(connection)?
.grouped_by(&users);
let data = users.into_iter().zip(posts).collect::<Vec<_>>();
let expected_data = vec![
(
User { id: 1, name: "Sean".into() },
vec![
Post { id: 1, user_id: 1, title: "My first post".into() },
Post { id: 2, user_id: 1, title: "About Rust".into() },
],
),
(
User { id: 2, name: "Tess".into() },
vec![
Post { id: 3, user_id: 2, title: "My first post too".into() },
],
),
];
assert_eq!(expected_data, data);See the module documentation for more examples