如何实现下面的AND与OR的优先级？ about gorm HOT 2 CLOSED

@JaneMeary change your code to the following:

        conditions := []struct {
                GoodsID      string
                PurchaseType int
        }{
                {"33B3AFBAF000", 1},
                {"33B3AFBAF001", 1},
        }
        // 初始 where 条件
        query := db.Where("buyer_id = ?", "test")

        sub_query := db
        // 动态构建 OR 条件
        for _, condition := range conditions {
                sub_query = sub_query.Or("goods_id = ? AND purchase_type = ?", condition.GoodsID, condition.PurchaseType)
        }
        query = query.Where(sub_query)
        // 执行删除操作
        err := query.Delete(&User{}).Error

It works with version v1.25.9, try testing the codes with your verison first.

from gorm.

@JaneMeary change your code to the following:

        conditions := []struct {
                GoodsID      string
                PurchaseType int
        }{
                {"33B3AFBAF000", 1},
                {"33B3AFBAF001", 1},
        }
        // 初始 where 条件
        query := db.Where("buyer_id = ?", "test")

        sub_query := db
        // 动态构建 OR 条件
        for _, condition := range conditions {
                sub_query = sub_query.Or("goods_id = ? AND purchase_type = ?", condition.GoodsID, condition.PurchaseType)
        }
        query = query.Where(sub_query)
        // 执行删除操作
        err := query.Delete(&User{}).Error

It works with version v1.25.9, try testing the codes with your verison first.

非常感谢，这样是可以的。

from gorm.