project_mapping_resource.go 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  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/tristate"
  21. "yunion.io/x/pkg/util/reflectutils"
  22. "yunion.io/x/sqlchemy"
  23. api "yunion.io/x/onecloud/pkg/apis/compute"
  24. "yunion.io/x/onecloud/pkg/cloudcommon/db"
  25. "yunion.io/x/onecloud/pkg/cloudcommon/validators"
  26. "yunion.io/x/onecloud/pkg/httperrors"
  27. "yunion.io/x/onecloud/pkg/mcclient"
  28. "yunion.io/x/onecloud/pkg/util/stringutils2"
  29. )
  30. type SProjectMappingResourceBase struct {
  31. ProjectMappingId string `width:"36" charset:"ascii" nullable:"true" create:"optional" index:"true" list:"user" json:"project_mapping_id"`
  32. EnableProjectSync tristate.TriState `default:"false" list:"user" create:"optional"`
  33. EnableResourceSync tristate.TriState `default:"true" list:"user" create:"optional"`
  34. }
  35. type SProjectMappingResourceBaseManager struct{}
  36. func (manager *SProjectMappingResourceBaseManager) ValidateCreateData(
  37. ctx context.Context,
  38. userCred mcclient.TokenCredential,
  39. ownerId mcclient.IIdentityProvider,
  40. query jsonutils.JSONObject,
  41. input api.SProjectMappingResourceInput,
  42. ) (api.SProjectMappingResourceInput, error) {
  43. if len(input.ProjectMappingId) > 0 {
  44. _, err := validators.ValidateModel(ctx, userCred, ProjectMappingManager, &input.ProjectMappingId)
  45. if err != nil {
  46. return input, err
  47. }
  48. }
  49. return input, nil
  50. }
  51. func (self *SProjectMappingResourceBase) GetProjectMapping() (*SProjectMapping, error) {
  52. pm, err := ProjectMappingManager.FetchById(self.ProjectMappingId)
  53. if err != nil {
  54. return nil, errors.Wrapf(err, "FetchById")
  55. }
  56. return pm.(*SProjectMapping), nil
  57. }
  58. func (manager *SProjectMappingResourceBaseManager) FetchCustomizeColumns(
  59. ctx context.Context,
  60. userCred mcclient.TokenCredential,
  61. query jsonutils.JSONObject,
  62. objs []interface{},
  63. fields stringutils2.SSortedStrings,
  64. isList bool,
  65. ) []api.ProjectMappingResourceInfo {
  66. rows := make([]api.ProjectMappingResourceInfo, len(objs))
  67. pmIds := make([]string, len(objs))
  68. for i := range objs {
  69. var base *SProjectMappingResourceBase
  70. err := reflectutils.FindAnonymouStructPointer(objs[i], &base)
  71. if err != nil {
  72. log.Errorf("Cannot find SProjectMappingResourceBase in object %s", objs[i])
  73. continue
  74. }
  75. pmIds[i] = base.ProjectMappingId
  76. }
  77. pmNames, err := db.FetchIdNameMap2(ProjectMappingManager, pmIds)
  78. if err != nil {
  79. log.Errorf("FetchIdNameMap2 fail %s", err)
  80. return rows
  81. }
  82. for i := range rows {
  83. if name, ok := pmNames[pmIds[i]]; ok {
  84. rows[i].ProjectMapping = name
  85. }
  86. }
  87. return rows
  88. }
  89. func (manager *SProjectMappingResourceBaseManager) ListItemFilter(
  90. ctx context.Context,
  91. q *sqlchemy.SQuery,
  92. userCred mcclient.TokenCredential,
  93. query api.ProjectMappingFilterListInput,
  94. ) (*sqlchemy.SQuery, error) {
  95. if len(query.ProjectMappingId) > 0 {
  96. _, err := validators.ValidateModel(ctx, userCred, ProjectMappingManager, &query.ProjectMappingId)
  97. if err != nil {
  98. return nil, err
  99. }
  100. q = q.Equals("project_mapping_id", query.ProjectMappingId)
  101. }
  102. return q, nil
  103. }
  104. func (manager *SProjectMappingResourceBaseManager) OrderByExtraFields(
  105. ctx context.Context,
  106. q *sqlchemy.SQuery,
  107. userCred mcclient.TokenCredential,
  108. query api.ProjectMappingFilterListInput,
  109. ) (*sqlchemy.SQuery, error) {
  110. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  111. return q, nil
  112. }
  113. orderQ := ProjectMappingManager.Query("id")
  114. orderSubQ := orderQ.SubQuery()
  115. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  116. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("project_mapping_id"), orderSubQ.Field("id")))
  117. q = db.OrderByFields(q, orders, fields)
  118. return q, nil
  119. }
  120. func (manager *SProjectMappingResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  121. if field == "project_mapping" {
  122. mpQuery := ProjectMappingManager.Query("name", "id").Distinct().SubQuery()
  123. q.AppendField(mpQuery.Field("name", field))
  124. q = q.Join(mpQuery, sqlchemy.Equals(q.Field("project_mapping_id"), mpQuery.Field("id")))
  125. q.GroupBy(mpQuery.Field("name"))
  126. return q, nil
  127. }
  128. return q, httperrors.ErrNotFound
  129. }
  130. func (manager *SProjectMappingResourceBaseManager) GetOrderBySubQuery(
  131. q *sqlchemy.SQuery,
  132. subq *sqlchemy.SSubQuery,
  133. joinField sqlchemy.IQueryField,
  134. userCred mcclient.TokenCredential,
  135. query api.ProjectMappingFilterListInput,
  136. orders []string,
  137. fields []sqlchemy.IQueryField,
  138. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  139. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  140. return q, orders, fields
  141. }
  142. mpQ := ProjectMappingManager.Query().SubQuery()
  143. q = q.LeftJoin(mpQ, sqlchemy.Equals(joinField, mpQ.Field("id")))
  144. q = q.AppendField(mpQ.Field("name").Label("project_mapping"))
  145. orders = append(orders, query.OrderByProjectMapping)
  146. fields = append(fields, subq.Field("project_mapping"))
  147. return q, orders, fields
  148. }
  149. func (manager *SProjectMappingResourceBaseManager) GetOrderByFields(query api.ProjectMappingFilterListInput) []string {
  150. return []string{query.OrderByProjectMapping}
  151. }
  152. func (manager *SProjectMappingResourceBaseManager) ListItemExportKeys(ctx context.Context,
  153. q *sqlchemy.SQuery,
  154. userCred mcclient.TokenCredential,
  155. keys stringutils2.SSortedStrings,
  156. ) (*sqlchemy.SQuery, error) {
  157. if keys.ContainsAny(manager.GetExportKeys()...) {
  158. subq := ProjectMappingManager.Query("id", "name").SubQuery()
  159. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("project_mapping_id"), subq.Field("id")))
  160. q = q.AppendField(subq.Field("name", "project_mapping"))
  161. }
  162. return q, nil
  163. }
  164. func (manager *SProjectMappingResourceBaseManager) GetExportKeys() []string {
  165. return []string{"project_mapping"}
  166. }