natgatewayresource.go 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208
  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. "database/sql"
  18. "yunion.io/x/jsonutils"
  19. "yunion.io/x/log"
  20. "yunion.io/x/pkg/errors"
  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/httperrors"
  26. "yunion.io/x/onecloud/pkg/mcclient"
  27. "yunion.io/x/onecloud/pkg/util/stringutils2"
  28. )
  29. type SNatgatewayResourceBase struct {
  30. NatgatewayId string `width:"36" charset:"ascii" nullable:"false" list:"user" create:"required"`
  31. }
  32. type SNatgatewayResourceBaseManager struct {
  33. SVpcResourceBaseManager
  34. }
  35. func ValidateNatGatewayResourceInput(ctx context.Context, userCred mcclient.TokenCredential, input api.NatGatewayResourceInput) (*SNatGateway, api.NatGatewayResourceInput, error) {
  36. natObj, err := NatGatewayManager.FetchByIdOrName(ctx, userCred, input.NatgatewayId)
  37. if err != nil {
  38. if errors.Cause(err) == sql.ErrNoRows {
  39. return nil, input, errors.Wrapf(httperrors.ErrResourceNotFound, "%s %s", NatGatewayManager.Keyword(), input.NatgatewayId)
  40. } else {
  41. return nil, input, errors.Wrap(err, "NatGatewayManager.FetchByIdOrName")
  42. }
  43. }
  44. input.NatgatewayId = natObj.GetId()
  45. return natObj.(*SNatGateway), input, nil
  46. }
  47. func (self *SNatgatewayResourceBase) GetNatgateway() (*SNatGateway, error) {
  48. obj, err := NatGatewayManager.FetchById(self.NatgatewayId)
  49. if err != nil {
  50. return nil, errors.Wrap(err, "NatGatewayManager.FetchById")
  51. }
  52. return obj.(*SNatGateway), nil
  53. }
  54. func (self *SNatgatewayResourceBase) GetVpc() (*SVpc, error) {
  55. nat, err := self.GetNatgateway()
  56. if err != nil {
  57. return nil, errors.Wrapf(err, "self.GetNatgateway")
  58. }
  59. return nat.GetVpc()
  60. }
  61. func (manager *SNatgatewayResourceBaseManager) FetchCustomizeColumns(
  62. ctx context.Context,
  63. userCred mcclient.TokenCredential,
  64. query jsonutils.JSONObject,
  65. objs []interface{},
  66. fields stringutils2.SSortedStrings,
  67. isList bool,
  68. ) []api.NatGatewayResourceInfo {
  69. rows := make([]api.NatGatewayResourceInfo, len(objs))
  70. natIds := make([]string, len(objs))
  71. for i := range objs {
  72. var base *SNatgatewayResourceBase
  73. reflectutils.FindAnonymouStructPointer(objs[i], &base)
  74. if base != nil {
  75. natIds[i] = base.NatgatewayId
  76. }
  77. }
  78. nats := make(map[string]SNatGateway)
  79. err := db.FetchStandaloneObjectsByIds(NatGatewayManager, natIds, &nats)
  80. if err != nil {
  81. log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
  82. return rows
  83. }
  84. vpcList := make([]interface{}, len(rows))
  85. for i := range rows {
  86. rows[i] = api.NatGatewayResourceInfo{}
  87. if _, ok := nats[natIds[i]]; ok {
  88. rows[i].Natgateway = nats[natIds[i]].Name
  89. rows[i].VpcId = nats[natIds[i]].VpcId
  90. }
  91. vpcList[i] = &SVpcResourceBase{rows[i].VpcId}
  92. }
  93. vpcRows := manager.SVpcResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, vpcList, fields, isList)
  94. for i := range rows {
  95. rows[i].VpcResourceInfo = vpcRows[i]
  96. }
  97. return rows
  98. }
  99. func (manager *SNatgatewayResourceBaseManager) ListItemFilter(
  100. ctx context.Context,
  101. q *sqlchemy.SQuery,
  102. userCred mcclient.TokenCredential,
  103. query api.NatGatewayFilterListInput,
  104. ) (*sqlchemy.SQuery, error) {
  105. if len(query.NatgatewayId) > 0 {
  106. natObj, _, err := ValidateNatGatewayResourceInput(ctx, userCred, query.NatGatewayResourceInput)
  107. if err != nil {
  108. return nil, errors.Wrap(err, "ValidateNatGatewayResourceInput")
  109. }
  110. q = q.Equals("natgateway_id", natObj.GetId())
  111. }
  112. subq := NatGatewayManager.Query("id").Snapshot()
  113. subq, err := manager.SVpcResourceBaseManager.ListItemFilter(ctx, subq, userCred, query.VpcFilterListInput)
  114. if err != nil {
  115. return nil, errors.Wrap(err, "SVpcResourceBaseManager.ListItemFilter")
  116. }
  117. if subq.IsAltered() {
  118. q = q.Filter(sqlchemy.In(q.Field("natgateway_id"), subq.SubQuery()))
  119. }
  120. return q, nil
  121. }
  122. func (manager *SNatgatewayResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  123. switch field {
  124. case "natgateway":
  125. natQuery := NatGatewayManager.Query("name", "id").Distinct().SubQuery()
  126. q.AppendField(natQuery.Field("name", field))
  127. q = q.Join(natQuery, sqlchemy.Equals(q.Field("natgateway_id"), natQuery.Field("id")))
  128. q.GroupBy(natQuery.Field("name"))
  129. return q, nil
  130. }
  131. nats := NatGatewayManager.Query("id", "vpc_id").SubQuery()
  132. q = q.LeftJoin(nats, sqlchemy.Equals(q.Field("natgateway_id"), nats.Field("id")))
  133. q, err := manager.SVpcResourceBaseManager.QueryDistinctExtraField(q, field)
  134. if err == nil {
  135. return q, nil
  136. }
  137. return q, httperrors.ErrNotFound
  138. }
  139. func (manager *SNatgatewayResourceBaseManager) OrderByExtraFields(
  140. ctx context.Context,
  141. q *sqlchemy.SQuery,
  142. userCred mcclient.TokenCredential,
  143. query api.NatGatewayFilterListInput,
  144. ) (*sqlchemy.SQuery, error) {
  145. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  146. return q, nil
  147. }
  148. orderQ := NatGatewayManager.Query("id")
  149. orderSubQ := orderQ.SubQuery()
  150. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  151. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("natgateway_id"), orderSubQ.Field("id")))
  152. q = db.OrderByFields(q, orders, fields)
  153. return q, nil
  154. }
  155. func (manager *SNatgatewayResourceBaseManager) GetOrderBySubQuery(
  156. q *sqlchemy.SQuery,
  157. subq *sqlchemy.SSubQuery,
  158. joinField sqlchemy.IQueryField,
  159. userCred mcclient.TokenCredential,
  160. query api.NatGatewayFilterListInput,
  161. orders []string,
  162. fields []sqlchemy.IQueryField,
  163. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  164. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  165. return q, orders, fields
  166. }
  167. natQ := NatGatewayManager.Query().SubQuery()
  168. q = q.LeftJoin(natQ, sqlchemy.Equals(joinField, natQ.Field("id")))
  169. q = q.AppendField(natQ.Field("name").Label("natgateway"))
  170. orders = append(orders, query.OrderByNatgateway)
  171. fields = append(fields, subq.Field("natgateway"))
  172. q, orders, fields = manager.SVpcResourceBaseManager.GetOrderBySubQuery(q, subq, natQ.Field("vpc_id"), userCred, query.VpcFilterListInput, orders, fields)
  173. return q, orders, fields
  174. }
  175. func (manager *SNatgatewayResourceBaseManager) GetOrderByFields(query api.NatGatewayFilterListInput) []string {
  176. fields := make([]string, 0)
  177. vpcFields := manager.SVpcResourceBaseManager.GetOrderByFields(query.VpcFilterListInput)
  178. fields = append(fields, vpcFields...)
  179. fields = append(fields, query.OrderByNatgateway)
  180. return fields
  181. }
  182. func (self *SNatgatewayResourceBase) GetChangeOwnerCandidateDomainIds() []string {
  183. nat, _ := self.GetNatgateway()
  184. if nat != nil {
  185. return nat.GetChangeOwnerCandidateDomainIds()
  186. }
  187. return nil
  188. }