Function find_many_to_many

examples/basic/src/select.rs:178–225

(db: &DbConn)

}

async fn find_many_to_many(db: &DbConn) -> Result<(), DbErr> {
    print!("find cakes and fillings: ");

    let cakes_with_fillings: Vec<(cake::Model, Vec<filling::Model>)> =
        Cake::find().find_with_related(Filling).all(db).await?;

    println!("with loader: ");
    let cakes: Vec<cake::Model> = Cake::find().all(db).await?;
    let fillings: Vec<Vec<filling::Model>> =
        cakes.load_many_to_many(Filling, CakeFilling, db).await?;

    println!();
    for (left, right) in cakes_with_fillings
        .into_iter()
        .zip(cakes.into_iter().zip(fillings.into_iter()))
    {
        println!("{left:?}\n");
        assert_eq!(left, right);
    }

    print!("find fillings for cheese cake: ");

    let cheese = Cake::find_by_id(1).one(db).await?;

    if let Some(cheese) = cheese {
        let fillings: Vec<filling::Model> = cheese.find_related(Filling).all(db).await?;

        println!();
        for ff in fillings.iter() {
            println!("{ff:?}\n");
        }
    }

    print!("find cakes for lemon: ");

    let lemon = Filling::find_by_id(2).one(db).await?;

    if let Some(lemon) = lemon {
        let cakes: Vec<cake::Model> = lemon.find_related(Cake).all(db).await?;

        println!();
        for cc in cakes.iter() {
            println!("{cc:?}\n");
        }
    }

    Ok(())
}

async fn all_about_select_json(db: &DbConn) -> Result<(), DbErr> {
    find_all_json(db).await?;