關聯查詢 · PHP/Python/前端/Linux 等等學習筆記

[TOC] ## 案例一 find查找 [推薦] ``` type HS_USER_TREE struct { TREE_ID string DEPT_ID string DEPT_CODE string USER_ID string USER_NAME string POSITION_ID string USER_ORDER_ID string } type USER_TREE_WITH_USER struct { HS_USER_TREE `xorm:"extends"` HS_USER HS_USER `xorm:"extends"` } type HS_USER struct { USER_ID string USER_LOGIN string USER_NAME string USER_STATUS string USER_ORDER_ID string } //通過dept 獲取 users func GetUserByDeptid(deptId interface{}) ([]USER_TREE_WITH_USER, int64) { trees := make([]USER_TREE_WITH_USER, 0) num, e := Saas.Table(new(HS_USER_TREE)).Join("INNER", new(HS_USER), "HS_USER_TREE.USER_ID=HS_USER.USER_ID").Where(builder.Eq{"HS_USER.USER_STATUS": "1"}).FindAndCount(&trees, &HS_USER_TREE{DEPT_ID: deptId.(string)}) if e != nil { beego.Error("通過dept 獲取 users error ", e) } return trees, num } ``` ## 案例一 get 查找 [推薦] 省略其他代碼,與find 相同,關鍵在于查詢條件那個當作 `Table()`中的表名 ``` dept := new(USER_TREE_WITH_DEPT) dept.HS_USER_TREE.USER_ID = userId _, e := Saas.Table(new(HS_USER_TREE)).Join("INNER", new(HS_DEPT), "HS_DEPT.DEPT_ID=HS_USER_TREE.DEPT_ID").Get(dept) ``` ## 案例三[不推薦] 存在的問題是所有調用 `HS_USER_TREE`都會受到`HS_USER`的影響,所以并不推薦 ``` type HS_USER_TREE struct { TREE_ID string DEPT_ID string DEPT_CODE string USER_ID string USER_NAME string POSITION_ID string USER_ORDER_ID string HS_USER HS_USER `xorm:"extends"` } type HS_USER struct { USER_ID string USER_LOGIN string USER_NAME string USER_STATUS string USER_ORDER_ID string } //通過dept 獲取 users func GetUserByDeptid(deptId interface{}) ([]HS_USER_TREE, int64) { trees := make([]HS_USER_TREE, 0) //方法一使用where num, e := Saas.Join("INNER", new(HS_USER), "HS_USER_TREE.USER_ID=HS_USER.USER_ID").In(new(HS_USER_TREE).DEPT_ID, deptId).FindAndCount(&trees) //方法二單個表的條件 num, e := Saas.Join("INNER", new(HS_USER), "HS_USER_TREE.USER_ID=HS_USER.USER_ID").FindAndCount(&trees, &HS_USER{USER_NAME: "趙昂然"}) //方法三多張表的條件 num, e := Saas.Join("INNER", new(HS_USER), "HS_USER_TREE.USER_ID=HS_USER.USER_ID").FindAndCount(&trees, &HS_USER_TREE{DEPT_ID: deptId.(string), HS_USER: HS_USER{USER_NAME: "趙昂然"}}) if e != nil { beego.Error("通過dept 獲取 users error ", e) } return trees, num } ``` ```