loadbalanceraclresource.go 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  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 SLoadbalancerAclResourceBase struct {
  30. // 本地Acl ID
  31. AclId string `width:"36" charset:"ascii" nullable:"true" list:"user" create:"optional" update:"user"`
  32. }
  33. type SLoadbalancerAclResourceBaseManager struct{}
  34. func (self *SLoadbalancerAclResourceBase) GetAcl() (*SLoadbalancerAcl, error) {
  35. acl, err := LoadbalancerAclManager.FetchById(self.AclId)
  36. if err != nil {
  37. return nil, errors.Wrapf(err, "GetAcl.FetchById(%s)", self.AclId)
  38. }
  39. return acl.(*SLoadbalancerAcl), nil
  40. }
  41. func (manager *SLoadbalancerAclResourceBaseManager) FetchCustomizeColumns(
  42. ctx context.Context,
  43. userCred mcclient.TokenCredential,
  44. query jsonutils.JSONObject,
  45. objs []interface{},
  46. fields stringutils2.SSortedStrings,
  47. isList bool,
  48. ) []api.LoadbalancerAclResourceInfo {
  49. rows := make([]api.LoadbalancerAclResourceInfo, len(objs))
  50. aclIds := make([]string, len(objs))
  51. for i := range objs {
  52. var base *SLoadbalancerAclResourceBase
  53. err := reflectutils.FindAnonymouStructPointer(objs[i], &base)
  54. if err != nil {
  55. log.Errorf("Cannot find SCloudregionResourceBase in object %s", objs[i])
  56. continue
  57. }
  58. aclIds[i] = base.AclId
  59. }
  60. acls := make(map[string]SLoadbalancerAcl)
  61. err := db.FetchStandaloneObjectsByIds(LoadbalancerAclManager, aclIds, &acls)
  62. if err != nil {
  63. log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
  64. return rows
  65. }
  66. for i := range rows {
  67. rows[i] = api.LoadbalancerAclResourceInfo{}
  68. if acl, ok := acls[aclIds[i]]; ok {
  69. rows[i].Acl = acl.Name
  70. }
  71. }
  72. return rows
  73. }
  74. func (manager *SLoadbalancerAclResourceBaseManager) ListItemFilter(
  75. ctx context.Context,
  76. q *sqlchemy.SQuery,
  77. userCred mcclient.TokenCredential,
  78. query api.LoadbalancerAclFilterListInput,
  79. ) (*sqlchemy.SQuery, error) {
  80. if len(query.AclId) > 0 {
  81. _, err := validators.ValidateModel(ctx, userCred, LoadbalancerAclManager, &query.AclId)
  82. if err != nil {
  83. return nil, err
  84. }
  85. q = q.Equals("acl_id", query.AclId)
  86. }
  87. return q, nil
  88. }
  89. func (manager *SLoadbalancerAclResourceBaseManager) OrderByExtraFields(
  90. ctx context.Context,
  91. q *sqlchemy.SQuery,
  92. userCred mcclient.TokenCredential,
  93. query api.LoadbalancerAclFilterListInput,
  94. ) (*sqlchemy.SQuery, error) {
  95. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  96. return q, nil
  97. }
  98. orderQ := LoadbalancerAclManager.Query("id")
  99. orderSubQ := orderQ.SubQuery()
  100. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  101. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("acl_id"), orderSubQ.Field("id")))
  102. q = db.OrderByFields(q, orders, fields)
  103. return q, nil
  104. }
  105. func (manager *SLoadbalancerAclResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  106. if field == "acl" {
  107. aclQuery := LoadbalancerAclManager.Query("name", "id").Distinct().SubQuery()
  108. q.AppendField(aclQuery.Field("name", field))
  109. q = q.Join(aclQuery, sqlchemy.Equals(q.Field("acl_id"), aclQuery.Field("id")))
  110. q.GroupBy(aclQuery.Field("name"))
  111. return q, nil
  112. }
  113. return q, httperrors.ErrNotFound
  114. }
  115. func (manager *SLoadbalancerAclResourceBaseManager) GetOrderBySubQuery(
  116. q *sqlchemy.SQuery,
  117. subq *sqlchemy.SSubQuery,
  118. joinField sqlchemy.IQueryField,
  119. userCred mcclient.TokenCredential,
  120. query api.LoadbalancerAclFilterListInput,
  121. orders []string,
  122. fields []sqlchemy.IQueryField,
  123. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  124. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  125. return q, orders, fields
  126. }
  127. aclQ := LoadbalancerAclManager.Query().SubQuery()
  128. q = q.LeftJoin(aclQ, sqlchemy.Equals(joinField, aclQ.Field("id")))
  129. q = q.AppendField(aclQ.Field("name").Label("acl"))
  130. orders = append(orders, query.OrderByAcl)
  131. fields = append(fields, subq.Field("acl"))
  132. return q, orders, fields
  133. }
  134. func (manager *SLoadbalancerAclResourceBaseManager) GetOrderByFields(query api.LoadbalancerAclFilterListInput) []string {
  135. return []string{query.OrderByAcl}
  136. }
  137. func (manager *SLoadbalancerAclResourceBaseManager) ListItemExportKeys(ctx context.Context,
  138. q *sqlchemy.SQuery,
  139. userCred mcclient.TokenCredential,
  140. keys stringutils2.SSortedStrings,
  141. ) (*sqlchemy.SQuery, error) {
  142. if keys.ContainsAny(manager.GetExportKeys()...) {
  143. subq := LoadbalancerAclManager.Query("id", "name").SubQuery()
  144. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("acl_id"), subq.Field("id")))
  145. if keys.Contains("acl") {
  146. q = q.AppendField(subq.Field("name", "acl"))
  147. }
  148. }
  149. return q, nil
  150. }
  151. func (manager *SLoadbalancerAclResourceBaseManager) GetExportKeys() []string {
  152. return []string{"acl"}
  153. }