我试图做与所选列的多个表的联合,并运行where子句和按子句对结果集排序。我如何用GORM (Golang)写这个
我尝试了以下代码片段,但没有在DB查询中运行where子句和order by子句:
var union []map[string]interface{}
database.CONNECTION.Raw("? UNION ?",
database.CONNECTION.Select(ContentAttributes).Model(&model1{}),
database.CONNECTION.Select(ContentAttributes).Model(&model2{}),
).Where("id > ?", 1).Order("Name").Scan(&union)
注意:ContentAttributes
是包含我想要选择的属性的字符串切片。
它正在运行以下查询:
SELECT "id","name","created_at","updated_at" FROM "model1" WHERE "model1"."deleted_at" IS NULL UNION SELECT "id","name","created_at","updated_at" FROM "model2" WHERE "model2"."deleted_at" IS NULL
我希望在联合结果集上运行where条件和order by子句。但它只是做了并集,并在union
变量中收集了结果。请建议一种方法。
不确定这是否是最干净的方法,但它确实有效。
var db = database.CONNECTION
var union []map[string]interface{}
var raw = "SELECT * (? UNION ?) union WHERE union.id > ? ORDER BY union.name"
db.Raw(raw,
db.Select("*").Model(&model1{}),
db.Select("*").Model(&model2{}),
1
).Scan(&union)