access_group_resource.go 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  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 SAccessGroupResourceBase struct {
  30. // 权限组Id
  31. AccessGroupId string `width:"36" charset:"ascii" nullable:"false" create:"required" index:"true" list:"user"`
  32. }
  33. type SAccessGroupResourceBaseManager struct{}
  34. func (self *SAccessGroupResourceBase) GetAccessGroup() (*SAccessGroup, error) {
  35. group, err := AccessGroupManager.FetchById(self.AccessGroupId)
  36. if err != nil {
  37. return nil, errors.Wrapf(err, "AccessGroupManager.FetchById(%s)", self.AccessGroupId)
  38. }
  39. return group.(*SAccessGroup), nil
  40. }
  41. func (manager *SAccessGroupResourceBaseManager) 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.AccessGroupResourceInfo {
  49. rows := make([]api.AccessGroupResourceInfo, len(objs))
  50. groupIds := make([]string, len(objs))
  51. for i := range objs {
  52. var base *SAccessGroupResourceBase
  53. err := reflectutils.FindAnonymouStructPointer(objs[i], &base)
  54. if err != nil {
  55. log.Errorf("Cannot find SAccessGroupResourceBase in object %s", objs[i])
  56. continue
  57. }
  58. groupIds[i] = base.AccessGroupId
  59. }
  60. groupNames, err := db.FetchIdNameMap2(AccessGroupManager, groupIds)
  61. if err != nil {
  62. return rows
  63. }
  64. for i := range rows {
  65. rows[i].AccessGroup, _ = groupNames[groupIds[i]]
  66. }
  67. return rows
  68. }
  69. func (manager *SAccessGroupResourceBaseManager) ListItemFilter(
  70. ctx context.Context,
  71. q *sqlchemy.SQuery,
  72. userCred mcclient.TokenCredential,
  73. query api.AccessGroupFilterListInput,
  74. ) (*sqlchemy.SQuery, error) {
  75. if len(query.AccessGroupId) > 0 {
  76. _, err := validators.ValidateModel(ctx, userCred, AccessGroupManager, &query.AccessGroupId)
  77. if err != nil {
  78. return nil, err
  79. }
  80. q = q.Equals("access_group_id", query.AccessGroupId)
  81. }
  82. return q, nil
  83. }
  84. func (manager *SAccessGroupResourceBaseManager) OrderByExtraFields(
  85. ctx context.Context,
  86. q *sqlchemy.SQuery,
  87. userCred mcclient.TokenCredential,
  88. query api.AccessGroupFilterListInput,
  89. ) (*sqlchemy.SQuery, error) {
  90. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  91. return q, nil
  92. }
  93. orderQ := AccessGroupManager.Query("id")
  94. orderSubQ := orderQ.SubQuery()
  95. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  96. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("access_group_id"), orderSubQ.Field("id")))
  97. q = db.OrderByFields(q, orders, fields)
  98. return q, nil
  99. }
  100. func (manager *SAccessGroupResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  101. if field == "access_group" {
  102. groupQuery := AccessGroupManager.Query("name", "id").Distinct().SubQuery()
  103. q.AppendField(groupQuery.Field("name", field))
  104. q = q.Join(groupQuery, sqlchemy.Equals(q.Field("access_group_id"), groupQuery.Field("id")))
  105. q.GroupBy(groupQuery.Field("name"))
  106. return q, nil
  107. }
  108. return q, httperrors.ErrNotFound
  109. }
  110. func (manager *SAccessGroupResourceBaseManager) GetOrderBySubQuery(
  111. q *sqlchemy.SQuery,
  112. subq *sqlchemy.SSubQuery,
  113. joinField sqlchemy.IQueryField,
  114. userCred mcclient.TokenCredential,
  115. query api.AccessGroupFilterListInput,
  116. orders []string,
  117. fields []sqlchemy.IQueryField,
  118. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  119. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  120. return q, orders, fields
  121. }
  122. groupQ := AccessGroupManager.Query().SubQuery()
  123. q = q.LeftJoin(groupQ, sqlchemy.Equals(joinField, groupQ.Field("id")))
  124. q = q.AppendField(groupQ.Field("name").Label("access_group"))
  125. orders = append(orders, query.OrderByAccessGroup)
  126. fields = append(fields, subq.Field("access_group"))
  127. return q, orders, fields
  128. }
  129. func (manager *SAccessGroupResourceBaseManager) GetOrderByFields(query api.AccessGroupFilterListInput) []string {
  130. return []string{query.OrderByAccessGroup}
  131. }
  132. func (manager *SAccessGroupResourceBaseManager) ListItemExportKeys(ctx context.Context,
  133. q *sqlchemy.SQuery,
  134. userCred mcclient.TokenCredential,
  135. keys stringutils2.SSortedStrings,
  136. ) (*sqlchemy.SQuery, error) {
  137. if keys.ContainsAny(manager.GetExportKeys()...) {
  138. subq := AccessGroupManager.Query("id", "name").SubQuery()
  139. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("access_group_id"), subq.Field("id")))
  140. q = q.AppendField(subq.Field("name", "access_group"))
  141. }
  142. return q, nil
  143. }
  144. func (manager *SAccessGroupResourceBaseManager) GetExportKeys() []string {
  145. return []string{"access_group"}
  146. }