loadbalancerresource.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347
  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 SLoadbalancerResourceBase struct {
  30. // 负载均衡ID
  31. LoadbalancerId string `width:"36" charset:"ascii" nullable:"true" list:"user" create:"optional"`
  32. }
  33. type SLoadbalancerResourceBaseManager struct {
  34. SVpcResourceBaseManager
  35. SZoneResourceBaseManager
  36. }
  37. func ValidateLoadbalancerResourceInput(ctx context.Context, userCred mcclient.TokenCredential, input api.LoadbalancerResourceInput) (*SLoadbalancer, api.LoadbalancerResourceInput, error) {
  38. lbObj, err := LoadbalancerManager.FetchByIdOrName(ctx, userCred, input.LoadbalancerId)
  39. if err != nil {
  40. if errors.Cause(err) == sql.ErrNoRows {
  41. return nil, input, errors.Wrapf(httperrors.ErrResourceNotFound, "%s %s", LoadbalancerManager.Keyword(), input.LoadbalancerId)
  42. } else {
  43. return nil, input, errors.Wrap(err, "LoadbalancerManager.FetchByIdOrName")
  44. }
  45. }
  46. input.LoadbalancerId = lbObj.GetId()
  47. return lbObj.(*SLoadbalancer), input, nil
  48. }
  49. func (self *SLoadbalancerResourceBase) GetLoadbalancer() (*SLoadbalancer, error) {
  50. w, err := LoadbalancerManager.FetchById(self.LoadbalancerId)
  51. if err != nil {
  52. return nil, err
  53. }
  54. return w.(*SLoadbalancer), nil
  55. }
  56. func (self *SLoadbalancerResourceBase) GetVpc() (*SVpc, error) {
  57. lb, err := self.GetLoadbalancer()
  58. if err != nil {
  59. return nil, err
  60. }
  61. return lb.GetVpc()
  62. }
  63. func (self *SLoadbalancerResourceBase) GetCloudprovider() *SCloudprovider {
  64. vpc, _ := self.GetVpc()
  65. if vpc != nil {
  66. return vpc.GetCloudprovider()
  67. }
  68. lb, _ := self.GetLoadbalancer()
  69. if lb != nil {
  70. return lb.GetCloudprovider()
  71. }
  72. return nil
  73. }
  74. func (self *SLoadbalancerResourceBase) GetCloudproviderId() string {
  75. cloudprovider := self.GetCloudprovider()
  76. if cloudprovider != nil {
  77. return cloudprovider.Id
  78. }
  79. return ""
  80. }
  81. func (self *SLoadbalancerResourceBase) GetProviderName() string {
  82. vpc, _ := self.GetVpc()
  83. if vpc != nil {
  84. return vpc.GetProviderName()
  85. }
  86. return ""
  87. }
  88. func (self *SLoadbalancerResourceBase) GetCloudaccount() *SCloudaccount {
  89. vpc, _ := self.GetVpc()
  90. if vpc != nil {
  91. return vpc.GetCloudaccount()
  92. }
  93. return nil
  94. }
  95. func (self *SLoadbalancerResourceBase) GetRegion() (*SCloudregion, error) {
  96. vpc, err := self.GetVpc()
  97. if err != nil {
  98. return nil, err
  99. }
  100. return vpc.GetRegion()
  101. }
  102. func (self *SLoadbalancerResourceBase) GetRegionId() string {
  103. region, _ := self.GetRegion()
  104. if region != nil {
  105. return region.Id
  106. }
  107. return ""
  108. }
  109. func (self *SLoadbalancerResourceBase) GetZone() (*SZone, error) {
  110. lb, err := self.GetLoadbalancer()
  111. if err != nil {
  112. return nil, err
  113. }
  114. return lb.GetZone()
  115. }
  116. func (manager *SLoadbalancerResourceBaseManager) FetchCustomizeColumns(
  117. ctx context.Context,
  118. userCred mcclient.TokenCredential,
  119. query jsonutils.JSONObject,
  120. objs []interface{},
  121. fields stringutils2.SSortedStrings,
  122. isList bool,
  123. ) []api.LoadbalancerResourceInfo {
  124. rows := make([]api.LoadbalancerResourceInfo, len(objs))
  125. lbIds := make([]string, len(objs))
  126. for i := range objs {
  127. var base *SLoadbalancerResourceBase
  128. err := reflectutils.FindAnonymouStructPointer(objs[i], &base)
  129. if err != nil {
  130. log.Errorf("Cannot find SLoadbalancerResourceBase in object %#v: %s", objs[i], err)
  131. continue
  132. }
  133. lbIds[i] = base.LoadbalancerId
  134. }
  135. lbs := make(map[string]SLoadbalancer)
  136. err := db.FetchStandaloneObjectsByIds(LoadbalancerManager, lbIds, &lbs)
  137. if err != nil {
  138. log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
  139. return nil
  140. }
  141. vpcList := make([]interface{}, len(rows))
  142. zoneList := make([]interface{}, len(rows))
  143. manList := make([]interface{}, len(rows))
  144. for i := range rows {
  145. rows[i] = api.LoadbalancerResourceInfo{}
  146. if lb, ok := lbs[lbIds[i]]; ok {
  147. rows[i].Loadbalancer = lb.Name
  148. rows[i].VpcId = lb.VpcId
  149. rows[i].ZoneId = lb.ZoneId
  150. rows[i].ManagerId = lb.ManagerId
  151. }
  152. vpcList[i] = &SVpcResourceBase{rows[i].VpcId}
  153. zoneList[i] = &SZoneResourceBase{rows[i].ZoneId}
  154. manList[i] = &SManagedResourceBase{rows[i].ManagerId}
  155. }
  156. vpcRows := manager.SVpcResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, vpcList, fields, isList)
  157. zoneRows := manager.SZoneResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, zoneList, fields, isList)
  158. manRows := manager.SManagedResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, manList, fields, isList)
  159. for i := range rows {
  160. rows[i].VpcResourceInfo = vpcRows[i]
  161. rows[i].ZoneResourceInfo = zoneRows[i]
  162. rows[i].ManagedResourceInfo = manRows[i]
  163. }
  164. return rows
  165. }
  166. func (manager *SLoadbalancerResourceBaseManager) ListItemFilter(
  167. ctx context.Context,
  168. q *sqlchemy.SQuery,
  169. userCred mcclient.TokenCredential,
  170. query api.LoadbalancerFilterListInput,
  171. ) (*sqlchemy.SQuery, error) {
  172. if len(query.LoadbalancerId) > 0 {
  173. lbObj, _, err := ValidateLoadbalancerResourceInput(ctx, userCred, query.LoadbalancerResourceInput)
  174. if err != nil {
  175. return nil, errors.Wrap(err, "ValidateLoadbalancerResourceInput")
  176. }
  177. q = q.Equals("loadbalancer_id", lbObj.GetId())
  178. }
  179. lbQ := LoadbalancerManager.Query("id").Snapshot()
  180. lbQ, err := manager.SVpcResourceBaseManager.ListItemFilter(ctx, lbQ, userCred, query.VpcFilterListInput)
  181. if err != nil {
  182. return nil, errors.Wrap(err, "SVpcResourceBaseManager.ListItemFilter")
  183. }
  184. zoneQuery := api.ZonalFilterListInput{
  185. ZonalFilterListBase: query.ZonalFilterListBase,
  186. }
  187. lbQ, err = manager.SZoneResourceBaseManager.ListItemFilter(ctx, lbQ, userCred, zoneQuery)
  188. if err != nil {
  189. return nil, errors.Wrap(err, "SZoneResourceBaseManager.ListItemFilter")
  190. }
  191. if lbQ.IsAltered() {
  192. q = q.Filter(sqlchemy.In(q.Field("loadbalancer_id"), lbQ.SubQuery()))
  193. }
  194. return q, nil
  195. }
  196. func (manager *SLoadbalancerResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  197. if field == "loadbalancer" {
  198. lbQuery := LoadbalancerManager.Query("name", "id").Distinct().SubQuery()
  199. q.AppendField(lbQuery.Field("name", field))
  200. q = q.Join(lbQuery, sqlchemy.Equals(q.Field("loadbalancer_id"), lbQuery.Field("id")))
  201. q.GroupBy(lbQuery.Field("name"))
  202. return q, nil
  203. } else {
  204. lbs := LoadbalancerManager.Query("id", "zone_id", "vpc_id").SubQuery()
  205. q = q.LeftJoin(lbs, sqlchemy.Equals(q.Field("loadbalancer_id"), lbs.Field("id")))
  206. q, err := manager.SZoneResourceBaseManager.QueryDistinctExtraField(q, field)
  207. if err == nil {
  208. return q, nil
  209. }
  210. q, err = manager.SVpcResourceBaseManager.QueryDistinctExtraField(q, field)
  211. if err == nil {
  212. return q, nil
  213. }
  214. return q, httperrors.ErrNotFound
  215. }
  216. }
  217. func (manager *SLoadbalancerResourceBaseManager) OrderByExtraFields(
  218. ctx context.Context,
  219. q *sqlchemy.SQuery,
  220. userCred mcclient.TokenCredential,
  221. query api.LoadbalancerFilterListInput,
  222. ) (*sqlchemy.SQuery, error) {
  223. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  224. return q, nil
  225. }
  226. orderQ := LoadbalancerManager.Query("id")
  227. orderSubQ := orderQ.SubQuery()
  228. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  229. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("loadbalancer_id"), orderSubQ.Field("id")))
  230. q = db.OrderByFields(q, orders, fields)
  231. return q, nil
  232. }
  233. func (manager *SLoadbalancerResourceBaseManager) GetOrderBySubQuery(
  234. q *sqlchemy.SQuery,
  235. subq *sqlchemy.SSubQuery,
  236. joinField sqlchemy.IQueryField,
  237. userCred mcclient.TokenCredential,
  238. query api.LoadbalancerFilterListInput,
  239. orders []string,
  240. fields []sqlchemy.IQueryField,
  241. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  242. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  243. return q, orders, fields
  244. }
  245. lbQ := LoadbalancerManager.Query().SubQuery()
  246. q = q.LeftJoin(lbQ, sqlchemy.Equals(joinField, lbQ.Field("id")))
  247. q = q.AppendField(lbQ.Field("name").Label("loadbalancer"))
  248. orders = append(orders, query.OrderByLoadbalancer)
  249. fields = append(fields, subq.Field("loadbalancer"))
  250. zoneQuery := api.ZonalFilterListInput{
  251. ZonalFilterListBase: query.ZonalFilterListBase,
  252. }
  253. q, orders, fields = manager.SZoneResourceBaseManager.GetOrderBySubQuery(q, subq, lbQ.Field("zone_id"), userCred, zoneQuery, orders, fields)
  254. q, orders, fields = manager.SVpcResourceBaseManager.GetOrderBySubQuery(q, subq, lbQ.Field("vpc_id"), userCred, query.VpcFilterListInput, orders, fields)
  255. return q, orders, fields
  256. }
  257. func (manager *SLoadbalancerResourceBaseManager) GetOrderByFields(query api.LoadbalancerFilterListInput) []string {
  258. fields := make([]string, 0)
  259. zoneQuery := api.ZonalFilterListInput{
  260. ZonalFilterListBase: query.ZonalFilterListBase,
  261. }
  262. zoneFields := manager.SZoneResourceBaseManager.GetOrderByFields(zoneQuery)
  263. fields = append(fields, zoneFields...)
  264. vpcFields := manager.SVpcResourceBaseManager.GetOrderByFields(query.VpcFilterListInput)
  265. fields = append(fields, vpcFields...)
  266. fields = append(fields, query.OrderByLoadbalancer)
  267. return fields
  268. }
  269. func (manager *SLoadbalancerResourceBaseManager) ListItemExportKeys(ctx context.Context,
  270. q *sqlchemy.SQuery,
  271. userCred mcclient.TokenCredential,
  272. keys stringutils2.SSortedStrings,
  273. ) (*sqlchemy.SQuery, error) {
  274. if keys.ContainsAny(manager.GetExportKeys()...) {
  275. var err error
  276. subq := LoadbalancerManager.Query("id", "name", "vpc_id", "zone_id").SubQuery()
  277. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("loadbalancer_id"), q.Field("id")))
  278. if keys.Contains("loadbalancer") {
  279. q = q.AppendField(subq.Field("name", "loadbalancer"))
  280. }
  281. if keys.Contains("vpc") {
  282. q, err = manager.SVpcResourceBaseManager.ListItemExportKeys(ctx, q, userCred, keys)
  283. if err != nil {
  284. return nil, errors.Wrap(err, "SVpcResourceBaseManager.ListItemExportKeys")
  285. }
  286. }
  287. if keys.ContainsAny(manager.SZoneResourceBaseManager.GetExportKeys()...) {
  288. q, err = manager.SZoneResourceBaseManager.ListItemExportKeys(ctx, q, userCred, keys)
  289. if err != nil {
  290. return nil, errors.Wrap(err, "SZoneResourceBaseManager.ListItemExportKeys")
  291. }
  292. }
  293. }
  294. return q, nil
  295. }
  296. func (manager *SLoadbalancerResourceBaseManager) GetExportKeys() []string {
  297. keys := []string{"loadbalancer"}
  298. keys = append(keys, manager.SZoneResourceBaseManager.GetExportKeys()...)
  299. keys = append(keys, "vpc")
  300. return keys
  301. }
  302. func (self *SLoadbalancerResourceBase) GetChangeOwnerCandidateDomainIds() []string {
  303. lb, _ := self.GetLoadbalancer()
  304. if lb != nil {
  305. return lb.GetChangeOwnerCandidateDomainIds()
  306. }
  307. return nil
  308. }