select composite key

[karatakis]

Is there a way to perform the following query ?

SELECT *
  FROM table_name
  WHERE (key_part_1, key_part_2) IN ( ('B',1), ('C',2) );

Like for example:

let condition = Condition::all().add((Column::key_part_1, Column::key_part_2).in(vec![('B',1), ('C',2)]));
let data = Entity::find().filter(condition).all(db).await

[billy1624]

Hey @karatakis, it's not support at the moment. But I think we could support it as all three db backends support such "tuple" conditioning. Would you like to create a PR for it on SeaQuery?

[karatakis]

Yeah, I can work on that.

Should I open both an issue and a PR or only a PR ?

[ondratra]

Hello there. Has this feature been added in the end or is it yet to be implemented?

[vtvz]

I guess I found a way:

    Expr::tuple([
        Column::One.into_simple_expr(),
        Column::Two.into_simple_expr(),
    ])
    .in_tuples([
        ["one_value_1", "two_value_1"],
        ["one_value_2", "two_value_2"],
    ]);

For "not in" is a bit harder, cause we don't have not_in_tuples helper:

    SimpleExpr::Binary(
        Box::new(SimpleExpr::Tuple(vec![
            Column::One.into_simple_expr(),
            Column::Two.into_simple_expr(),
        ])),
        BinOper::NotIn,
        Box::new(SimpleExpr::Tuple(vec![
            SimpleExpr::Values(vec![
                "one_value_1".into(),
                "two_value_1".into(),
            ]),
            SimpleExpr::Values(vec![
                "one_value_2".into(),
                "two_value_2".into(),
            ]),
        ])),
    );