loadbalancerbackendgroupresource.go 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  1. // Copyright 2019 Yunion
  2. //
  3. // Licensed under the Apache License, Version 2.0 (the "License");
  4. // you may not use this file except in compliance with the License.
  5. // You may obtain a copy of the License at
  6. //
  7. // http://www.apache.org/licenses/LICENSE-2.0
  8. //
  9. // Unless required by applicable law or agreed to in writing, software
  10. // distributed under the License is distributed on an "AS IS" BASIS,
  11. // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12. // See the License for the specific language governing permissions and
  13. // limitations under the License.
  14. package models
  15. import (
  16. "context"
  17. "yunion.io/x/jsonutils"
  18. "yunion.io/x/log"
  19. "yunion.io/x/pkg/errors"
  20. "yunion.io/x/pkg/util/reflectutils"
  21. "yunion.io/x/sqlchemy"
  22. api "yunion.io/x/onecloud/pkg/apis/compute"
  23. "yunion.io/x/onecloud/pkg/cloudcommon/db"
  24. "yunion.io/x/onecloud/pkg/cloudcommon/validators"
  25. "yunion.io/x/onecloud/pkg/httperrors"
  26. "yunion.io/x/onecloud/pkg/mcclient"
  27. "yunion.io/x/onecloud/pkg/util/stringutils2"
  28. )
  29. type SLoadbalancerBackendgroupResourceBase struct {
  30. // 负载均衡后端组ID
  31. BackendGroupId string `width:"36" charset:"ascii" nullable:"true" list:"user" create:"optional" json:"backend_group_id"`
  32. }
  33. type SLoadbalancerBackendgroupResourceBaseManager struct {
  34. SLoadbalancerResourceBaseManager
  35. }
  36. func (self *SLoadbalancerBackendgroupResourceBase) GetLoadbalancerBackendGroup() (*SLoadbalancerBackendGroup, error) {
  37. w, err := LoadbalancerBackendGroupManager.FetchById(self.BackendGroupId)
  38. if err != nil {
  39. return nil, err
  40. }
  41. return w.(*SLoadbalancerBackendGroup), nil
  42. }
  43. func (self *SLoadbalancerBackendgroupResourceBase) GetLoadbalancer() (*SLoadbalancer, error) {
  44. lbbg, err := self.GetLoadbalancerBackendGroup()
  45. if err != nil {
  46. return nil, err
  47. }
  48. return lbbg.GetLoadbalancer()
  49. }
  50. func (self *SLoadbalancerBackendgroupResourceBase) GetVpc() (*SVpc, error) {
  51. lb, err := self.GetLoadbalancer()
  52. if err != nil {
  53. return nil, errors.Wrapf(err, "GetLoadbalancer")
  54. }
  55. return lb.GetVpc()
  56. }
  57. func (self *SLoadbalancerBackendgroupResourceBase) GetCloudprovider() (*SCloudprovider, error) {
  58. lb, err := self.GetLoadbalancer()
  59. if err != nil {
  60. return nil, err
  61. }
  62. return lb.GetCloudprovider(), nil
  63. }
  64. func (self *SLoadbalancerBackendgroupResourceBase) GetProviderName() string {
  65. lb, err := self.GetLoadbalancer()
  66. if err != nil {
  67. return ""
  68. }
  69. return lb.SManagedResourceBase.GetProviderName()
  70. }
  71. func (self *SLoadbalancerBackendgroupResourceBase) GetRegion() (*SCloudregion, error) {
  72. vpc, err := self.GetVpc()
  73. if err != nil {
  74. return nil, err
  75. }
  76. return vpc.GetRegion()
  77. }
  78. func (self *SLoadbalancerBackendgroupResourceBase) GetZone() (*SZone, error) {
  79. lb, err := self.GetLoadbalancer()
  80. if err != nil {
  81. return nil, err
  82. }
  83. return lb.GetZone()
  84. }
  85. func (manager *SLoadbalancerBackendgroupResourceBaseManager) FetchCustomizeColumns(
  86. ctx context.Context,
  87. userCred mcclient.TokenCredential,
  88. query jsonutils.JSONObject,
  89. objs []interface{},
  90. fields stringutils2.SSortedStrings,
  91. isList bool,
  92. ) []api.LoadbalancerBackendGroupResourceInfo {
  93. rows := make([]api.LoadbalancerBackendGroupResourceInfo, len(objs))
  94. lbbgIds := make([]string, len(objs))
  95. for i := range objs {
  96. var base *SLoadbalancerBackendgroupResourceBase
  97. reflectutils.FindAnonymouStructPointer(objs[i], &base)
  98. if base != nil {
  99. lbbgIds[i] = base.BackendGroupId
  100. }
  101. }
  102. lbbgs := make(map[string]SLoadbalancerBackendGroup)
  103. err := db.FetchStandaloneObjectsByIds(LoadbalancerBackendGroupManager, lbbgIds, &lbbgs)
  104. if err != nil {
  105. log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
  106. return rows
  107. }
  108. lbList := make([]interface{}, len(rows))
  109. for i := range rows {
  110. rows[i] = api.LoadbalancerBackendGroupResourceInfo{}
  111. if lbbg, ok := lbbgs[lbbgIds[i]]; ok {
  112. rows[i].BackendGroup = lbbg.Name
  113. rows[i].LoadbalancerId = lbbg.LoadbalancerId
  114. }
  115. lbList[i] = &SLoadbalancerResourceBase{rows[i].LoadbalancerId}
  116. }
  117. lbRows := manager.SLoadbalancerResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, lbList, fields, isList)
  118. for i := range rows {
  119. rows[i].LoadbalancerResourceInfo = lbRows[i]
  120. }
  121. return rows
  122. }
  123. func (manager *SLoadbalancerBackendgroupResourceBaseManager) ListItemFilter(
  124. ctx context.Context,
  125. q *sqlchemy.SQuery,
  126. userCred mcclient.TokenCredential,
  127. query api.LoadbalancerBackendGroupFilterListInput,
  128. ) (*sqlchemy.SQuery, error) {
  129. if len(query.BackendGroupId) > 0 {
  130. _, err := validators.ValidateModel(ctx, userCred, LoadbalancerBackendGroupManager, &query.BackendGroupId)
  131. if err != nil {
  132. return nil, err
  133. }
  134. q = q.Equals("backend_group_id", query.BackendGroupId)
  135. }
  136. lbbgQ := LoadbalancerBackendGroupManager.Query("id").Snapshot()
  137. lbbgQ, err := manager.SLoadbalancerResourceBaseManager.ListItemFilter(ctx, lbbgQ, userCred, query.LoadbalancerFilterListInput)
  138. if err != nil {
  139. return nil, errors.Wrap(err, "SLoadbalancerResourceBaseManager.ListItemFilter")
  140. }
  141. if lbbgQ.IsAltered() {
  142. q = q.Filter(sqlchemy.In(q.Field("backend_group_id"), lbbgQ.SubQuery()))
  143. }
  144. return q, nil
  145. }
  146. func (manager *SLoadbalancerBackendgroupResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  147. if field == "backend_group" {
  148. lbbgQuery := LoadbalancerBackendGroupManager.Query("name", "id").Distinct().SubQuery()
  149. q.AppendField(lbbgQuery.Field("name", field))
  150. q = q.Join(lbbgQuery, sqlchemy.Equals(q.Field("backend_group_id"), lbbgQuery.Field("id")))
  151. q.GroupBy(lbbgQuery.Field("name"))
  152. return q, nil
  153. } else {
  154. lbbgs := LoadbalancerBackendGroupManager.Query("id", "loadbalancer_id").SubQuery()
  155. q = q.LeftJoin(lbbgs, sqlchemy.Equals(q.Field("backend_id"), lbbgs.Field("id")))
  156. q, err := manager.SLoadbalancerResourceBaseManager.QueryDistinctExtraField(q, field)
  157. if err == nil {
  158. return q, nil
  159. }
  160. }
  161. return q, httperrors.ErrNotFound
  162. }
  163. func (manager *SLoadbalancerBackendgroupResourceBaseManager) OrderByExtraFields(
  164. ctx context.Context,
  165. q *sqlchemy.SQuery,
  166. userCred mcclient.TokenCredential,
  167. query api.LoadbalancerBackendGroupFilterListInput,
  168. ) (*sqlchemy.SQuery, error) {
  169. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  170. return q, nil
  171. }
  172. orderQ := LoadbalancerBackendGroupManager.Query("id")
  173. orderSubQ := orderQ.SubQuery()
  174. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  175. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("backend_group_id"), orderSubQ.Field("id")))
  176. q = db.OrderByFields(q, orders, fields)
  177. return q, nil
  178. }
  179. func (manager *SLoadbalancerBackendgroupResourceBaseManager) GetOrderBySubQuery(
  180. q *sqlchemy.SQuery,
  181. subq *sqlchemy.SSubQuery,
  182. joinField sqlchemy.IQueryField,
  183. userCred mcclient.TokenCredential,
  184. query api.LoadbalancerBackendGroupFilterListInput,
  185. orders []string,
  186. fields []sqlchemy.IQueryField,
  187. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  188. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  189. return q, orders, fields
  190. }
  191. lbbgQ := LoadbalancerBackendGroupManager.Query().SubQuery()
  192. q = q.LeftJoin(lbbgQ, sqlchemy.Equals(joinField, lbbgQ.Field("id")))
  193. q = q.AppendField(lbbgQ.Field("name").Label("backend_group"))
  194. orders = append(orders, query.OrderByBackendGroup)
  195. fields = append(fields, subq.Field("backend_group"))
  196. q, orders, fields = manager.SLoadbalancerResourceBaseManager.GetOrderBySubQuery(q, subq, lbbgQ.Field("loadbalancer_id"), userCred, query.LoadbalancerFilterListInput, orders, fields)
  197. return q, orders, fields
  198. }
  199. func (manager *SLoadbalancerBackendgroupResourceBaseManager) GetOrderByFields(query api.LoadbalancerBackendGroupFilterListInput) []string {
  200. fields := make([]string, 0)
  201. lbFields := manager.SLoadbalancerResourceBaseManager.GetOrderByFields(query.LoadbalancerFilterListInput)
  202. fields = append(fields, lbFields...)
  203. fields = append(fields, query.OrderByBackendGroup)
  204. return fields
  205. }
  206. func (manager *SLoadbalancerBackendgroupResourceBaseManager) ListItemExportKeys(ctx context.Context,
  207. q *sqlchemy.SQuery,
  208. userCred mcclient.TokenCredential,
  209. keys stringutils2.SSortedStrings,
  210. ) (*sqlchemy.SQuery, error) {
  211. if keys.ContainsAny(manager.GetExportKeys()...) {
  212. var err error
  213. subq := LoadbalancerBackendGroupManager.Query("id", "name", "loadbalancer_id").SubQuery()
  214. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("backend_group_id"), subq.Field("id")))
  215. if keys.Contains("backend_group") {
  216. q = q.AppendField(subq.Field("name", "backend_group"))
  217. }
  218. if keys.ContainsAny(manager.SLoadbalancerResourceBaseManager.GetExportKeys()...) {
  219. q, err = manager.SLoadbalancerResourceBaseManager.ListItemExportKeys(ctx, q, userCred, keys)
  220. if err != nil {
  221. return nil, errors.Wrap(err, "SLoadbalancerResourceBaseManager.ListItemExportKeys")
  222. }
  223. }
  224. }
  225. return q, nil
  226. }
  227. func (manager *SLoadbalancerBackendgroupResourceBaseManager) GetExportKeys() []string {
  228. keys := []string{"backend_group"}
  229. keys = append(keys, manager.SLoadbalancerResourceBaseManager.GetExportKeys()...)
  230. return keys
  231. }